DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 441: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID

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

Line 498: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID

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

Line 687: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

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,

Line 831: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID

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

Line 887: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID

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

Line 1076: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

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,

Line 1221: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID

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

Line 1279: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID

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

Line 1471: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

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,

Line 1615: iby_fndcpt_tx_extensions_s.nextval, -- the new transaction extension ID

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

Line 1672: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, -- the new transaction extension ID

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

Line 1863: INSERT INTO IBY_FNDCPT_TX_EXTENSIONS

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,