eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_CREDITCARD_PKG dependencies on IBY_CREDITCARD_ISSUERS_B

Line 334: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

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;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;

Line 882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%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;
886:

Line 900: iby_creditcard_issuers_b i

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(+))
904: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 942: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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
946: )

Line 1018: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1014: r.card_number_prefix, i.digit_check_flag, c.card_mask_setting,
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(+))

Line 1112: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1108: IS
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(+))

Line 1223: FROM iby_creditcard c, iby_creditcard_issuers_b i,

1219: NVL(r.card_number_length,c.cc_number_length) card_len,
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(+))

Line 1307: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

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,
1311: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE

Line 1362: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

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
1366: )

Line 1427: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,

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: )
1431: RETURN NUMBER