DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on IBY_FNDCPT_SETUP_PUB

Line 505: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,

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,
509: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,

Line 506: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,

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,
509: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
510: Null sec_segment_id,

Line 507: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,

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,
509: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
510: Null sec_segment_id,
511: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no), NULL,LENGTH(oksline.cc_no), NULL) cc_number_length,

Line 508: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

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,
509: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
510: Null sec_segment_id,
511: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no), NULL,LENGTH(oksline.cc_no), NULL) cc_number_length,
512: SUBSTR(oksline.cc_no,GREATEST(-4,-LENGTH(oksline.cc_no))) cc_unmask_digits,

Line 894: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_FALSE) cc_number_hash1,

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,
898: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,

Line 895: ----iby_fndcpt_setup_pub.get_hash(oksline.cc_no, FND_API.G_TRUE) cc_number_hash2,

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,
898: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
899: Null sec_segment_id,

Line 896: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'F') cc_number_hash1,

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,
898: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
899: Null sec_segment_id,
900: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no), NULL,LENGTH(oksline.cc_no), NULL) cc_number_length,

Line 897: iby_fndcpt_setup_pub.get_hash(oksline.cc_no, 'T') cc_number_hash2,

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,
898: IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no) cc_issuer_range_id,
899: Null sec_segment_id,
900: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(oksline.cc_no), NULL,LENGTH(oksline.cc_no), NULL) cc_number_length,
901: SUBSTR(oksline.cc_no,GREATEST(-4,-LENGTH(oksline.cc_no))) cc_unmask_digits,

Line 1286: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,

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,
1290: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,

Line 1287: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,

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,
1290: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1291: Null sec_segment_id,

Line 1288: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,

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,
1290: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1291: Null sec_segment_id,
1292: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no), NULL,LENGTH(okshdr.cc_no), NULL) cc_number_length,

Line 1289: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,

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,
1290: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1291: Null sec_segment_id,
1292: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no), NULL,LENGTH(okshdr.cc_no), NULL) cc_number_length,
1293: SUBSTR(okshdr.cc_no,GREATEST(-4,-LENGTH(okshdr.cc_no))) cc_unmask_digits,

Line 1679: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_FALSE) cc_number_hash1,

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,
1683: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,

Line 1680: ----iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, FND_API.G_TRUE) cc_number_hash2,

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,
1683: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1684: Null sec_segment_id,

Line 1681: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'F') cc_number_hash1,

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,
1683: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1684: Null sec_segment_id,
1685: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no), NULL,LENGTH(okshdr.cc_no), NULL) cc_number_length,

Line 1682: iby_fndcpt_setup_pub.get_hash(okshdr.cc_no, 'T') cc_number_hash2,

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,
1683: IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no) cc_issuer_range_id,
1684: Null sec_segment_id,
1685: DECODE(IBY_CC_VALIDATE.Get_CC_Issuer_Range(okshdr.cc_no), NULL,LENGTH(okshdr.cc_no), NULL) cc_number_length,
1686: SUBSTR(okshdr.cc_no,GREATEST(-4,-LENGTH(okshdr.cc_no))) cc_unmask_digits,