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

Line 5: G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;

1: PACKAGE MSD_SPF_COLLECT_HISTORY_DATA AUTHID CURRENT_USER AS
2: /* $Header: msdspfchds.pls 120.8.12020000.3 2012/11/05 09:20:25 kkhatri ship $ */
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: G_SCHEMA VARCHAR2(50) := fnd_profile.value('MSD_DEM_SCHEMA');
8:
9: G_INSTALL_BASE_UC_SERIES_ID NUMBER := 114;

Line 6: G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;

2: /* $Header: msdspfchds.pls 120.8.12020000.3 2012/11/05 09:20:25 kkhatri ship $ */
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: G_SCHEMA VARCHAR2(50) := fnd_profile.value('MSD_DEM_SCHEMA');
8:
9: G_INSTALL_BASE_UC_SERIES_ID NUMBER := 114;
10:

Line 30: CS_DEM_SPF_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);

26: C_SPARE_USAGE_HISTORY NUMBER := 201;
27: C_SPARE_SHIPMENT_HISTORY NUMBER := 202;
28: C_SPARE_USAGE_HISTORY_TABLE VARCHAR2(30) := 'MSD_SPF_ST_SPARE_USAGE';
29:
30: CS_DEM_SPF_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
31: CS_DEM_SPF_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
33:
34: -- bug#14694463 kkhatri

Line 31: CS_DEM_SPF_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);

27: C_SPARE_SHIPMENT_HISTORY NUMBER := 202;
28: C_SPARE_USAGE_HISTORY_TABLE VARCHAR2(30) := 'MSD_SPF_ST_SPARE_USAGE';
29:
30: CS_DEM_SPF_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
31: CS_DEM_SPF_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
33:
34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);

Line 32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);

28: C_SPARE_USAGE_HISTORY_TABLE VARCHAR2(30) := 'MSD_SPF_ST_SPARE_USAGE';
29:
30: CS_DEM_SPF_BASE_MODEL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 1);
31: CS_DEM_SPF_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
33:
34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

Line 35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);

31: CS_DEM_SPF_OPTION_CLASS VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);
32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
33:
34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

Line 36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

32: CS_DEM_SPF_OPTION VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);
33:
34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:

Line 37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);

33:
34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:
41:

Line 38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

34: -- bug#14694463 kkhatri
35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:
41:
42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');

Line 39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

35: CS_DEM_MATERIAL VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
36: CS_DEM_PRODUCT VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
37: CS_DEM_RESOURCE VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:
41:
42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');

Line 42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');

38: CS_DEM_WORK_ORDER VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:
41:
42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
44:
45:
46: CS_DEM_LEVEL_ASSET_GROUP_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));

Line 43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');

39: CS_DEM_WORKORDER_ITEM VARCHAR2(100) := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
40:
41:
42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
44:
45:
46: CS_DEM_LEVEL_ASSET_GROUP_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
47: CS_DEM_LEVEL_CLASS_CODE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));

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

42: CS_DEM_LEVEL_ASSET_GROUP_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'table_label');
43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
44:
45:
46: CS_DEM_LEVEL_ASSET_GROUP_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
47: CS_DEM_LEVEL_CLASS_CODE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
48:
49: /*** PROCEDURES ***/
50:

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

43: CS_DEM_LEVEL_CLASS_CODE_LABEL VARCHAR2(255) := msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'table_label');
44:
45:
46: CS_DEM_LEVEL_ASSET_GROUP_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_ASSET_GROUP', 1, 'group_table_id'));
47: CS_DEM_LEVEL_CLASS_CODE_ID NUMBER := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'LEVEL_CLASS_CODE', 1, 'group_table_id'));
48:
49: /*** PROCEDURES ***/
50:
51: