eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_COLLECT_FACT_DATA dependencies on MSD_COMMON_UTILITIES

Line 211: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

207: ****************************************************/
208:
209: retcode :=0;
210:
211: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
212: if (x_retcode = -1) then
213: retcode :=-1;
214: errbuf := 'Error while getting db_link';
215: return;

Line 245: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,

241: return;
242: end if;
243:
244: /* OPM Comment By Rajesh Patangya */
245: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
246: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
247: if (o_retcode = -1) then
248: retcode :=-1;
249: errbuf := 'Error while getting instance_info';

Line 254: x_source_table := MSD_COMMON_UTILITIES.SHIPMENT_SOURCE_TABLE || x_dblink ;

250: return;
251: end if;
252:
253:
254: x_source_table := MSD_COMMON_UTILITIES.SHIPMENT_SOURCE_TABLE || x_dblink ;
255:
256: /* OPM Comment By Rajesh Patangya */
257: o_source_table := MSD_COMMON_UTILITIES.OPM_SHIPMENT_SOURCE_TABLE || x_dblink ;
258:

Line 257: o_source_table := MSD_COMMON_UTILITIES.OPM_SHIPMENT_SOURCE_TABLE || x_dblink ;

253:
254: x_source_table := MSD_COMMON_UTILITIES.SHIPMENT_SOURCE_TABLE || x_dblink ;
255:
256: /* OPM Comment By Rajesh Patangya */
257: o_source_table := MSD_COMMON_UTILITIES.OPM_SHIPMENT_SOURCE_TABLE || x_dblink ;
258:
259: x_dest_table := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;
260:
261: x_from_date := FND_DATE.canonical_to_date(p_from_date);

Line 259: x_dest_table := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;

255:
256: /* OPM Comment By Rajesh Patangya */
257: o_source_table := MSD_COMMON_UTILITIES.OPM_SHIPMENT_SOURCE_TABLE || x_dblink ;
258:
259: x_dest_table := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;
260:
261: x_from_date := FND_DATE.canonical_to_date(p_from_date);
262: x_to_date := FND_DATE.canonical_to_date(p_to_date);
263:

Line 410: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

406: ****************************************************/
407:
408: retcode :=0;
409:
410: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
411: if (x_retcode = -1) then
412: retcode :=-1;
413: errbuf := 'Error while getting db_link';
414: return;

Line 444: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,

440: return;
441: END IF;
442:
443: /* OPM Comment By Rajesh Patangya */
444: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
445: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
446: if (o_retcode = -1) then
447: retcode :=-1;
448: errbuf := 'Error while getting instance_info';

Line 453: x_source_table := MSD_COMMON_UTILITIES.BOOKING_SOURCE_TABLE || x_dblink ;

449: return;
450: end if;
451:
452:
453: x_source_table := MSD_COMMON_UTILITIES.BOOKING_SOURCE_TABLE || x_dblink ;
454: /* OPM Comment By Rajesh Patangya */
455: o_source_table := MSD_COMMON_UTILITIES.OPM_BOOKING_SOURCE_TABLE || x_dblink ;
456:
457: x_dest_table := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;

Line 455: o_source_table := MSD_COMMON_UTILITIES.OPM_BOOKING_SOURCE_TABLE || x_dblink ;

451:
452:
453: x_source_table := MSD_COMMON_UTILITIES.BOOKING_SOURCE_TABLE || x_dblink ;
454: /* OPM Comment By Rajesh Patangya */
455: o_source_table := MSD_COMMON_UTILITIES.OPM_BOOKING_SOURCE_TABLE || x_dblink ;
456:
457: x_dest_table := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;
458:
459: x_from_date := FND_DATE.canonical_to_date(p_from_date);

Line 457: x_dest_table := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;

453: x_source_table := MSD_COMMON_UTILITIES.BOOKING_SOURCE_TABLE || x_dblink ;
454: /* OPM Comment By Rajesh Patangya */
455: o_source_table := MSD_COMMON_UTILITIES.OPM_BOOKING_SOURCE_TABLE || x_dblink ;
456:
457: x_dest_table := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;
458:
459: x_from_date := FND_DATE.canonical_to_date(p_from_date);
460: x_to_date := FND_DATE.canonical_to_date(p_to_date);
461:

Line 591: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

587: IF (nvl(retcode, 0) <> 0) THEN
588: return;
589: END IF;
590:
591: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
592: if (x_retcode = -1) then
593: retcode :=-1;
594: errbuf := 'Error while getting db_link';
595: return;

Line 598: x_source_table := MSD_COMMON_UTILITIES.UOM_SOURCE_TABLE || x_dblink ;

594: errbuf := 'Error while getting db_link';
595: return;
596: end if;
597:
598: x_source_table := MSD_COMMON_UTILITIES.UOM_SOURCE_TABLE || x_dblink ;
599:
600: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
601:
602: x_dest_table := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;

Line 602: x_dest_table := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;

598: x_source_table := MSD_COMMON_UTILITIES.UOM_SOURCE_TABLE || x_dblink ;
599:
600: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
601:
602: x_dest_table := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;
603:
604:
605: MSD_TRANSLATE_FACT_DATA.translate_uom_conversion(
606: errbuf => errbuf,

Line 697: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

693: return;
694: END IF;
695:
696:
697: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
698: if (x_retcode = -1) then
699: retcode :=-1;
700: errbuf := 'Error while getting db_link';
701: return;

Line 704: x_source_table := MSD_COMMON_UTILITIES.CURRENCY_SOURCE_TABLE || x_dblink ;

700: errbuf := 'Error while getting db_link';
701: return;
702: end if;
703:
704: x_source_table := MSD_COMMON_UTILITIES.CURRENCY_SOURCE_TABLE || x_dblink ;
705:
706: x_dest_table := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;
707:
708:

Line 706: x_dest_table := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;

702: end if;
703:
704: x_source_table := MSD_COMMON_UTILITIES.CURRENCY_SOURCE_TABLE || x_dblink ;
705:
706: x_dest_table := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;
707:
708:
709: x_from_date := FND_DATE.canonical_to_date(p_from_date);
710: x_to_date := FND_DATE.canonical_to_date(p_to_date);

Line 820: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

816:
817:
818:
819:
820: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
821: if (x_retcode = -1) then
822: retcode :=-1;
823: errbuf := 'Error while getting db_link';
824: return;

Line 828: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,

824: return;
825: end if;
826:
827: /* OPM Comment By Rajesh Patangya */
828: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
829: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
830: if (o_retcode = -1) then
831: retcode :=-1;
832: errbuf := 'Error while getting instance_info';

Line 836: x_source_table := MSD_COMMON_UTILITIES.MFG_FCST_SOURCE_TABLE || x_dblink ;

832: errbuf := 'Error while getting instance_info';
833: return;
834: end if;
835:
836: x_source_table := MSD_COMMON_UTILITIES.MFG_FCST_SOURCE_TABLE || x_dblink ;
837: /* OPM Comment By Rajesh Patangya */
838: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_FCST_SOURCE_TABLE || x_dblink ;
839:
840: x_dest_table := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;

Line 838: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_FCST_SOURCE_TABLE || x_dblink ;

834: end if;
835:
836: x_source_table := MSD_COMMON_UTILITIES.MFG_FCST_SOURCE_TABLE || x_dblink ;
837: /* OPM Comment By Rajesh Patangya */
838: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_FCST_SOURCE_TABLE || x_dblink ;
839:
840: x_dest_table := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;
841:
842: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');

Line 840: x_dest_table := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;

836: x_source_table := MSD_COMMON_UTILITIES.MFG_FCST_SOURCE_TABLE || x_dblink ;
837: /* OPM Comment By Rajesh Patangya */
838: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_FCST_SOURCE_TABLE || x_dblink ;
839:
840: x_dest_table := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;
841:
842: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
843:
844: /* OPM Comment By Rajesh Patangya */

Line 964: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

960: return;
961: END IF;
962:
963:
964: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
965: if (x_retcode = -1) then
966: retcode :=-1;
967: errbuf := 'Error while getting db_link';
968: return;

Line 971: x_source_table := MSD_COMMON_UTILITIES.PRICING_SOURCE_TABLE || x_dblink ;

967: errbuf := 'Error while getting db_link';
968: return;
969: end if;
970:
971: x_source_table := MSD_COMMON_UTILITIES.PRICING_SOURCE_TABLE || x_dblink ;
972:
973: x_dest_table := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;
974:
975:

Line 973: x_dest_table := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;

969: end if;
970:
971: x_source_table := MSD_COMMON_UTILITIES.PRICING_SOURCE_TABLE || x_dblink ;
972:
973: x_dest_table := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;
974:
975:
976: MSD_TRANSLATE_FACT_DATA.translate_pricing_data(
977: errbuf => errbuf,

Line 1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);

1038:
1039: begin
1040: retcode := 0;
1041:
1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);
1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);

Line 1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);

1039: begin
1040: retcode := 0;
1041:
1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);
1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/

Line 1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);

1040: retcode := 0;
1041:
1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);
1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);

Line 1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);

1041:
1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);
1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);

Line 1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);

1042: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE, p_instance_id);
1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);

Line 1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/

1043: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE, p_instance_id);
1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);

Line 1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);

1044: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE, p_instance_id);
1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);

Line 1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);

1045: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, p_instance_id);
1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);
1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);

Line 1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);

1046: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE, p_instance_id);
1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);
1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);
1054:

Line 1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);

1047: /* EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, p_instance_id);*/
1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);
1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);
1054:
1055: COMMIT;

Line 1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);

1048: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, p_instance_id);
1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);
1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);
1054:
1055: COMMIT;
1056:

Line 1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);

1049: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE, p_instance_id);
1050: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE, p_instance_id);
1051: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE, p_instance_id);
1052: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, p_instance_id);
1053: EXECUTE IMMEDIATE get_purge_sql(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, p_instance_id);
1054:
1055: COMMIT;
1056:
1057: exception