APPS.MSC_REL_PLAN_PUB dependencies on MSC_UTIL

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

1290:
1291: lv_output := dbms_lock.request(lv_handle, 6, 32767, TRUE);
1292:
1293: /*
1294: IF l_plan_type = 8 AND l_apps_ver = MSC_UTIL. G_APPS115 THEN
1295: RAISE_APPLICATION_ERROR(-20000,'SRP release not supported to 11510 source',TRUE);
1296: END IF;
1297: */
1298: if(lv_output <> 0) then

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

1340: /* start bug 6021045 */
1341: /* For releasing IRO (internal repair order )*/
1342: IF ( lv_wf_load_type = IRO_LOAD OR
1343: lv_wf= SYS_NO OR
1344: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1345:
1346: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1347: OPEN c_batch_number for lv_sql_stmt;
1348: FETCH c_batch_number INTO l_batch_number3;

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

1426:
1427: /* Start of Bug 6051361 */
1428: IF (lv_wf_load_type = ERO_LOAD OR
1429: lv_wf= SYS_NO OR
1430: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1431:
1432: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1433: OPEN c_batch_number for lv_sql_stmt;
1434: FETCH c_batch_number INTO l_batch_number4;

Line 1649: ELSIF ((l_plan_type in (1,2,3)) AND (l_apps_ver >= MSC_UTIL.G_APPS121)) THEN

1645:
1646:
1647: END IF;
1648: -- IR/ISO resch Proj Start
1649: ELSIF ((l_plan_type in (1,2,3)) AND (l_apps_ver >= MSC_UTIL.G_APPS121)) THEN
1650: -- Call Need to reschedule ISOs that have corresponding IRs in
1651: -- the same plan. Here we need to call the same OM routine as
1652: -- the DRP code for a new load_type ASCP_IREQ_RESCHED
1653:

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

1849: --- PO_MASS_RESCHEDULE ---
1850: IF lv_wf= SYS_NO OR
1851: (lv_wf_load_type= PO_MASS_RESCHEDULE OR
1852: (lv_wf_load_type = DRP_REQ_RESCHED and
1853: l_apps_ver <= MSC_UTIL.G_APPS120)) THEN -- IR/ISO resch Proj
1854:
1855: arg_resched_reqs:= reschedule_po
1856: ( arg_plan_id,
1857: arg_log_org_id,

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

9262: AND s.sr_instance_id = mai.instance_id
9263: AND ((arg_mode is null and s.load_type = PO_MASS_RESCHEDULE and s.load_type IS NOT NULL)
9264: OR (arg_mode is null
9265: and s.load_type = DRP_REQ_RESCHED
9266: and mai.APPS_VER <= MSC_UTIL.G_APPS120
9267: and s.load_type IS NOT NULL)) -- IR/ISO resch Proj
9268: AND s.last_updated_by = decode(v_msc_released_only_by_user,1,v_user_id,s.last_updated_by)
9269: and (s.releasable = RELEASABLE or s.releasable is null )
9270: and (s.batch_id = g_batch_id or (v_batch_id_populated = 2 and s.batch_id is null) )