APPS.EDW_MAPPING_COLLECT dependencies on DBMS_LOCK

Line 3719: DBMS_LOCK.SLEEP(g_sleep_time);

3715: elsif sqlcode=-00060 then
3716: if g_debug then
3717: write_to_log_file_n('Deadlock detected. Try again after sleep');
3718: end if;
3719: DBMS_LOCK.SLEEP(g_sleep_time);
3720: goto start_update;
3721: end if;
3722: g_status:=false;
3723: g_status_message:=sqlerrm;

Line 12537: DBMS_LOCK.SLEEP(g_sleep_time);

12533: elsif sqlcode=-00060 then
12534: if g_debug then
12535: write_to_log_file_n('Deadlock detected. Try again after sleep');
12536: end if;
12537: DBMS_LOCK.SLEEP(g_sleep_time);
12538: goto start_insert;
12539: else
12540: g_status:=false;
12541: g_status_message:=sqlerrm;

Line 12670: DBMS_LOCK.SLEEP(g_sleep_time);

12666: elsif sqlcode=-00060 then
12667: if g_debug then
12668: write_to_log_file_n('Deadlock detected. Try again after sleep');
12669: end if;
12670: DBMS_LOCK.SLEEP(g_sleep_time);
12671: goto start_insert;
12672: else
12673: g_status:=false;
12674: g_status_message:=sqlerrm;