DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on FND_DATE

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

617: g_supply_undo_rec(a).orig_firm_date) then
618: supply_columns(i).column_changed := 'FIRM_DATE';
619: supply_columns(i).column_changed_text := get_msg('MSC','FIRM_DATE');
620: supply_columns(i).old_value :=
621: fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_firm_date);
622: supply_columns(i).column_type := 'DATE';
623: supply_columns(i).new_value :=
624: fnd_date.date_to_canonical(g_supply_undo_rec(a).firm_date);
625: i := i+1 ;

Line 624: fnd_date.date_to_canonical(g_supply_undo_rec(a).firm_date);

620: supply_columns(i).old_value :=
621: fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_firm_date);
622: supply_columns(i).column_type := 'DATE';
623: supply_columns(i).new_value :=
624: fnd_date.date_to_canonical(g_supply_undo_rec(a).firm_date);
625: i := i+1 ;
626: END IF;
627: if notEqual(g_supply_undo_rec(a).firm_qty,
628: g_supply_undo_rec(a).orig_firm_qty) then

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

669: if notEqual(g_supply_undo_rec(a).ship_date,
670: g_supply_undo_rec(a).orig_ship_date) then
671: supply_columns(i).column_changed := 'NEW_SHIP_DATE';
672: supply_columns(i).column_changed_text := get_msg('MSC','MSC_SHIP_DATE');
673: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_ship_date);
674: supply_columns(i).column_type := 'DATE';
675: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).ship_date);
676: i := i+1 ;
677: END IF;

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

671: supply_columns(i).column_changed := 'NEW_SHIP_DATE';
672: supply_columns(i).column_changed_text := get_msg('MSC','MSC_SHIP_DATE');
673: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_ship_date);
674: supply_columns(i).column_type := 'DATE';
675: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).ship_date);
676: i := i+1 ;
677: END IF;
678: if notEqual(g_supply_undo_rec(a).dock_date,
679: g_supply_undo_rec(a).orig_dock_date) then

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

678: if notEqual(g_supply_undo_rec(a).dock_date,
679: g_supply_undo_rec(a).orig_dock_date) then
680: supply_columns(i).column_changed := 'NEW_DOCK_DATE';
681: supply_columns(i).column_changed_text := get_msg('MSC','MSC_DOCK_DATE');
682: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_dock_date);
683: supply_columns(i).column_type := 'DATE';
684: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).dock_date);
685: i := i+1 ;
686: END IF;

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

680: supply_columns(i).column_changed := 'NEW_DOCK_DATE';
681: supply_columns(i).column_changed_text := get_msg('MSC','MSC_DOCK_DATE');
682: supply_columns(i).old_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).orig_dock_date);
683: supply_columns(i).column_type := 'DATE';
684: supply_columns(i).new_value := fnd_date.date_to_canonical(g_supply_undo_rec(a).dock_date);
685: i := i+1 ;
686: END IF;
687: msc_undo.store_undo(1, --table_changed
688: 2, --insert or update