eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 447: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
446: -- should create new external payer
447: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
448: SEC.cc_number_hash1,
449: SEC.cc_number_hash2,
450: SEC.cc_issuer_range_id,
451: SEC.sec_segment_id,

Line 504: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
503: -- should create new external payer
504: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
505: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,
506: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,
507: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,
508: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

Line 645: INSERT INTO IBY_PMT_INSTR_USES_ALL

641:
642: -- Now insert into the instrument use table
643:
644: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
645: INSERT INTO IBY_PMT_INSTR_USES_ALL
646: (INSTRUMENT_PAYMENT_USE_ID,
647: EXT_PMT_PARTY_ID,
648: INSTRUMENT_TYPE,
649: INSTRUMENT_ID,

Line 837: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
836: -- should create new external payer
837: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
838: SEC.cc_number_hash1,
839: SEC.cc_number_hash2,
840: SEC.cc_issuer_range_id,
841: SEC.sec_segment_id,

Line 893: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
892: -- should create new external payer
893: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
894: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,
895: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,
896: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,
897: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

Line 1034: INSERT INTO IBY_PMT_INSTR_USES_ALL

1030:
1031: -- Now insert into the instrument use table
1032:
1033: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1034: INSERT INTO IBY_PMT_INSTR_USES_ALL
1035: (INSTRUMENT_PAYMENT_USE_ID,
1036: EXT_PMT_PARTY_ID,
1037: INSTRUMENT_TYPE,
1038: INSTRUMENT_ID,

Line 1227: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
1226: -- should create new external payer
1227: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1228: SEC.cc_number_hash1,
1229: SEC.cc_number_hash2,
1230: SEC.cc_issuer_range_id,
1231: SEC.sec_segment_id,

Line 1285: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
1284: -- should create new external payer
1285: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1286: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,
1287: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,
1288: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,
1289: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,

Line 1429: INSERT INTO IBY_PMT_INSTR_USES_ALL

1425:
1426: -- Now insert into the instrument use table
1427:
1428: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1429: INSERT INTO IBY_PMT_INSTR_USES_ALL
1430: (INSTRUMENT_PAYMENT_USE_ID,
1431: EXT_PMT_PARTY_ID,
1432: INSTRUMENT_TYPE,
1433: INSTRUMENT_ID,

Line 1621: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
1620: -- should create new external payer
1621: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1622: SEC.cc_number_hash1,
1623: SEC.cc_number_hash2,
1624: SEC.cc_issuer_range_id,
1625: SEC.sec_segment_id,

Line 1678: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use 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
1677: -- should create new external payer
1678: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
1679: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,
1680: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,
1681: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,
1682: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,

Line 1821: INSERT INTO IBY_PMT_INSTR_USES_ALL

1817:
1818: -- Now insert into the instrument use table
1819:
1820: FORALL i IN c_trxn_entity_id.first..c_trxn_entity_id.last
1821: INSERT INTO IBY_PMT_INSTR_USES_ALL
1822: (INSTRUMENT_PAYMENT_USE_ID,
1823: EXT_PMT_PARTY_ID,
1824: INSTRUMENT_TYPE,
1825: INSTRUMENT_ID,