437: IV.party_id,
438: IV.cust_acct_id,
439: IV.bill_to_site_use_id,
440: IV.authoring_org_id,
441: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
442: iby_instr_s.nextval, -- the new credit card id
443: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
444: PAYER.EXT_PAYER_ID),
445: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
494: IV.party_id,
495: IV.cust_acct_id,
496: IV.bill_to_site_use_id,
497: IV.authoring_org_id,
498: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
499: IBY_INSTR_S.nextval, -- the new credit card id
500: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
501: PAYER.EXT_PAYER_ID),
502: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
683:
684:
685: -- insert the transactions into IBY transaction extension table
686: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
687: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
688: (TRXN_EXTENSION_ID,
689: PAYMENT_CHANNEL_CODE,
690: INSTR_ASSIGNMENT_ID,
691: ENCRYPTED,
827: IV.party_id,
828: IV.cust_acct_id,
829: IV.bill_to_site_use_id,
830: IV.authoring_org_id,
831: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
832: iby_instr_s.nextval, -- the new credit card id
833: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
834: PAYER.EXT_PAYER_ID),
835: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
883: IV.party_id,
884: IV.cust_acct_id,
885: IV.bill_to_site_use_id,
886: IV.authoring_org_id,
887: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
888: IBY_INSTR_S.nextval, -- the new credit card id
889: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
890: PAYER.EXT_PAYER_ID),
891: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1072:
1073:
1074: -- insert the transactions into IBY transaction extension table
1075: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1076: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
1077: (TRXN_EXTENSION_ID,
1078: PAYMENT_CHANNEL_CODE,
1079: INSTR_ASSIGNMENT_ID,
1080: ENCRYPTED,
1217: IV.party_id,
1218: IV.cust_account_id,
1219: IV.bill_to_site_use_id,
1220: IV.authoring_org_id,
1221: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
1222: iby_instr_s.nextval, -- the new credit card id
1223: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1224: PAYER.EXT_PAYER_ID),
1225: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1275: IV.party_id,
1276: IV.cust_account_id,
1277: IV.bill_to_site_use_id,
1278: IV.authoring_org_id,
1279: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
1280: IBY_INSTR_S.nextval, -- the new credit card id
1281: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1282: PAYER.EXT_PAYER_ID),
1283: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1467:
1468:
1469: -- insert the transactions into IBY transaction extension table
1470: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1471: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
1472: (TRXN_EXTENSION_ID,
1473: PAYMENT_CHANNEL_CODE,
1474: INSTR_ASSIGNMENT_ID,
1475: ENCRYPTED,
1611: IV.party_id,
1612: IV.cust_account_id,
1613: IV.bill_to_site_use_id,
1614: IV.authoring_org_id,
1615: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID
1616: iby_instr_s.nextval, -- the new credit card id
1617: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1618: PAYER.EXT_PAYER_ID),
1619: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1668: IV.party_id,
1669: IV.cust_account_id,
1670: IV.bill_to_site_use_id,
1671: IV.authoring_org_id,
1672: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID
1673: IBY_INSTR_S.nextval, -- the new credit card id
1674: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval,
1675: PAYER.EXT_PAYER_ID),
1676: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we
1859:
1860:
1861: -- insert the transactions into IBY transaction extension table
1862: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1863: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS
1864: (TRXN_EXTENSION_ID,
1865: PAYMENT_CHANNEL_CODE,
1866: INSTR_ASSIGNMENT_ID,
1867: ENCRYPTED,