[Home] [Help]
394: lx_msg_count NUMBER;
395: lx_msg_data VARCHAR2(200);
396: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
397: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
398: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
399: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
400: l_card_len iby_creditcard.cc_number_length%TYPE;
401:
402: lx_cc_number iby_creditcard.ccnumber%TYPE;
1120: IS
1121: SELECT c.invalid_flag, c.invalidation_reason,
1122: c.expired_flag,
1123: c.card_issuer_code, r.card_issuer_code
1124: FROM iby_creditcard c, iby_cc_issuer_ranges r
1125: WHERE instrid = ci_instrid
1126: AND c.cc_issuer_range_id = r.cc_issuer_range_id(+);
1127:
1128: BEGIN
1196: l_masked_cc_number iby_creditcard.masked_cc_number%TYPE;
1197: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
1198: l_card_len iby_creditcard.cc_number_length%TYPE;
1199: l_encrypted iby_creditcard.encrypted%TYPE;
1200: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
1201: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
1202: l_mask_option iby_creditcard.card_mask_setting%TYPE;
1203: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
1204: l_unmask_digits iby_creditcard.ccnumber%TYPE;
1214: NVL(i.digit_check_flag,'N'), c.card_mask_setting, c.card_unmask_length,
1215: DECODE(encrypted, 'Y',c.ccnumber,'A',c.ccnumber, NULL),
1216: NVL(r.card_number_length,c.cc_number_length)
1217: FROM iby_creditcard c, iby_security_segments seg,
1218: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
1219: iby_creditcard_issuers_b i
1220: WHERE (instrid = ci_instrid)
1221: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
1222: AND (seg.sec_subkey_id = k.sec_subkey_id(+))
1261: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1262: p_encrypted IN iby_creditcard.encrypted%TYPE,
1263: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
1264: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1265: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
1266: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1267: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1268: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1269: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1262: p_encrypted IN iby_creditcard.encrypted%TYPE,
1263: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
1264: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1265: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
1266: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1267: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1268: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1269: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1270: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1320: c.card_unmask_length, c.ccnumber unmask_digits, c.cc_num_sec_segment_id,
1321: c.chname, c.chname_sec_segment_id,
1322: c.expirydate, c.expiry_sec_segment_id
1323: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1324: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1325: iby_security_segments seg
1326: WHERE (NVL(c.encrypted,'N') <> 'N')
1327: AND (c.card_issuer_code = i.card_issuer_code(+))
1328: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1427: SELECT c.instrid, c.ccnumber, c.cc_issuer_range_id,
1428: k.subkey_cipher_text, r.card_number_prefix, i.digit_check_flag,
1429: c.card_mask_setting, c.card_unmask_length, c.chname, c.expirydate
1430: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1431: iby_cc_issuer_ranges r, iby_security_segments seg,
1432: iby_sys_security_subkeys k
1433: WHERE (NVL(c.encrypted,'N') = 'N')
1434: AND (c.card_issuer_code = i.card_issuer_code(+))
1435: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1571: c.card_unmask_length, c.ccnumber unmask_digits, seg.sec_segment_id,
1572: LENGTH(c.ccnumber) len, c.chname, c.chname_sec_segment_id,
1573: c.chname_mask_setting, c.chname_unmask_length
1574: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1575: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1576: iby_security_segments seg
1577: WHERE (c.card_issuer_code = i.card_issuer_code(+))
1578: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1579: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
1686: END Remask_Instruments;
1687:
1688: PROCEDURE Compress_CC_Number
1689: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1690: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1691: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1692: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1693: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1694: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1707:
1708: FUNCTION Uncompress_CC_Number
1709: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1710: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1711: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1712: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1713: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1714: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1715: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1727: END Uncompress_CC_Number;
1728:
1729: FUNCTION Get_Compressed_Len
1730: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1731: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1732: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1733: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1734: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1735: )