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_CL_PRE_PROCESS dependencies on MSD_LOCAL_ID_SETUP

Line 242: select local_id from msd_local_id_setup

238: and instance = p_instance
239: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
240:
241: cursor c2 (p_instance_code varchar2) is
242: select local_id from msd_local_id_setup
243: where char1 = p_instance_code
244: -- and char2 = 'All Products'
245: and level_id = 28;
246:

Line 516: -- insert into msd_local_id_setup

512: IF lv_all_prd_pk = 0 THEN --Renamed 'lv_sr_level_pk' to 'lv_all_prd_pk'.
513:
514: lv_all_prd_pk := msd_sr_util.get_all_prd_pk; -- Inserting 'All Products' records with sr_level_pk using function msd_sr_util.get_all_prd_pk(lv_all_prd_pk= -1)
515:
516: -- insert into msd_local_id_setup
517:
518: INSERT INTO msd_local_id_setup
519: (local_id,
520: instance_id,

Line 518: INSERT INTO msd_local_id_setup

514: lv_all_prd_pk := msd_sr_util.get_all_prd_pk; -- Inserting 'All Products' records with sr_level_pk using function msd_sr_util.get_all_prd_pk(lv_all_prd_pk= -1)
515:
516: -- insert into msd_local_id_setup
517:
518: INSERT INTO msd_local_id_setup
519: (local_id,
520: instance_id,
521: level_id,
522: char1,

Line 1160: select local_id from msd_local_id_setup

1156: lv_error_text VARCHAR2(250);
1157: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1158:
1159: cursor c1 (p_instance_code varchar2) is
1160: select local_id from msd_local_id_setup
1161: where char1 = p_instance_code
1162: -- and char2 = 'All Demand Classes'
1163: and level_id = 40;
1164:

Line 1238: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup

1234:
1235: lv_all_dcs_pk := msd_sr_util.get_all_dcs_pk; -- Insert 'All Demand Classes' records with sr_level_pk as -6
1236: lv_all_dcs_desc := msd_sr_util.get_all_dcs_desc; -- Calling fuction - msd_sr_util.get_all_dcs_desc, to fetch the level value 'All Demand Classes'
1237:
1238: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup
1239: (local_id,
1240: instance_id,
1241: level_id,
1242: char1,

Line 1665: -- Now derive sr_level_pk from the msd_local_id_setup

1661: CLOSE c3;
1662:
1663: END IF; --IF (lv_instance_type <> G_INS_OTHER) THEN
1664:
1665: -- Now derive sr_level_pk from the msd_local_id_setup
1666: v_sql_stmt := 08;
1667: lv_return := MSC_ST_UTIL.DERIVE_SR_LEVEL_PK
1668: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1669: p_level_val_col => 'LEVEL_VALUE',

Line 1721: INSERT INTO msd_local_id_setup

1717:
1718: -- Insert into the LID table this new level_value
1719:
1720: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1721: INSERT INTO msd_local_id_setup
1722: (local_id,
1723: instance_id,
1724: level_id,
1725: data_source_type,

Line 2156: select local_id from msd_local_id_setup

2152: and instance = p_instance
2153: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
2154:
2155: cursor c4 (p_instance_code varchar2) is
2156: select local_id from msd_local_id_setup
2157: where char1 = p_instance_code
2158: -- and char2 = 'All Demand Classes'
2159: and level_id = 40;
2160: Bug3749959 */

Line 2272: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup

2268: IF lv_all_dcs_pk = 0 THEN --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
2269:
2270: lv_all_dcs_pk := msd_sr_util.get_all_dcs_pk; -- Fetching the SR_LEVEL_PK for 'ALL Demand Classes' level value from function - msd_sr_util.get_all_dcs_pk
2271:
2272: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup
2273: (local_id,
2274: instance_id,
2275: level_id,
2276: char1,

Line 3045: select local_id from msd_local_id_setup

3041: and instance = p_instance
3042: and SR_LEVEL_PK = to_char(v_null_pk); --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
3043:
3044: cursor c4 (p_instance_code varchar2) is
3045: select local_id from msd_local_id_setup
3046: where char1 = p_instance_code
3047: -- and char2 = 'All Demand Classes'
3048: and level_id = 40;
3049: Bug3749959 */

Line 3162: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup

3158: IF lv_all_dcs_pk = 0 THEN --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
3159:
3160: lv_all_dcs_pk := msd_sr_util.get_all_dcs_pk; -- Fetching the SR_LEVEL_PK for 'ALL Demand Classes' level value from function - msd_sr_util.get_all_dcs_pk
3161:
3162: INSERT INTO msd_local_id_setup -- insert into msd_local_id_setup
3163: (local_id,
3164: instance_id,
3165: level_id,
3166: char1,

Line 3933: select local_id from msd_local_id_setup

3929: and instance = p_instance
3930: and SR_LEVEL_PK = to_char(v_null_pk);
3931:
3932: cursor c4 (p_instance_code varchar2) is -- This cursor is added to find whether the level value 'All Demand Classes' exist alreday or not. --Bug 3749959
3933: select local_id from msd_local_id_setup
3934: where char1 = p_instance_code
3935: -- and char2 = 'All Demand Classes'
3936: and level_id = 40;
3937: Bug3749959 */

Line 4048: INSERT INTO msd_local_id_setup --Inserting the level value 'All Demand Classes' in MSD_LOCAL_ID_SETUP.

4044: IF lv_all_dcs_pk = 0 THEN
4045:
4046: lv_all_dcs_pk := msd_sr_util.get_all_dcs_pk; -- Fetching the SR_LEVEL_PK for 'ALL Demand Classes' level value from function - msd_sr_util.get_all_dcs_pk
4047:
4048: INSERT INTO msd_local_id_setup --Inserting the level value 'All Demand Classes' in MSD_LOCAL_ID_SETUP.
4049: (local_id,
4050: instance_id,
4051: level_id,
4052: char1,