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

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

1558: log_message('MSD.MSD_DEM_TIME');
1559: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_TIME TO ' || x_dem_schema;
1560: execute immediate x_grant_sql;
1561:
1562: log_message('MSD.MSD_DEM_CTO_BOM');
1563: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
1564: execute immediate x_grant_sql;
1565:
1566: /* Set the profile MSD_DEM_SCHEMA if not set */

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

1559: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_TIME TO ' || x_dem_schema;
1560: execute immediate x_grant_sql;
1561:
1562: log_message('MSD.MSD_DEM_CTO_BOM');
1563: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
1564: execute immediate x_grant_sql;
1565:
1566: /* Set the profile MSD_DEM_SCHEMA if not set */
1567: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');

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

1576: log_message ('Global Parameter C_MSD_DEM_SCHEMA has been set to ' || x_dem_schema );
1577:
1578: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
1579:
1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');

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

1577:
1578: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
1579:
1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');

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

1578: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
1579:
1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');

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

1579:
1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');

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

1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');

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

1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));

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

1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));

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

1583: MSD_DEM_CTO.CS_DEM_CTO_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));

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

1584: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));

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

1585: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
1593: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));

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

1586: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
1593: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
1594:

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

1587: MSD_DEM_CTO.CS_DEM_LEVEL_DC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
1593: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
1594:
1595: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);

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

1588: MSD_DEM_CTO.CS_DEM_LEVEL_SC_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
1593: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
1594:
1595: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
1596: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);

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

1589: MSD_DEM_CTO.CS_DEM_LEVEL_ITEM_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
1590: MSD_DEM_CTO.CS_DEM_LEVEL_ORG_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
1591: MSD_DEM_CTO.CS_DEM_LEVEL_SITE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
1592: MSD_DEM_CTO.CS_DEM_LEVEL_DC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
1593: MSD_DEM_CTO.CS_DEM_LEVEL_SC_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
1594:
1595: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
1596: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
1597: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);