APPS.IGIRCBJP dependencies on FND_CONCURRENT

Line 2459: UPDATE fnd_concurrent_requests

2455: if nvl(l_DetAccRequestId, 0) > 0
2456: OR nvl(l_DetCatRequestId, 0) > 0
2457: OR nvl(l_SumAccRequestId, 0) > 0
2458: OR nvl(l_SumCatRequestId, 0) > 0 THEN
2459: UPDATE fnd_concurrent_requests
2460: SET has_sub_request = 'Y'
2461: -- , status_code = 'W'-- This does not work! The parent
2462: -- request restarts ad infinitum if
2463: -- status_code set to 'W' (Paused).

Line 2470: UPDATE fnd_concurrent_requests

2466: --
2467: -- Update each child in turn, waiting for each to complete.
2468: --
2469: if nvl(l_DetAccRequestId, 0) > 0 THEN
2470: UPDATE fnd_concurrent_requests
2471: SET status_code = 'I'
2472: WHERE request_id = l_DetAccRequestId
2473: AND status_code = 'Z';
2474: commit;

Line 2475: l_wait := fnd_concurrent.wait_for_request

2471: SET status_code = 'I'
2472: WHERE request_id = l_DetAccRequestId
2473: AND status_code = 'Z';
2474: commit;
2475: l_wait := fnd_concurrent.wait_for_request
2476: ( l_DetAccRequestId
2477: , 30
2478: , 0
2479: , l_phase

Line 2488: UPDATE fnd_concurrent_requests

2484: );
2485: end if;
2486: --
2487: if nvl(l_DetCatRequestId, 0) > 0 THEN
2488: UPDATE fnd_concurrent_requests
2489: SET status_code = 'I'
2490: WHERE request_id = l_DetCatRequestId
2491: AND status_code = 'Z';
2492: commit;

Line 2493: l_wait := fnd_concurrent.wait_for_request

2489: SET status_code = 'I'
2490: WHERE request_id = l_DetCatRequestId
2491: AND status_code = 'Z';
2492: commit;
2493: l_wait := fnd_concurrent.wait_for_request
2494: ( l_DetCatRequestId
2495: , 30
2496: , 0
2497: , l_phase

Line 2506: UPDATE fnd_concurrent_requests

2502: );
2503: end if;
2504: --
2505: if nvl(l_SumAccRequestId, 0) > 0 THEN
2506: UPDATE fnd_concurrent_requests
2507: SET status_code = 'I'
2508: WHERE request_id = l_SumAccRequestId
2509: AND status_code = 'Z';
2510: commit;

Line 2511: l_wait := fnd_concurrent.wait_for_request

2507: SET status_code = 'I'
2508: WHERE request_id = l_SumAccRequestId
2509: AND status_code = 'Z';
2510: commit;
2511: l_wait := fnd_concurrent.wait_for_request
2512: ( l_SumAccRequestId
2513: , 30
2514: , 0
2515: , l_phase

Line 2524: UPDATE fnd_concurrent_requests

2520: );
2521: end if;
2522: --
2523: if nvl(l_SumCatRequestId, 0) > 0 THEN
2524: UPDATE fnd_concurrent_requests
2525: SET status_code = 'I'
2526: WHERE request_id = l_SumCatRequestId
2527: AND status_code = 'Z';
2528: commit;

Line 2529: l_wait := fnd_concurrent.wait_for_request

2525: SET status_code = 'I'
2526: WHERE request_id = l_SumCatRequestId
2527: AND status_code = 'Z';
2528: commit;
2529: l_wait := fnd_concurrent.wait_for_request
2530: ( l_SumCatRequestId
2531: , 30
2532: , 0
2533: , l_phase