APPS.CN_PROC_BATCHES_PKG dependencies on DBMS_LOCK

Line 2299: DBMS_LOCK.sleep(l_sleep_time);

2295: NULL;
2296: ELSIF(l_completed_populate_count = x_batch_total AND l_completed_calculate_count = 0) THEN
2297: NULL;
2298: ELSE
2299: DBMS_LOCK.sleep(l_sleep_time);
2300: END IF;
2301: */
2302:
2303: cn_message_pkg.debug(

Line 2318: DBMS_LOCK.sleep(l_sleep_time);

2314: cn_message_pkg.debug('A new request has been submitted.. Lets check once more whether any other request has completed.');
2315: l_new_request_submitted := FALSE;
2316: ELSE
2317: cn_message_pkg.debug('There is no change evident in this iteration. Therefore sleep for ' || l_sleep_time);
2318: DBMS_LOCK.sleep(l_sleep_time);
2319: END IF;
2320:
2321: FOR i IN 1 .. x_batch_total LOOP
2322: primary_ptr := l_process_order(i);

Line 2900: DBMS_LOCK.sleep(l_sleep_time);

2896: NULL;
2897: ELSIF(l_completed_populate_count = g_batch_total AND l_completed_calculate_count = 0) THEN
2898: NULL;
2899: ELSE
2900: DBMS_LOCK.sleep(l_sleep_time);
2901: END IF;
2902: */
2903:
2904: cn_message_pkg.debug(

Line 2919: DBMS_LOCK.sleep(l_sleep_time);

2915: cn_message_pkg.debug('A new request has been submitted.. Lets check once more whether any other request has completed.');
2916: l_new_request_submitted := FALSE;
2917: ELSE
2918: cn_message_pkg.debug('There is no change evident in this iteration. Therefore sleep for ' || l_sleep_time);
2919: DBMS_LOCK.sleep(l_sleep_time);
2920: END IF;
2921:
2922: END LOOP;
2923: