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_COMMON_UTILITIES

Line 1503: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;

1499: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
1500: EXECUTE IMMEDIATE x_grant_sql;
1501: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
1502:
1503: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
1504: EXECUTE IMMEDIATE x_grant_sql;
1505: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');
1506:
1507: x_grant_sql := 'GRANT EXECUTE ON MSC_PHUB_PKG TO ' || x_dem_schema;

Line 1505: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');

1501: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
1502:
1503: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
1504: EXECUTE IMMEDIATE x_grant_sql;
1505: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');
1506:
1507: x_grant_sql := 'GRANT EXECUTE ON MSC_PHUB_PKG TO ' || x_dem_schema;
1508: EXECUTE IMMEDIATE x_grant_sql;
1509: log_message ('Execute privilege granted on package MSC_PHUB_PKG to ' || x_dem_schema || ' 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);

Line 1595: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);

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);
1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');

Line 1596: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);

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);
1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');

Line 1597: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);

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);
1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
1601:

Line 1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');

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);
1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
1601:
1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));

Line 1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');

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);
1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
1601:
1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
1604:

Line 1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));

1598:
1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
1601:
1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
1604:
1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);

Line 1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));

1599: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
1600: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
1601:
1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
1604:
1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

Line 1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);

1602: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
1604:
1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

Line 1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

1603: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
1604:
1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1611:

Line 1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);

1604:
1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1611:
1612: END IF;

Line 1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

1605: -- Bug#15907861 (12.2.1) , 15907886 (12.3) --nallkuma
1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1611:
1612: END IF;
1613:

Line 1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

1606: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
1607: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
1608: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
1609: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1610: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
1611:
1612: END IF;
1613:
1614: /* Set the profile MSD_DEM_VERSION */ -- nallkuma

Line 1885: msd_dem_common_utilities.update_dem_apcc_synonym(errbuf,retcode);

1881:
1882: END IF;
1883: END IF;
1884:
1885: msd_dem_common_utilities.update_dem_apcc_synonym(errbuf,retcode);
1886: COMMIT;
1887:
1888: EXCEPTION
1889: WHEN OTHERS THEN