APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_TX_XE_COPIES

Line 481: FROM iby_fndcpt_tx_xe_copies

477:
478: CURSOR c_xe_copies(ci_x_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
479: IS
480: SELECT COUNT(copy_trxn_extension_id)
481: FROM iby_fndcpt_tx_xe_copies
482: WHERE (source_trxn_extension_id = ci_x_id);
483:
484: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Tx_Extension_Copy_Count';
485: BEGIN

Line 2071: DELETE iby_fndcpt_tx_xe_copies

2067: ELSE
2068: SAVEPOINT Delete_Transaction_Extension;
2069:
2070: -- delete all links to its source extensions
2071: DELETE iby_fndcpt_tx_xe_copies
2072: WHERE (copy_trxn_extension_id = p_entity_id);
2073:
2074: DELETE iby_fndcpt_tx_extensions
2075: WHERE (trxn_extension_id = p_entity_id);

Line 2624: INSERT INTO iby_fndcpt_tx_xe_copies

2620:
2621: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
2622:
2623: -- associate the merged copy with all its sources
2624: INSERT INTO iby_fndcpt_tx_xe_copies
2625: (source_trxn_extension_id, copy_trxn_extension_id,
2626: created_by, creation_date, last_updated_by, last_update_date,
2627: last_update_login, object_version_number
2628: )

Line 2936: FROM iby_fndcpt_tx_xe_copies cp, iby_fndcpt_tx_extensions ex

2932: ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
2933: )
2934: IS
2935: SELECT cp.source_trxn_extension_id, ex.instr_code_sec_segment_id, ex.instrument_security_code
2936: FROM iby_fndcpt_tx_xe_copies cp, iby_fndcpt_tx_extensions ex
2937: WHERE cp.source_trxn_extension_id = ex.trxn_extension_id
2938: START WITH cp.copy_trxn_extension_id = ci_trxn_extension_id
2939: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
2940:

Line 3226: FROM iby_fndcpt_tx_xe_copies

3222: last_update_login = fnd_global.login_id,
3223: object_version_number = object_version_number + 1
3224: WHERE trxn_extension_id IN
3225: (SELECT source_trxn_extension_id
3226: FROM iby_fndcpt_tx_xe_copies
3227: START WITH copy_trxn_extension_id = p_trxn_entity_id
3228: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id
3229: );
3230:

Line 3337: FROM iby_fndcpt_tx_xe_copies

3333: )
3334: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3335: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3336: fnd_global.login_id, 1
3337: FROM iby_fndcpt_tx_xe_copies
3338: START WITH copy_trxn_extension_id = p_trxn_entity_id
3339: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3340:
3341: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3356: FROM iby_fndcpt_tx_xe_copies

3352: )
3353: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3354: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3355: fnd_global.login_id, 1
3356: FROM iby_fndcpt_tx_xe_copies
3357: START WITH source_trxn_extension_id = p_trxn_entity_id
3358: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3359:
3360: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4110: FROM iby_fndcpt_tx_xe_copies

4106: )
4107: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
4108: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4109: fnd_global.login_id, 1
4110: FROM iby_fndcpt_tx_xe_copies
4111: START WITH copy_trxn_extension_id = p_trxn_entity_id
4112: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
4113:
4114: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4130: FROM iby_fndcpt_tx_xe_copies

4126: )
4127: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
4128: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4129: fnd_global.login_id, 1
4130: FROM iby_fndcpt_tx_xe_copies
4131: START WITH source_trxn_extension_id = p_trxn_entity_id
4132: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4133:
4134: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5814: FROM iby_fndcpt_tx_xe_copies

5810: )
5811: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
5812: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
5813: fnd_global.login_id, 1
5814: FROM iby_fndcpt_tx_xe_copies
5815: START WITH copy_trxn_extension_id = p_trxn_entity_id
5816: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
5817:
5818: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of