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_SPF_COLLECT_HISTORY_DATA

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

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);
619:
620: 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 617: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 2);

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);
619:
620: 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');
621: 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 618: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION := get_lookup_code ('T_EP_SPF_DEMAND_TYPE', 3);

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);
619:
620: 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');
621: 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');
622:

Line 620: 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');

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);
619:
620: 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');
621: 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');
622:
623: 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'));
624: 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 621: 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');

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);
619:
620: 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');
621: 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');
622:
623: 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'));
624: 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'));
625: -- bug#14694463 kkhatri

Line 623: 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'));

619:
620: 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');
621: 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');
622:
623: 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'));
624: 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'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);

Line 624: 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'));

620: 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');
621: 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');
622:
623: 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'));
624: 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'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);

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

622:
623: 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'));
624: 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'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);

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

623: 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'));
624: 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'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:

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

624: 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'));
625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;

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

625: -- bug#14694463 kkhatri
626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;
633:

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

626: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_MATERIAL := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 1);
627: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_PRODUCT := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 2);
628: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_RESOURCE := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 3);
629: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORK_ORDER := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
630: MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM := msd_dem_common_utilities.get_lookup_code ('T_EP_I_ATT_10', 4);
631:
632: END IF;
633:
634: /* Set the profile MSD_DEM_VERSION */ -- nallkuma

Line 2696: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL;

2692: FUNCTION GET_DEM_SPF_BASE_MODEL
2693: RETURN VARCHAR2
2694: IS
2695: BEGIN
2696: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_BASE_MODEL;
2697: END;
2698:
2699: /*
2700: * This function returns the value of the constant CS_DEM_SPF_OPTION_CLASS

Line 2706: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS;

2702: FUNCTION GET_DEM_SPF_OPTION_CLASS
2703: RETURN VARCHAR2
2704: IS
2705: BEGIN
2706: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION_CLASS;
2707: END;
2708:
2709: /*
2710: * This function returns the value of the constant CS_DEM_SPF_OPTION

Line 2716: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION;

2712: FUNCTION GET_DEM_SPF_OPTION
2713: RETURN VARCHAR2
2714: IS
2715: BEGIN
2716: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_SPF_OPTION;
2717: END;
2718:
2719: /*
2720: * This function returns the value of the constant CS_DEM_LEVEL_ITEM_LABEL

Line 2776: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL;

2772: FUNCTION GET_ASSET_GROUP_LABEL
2773: RETURN VARCHAR2
2774: IS
2775: BEGIN
2776: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_LABEL;
2777: END;
2778:
2779: /*
2780: * This function returns the value of the constant CS_DEM_LEVEL_CLASS_CODE_LABEL

Line 2786: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL;

2782: FUNCTION GET_CLASS_CODE_LABEL
2783: RETURN VARCHAR2
2784: IS
2785: BEGIN
2786: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_LABEL;
2787: END;
2788:
2789: /*
2790: * This function returns the value of the constant CS_DEM_WORKORDER_ITEM

Line 2796: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM;

2792: FUNCTION GET_WORKORDER_ITEM
2793: RETURN VARCHAR2
2794: IS
2795: BEGIN
2796: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_WORKORDER_ITEM;
2797: END;
2798:
2799: /*
2800: * This function returns the value of the constant CS_DEM_LEVEL_ITEM_ID

Line 2856: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID;

2852: FUNCTION GET_ASSET_GROUP_ID
2853: RETURN NUMBER
2854: IS
2855: BEGIN
2856: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_ASSET_GROUP_ID;
2857: END;
2858:
2859: /*
2860: * This function returns the value of the constant CS_DEM_LEVEL_CLASS_CODE_ID

Line 2866: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID;

2862: FUNCTION GET_CLASS_CODE_ID
2863: RETURN NUMBER
2864: IS
2865: BEGIN
2866: RETURN MSD_SPF_COLLECT_HISTORY_DATA.CS_DEM_LEVEL_CLASS_CODE_ID;
2867: END;
2868:
2869: /*
2870: * This function given a source instance, will get the source category set id for the category