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_SR_UTIL

Line 7: v_null_pk NUMBER := msd_sr_util.get_null_pk; --Use this variable to assign SR_LEVEL_PK for the level value 'Others' in ALL DIMENSIONS.

3:
4:
5: v_sql_stmt PLS_INTEGER;--Holds the DML statement no used for error logging.
6: v_plan_per_profile NUMBER:=nvl(fnd_profile.value('MSD_PLANNING_PERCENTAGE'), G_NO_PLAN_PERCENTAGE);
7: v_null_pk NUMBER := msd_sr_util.get_null_pk; --Use this variable to assign SR_LEVEL_PK for the level value 'Others' in ALL DIMENSIONS.
8:
9:
10: --========================PROCEDURES/FUNCTION=================
11:

Line 460: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'

456: CLOSE c1;
457:
458: IF lv_other_exist = 0 THEN
459:
460: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
461: lv_all_prd_desc := msd_sr_util.get_all_prd_desc; --Calling fuction - msd_sr_util.get_all_prd_desc, to fetch the level value 'All Products'
462:
463: INSERT INTO MSD_ST_LEVEL_VALUES
464: (INSTANCE ,

Line 461: lv_all_prd_desc := msd_sr_util.get_all_prd_desc; --Calling fuction - msd_sr_util.get_all_prd_desc, to fetch the level value 'All Products'

457:
458: IF lv_other_exist = 0 THEN
459:
460: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
461: lv_all_prd_desc := msd_sr_util.get_all_prd_desc; --Calling fuction - msd_sr_util.get_all_prd_desc, to fetch the level value 'All Products'
462:
463: INSERT INTO MSD_ST_LEVEL_VALUES
464: (INSTANCE ,
465: LEVEL_ID,

Line 485: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc

481: PROGRAM_UPDATE_DATE )
482: VALUES
483: (p_instance_id,
484: 2,
485: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc
486: to_char(v_null_pk), --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
487: NULL,
488: NULL,
489: NULL,

Line 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)

510: CLOSE c2;
511:
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

Line 533: lv_all_prd_desc, --Using the value fetched from function - msd_sr_util.get_all_prd_desc

529: (lv_all_prd_pk, --Using the value lv_all_prd_pk fetched above.
530: p_instance_id,
531: 28,
532: lv_instance_code,
533: lv_all_prd_desc, --Using the value fetched from function - msd_sr_util.get_all_prd_desc
534: sysdate,
535: -1,
536: sysdate,
537: -1);

Line 564: lv_all_prd_desc, --Using the value fetched from function - msd_sr_util.get_all_prd_desc

560: PROGRAM_UPDATE_DATE )
561: VALUES
562: (p_instance_id,
563: 28,
564: lv_all_prd_desc, --Using the value fetched from function - msd_sr_util.get_all_prd_desc
565: lv_all_prd_pk, --Inserting lv_all_prd_pk(-1) as sr_level_pk instead of '-7771'.
566: NULL,
567: NULL,
568: NULL,

Line 1235: lv_all_dcs_pk := msd_sr_util.get_all_dcs_pk; -- Insert 'All Demand Classes' records with sr_level_pk as -6

1231: CLOSE c1;
1232:
1233: IF lv_all_dcs_pk = 0 THEN --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
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,

Line 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'

1232:
1233: IF lv_all_dcs_pk = 0 THEN --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
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,

Line 1253: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

1249: (lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
1250: p_instance_id,
1251: 40,
1252: p_instance_code,
1253: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
1254: sysdate,
1255: -1,
1256: sysdate,
1257: -1);

Line 1281: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

1277: PROGRAM_UPDATE_DATE )
1278: VALUES
1279: (p_instance_id,
1280: 40,
1281: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
1282: lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
1283: NULL,
1284: NULL,
1285: NULL,

Line 2208: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'

2204: CLOSE c2;
2205:
2206: IF ( lb_rowid1.COUNT <> 0 ) THEN
2207:
2208: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
2209: 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'
2210:
2211: v_sql_stmt := 05;
2212: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST

Line 2209: 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'

2205:
2206: IF ( lb_rowid1.COUNT <> 0 ) THEN
2207:
2208: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
2209: 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'
2210:
2211: v_sql_stmt := 05;
2212: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
2213: UPDATE msd_st_booking_data

Line 2214: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc

2210:
2211: v_sql_stmt := 05;
2212: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
2213: UPDATE msd_st_booking_data
2214: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
2215: WHERE rowid = lb_rowid1(j);
2216:
2217:
2218: OPEN c3(p_instance_id);

Line 2245: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc

2241: PROGRAM_UPDATE_DATE )
2242: VALUES
2243: (p_instance_id,
2244: 34,
2245: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc
2246: to_char(v_null_pk), --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
2247: NULL,
2248: NULL,
2249: NULL,

Line 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

2266: CLOSE c4;
2267:
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,

Line 2287: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

2283: (lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
2284: p_instance_id,
2285: 40,
2286: p_instance_code,
2287: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
2288: sysdate,
2289: -1,
2290: sysdate,
2291: -1);

Line 2318: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

2314: PROGRAM_UPDATE_DATE )
2315: VALUES
2316: (p_instance_id,
2317: 40,
2318: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
2319: lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
2320: NULL,
2321: NULL,
2322: NULL,

Line 3097: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'

3093: CLOSE c2;
3094:
3095: IF ( lb_rowid1.COUNT <> 0 ) THEN
3096:
3097: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
3098: 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'
3099:
3100: v_sql_stmt := 05;
3101: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST

Line 3098: 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'

3094:
3095: IF ( lb_rowid1.COUNT <> 0 ) THEN
3096:
3097: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
3098: 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'
3099:
3100: v_sql_stmt := 05;
3101: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
3102: UPDATE msd_st_shipment_data

Line 3103: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc

3099:
3100: v_sql_stmt := 05;
3101: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
3102: UPDATE msd_st_shipment_data
3103: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
3104: WHERE rowid = lb_rowid1(j);
3105:
3106:
3107:

Line 3135: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc

3131: PROGRAM_UPDATE_DATE )
3132: VALUES
3133: (p_instance_id,
3134: 34,
3135: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc
3136: to_char(v_null_pk), --Using global variable v_null_pk insteda of hardcoding -777 at multiple places.
3137: NULL,
3138: NULL,
3139: NULL,

Line 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

3156: CLOSE c4;
3157:
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,

Line 3177: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

3173: (lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
3174: p_instance_id,
3175: 40,
3176: p_instance_code,
3177: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
3178: sysdate,
3179: -1,
3180: sysdate,
3181: -1);

Line 3208: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

3204: PROGRAM_UPDATE_DATE )
3205: VALUES
3206: (p_instance_id,
3207: 40,
3208: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
3209: lv_all_dcs_pk, --Renamed 'lv_sr_level_pk' to 'lv_all_dcs_pk'.
3210: NULL,
3211: NULL,
3212: NULL,

Line 3983: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'

3979: CLOSE c2;
3980:
3981: IF ( lb_rowid1.COUNT <> 0 ) THEN -- If records exist for which, demand class level values is not provided.
3982:
3983: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
3984: 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'
3985:
3986: v_sql_stmt := 05;
3987: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST -- Update the demand class level value column with 'Other' as Demand Class Level Value.

Line 3984: 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'

3980:
3981: IF ( lb_rowid1.COUNT <> 0 ) THEN -- If records exist for which, demand class level values is not provided.
3982:
3983: lv_other_desc := msd_sr_util.get_null_desc; --Calling fuction - msd_sr_util.get_null_desc, to fetch the level value 'Others'
3984: 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'
3985:
3986: v_sql_stmt := 05;
3987: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST -- Update the demand class level value column with 'Other' as Demand Class Level Value.
3988: UPDATE msd_st_mfg_forecast

Line 3989: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc

3985:
3986: v_sql_stmt := 05;
3987: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST -- Update the demand class level value column with 'Other' as Demand Class Level Value.
3988: UPDATE msd_st_mfg_forecast
3989: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
3990: WHERE rowid = lb_rowid1(j);
3991:
3992:
3993: OPEN c3(p_instance_id);

Line 4021: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc

4017: PROGRAM_UPDATE_DATE )
4018: VALUES
4019: (p_instance_id,
4020: 34,
4021: lv_other_desc, --Using the value fetched from function - msd_sr_util.get_null_desc
4022: to_char(v_null_pk),
4023: NULL,
4024: NULL,
4025: NULL,

Line 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

4042: CLOSE c4;
4043:
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,

Line 4063: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

4059: (lv_all_dcs_pk,
4060: p_instance_id,
4061: 40,
4062: p_instance_code,
4063: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
4064: sysdate,
4065: -1,
4066: sysdate,
4067: -1);

Line 4094: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc

4090: PROGRAM_UPDATE_DATE )
4091: VALUES
4092: (p_instance_id,
4093: 40,
4094: lv_all_dcs_desc, --Using the value fetched from function - msd_sr_util.get_all_dcs_desc
4095: lv_all_dcs_pk,
4096: NULL,
4097: NULL,
4098: NULL,