APPS.MSC_LAUNCH_PLAN_PK dependencies on DBMS_LOCK

Line 2062: DBMS_LOCK.SLEEP(10);

2058: INTO l_request_id
2059: FROM msc_plans
2060: WHERE plan_id = l_plan_id;
2061:
2062: DBMS_LOCK.SLEEP(10);
2063: END LOOP;
2064:
2065: -- Request_id is populated. Get the planning Mode
2066: SELECT planning_mode

Line 2102: DBMS_LOCK.SLEEP(10);

2098: INTO l_request_id
2099: FROM msc_plans
2100: WHERE plan_id = l_plan_id;
2101:
2102: DBMS_LOCK.SLEEP(10);
2103: END LOOP;
2104: END IF;
2105:
2106: --- Planner Request_id is populated

Line 2183: DBMS_LOCK.SLEEP(10);

2179: ELSIF l_dev_phase='INACTIVE' THEN
2180: EXIT WHEN l_pending_timeout_flag= 1;
2181: END IF;
2182:
2183: DBMS_LOCK.SLEEP(10);
2184:
2185: END LOOP;
2186:
2187: o_retcode:= SYS_NO;