eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_INTERFACES dependencies on XDP_ADAPTER_JOB_QUEUE

Line 2079: from xdp_adapter_job_queue

2075: IF lv_in_fa_q = 'N' THEN
2076: savepoint lv_job_tag;
2077: begin
2078: select job_id into lv_id
2079: from xdp_adapter_job_queue
2080: where
2081: wf_item_type = lv_item_type and
2082: wf_item_key = lv_item_key
2083: for update nowait ;

Line 2084: delete from xdp_adapter_job_queue

2080: where
2081: wf_item_type = lv_item_type and
2082: wf_item_key = lv_item_key
2083: for update nowait ;
2084: delete from xdp_adapter_job_queue
2085: where job_id = lv_id ;
2086: commit;
2087: exception
2088: when resource_busy or no_data_found then

Line 3493: FROM xdp_adapter_job_queue

3489:
3490: BEGIN
3491: SELECT fa_instance_id
3492: INTO lv_fa_instance_id
3493: FROM xdp_adapter_job_queue
3494: WHERE fa_instance_id = p_fa_instance_id
3495: AND wf_item_type = p_fa_wf_item_type
3496: AND wf_item_key = p_fa_wf_item_key
3497: FOR UPDATE NOWAIT;

Line 3501: dbg_msg := ('Aquired Lock Deleting From XDP_ADAPTER_JOB_QUEUE ');

3497: FOR UPDATE NOWAIT;
3498:
3499: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
3500: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_FA')) THEN
3501: dbg_msg := ('Aquired Lock Deleting From XDP_ADAPTER_JOB_QUEUE ');
3502: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_FA', dbg_msg);
3504: END IF;
3505: END IF;

Line 3508: DELETE from xdp_adapter_job_queue

3504: END IF;
3505: END IF;
3506: END IF;
3507:
3508: DELETE from xdp_adapter_job_queue
3509: WHERE fa_instance_id = p_fa_instance_id
3510: AND wf_item_type = p_fa_wf_item_type
3511: AND wf_item_key = p_fa_wf_item_key;
3512:

Line 3515: dbg_msg := ('Deleted From XDP_ADAPTER_JOB_QUEUE Calling UPDATE_XDP_FA_INSTANCE_STATUS ');

3511: AND wf_item_key = p_fa_wf_item_key;
3512:
3513: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
3514: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_FA')) THEN
3515: dbg_msg := ('Deleted From XDP_ADAPTER_JOB_QUEUE Calling UPDATE_XDP_FA_INSTANCE_STATUS ');
3516: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3517: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_FA', dbg_msg);
3518: END IF;
3519: END IF;