APPS.AP_LINES_UPGRADE_PKG dependencies on DBMS_LOCK

Line 2859: dbms_lock.sleep(300);

2855: /*
2856:
2857: WHILE l_child_notcomplete LOOP
2858:
2859: dbms_lock.sleep(300);
2860:
2861: l_debug_info := 'Inside Loop for checking the child request status';
2862: IF g_debug_flag = 'Y' THEN
2863: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

Line 2908: dbms_lock.sleep(300);

2904: LOOP
2905:
2906: WHILE l_child_notcomplete LOOP
2907:
2908: dbms_lock.sleep(300);
2909:
2910: l_debug_info := 'Inside Loop for checking the child request status';
2911: IF g_debug_flag = 'Y' THEN
2912: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);