The customer recently wanted to synchronized the "decision_date" from table BC_info and decided in DOCS.
(BC_info primary keys ca_year, ca_number) so in the BC_INFO trigger(insert or update or delete) i did the following.
if nvl(:new.DECISION_DATE,null_date) != nvl(ld.DECISION_DATE,null_date) then
set decided = :new.decision_date
where ca_year = ca_year (Instead of :new.ca_year )
and ca_number = ca_number (Instead of :new.ca_number
and type in ('ADP');
exception when others then
Due to which all docs with type('ADP') are updated with wrong date, i need to correct this mistake so they are synchronized with same date.
But now i think i need to write some code to see if there is a decision date and then loop and update only 'ADP' documents with the new ones. So please help me it's very critical for me to fix it by monday.
Please Help me out, it 's very critical, i would provide more info if required and would be very very grateful.