APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 166: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.

162: -- Cursors that query all transactions needed to be migrated
163: -- since all credit cards for closed orders would have already created bank account id
164: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument
165: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
166: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
167:
168: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
169: -- but not in oe_payments for closed orders
170:

Line 178: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID

174: OE_Default_Header_Payment.get_payment_number(ooh.header_id),
175: ita.tangibleid,
176: uba.instr_assignment_id,
177: uba.ext_party_id,
178: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
179: FROM oe_order_headers_all ooh,
180: hz_cust_site_uses_all su,
181: hz_cust_acct_sites_all cas,
182: ap_bank_accounts_all ba,

Line 220: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID

216: OE_Default_Header_Payment.get_payment_number(ooh.header_id),
217: ita.tangibleid,
218: uba.instr_assignment_id,
219: uba.ext_party_id,
220: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
221: FROM oe_order_headers_all ooh,
222: hz_cust_site_uses_all su,
223: hz_cust_acct_sites_all cas,
224: iby_trans_all_v ita,

Line 264: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID

260: op.payment_number,
261: ita.tangibleid,
262: uba.instr_assignment_id,
263: uba.ext_party_id,
264: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
265: FROM oe_order_headers_all ooh,
266: hz_cust_site_uses_all su,
267: hz_cust_acct_sites_all cas,
268: ap_bank_accounts_all ba,

Line 307: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID

303: op.payment_number,
304: ita.tangibleid,
305: uba.instr_assignment_id,
306: uba.ext_party_id,
307: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
308: FROM oe_order_headers_all ooh,
309: hz_cust_site_uses_all su,
310: hz_cust_acct_sites_all cas,
311: iby_trans_all_v ita,

Line 353: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID

349: op.line_id,
350: op.payment_number,
351: uba.instr_assignment_id,
352: uba.ext_party_id,
353: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
354: FROM oe_order_headers_all ooh,
355: hz_cust_site_uses_all su,
356: hz_cust_acct_sites_all cas,
357: iby_upg_instruments uba,

Line 494: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

490:
491: IF trxn_entity_id_tab.count > 0 THEN
492: -- insert the transactions into IBY transaction extension table
493: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
494: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
495: (trxn_extension_id,
496: payment_channel_code,
497: instr_assignment_id,
498: ext_payer_id,

Line 729: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

725:
726: IF trxn_entity_id_tab.count > 0 THEN
727: -- insert the transactions into IBY transaction extension table
728: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
729: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
730: (trxn_extension_id,
731: payment_channel_code,
732: instr_assignment_id,
733: ext_payer_id,

Line 904: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

900:
901: IF trxn_entity_id_tab.count > 0 THEN
902: -- insert the transactions into IBY transaction extension table
903: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
904: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
905: (trxn_extension_id,
906: payment_channel_code,
907: instr_assignment_id,
908: ext_payer_id,