DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on FND_DATE

Line 625: fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_firm_date);

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 ;

Line 628: fnd_date.date_to_canonical(g_supply_undo_rec(a).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 ;
630: END IF;
631: if notEqual(g_supply_undo_rec(a).firm_qty,
632: g_supply_undo_rec(a).orig_firm_qty) then

Line 677: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_ship_date);

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;

Line 679: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).ship_date);

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

Line 686: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_dock_date);

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;

Line 688: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).dock_date);

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