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_PURGE dependencies on MSD_COMMON_UTILITIES

Line 431: if (p_shipment_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

427: l_date_used := 1;
428: end if ;
429:
430: -- Delete Shipment data
431: if (p_shipment_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
432: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE;
433: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
434: if(l_date_used = 1) then
435: l_where := l_where || ' and shipped_date ' || l_date_where;

Line 432: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE;

428: end if ;
429:
430: -- Delete Shipment data
431: if (p_shipment_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
432: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE;
433: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
434: if(l_date_used = 1) then
435: l_where := l_where || ' and shipped_date ' || l_date_where;
436: end if;

Line 441: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE,null);

437: l_final_str := l_delete_from || l_where;
438: EXECUTE IMMEDIATE l_final_str;
439:
440: /* Analyze Shipment Fact Tables */
441: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE,null);
442: /* End Analyze Shipment Fact Tables */
443:
444: end if;
445:

Line 447: if (p_booking_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

443:
444: end if;
445:
446: -- Delete Booking data
447: if (p_booking_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
448: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE;
449: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
450: if(l_date_used = 1) then
451: l_where := l_where || ' and booked_date ' || l_date_where;

Line 448: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE;

444: end if;
445:
446: -- Delete Booking data
447: if (p_booking_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
448: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE;
449: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
450: if(l_date_used = 1) then
451: l_where := l_where || ' and booked_date ' || l_date_where;
452: end if;

Line 457: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE,null);

453: l_final_str := l_delete_from || l_where;
454: EXECUTE IMMEDIATE l_final_str;
455:
456: /* Analyze Booking Fact Tables */
457: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE,null);
458: /* End Analyze Booking Fact Tables */
459:
460: end if;
461:

Line 465: if (p_mfg_fcst_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

461:
462:
463:
464: -- Delete Manufacturing Forecast data
465: if (p_mfg_fcst_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
466: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE;
467: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
468: if(l_date_used = 1) then
469: l_where := l_where || ' and forecast_date ' || l_date_where;

Line 466: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE;

462:
463:
464: -- Delete Manufacturing Forecast data
465: if (p_mfg_fcst_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
466: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE;
467: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
468: if(l_date_used = 1) then
469: l_where := l_where || ' and forecast_date ' || l_date_where;
470: end if;

Line 489: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, null);

485:
486: /* End Remove headers */
487:
488: /* Analyze Manufacturing Forecast Fact Tables */
489: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE, null);
490: /* End Analyze Manufacturing Forecast Fact Tables */
491:
492:
493: end if;

Line 496: if (p_sales_opp_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

492:
493: end if;
494:
495: -- Delete Sales Opportunity data
496: if (p_sales_opp_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
497:
498: open get_cs_definition_id('MSD_SALES_OPPORTUNITY');
499: fetch get_cs_definition_id into x_cs_id;
500: close get_cs_definition_id;

Line 519: if (p_cust_order_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

515:
516:
517: /** Added for Bug 2488293 - PURGE CUSTOM STREAM DATA GOT FROM DP-CP INTEGRATION **/
518: -- Delete Customer Orders Forecast data
519: if (p_cust_order_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
520:
521: open get_cs_definition_id('MSD_CUSTOMER_ORDER_FORECAST');
522: fetch get_cs_definition_id into x_cs_id;
523: close get_cs_definition_id;

Line 541: if (p_cust_sales_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

537:
538: end if;
539:
540: -- Delete Customer Sales Forecast data
541: if (p_cust_sales_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
542:
543: open get_cs_definition_id('MSD_CUSTOMER_SALES_FORECAST');
544: fetch get_cs_definition_id into x_cs_id;
545: close get_cs_definition_id;

Line 563: if p_cs_data_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG then

559: end if;
560:
561:
562: /** Delete Custom Data **/
563: if p_cs_data_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG then
564:
565: if (p_cs_definition_id is not null) then
566: open get_cs_system_flag(p_cs_definition_id);
567: fetch get_cs_system_flag into x_sys_flag;

Line 613: if (p_curr_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

609:
610: end if;
611:
612: /** Delete Currency data **/
613: if (p_curr_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
614: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE;
615: l_final_str := l_delete_from;
616: EXECUTE IMMEDIATE l_final_str;
617:

Line 614: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE;

610: end if;
611:
612: /** Delete Currency data **/
613: if (p_curr_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
614: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE;
615: l_final_str := l_delete_from;
616: EXECUTE IMMEDIATE l_final_str;
617:
618: /* Analyze Currency Code Fact Tables */

Line 619: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, null);

615: l_final_str := l_delete_from;
616: EXECUTE IMMEDIATE l_final_str;
617:
618: /* Analyze Currency Code Fact Tables */
619: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE, null);
620: /* End Analyze Currency Code Fact Tables */
621:
622: end if;
623:

Line 625: if (p_uom_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

621:
622: end if;
623:
624: -- Delete UOM data
625: if (p_uom_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
626: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.UOM_FACT_TABLE;
627: l_where := ' where nvl(instance,1) = nvl(''' || p_instance_id || ''',nvl(instance,1))' ;
628: l_final_str := l_delete_from || l_where;
629: EXECUTE IMMEDIATE l_final_str;

Line 626: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.UOM_FACT_TABLE;

622: end if;
623:
624: -- Delete UOM data
625: if (p_uom_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
626: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.UOM_FACT_TABLE;
627: l_where := ' where nvl(instance,1) = nvl(''' || p_instance_id || ''',nvl(instance,1))' ;
628: l_final_str := l_delete_from || l_where;
629: EXECUTE IMMEDIATE l_final_str;
630:

Line 632: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, null);

628: l_final_str := l_delete_from || l_where;
629: EXECUTE IMMEDIATE l_final_str;
630:
631: /* Analyze Uom Conversion Fact Tables */
632: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.UOM_FACT_TABLE, null);
633: /* End Analyze Uom Conversion Fact Tables */
634:
635: end if;
636:

Line 638: if (p_time_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

634:
635: end if;
636:
637: -- Delete Time data
638: if (p_time_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
639:
640: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.TIME_FACT_TABLE;
641:
642: if (p_calendar_code = 'GREGORIAN') then

Line 640: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.TIME_FACT_TABLE;

636:
637: -- Delete Time data
638: if (p_time_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
639:
640: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.TIME_FACT_TABLE;
641:
642: if (p_calendar_code = 'GREGORIAN') then
643:
644: l_where := ' where calendar_type = ' || MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR;

Line 644: l_where := ' where calendar_type = ' || MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR;

640: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.TIME_FACT_TABLE;
641:
642: if (p_calendar_code = 'GREGORIAN') then
643:
644: l_where := ' where calendar_type = ' || MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR;
645: if(l_date_used = 1) then
646: l_where := l_where || ' and day ' || l_date_where;
647: end if;
648: l_final_str := l_delete_from || l_where;

Line 664: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, null);

660:
661: end if;
662:
663: /* Analyze Time Fact Tables */
664: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.TIME_FACT_TABLE, null);
665: /* End Analyze Time Fact Tables */
666:
667: end if;
668:

Line 671: if (p_pricing_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

667: end if;
668:
669:
670: -- Delete Pricing data
671: if (p_pricing_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
672: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.PRICING_FACT_TABLE;
673: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
674: l_where := l_where || ' and price_list_name = nvl(:p_price_list, price_list_name)' ;
675: l_final_str := l_delete_from || l_where;

Line 672: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.PRICING_FACT_TABLE;

668:
669:
670: -- Delete Pricing data
671: if (p_pricing_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
672: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.PRICING_FACT_TABLE;
673: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
674: l_where := l_where || ' and price_list_name = nvl(:p_price_list, price_list_name)' ;
675: l_final_str := l_delete_from || l_where;
676: EXECUTE IMMEDIATE l_final_str using p_price_list;

Line 679: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, null);

675: l_final_str := l_delete_from || l_where;
676: EXECUTE IMMEDIATE l_final_str using p_price_list;
677:
678: /* Analyze Pricing Fact Tables */
679: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.PRICING_FACT_TABLE, null);
680: /* End Analyze Pricing Fact Tables */
681:
682: end if;
683:

Line 686: if (p_scn_ent_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

682: end if;
683:
684:
685: -- Delete Scenario entries data
686: if (p_scn_ent_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
687:
688: IF p_revision is not null THEN
689:
690: SELECt nvl(max(revision), -999) into l_latest_revision

Line 702: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE;

698: b_delete_denorm := FALSE;
699: END IF;
700: END IF;
701:
702: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE;
703: l_where := ' where nvl(instance,-999) = nvl(''' || p_instance_id || ''', nvl(instance,-999))' ;
704: l_where := l_where || ' and demand_plan_id = nvl(''' || p_demand_plan_id || ''',demand_plan_id)' ;
705: l_where := l_where || ' and scenario_id = nvl(''' || p_scenario_id || ''',scenario_id)' ;
706: l_where := l_where || ' and revision = nvl(''' || p_revision || ''',revision)' ;

Line 745: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE, null);

741:
742: END IF;
743:
744: /* Analyze Scenario Entry Fact Tables */
745: MSD_ANALYZE_TABLES.analyze_table(MSD_COMMON_UTILITIES.SCENARIO_ENTRIES_TABLE, null);
746: /* End Analyze Scenario Entry Fact Tables */
747:
748:
749: end if;

Line 752: if (p_level_values_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then

748:
749: end if;
750:
751: -- Delete Level value, associations and item attributes data
752: if (p_level_values_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
753: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
754: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
755: l_final_str := l_delete_from || l_where;
756: EXECUTE IMMEDIATE l_final_str;

Line 753: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;

749: end if;
750:
751: -- Delete Level value, associations and item attributes data
752: if (p_level_values_yes_no = MSD_COMMON_UTILITIES.MSD_YES_FLAG) then
753: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
754: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
755: l_final_str := l_delete_from || l_where;
756: EXECUTE IMMEDIATE l_final_str;
757:

Line 758: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE;

754: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
755: l_final_str := l_delete_from || l_where;
756: EXECUTE IMMEDIATE l_final_str;
757:
758: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE;
759: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
760: l_final_str := l_delete_from || l_where;
761: EXECUTE IMMEDIATE l_final_str;
762:

Line 763: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE;

759: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
760: l_final_str := l_delete_from || l_where;
761: EXECUTE IMMEDIATE l_final_str;
762:
763: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.ITEM_INFO_FACT_TABLE;
764: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
765: l_final_str := l_delete_from || l_where;
766: EXECUTE IMMEDIATE l_final_str;
767:

Line 768: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.MSD_LOCAL_ID_SETUP_TABLE;

764: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
765: l_final_str := l_delete_from || l_where;
766: EXECUTE IMMEDIATE l_final_str;
767:
768: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.MSD_LOCAL_ID_SETUP_TABLE;
769: l_where := ' where instance_id = nvl(''' || p_instance_id || ''',instance_id)' ;
770: l_final_str := l_delete_from || l_where;
771: EXECUTE IMMEDIATE l_final_str;
772:

Line 773: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_ORG_ASSCNS_FACT_TABLE;

769: l_where := ' where instance_id = nvl(''' || p_instance_id || ''',instance_id)' ;
770: l_final_str := l_delete_from || l_where;
771: EXECUTE IMMEDIATE l_final_str;
772:
773: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.LEVEL_ORG_ASSCNS_FACT_TABLE;
774: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
775: l_final_str := l_delete_from || l_where;
776: EXECUTE IMMEDIATE l_final_str;
777:

Line 778: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.ITEM_RELATIONSHIPS_FACT_TABLE;

774: l_where := ' where instance = nvl(''' || p_instance_id || ''',instance)' ;
775: l_final_str := l_delete_from || l_where;
776: EXECUTE IMMEDIATE l_final_str;
777:
778: l_delete_from := 'delete from ' || MSD_COMMON_UTILITIES.ITEM_RELATIONSHIPS_FACT_TABLE;
779: l_where := ' where instance_id = nvl(''' || p_instance_id || ''',instance_id)' ;
780: l_final_str := l_delete_from || l_where;
781: EXECUTE IMMEDIATE l_final_str;
782: