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_DEM_COMMON_UTILITIES dependencies on MSD_DEM_CTO

Line 583: log_message('MSD.MSD_DEM_CTO_BOM');

579: log_message('MSD.MSD_DEM_TIME');
580: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_TIME TO ' || x_dem_schema;
581: execute immediate x_grant_sql;
582:
583: log_message('MSD.MSD_DEM_CTO_BOM');
584: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
585: execute immediate x_grant_sql;
586:
587: /* Set the profile MSD_DEM_SCHEMA if not set */

Line 584: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;

580: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_TIME TO ' || x_dem_schema;
581: execute immediate x_grant_sql;
582:
583: log_message('MSD.MSD_DEM_CTO_BOM');
584: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
585: execute immediate x_grant_sql;
586:
587: /* Set the profile MSD_DEM_SCHEMA if not set */
588: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');

Line 601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);

597: log_message ('Global Parameter C_MSD_DEM_SCHEMA has been set to ' || x_dem_schema );
598:
599: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
600:
601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');

Line 602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);

598:
599: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
600:
601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');

Line 603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);

599: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
600:
601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');

Line 604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);

600:
601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');

Line 605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');

601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');

Line 606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');

602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));

Line 607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');

603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));

Line 608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');

604: MSD_DEM_CTO.CS_DEM_CTO_OPTION := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));

Line 609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');

605: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));

Line 610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));

606: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));

Line 611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));

607: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
615:

Line 612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));

608: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
615:
616: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);

Line 613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));

609: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
615:
616: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
617: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);

Line 614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));

610: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
611: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
612: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
613: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
614: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
615:
616: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
617: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
618: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);

Line 2656: RETURN MSD_DEM_CTO.CS_DEM_SYSDATE;

2652: FUNCTION GET_DEM_SYSDATE
2653: RETURN DATE
2654: IS
2655: BEGIN
2656: RETURN MSD_DEM_CTO.CS_DEM_SYSDATE;
2657: END;
2658:
2659: /*
2660: * This function returns the value of the constant CS_DEM_CTO_BASE_MODEL

Line 2666: RETURN MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL;

2662: FUNCTION GET_DEM_CTO_BASE_MODEL
2663: RETURN VARCHAR2
2664: IS
2665: BEGIN
2666: RETURN MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL;
2667: END;
2668:
2669: /*
2670: * This function returns the value of the constant CS_DEM_CTO_OPTION_CLASS

Line 2676: RETURN MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS;

2672: FUNCTION GET_DEM_CTO_OPTION_CLASS
2673: RETURN VARCHAR2
2674: IS
2675: BEGIN
2676: RETURN MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS;
2677: END;
2678:
2679: /*
2680: * This function returns the value of the constant CS_DEM_CTO_OPTION

Line 2686: RETURN MSD_DEM_CTO.CS_DEM_CTO_OPTION;

2682: FUNCTION GET_DEM_CTO_OPTION
2683: RETURN VARCHAR2
2684: IS
2685: BEGIN
2686: RETURN MSD_DEM_CTO.CS_DEM_CTO_OPTION;
2687: END;
2688:
2689: /*
2690: * This function returns the value of the constant CS_DEM_SPF_BASE_MODEL

Line 2726: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL;

2722: FUNCTION GET_ITEM_LABEL
2723: RETURN VARCHAR2
2724: IS
2725: BEGIN
2726: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL;
2727: END;
2728:
2729: /*
2730: * This function returns the value of the constant CS_DEM_LEVEL_ORG_LABEL

Line 2736: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL;

2732: FUNCTION GET_ORG_LABEL
2733: RETURN VARCHAR2
2734: IS
2735: BEGIN
2736: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL;
2737: END;
2738:
2739: /*
2740: * This function returns the value of the constant CS_DEM_LEVEL_SITE_LABEL

Line 2746: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL;

2742: FUNCTION GET_SITE_LABEL
2743: RETURN VARCHAR2
2744: IS
2745: BEGIN
2746: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL;
2747: END;
2748:
2749: /*
2750: * This function returns the value of the constant CS_DEM_LEVEL_DC_LABEL

Line 2756: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL;

2752: FUNCTION GET_DC_LABEL
2753: RETURN VARCHAR2
2754: IS
2755: BEGIN
2756: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL;
2757: END;
2758:
2759: /*
2760: * This function returns the value of the constant CS_DEM_LEVEL_SC_LABEL

Line 2766: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL;

2762: FUNCTION GET_SC_LABEL
2763: RETURN VARCHAR2
2764: IS
2765: BEGIN
2766: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL;
2767: END;
2768:
2769: /*
2770: * This function returns the value of the constant CS_DEM_LEVEL_ASSET_GROUP_LABEL

Line 2806: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID;

2802: FUNCTION GET_ITEM_ID
2803: RETURN NUMBER
2804: IS
2805: BEGIN
2806: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID;
2807: END;
2808:
2809: /*
2810: * This function returns the value of the constant CS_DEM_LEVEL_ORG_ID

Line 2816: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID;

2812: FUNCTION GET_ORG_ID
2813: RETURN NUMBER
2814: IS
2815: BEGIN
2816: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID;
2817: END;
2818:
2819: /*
2820: * This function returns the value of the constant CS_DEM_LEVEL_SITE_ID

Line 2826: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID;

2822: FUNCTION GET_SITE_ID
2823: RETURN NUMBER
2824: IS
2825: BEGIN
2826: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID;
2827: END;
2828:
2829: /*
2830: * This function returns the value of the constant CS_DEM_LEVEL_DC_ID

Line 2836: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID;

2832: FUNCTION GET_DC_ID
2833: RETURN NUMBER
2834: IS
2835: BEGIN
2836: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID;
2837: END;
2838:
2839: /*
2840: * This function returns the value of the constant CS_DEM_LEVEL_SC_ID

Line 2846: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID;

2842: FUNCTION GET_SC_ID
2843: RETURN NUMBER
2844: IS
2845: BEGIN
2846: RETURN MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID;
2847: END;
2848:
2849: /*
2850: * This function returns the value of the constant CS_DEM_LEVEL_ASSET_GROUP_ID