APPS.MSC_LAUNCH_PLAN_PK dependencies on DBMS_LOCK

Line 1947: DBMS_LOCK.SLEEP(10);

1943: INTO l_request_id
1944: FROM msc_plans
1945: WHERE plan_id = l_plan_id;
1946:
1947: DBMS_LOCK.SLEEP(10);
1948: END LOOP;
1949:
1950: -- Request_id is populated. Get the planning Mode
1951: SELECT planning_mode

Line 1987: DBMS_LOCK.SLEEP(10);

1983: INTO l_request_id
1984: FROM msc_plans
1985: WHERE plan_id = l_plan_id;
1986:
1987: DBMS_LOCK.SLEEP(10);
1988: END LOOP;
1989: END IF;
1990:
1991: --- Planner Request_id is populated

Line 2068: DBMS_LOCK.SLEEP(10);

2064: ELSIF l_dev_phase='INACTIVE' THEN
2065: EXIT WHEN l_pending_timeout_flag= 1;
2066: END IF;
2067:
2068: DBMS_LOCK.SLEEP(10);
2069:
2070: END LOOP;
2071:
2072: o_retcode:= SYS_NO;