621: g_supply_undo_rec(a).orig_firm_date) then
622: supply_columns(i).column_changed := 'FIRM_DATE';
623: supply_columns(i).column_changed_text := get_msg('MSC','FIRM_DATE');
624: supply_columns(i).old_value :=
625: fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_firm_date);
626: supply_columns(i).column_type := 'DATE';
627: supply_columns(i).new_value :=
628: fnd_date.date_to_canonical(g_supply_undo_rec(a).firm_date);
629: i := i+1 ;
624: supply_columns(i).old_value :=
625: fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_firm_date);
626: supply_columns(i).column_type := 'DATE';
627: supply_columns(i).new_value :=
628: fnd_date.date_to_canonical(g_supply_undo_rec(a).firm_date);
629: i := i+1 ;
630: END IF;
631: if notEqual(g_supply_undo_rec(a).firm_qty,
632: g_supply_undo_rec(a).orig_firm_qty) then
673: if notEqual(g_supply_undo_rec(a).ship_date,
674: g_supply_undo_rec(a).orig_ship_date) then
675: supply_columns(i).column_changed := 'NEW_SHIP_DATE';
676: supply_columns(i).column_changed_text := get_msg('MSC','MSC_SHIP_DATE');
677: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_ship_date);
678: supply_columns(i).column_type := 'DATE';
679: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).ship_date);
680: i := i+1 ;
681: END IF;
675: supply_columns(i).column_changed := 'NEW_SHIP_DATE';
676: supply_columns(i).column_changed_text := get_msg('MSC','MSC_SHIP_DATE');
677: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_ship_date);
678: supply_columns(i).column_type := 'DATE';
679: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).ship_date);
680: i := i+1 ;
681: END IF;
682: if notEqual(g_supply_undo_rec(a).dock_date,
683: g_supply_undo_rec(a).orig_dock_date) then
682: if notEqual(g_supply_undo_rec(a).dock_date,
683: g_supply_undo_rec(a).orig_dock_date) then
684: supply_columns(i).column_changed := 'NEW_DOCK_DATE';
685: supply_columns(i).column_changed_text := get_msg('MSC','MSC_DOCK_DATE');
686: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_dock_date);
687: supply_columns(i).column_type := 'DATE';
688: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).dock_date);
689: i := i+1 ;
690: END IF;
684: supply_columns(i).column_changed := 'NEW_DOCK_DATE';
685: supply_columns(i).column_changed_text := get_msg('MSC','MSC_DOCK_DATE');
686: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_dock_date);
687: supply_columns(i).column_type := 'DATE';
688: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).dock_date);
689: i := i+1 ;
690: END IF;
691: msc_undo.store_undo(1, --table_changed
692: 2, --insert or update