APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_TX_XE_COPIES

Line 340: FROM iby_fndcpt_tx_xe_copies

336:
337: CURSOR c_xe_copies(ci_x_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
338: IS
339: SELECT COUNT(copy_trxn_extension_id)
340: FROM iby_fndcpt_tx_xe_copies
341: WHERE (source_trxn_extension_id = ci_x_id);
342: BEGIN
343:
344: IF (c_xe_copies%ISOPEN) THEN CLOSE c_xe_copies; END IF;

Line 1678: DELETE iby_fndcpt_tx_xe_copies

1674: ELSE
1675: SAVEPOINT Delete_Transaction_Extension;
1676:
1677: -- delete all links to its source extensions
1678: DELETE iby_fndcpt_tx_xe_copies
1679: WHERE (copy_trxn_extension_id = p_entity_id);
1680:
1681: DELETE iby_fndcpt_tx_extensions
1682: WHERE (trxn_extension_id = p_entity_id);

Line 2101: INSERT INTO iby_fndcpt_tx_xe_copies

2097:
2098: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
2099:
2100: -- associate the merged copy with all its sources
2101: INSERT INTO iby_fndcpt_tx_xe_copies
2102: (source_trxn_extension_id, copy_trxn_extension_id,
2103: created_by, creation_date, last_updated_by, last_update_date,
2104: last_update_login, object_version_number
2105: )

Line 2675: FROM iby_fndcpt_tx_xe_copies

2671: )
2672: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
2673: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2674: fnd_global.login_id, 1
2675: FROM iby_fndcpt_tx_xe_copies
2676: START WITH copy_trxn_extension_id = p_trxn_entity_id
2677: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
2678:
2679: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,

Line 2693: FROM iby_fndcpt_tx_xe_copies

2689: )
2690: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
2691: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2692: fnd_global.login_id, 1
2693: FROM iby_fndcpt_tx_xe_copies
2694: START WITH source_trxn_extension_id = p_trxn_entity_id
2695: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
2696:
2697: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,

Line 3343: FROM iby_fndcpt_tx_xe_copies

3339: )
3340: SELECT source_trxn_extension_id, l_reqresp.Trxn_Id,
3341: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3342: fnd_global.login_id, 1
3343: FROM iby_fndcpt_tx_xe_copies
3344: START WITH copy_trxn_extension_id = p_trxn_entity_id
3345: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3346:
3347: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,

Line 3361: FROM iby_fndcpt_tx_xe_copies

3357: )
3358: SELECT copy_trxn_extension_id, l_reqresp.Trxn_Id,
3359: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
3360: fnd_global.login_id, 1
3361: FROM iby_fndcpt_tx_xe_copies
3362: START WITH source_trxn_extension_id = p_trxn_entity_id
3363: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3364:
3365: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,

Line 4692: FROM iby_fndcpt_tx_xe_copies

4688: )
4689: SELECT source_trxn_extension_id, lx_creditresp.Trxn_Id,
4690: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
4691: fnd_global.login_id, 1
4692: FROM iby_fndcpt_tx_xe_copies
4693: START WITH copy_trxn_extension_id = p_trxn_entity_id
4694: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4695:
4696: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of