DBA Data[Home] [Help]

APPS.MSD_PULL_FACT_DATA dependencies on DUAL

Line 111: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

107:
108:
109: retcode :=0;
110:
111: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
112:
113:
114: For Shipment_Rec IN Shipment LOOP
115:

Line 186: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

182:
183:
184: retcode :=0;
185:
186: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
187:
188:
189: For Booking_Rec IN Booking LOOP
190:

Line 260: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

256:
257: retcode := 0;
258:
259:
260: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
261:
262: For UOM_Rec IN UOM LOOP
263:
264: MSD_TRANSLATE_FACT_DATA.translate_uom_conversion(

Line 541: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

537:
538: Begin
539:
540:
541: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
542:
543: FOR Mfg_Fcst_Rec IN Mfg_Forecast LOOP
544: DECLARE
545: e_post_process_err EXCEPTION;

Line 675: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

671:
672:
673: retcode :=0;
674:
675: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
676:
677: For Pricing_Rec IN Pricing LOOP
678:
679: MSD_TRANSLATE_FACT_DATA.translate_pricing_data(