112:
113:
114: For Shipment_Rec IN Shipment LOOP
115:
116: MSD_TRANSLATE_FACT_DATA.translate_shipment_data(
117: errbuf => errbuf,
118: retcode => retcode,
119: p_source_table => x_source_table,
120: p_dest_table => x_dest_table,
137:
138: End Loop ;
139:
140: /* Delete fact rows that are not used by any demand plans */
141: MSD_TRANSLATE_FACT_DATA.clean_fact_data( errbuf,
142: retcode,
143: x_dest_table);
144:
145: commit;
187:
188:
189: For Booking_Rec IN Booking LOOP
190:
191: MSD_TRANSLATE_FACT_DATA.translate_booking_data(
192: errbuf => errbuf,
193: retcode => retcode,
194: p_source_table => x_source_table,
195: p_dest_table => x_dest_table,
212:
213: End Loop ;
214:
215: /* Delete fact rows that are not used by any demand plans */
216: MSD_TRANSLATE_FACT_DATA.clean_fact_data( errbuf,
217: retcode,
218: x_dest_table);
219:
220:
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(
265: errbuf => errbuf,
266: retcode => retcode,
267: p_source_table => x_source_table,
268: p_dest_table => x_dest_table,
286:
287: /* Delete fact rows that are not used by any demand plans */
288: /* Not needed. Records are physically deleted
289:
290: MSD_TRANSLATE_FACT_DATA.clean_fact_data( errbuf,
291: retcode,
292: x_dest_table);
293: */
294:
336: none in the staging table */
337:
338: IF Curr_Conv_Rec.min_ship_date is not null THEN
339:
340: MSD_TRANSLATE_FACT_DATA.translate_currency_conversion(
341: errbuf => errbuf,
342: retcode => retcode,
343: p_source_table => x_source_table,
344: p_dest_table => x_dest_table,
398:
399: For Opportunity_Rec IN Opportunity LOOP
400:
401:
402: MSD_TRANSLATE_FACT_DATA.translate_opportunities_data(
403: errbuf => errbuf,
404: retcode => retcode,
405: p_source_table => x_source_table,
406: p_dest_table => x_dest_table,
462:
463: For Sales_Fcst_Rec IN Sales_Forecast LOOP
464:
465:
466: MSD_TRANSLATE_FACT_DATA.translate_sales_forecast(
467: errbuf => errbuf,
468: retcode => retcode,
469: p_source_table => x_source_table,
470: p_dest_table => x_dest_table,
546: BEGIN
547:
548: retcode :=0;
549:
550: MSD_TRANSLATE_FACT_DATA.translate_mfg_forecast(
551: errbuf => errbuf,
552: retcode => retcode,
553: p_source_table => x_source_table,
554: p_dest_table => x_dest_table,
557: p_new_refresh_num => l_new_refresh_num,
558: p_delete_flag => x_delete_flag );
559:
560: /* DWK Is posst process required */
561: b_post_process := MSD_TRANSLATE_FACT_DATA.Is_Post_Process_Required(errbuf,
562: retcode, Mfg_Fcst_Rec.instance, Mfg_Fcst_Rec.forecast_designator);
563:
564: IF ( b_post_process) THEN
565: IF (Mfg_Fcst_Rec.instance <> l_temp_instance) THEN
563:
564: IF ( b_post_process) THEN
565: IF (Mfg_Fcst_Rec.instance <> l_temp_instance) THEN
566: l_temp_instance := Mfg_Fcst_Rec.instance;
567: MSD_TRANSLATE_FACT_DATA.populate_calendar( errbuf,
568: retcode,
569: Mfg_Fcst_Rec.instance,
570: l_new_refresh_num,
571: MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE);
571: MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE);
572: END IF;
573:
574: /* Proceed post-process */
575: MSD_TRANSLATE_FACT_DATA.mfg_post_process( errbuf,
576: retcode,
577: Mfg_Fcst_Rec.instance,
578: Mfg_Fcst_Rec.forecast_designator,
579: l_new_refresh_num);
621:
622:
623:
624: /* Delete fact rows that are not used by any demand plans */
625: MSD_TRANSLATE_FACT_DATA.clean_fact_data( errbuf,
626: retcode,
627: x_dest_table);
628:
629: /* DWK Delete existing calendar after post process */
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(
680: errbuf => errbuf,
681: retcode => retcode,
682: p_source_table => x_source_table,
683: p_dest_table => x_dest_table,
695: End Loop ;
696:
697:
698: /* Delete fact rows that are not used by any demand plans */
699: MSD_TRANSLATE_FACT_DATA.clean_fact_data( errbuf,
700: retcode,
701: x_dest_table);
702:
703: