APPS.MSC_REL_PLAN_PUB dependencies on MSC_UTIL

Line 1563: IF l_plan_type = 8 AND l_apps_ver = MSC_UTIL. G_APPS115 THEN

1559:
1560: lv_output := dbms_lock.request(lv_handle, 6, 32767, TRUE);
1561:
1562: /*
1563: IF l_plan_type = 8 AND l_apps_ver = MSC_UTIL. G_APPS115 THEN
1564: RAISE_APPLICATION_ERROR(-20000,'SRP release not supported to 11510 source',TRUE);
1565: END IF;
1566: */
1567: if(lv_output <> 0) then

Line 1630: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN

1626: /* start bug 6021045 */
1627: /* For releasing IRO (internal repair order )*/
1628: IF ( lv_wf_load_type = IRO_LOAD OR
1629: lv_wf= SYS_NO OR
1630: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1631:
1632: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1633: OPEN c_batch_number for lv_sql_stmt;
1634: FETCH c_batch_number INTO l_batch_number3;

Line 1715: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN

1711:
1712: /* Start of Bug 6051361 */
1713: IF (lv_wf_load_type = ERO_LOAD OR
1714: lv_wf= SYS_NO OR
1715: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1716:
1717: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1718: OPEN c_batch_number for lv_sql_stmt;
1719: FETCH c_batch_number INTO l_batch_number4;

Line 1944: (l_apps_ver >= MSC_UTIL.G_APPS121)) THEN

1940: END IF;
1941: -- IR/ISO resch Proj Start
1942: ELSIF ((l_plan_type in (1,2,3, 101, 102, 103)) -- 9072267
1943: AND
1944: (l_apps_ver >= MSC_UTIL.G_APPS121)) THEN
1945: -- Call Need to reschedule ISOs that have corresponding IRs in
1946: -- the same plan. Here we need to call the same OM routine as
1947: -- the DRP code for a new load_type ASCP_IREQ_RESCHED
1948: -- BUG 9072267. Need to check for RP plan types

Line 2180: l_apps_ver <= MSC_UTIL.G_APPS120)) THEN -- IR/ISO resch Proj

2176: --- PO_MASS_RESCHEDULE ---
2177: IF lv_wf= SYS_NO OR
2178: (lv_wf_load_type= PO_MASS_RESCHEDULE OR
2179: (lv_wf_load_type = DRP_REQ_RESCHED and
2180: l_apps_ver <= MSC_UTIL.G_APPS120)) THEN -- IR/ISO resch Proj
2181:
2182: arg_resched_reqs:= reschedule_po
2183: ( arg_plan_id,
2184: arg_log_org_id,

Line 2207: l_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN

2203:
2204: /*USAF*/
2205: --- CMRO_EAM_MASS_LOAD ---
2206: IF ( lv_wf_load_type = CMRO_EAM_MASS_LOAD OR lv_wf= SYS_NO OR lv_wf =3) AND
2207: l_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER THEN
2208:
2209: OPEN c_plan_type(arg_plan_id);
2210: FETCH c_plan_type INTO l_plan_type;
2211: CLOSE c_plan_type;

Line 2214: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y') THEN

2210: FETCH c_plan_type INTO l_plan_type;
2211: CLOSE c_plan_type;
2212:
2213: IF l_plan_type = 1 THEN
2214: IF(MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y') THEN
2215:
2216: load_eam_cmro_jobs( p_arg_plan_id => arg_plan_id,
2217: p_arg_log_org_id => arg_log_org_id,
2218: p_arg_org_instance => arg_org_instance,

Line 10135: and mai.APPS_VER <= MSC_UTIL.G_APPS120

10131: AND s.sr_instance_id = mai.instance_id
10132: AND ((arg_mode is null and s.load_type = PO_MASS_RESCHEDULE and s.load_type IS NOT NULL)
10133: OR (arg_mode is null
10134: and s.load_type = DRP_REQ_RESCHED
10135: and mai.APPS_VER <= MSC_UTIL.G_APPS120
10136: and s.load_type IS NOT NULL)) -- IR/ISO resch Proj
10137: AND s.last_updated_by = decode(v_msc_released_only_by_user,1,v_user_id,s.last_updated_by)
10138: and (s.releasable = RELEASABLE or s.releasable is null )
10139: and (s.batch_id = g_batch_id or (v_batch_id_populated = 2 and s.batch_id is null) )