APPS.IBY_CREDITCARD_PKG dependencies on IBY_SYS_SECURITY_SUBKEYS

Line 361: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

357: -- l_encrypted_date_format VARCHAR2(20) := NULL;
358: -- l_chname_length NUMBER;
359: l_exp_date DATE;
360:
361: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
362: l_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
363: l_keyvalid VARCHAR2(100) := NULL;
364:
365:

Line 362: l_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;

358: -- l_chname_length NUMBER;
359: l_exp_date DATE;
360:
361: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
362: l_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
363: l_keyvalid VARCHAR2(100) := NULL;
364:
365:
366: CURSOR c_card

Line 887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%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;
886:
887: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
888: l_keyvalid VARCHAR2(100) := NULL;
889:
890: CURSOR c_instr_num(ci_instrid iby_creditcard.instrid%TYPE)
891: IS

Line 899: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,

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(+))

Line 939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

935: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
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,

Line 1019: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,

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(+))

Line 1114: iby_sys_security_subkeys k

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(+))
1118: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 1224: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,

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(+))