[Home] [Help]
424: l_chname_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
425: l_exp_date DATE;
426: l_expired VARCHAR2(1) := NULL;
427:
428: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
429: l_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
430: l_keyvalid VARCHAR2(100) := NULL;
431:
432: -- Variables to be used when an invalid card is registered
425: l_exp_date DATE;
426: l_expired VARCHAR2(1) := NULL;
427:
428: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
429: l_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
430: l_keyvalid VARCHAR2(100) := NULL;
431:
432: -- Variables to be used when an invalid card is registered
433: l_invalid_flag VARCHAR2(1) := NULL;
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;
1205:
1206: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
1207: l_keyvalid VARCHAR2(100) := NULL;
1208:
1209: CURSOR c_instr_num(ci_instrid iby_creditcard.instrid%TYPE)
1210: IS
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(+))
1260: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
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,
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(+))
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(+))
1436: AND (c.cc_num_sec_segment_id = seg.sec_segment_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(+))