APPS.AP_APPROVAL_PKG dependencies on FND_CONCURRENT

Line 9408: FROM fnd_concurrent_requests fcr

9404: SET validation_request_id = NULL
9405: WHERE validation_request_id IS NOT NULL
9406: AND EXISTS
9407: ( SELECT 'Request Completed'
9408: FROM fnd_concurrent_requests fcr
9409: WHERE fcr.request_id = api.validation_request_id
9410: AND fcr.phase_code = 'C' ); */
9411:
9412: UPDATE ap_invoices api

Line 9416: FROM fnd_concurrent_requests fcr

9412: UPDATE ap_invoices api
9413: SET validation_request_id = NULL
9414: WHERE validation_request_id IN
9415: ( SELECT request_id
9416: FROM fnd_concurrent_requests fcr
9417: WHERE fcr.concurrent_program_id = ( SELECT concurrent_program_id
9418: FROM fnd_concurrent_programs fcp
9419: WHERE fcp.application_id = 200
9420: AND fcp.concurrent_program_name = 'APPRVL'

Line 9418: FROM fnd_concurrent_programs fcp

9414: WHERE validation_request_id IN
9415: ( SELECT request_id
9416: FROM fnd_concurrent_requests fcr
9417: WHERE fcr.concurrent_program_id = ( SELECT concurrent_program_id
9418: FROM fnd_concurrent_programs fcp
9419: WHERE fcp.application_id = 200
9420: AND fcp.concurrent_program_name = 'APPRVL'
9421: )
9422: AND fcr.phase_code = 'C');

Line 9425: /* Following are the status code in fnd_concurrent_requests

9421: )
9422: AND fcr.phase_code = 'C');
9423: /* Bug 12712125 starts */
9424:
9425: /* Following are the status code in fnd_concurrent_requests
9426: 'X' Terminated
9427: 'S' Suspended
9428: 'D' Cancelled
9429: 'G' Warning

Line 10168: --bug 7512258 removed call to FND_CONCURRENT.SET_COMPLETION_STATUS

10164: END IF;
10165: ---------------------------------------------------------------------
10166:
10167: l_conc_status := 'WARNING';
10168: --bug 7512258 removed call to FND_CONCURRENT.SET_COMPLETION_STATUS
10169:
10170: ---------------------------------------------------------------------
10171: -- Print_Debug (l_api_name, 'Begin Single Mode');
10172: IF g_debug_mode = 'Y' THEN

Line 10662: --bug 7512258 removed call to FND_CONCURRENT.SET_COMPLETION_STATUS

10658: l_blk_err_dist := 'Y';
10659:
10660: --Bug9436217
10661:
10662: --bug 7512258 removed call to FND_CONCURRENT.SET_COMPLETION_STATUS
10663:
10664: ---------------------------------------------------------------------
10665: -- Print_Debug (l_api_name, 'Begin Single Mode');
10666: IF g_debug_mode = 'Y' THEN

Line 11120: l_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS(l_conc_status,l_errbuf);

11116: END IF;
11117: ---------------------------------------------------------------------
11118: IF l_conc_status = 'WARNING' THEN
11119: l_errbuf := 'Warning/Error message to be displayed';
11120: l_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS(l_conc_status,l_errbuf);
11121: END IF;
11122:
11123:
11124: ---------------------------------------------------------------------