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_CTO dependencies on MSD_DEM_COMMON_UTILITIES

Line 5: G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;

1: PACKAGE MSD_DEM_CTO AUTHID CURRENT_USER AS
2: /* $Header: msddemctos.pls 120.4 2011/01/30 16:28:55 syenamar noship $ */
3:
4: /*** GLOBAL VARIABLES ***/
5: G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;
6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;
7:
8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);

Line 6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;

2: /* $Header: msddemctos.pls 120.4 2011/01/30 16:28:55 syenamar noship $ */
3:
4: /*** GLOBAL VARIABLES ***/
5: G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;
6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;
7:
8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);

Line 9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);

5: G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;
6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;
7:
8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');

Line 10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);

6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;
7:
8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');

Line 11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);

7:
8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');

Line 12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);

8: /* Session Constants */
9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');

Line 13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');

9: CS_DEM_SYSDATE DATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');

Line 14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');

10: CS_DEM_CTO_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));

Line 15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');

11: CS_DEM_CTO_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);
12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));

Line 16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');

12: CS_DEM_CTO_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 3);
13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));

Line 17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');

13: CS_DEM_LEVEL_ITEM_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'table_label');
14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));

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

14: CS_DEM_LEVEL_ORG_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'table_label');
15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
22: CS_DEM_LEVEL_SC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));

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

15: CS_DEM_LEVEL_SITE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'table_label');
16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
22: CS_DEM_LEVEL_SC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
23:

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

16: CS_DEM_LEVEL_DC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'table_label');
17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
22: CS_DEM_LEVEL_SC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
23:
24:

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

17: CS_DEM_LEVEL_SC_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'table_label');
18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
22: CS_DEM_LEVEL_SC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
23:
24:
25: /*** PROCEDURES ***

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

18: CS_DEM_LEVEL_ITEM_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ITEM', 1, 'group_table_id'));
19: CS_DEM_LEVEL_ORG_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ORGANIZATION', 1, 'group_table_id'));
20: CS_DEM_LEVEL_SITE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SITE', 1, 'group_table_id'));
21: CS_DEM_LEVEL_DC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_DEMAND_CLASS', 1, 'group_table_id'));
22: CS_DEM_LEVEL_SC_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_SALES_CHANNEL', 1, 'group_table_id'));
23:
24:
25: /*** PROCEDURES ***
26: *