DBA Data[Home] [Help]

APPS.CN_PROC_BATCHES_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 2583: FROM fnd_concurrent_requests fcr

2579: l_new_request_submitted BOOLEAN;
2580:
2581: CURSOR parent_request IS
2582: SELECT MAX(fcr.parent_request_id)
2583: FROM fnd_concurrent_requests fcr
2584: WHERE fcr.program_application_id = 283
2585: AND fcr.concurrent_program_id =
2586: (SELECT concurrent_program_id
2587: FROM fnd_concurrent_programs

Line 2599: FROM fnd_concurrent_requests fcr

2595: AND physical_batch_id = fcr.argument4);
2596:
2597: CURSOR success_phase(p_physical_batch_id NUMBER) IS
2598: SELECT fcr.argument3 phase
2599: FROM fnd_concurrent_requests fcr
2600: WHERE fcr.parent_request_id = l_parent_request_id
2601: AND fcr.phase_code = 'C'
2602: AND fcr.status_code = 'C'
2603: AND argument4 = p_physical_batch_id