DBA Data[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 3866: ,fnd_concurrent_requests fcr

3862: -- Find a failed request for a specific defintion
3863: CURSOR c_failed_req_def IS
3864: SELECT xtb.request_id, xtb.process_mode_code
3865: FROM xla_tb_logs xtb
3866: ,fnd_concurrent_requests fcr
3867: WHERE xtb.ledger_id = p_ledger_id
3868: AND xtb.definition_code = p_definition_code
3869: AND xtb.request_status_code = 'PROCESSING'
3870: AND xtb.request_id = fcr.request_id

Line 3877: ,fnd_concurrent_requests fcr

3873: -- Find requests failed for a group_id or not specific to a definition code
3874: CURSOR c_failed_req ( p_ledger_id VARCHAR2 ) IS
3875: SELECT xtb.request_id
3876: FROM xla_tb_logs xtb
3877: ,fnd_concurrent_requests fcr
3878: WHERE xtb.ledger_id = p_ledger_id
3879: AND xtb.definition_code IS NULL
3880: AND xtb.request_status_code = 'PROCESSING'
3881: AND xtb.request_id = fcr.request_id

Line 3961: ,fnd_concurrent_requests fcr

3957: DELETE xla_tb_logs xtl
3958: WHERE request_id NOT IN
3959: ( SELECT xtb.request_id
3960: FROM xla_tb_logs xtb
3961: ,fnd_concurrent_requests fcr
3962: WHERE xtb.ledger_id = p_ledger_id
3963: AND nvl(xtb.definition_code,'###') = NVL(p_definition_code,'###')
3964: AND xtb.request_status_code = 'PROCESSING'
3965: AND xtb.request_id = fcr.request_id