DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on FND_CONCURRENT_REQUESTS

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