APPS.POS_BATCH_IMPORT_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 2108: FROM fnd_concurrent_requests fcr

2104: WHERE import_request_id IS NOT NULL
2105: AND sdh_batch_id = p_batch_id
2106: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
2107: AND EXISTS (SELECT 'Request Completed'
2108: FROM fnd_concurrent_requests fcr
2109: WHERE fcr.request_id = api.import_request_id
2110: AND fcr.phase_code = 'C');
2111:
2112: -- Updating Interface Record with request id

Line 3099: FROM fnd_concurrent_requests fcr

3095: WHERE import_request_id IS NOT NULL
3096: AND sdh_batch_id = p_batch_id
3097: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
3098: AND EXISTS (SELECT 'Request Completed'
3099: FROM fnd_concurrent_requests fcr
3100: WHERE fcr.request_id = api.import_request_id
3101: AND fcr.phase_code = 'C');
3102:
3103: -- Updating Interface Record with request id

Line 3789: FROM fnd_concurrent_requests fcr

3785: WHERE import_request_id IS NOT NULL
3786: AND sdh_batch_id = p_batch_id
3787: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
3788: AND EXISTS (SELECT 'Request Completed'
3789: FROM fnd_concurrent_requests fcr
3790: WHERE fcr.request_id = api.import_request_id
3791: AND fcr.phase_code = 'C');
3792:
3793: -- Updating Interface Record with request id

Line 4833: FROM fnd_concurrent_requests fcr

4829: WHERE import_request_id IS NOT NULL
4830: AND sdh_batch_id = p_batch_id
4831: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
4832: AND EXISTS (SELECT 'Request Completed'
4833: FROM fnd_concurrent_requests fcr
4834: WHERE fcr.request_id = api.import_request_id
4835: AND fcr.phase_code = 'C');
4836:
4837: -- Updating Interface Record with request id

Line 5601: FROM fnd_concurrent_requests fcr

5597: WHERE import_request_id IS NOT NULL
5598: AND sdh_batch_id = p_batch_id
5599: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
5600: AND EXISTS (SELECT 'Request Completed'
5601: FROM fnd_concurrent_requests fcr
5602: WHERE fcr.request_id = api.import_request_id
5603: AND fcr.phase_code = 'C');
5604:
5605: -- Updating Interface Record with request id

Line 7412: FROM fnd_concurrent_requests fcr

7408: WHERE request_id IS NOT NULL
7409: AND batch_id = p_batch_id
7410: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
7411: AND EXISTS (SELECT 'Request Completed'
7412: FROM fnd_concurrent_requests fcr
7413: WHERE fcr.request_id = api.request_id
7414: AND fcr.phase_code = 'C');
7415:
7416: UPDATE pos_party_tax_reg_int api

Line 7422: FROM fnd_concurrent_requests fcr

7418: WHERE request_id IS NOT NULL
7419: AND batch_id = p_batch_id
7420: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
7421: AND EXISTS (SELECT 'Request Completed'
7422: FROM fnd_concurrent_requests fcr
7423: WHERE fcr.request_id = api.request_id
7424: AND fcr.phase_code = 'C');
7425:
7426: UPDATE pos_fiscal_class_int api

Line 7432: FROM fnd_concurrent_requests fcr

7428: WHERE request_id IS NOT NULL
7429: AND batch_id = p_batch_id
7430: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
7431: AND EXISTS (SELECT 'Request Completed'
7432: FROM fnd_concurrent_requests fcr
7433: WHERE fcr.request_id = api.request_id
7434: AND fcr.phase_code = 'C');
7435:
7436: -- Updating Interface Record with request id

Line 8157: FROM fnd_concurrent_requests fcr

8153: WHERE request_id IS NOT NULL
8154: AND batch_id = p_batch_id
8155: AND nvl(interface_status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
8156: AND EXISTS (SELECT 'Request Completed'
8157: FROM fnd_concurrent_requests fcr
8158: WHERE fcr.request_id = api.request_id
8159: AND fcr.phase_code = 'C');
8160:
8161: UPDATE pos_bank_accnt_owners_int api

Line 8167: FROM fnd_concurrent_requests fcr

8163: WHERE request_id IS NOT NULL
8164: AND batch_id = p_batch_id
8165: AND nvl(interface_status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')
8166: AND EXISTS (SELECT 'Request Completed'
8167: FROM fnd_concurrent_requests fcr
8168: WHERE fcr.request_id = api.request_id
8169: AND fcr.phase_code = 'C');
8170:
8171: -- Updating Interface Record with request id