APPS.IGIRCBJP dependencies on FND_CONCURRENT_REQUESTS

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 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 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 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;