[Home] [Help]
329: lx_msg_count NUMBER;
330: lx_msg_data VARCHAR2(200);
331: lx_card_issuer iby_creditcard.card_issuer_code%TYPE;
332: lx_issuer_range iby_creditcard.cc_issuer_range_id%TYPE;
333: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
335: l_card_len iby_creditcard.cc_number_length%TYPE;
336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
883: l_mask_option iby_creditcard.card_mask_setting%TYPE;
884: l_unmask_len iby_creditcard.card_unmask_length%TYPE;
885: l_unmask_digits iby_creditcard.ccnumber%TYPE;
895: NVL(i.digit_check_flag,'N'), c.card_mask_setting, c.card_unmask_length,
896: DECODE(encrypted, 'Y',c.ccnumber, NULL),
897: NVL(r.card_number_length,c.cc_number_length)
898: FROM iby_creditcard c, iby_security_segments seg,
899: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
900: iby_creditcard_issuers_b i
901: WHERE (instrid = ci_instrid)
902: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
903: AND (seg.sec_subkey_id = k.sec_subkey_id(+))
936: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
937: p_encrypted IN iby_creditcard.encrypted%TYPE,
938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
940: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
941: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
943: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
944: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
937: p_encrypted IN iby_creditcard.encrypted%TYPE,
938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
940: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
941: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
943: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
944: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
945: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1015: c.card_unmask_length, c.ccnumber unmask_digits, c.cc_num_sec_segment_id,
1016: c.chname, c.chname_sec_segment_id,
1017: c.expirydate, c.expiry_sec_segment_id
1018: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1019: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1020: iby_security_segments seg
1021: WHERE (NVL(c.encrypted,'N') = 'Y')
1022: AND (c.card_issuer_code = i.card_issuer_code(+))
1023: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1109: SELECT c.instrid, c.ccnumber, c.cc_issuer_range_id,
1110: k.subkey_cipher_text, r.card_number_prefix, i.digit_check_flag,
1111: c.card_mask_setting, c.card_unmask_length, c.chname, c.expirydate
1112: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1113: iby_cc_issuer_ranges r, iby_security_segments seg,
1114: iby_sys_security_subkeys k
1115: WHERE (NVL(c.encrypted,'N') = 'N')
1116: AND (c.card_issuer_code = i.card_issuer_code(+))
1117: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1220: r.card_number_prefix, i.digit_check_flag, c.card_mask_setting,
1221: c.card_unmask_length, c.ccnumber unmask_digits, seg.sec_segment_id,
1222: LENGTH(c.ccnumber) len
1223: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1224: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1225: iby_security_segments seg
1226: WHERE (c.card_issuer_code = i.card_issuer_code(+))
1227: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1228: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
1302: END Remask_Instruments;
1303:
1304: PROCEDURE Compress_CC_Number
1305: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1306: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1308: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1309: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1310: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1357:
1358: FUNCTION Uncompress_CC_Number
1359: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1360: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1361: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1363: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1364: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1365: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1422: END Uncompress_CC_Number;
1423:
1424: FUNCTION Get_Compressed_Len
1425: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1426: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1427: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1428: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1429: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1430: )