APPS.CN_PROC_BATCHES_PKG dependencies on FND_CONCURRENT

Line 2287: * This can lead to bypassing SLEEP and calling FND_CONCURRENT.GET_REQUEST_STATUS

2283:
2284: WHILE unfinished LOOP
2285: /*
2286: * Bug#7265394 - Not sure whats been implemented here.
2287: * This can lead to bypassing SLEEP and calling FND_CONCURRENT.GET_REQUEST_STATUS
2288: * continuously. Therefore rewrote the logic in a different way.
2289: *
2290: IF (l_completed_revert_count = x_batch_total AND l_completed_classify_count = 0) THEN
2291: NULL;

Line 2326: fnd_concurrent.get_request_status(

2322: primary_ptr := l_process_order(i);
2323:
2324: IF (l_primary_request_stack(primary_ptr) IS NOT NULL) THEN
2325: l_call_status :=
2326: fnd_concurrent.get_request_status(
2327: request_id => l_primary_request_stack(primary_ptr)
2328: , phase => l_dummy
2329: , status => l_dummy
2330: , dev_phase => l_dev_phase

Line 2507: l_call_status := fnd_concurrent.cancel_request(l_primary_request_stack(i), l_dummy);

2503: , 'Cancelling request: ' || l_primary_request_stack(i)
2504: );
2505: END IF;
2506:
2507: l_call_status := fnd_concurrent.cancel_request(l_primary_request_stack(i), l_dummy);
2508: cn_message_pkg.DEBUG('Cancelling request (ID=' || l_primary_request_stack(i)
2509: || ' Status=' || l_dummy || ')');
2510: END IF;
2511: END LOOP;

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 2587: FROM fnd_concurrent_programs

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
2588: WHERE application_id = 283 AND concurrent_program_name = 'BATCH_RUNNER')
2589: AND fcr.phase_code = 'C'
2590: AND fcr.status_code <> 'C'
2591: AND EXISTS(

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

Line 2714: fnd_concurrent.get_request_status(

2710: primary_ptr := l_process_order(i);
2711:
2712: IF (l_primary_request_stack(primary_ptr) IS NOT NULL) THEN
2713: l_call_status :=
2714: fnd_concurrent.get_request_status(
2715: request_id => l_primary_request_stack(primary_ptr)
2716: , phase => l_dummy1
2717: , status => l_dummy2
2718: , dev_phase => l_dev_phase

Line 2888: * This can lead to bypassing SLEEP and calling FND_CONCURRENT.GET_REQUEST_STATUS

2884: END LOOP; -- for primary_pointer in 1..g_batch_total
2885:
2886: /*
2887: * Bug#7265394 - Not sure whats been implemented here.
2888: * This can lead to bypassing SLEEP and calling FND_CONCURRENT.GET_REQUEST_STATUS
2889: * continuously. Therefore rewrote the logic in a different way.
2890: *
2891: IF (l_completed_revert_count = g_batch_total AND l_completed_classify_count = 0) THEN
2892: NULL;

Line 2948: l_call_status := fnd_concurrent.cancel_request(l_primary_request_stack(i), l_dummy1);

2944: , 'Cancelling request: ' || l_primary_request_stack(i)
2945: );
2946: END IF;
2947:
2948: l_call_status := fnd_concurrent.cancel_request(l_primary_request_stack(i), l_dummy1);
2949: cn_message_pkg.DEBUG(
2950: 'Cancelling request (ID=' || l_primary_request_stack(i) || ' Status=' || l_dummy1
2951: || ')'
2952: );