APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_FNDCPT_TX_EXTENSIONS

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

123: -- Cursors that query all transactions needed to be migrated
124: -- since all credit cards for closed orders would have already created bank account id
125: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument
126: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
127: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
128:
129: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
130: -- but not in oe_payments for closed orders
131:

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

135: OE_Default_Header_Payment.get_payment_number(ooh.header_id),
136: ita.tangibleid,
137: uba.instr_assignment_id,
138: uba.ext_party_id,
139: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
140: FROM oe_order_headers_all ooh,
141: hz_cust_site_uses_all su,
142: hz_cust_acct_sites_all cas,
143: ap_bank_accounts_all ba,

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

177: OE_Default_Header_Payment.get_payment_number(ooh.header_id),
178: ita.tangibleid,
179: uba.instr_assignment_id,
180: uba.ext_party_id,
181: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
182: FROM oe_order_headers_all ooh,
183: hz_cust_site_uses_all su,
184: hz_cust_acct_sites_all cas,
185: iby_trans_all_v ita,

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

221: op.payment_number,
222: ita.tangibleid,
223: uba.instr_assignment_id,
224: uba.ext_party_id,
225: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
226: FROM oe_order_headers_all ooh,
227: hz_cust_site_uses_all su,
228: hz_cust_acct_sites_all cas,
229: ap_bank_accounts_all ba,

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

264: op.payment_number,
265: ita.tangibleid,
266: uba.instr_assignment_id,
267: uba.ext_party_id,
268: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
269: FROM oe_order_headers_all ooh,
270: hz_cust_site_uses_all su,
271: hz_cust_acct_sites_all cas,
272: iby_trans_all_v ita,

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

310: op.line_id,
311: op.payment_number,
312: uba.instr_assignment_id,
313: uba.ext_party_id,
314: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
315: FROM oe_order_headers_all ooh,
316: hz_cust_site_uses_all su,
317: hz_cust_acct_sites_all cas,
318: iby_upg_instruments uba,

Line 455: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

451:
452: IF trxn_entity_id_tab.count > 0 THEN
453: -- insert the transactions into IBY transaction extension table
454: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
455: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
456: (trxn_extension_id,
457: payment_channel_code,
458: instr_assignment_id,
459: ext_payer_id,

Line 690: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

686:
687: IF trxn_entity_id_tab.count > 0 THEN
688: -- insert the transactions into IBY transaction extension table
689: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
690: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
691: (trxn_extension_id,
692: payment_channel_code,
693: instr_assignment_id,
694: ext_payer_id,

Line 865: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

861:
862: IF trxn_entity_id_tab.count > 0 THEN
863: -- insert the transactions into IBY transaction extension table
864: FORALL k in trxn_entity_id_tab.FIRST..trxn_entity_id_tab.LAST SAVE EXCEPTIONS
865: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
866: (trxn_extension_id,
867: payment_channel_code,
868: instr_assignment_id,
869: ext_payer_id,