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