DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 15822: FROM fnd_concurrent_requests fcr

15818: WHERE import_request_id IS NOT NULL
15819: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
15820: AND EXISTS
15821: ( SELECT 'Request Completed'
15822: FROM fnd_concurrent_requests fcr
15823: WHERE fcr.request_id = api.import_request_id
15824: AND fcr.phase_code = 'C' );
15825: -- udhenuko Bug 6823885 End
15826: --bug 5591652

Line 16680: FROM fnd_concurrent_requests fcr

16676: WHERE import_request_id IS NOT NULL
16677: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
16678: AND EXISTS
16679: ( SELECT 'Request Completed'
16680: FROM fnd_concurrent_requests fcr
16681: WHERE fcr.request_id = api.import_request_id
16682: AND fcr.phase_code = 'C' )
16683: AND org_id = nvl(p_org_id, org_id) --bug13989575
16684: AND mo_global.check_access(org_id)= 'Y' --bug13989575

Line 17599: FROM fnd_concurrent_requests fcr

17595: WHERE import_request_id IS NOT NULL
17596: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
17597: AND EXISTS
17598: ( SELECT 'Request Completed'
17599: FROM fnd_concurrent_requests fcr
17600: WHERE fcr.request_id = api.import_request_id
17601: AND fcr.phase_code = 'C' );
17602: --udhenuko Bug 6823885 End
17603: --bug 5591652