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_TRANSACTIONCC_PKG dependencies on IBY_CREDITCARD_ISSUERS_B

Line 154: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

150: IS
151: lx_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
152: lx_unmask_digits iby_trxn_summaries_all.instrnumber%TYPE;
153: lx_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
154: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
155:
156: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
157: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
158: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 6295: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE

6291: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6292: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6293: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
6294: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
6295: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6296: )
6297: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6298: IS
6299: l_subkey_cleartxt iby_security_pkg.des3_key_type;

Line 6357: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

6353: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6354: l_sys_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6355: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
6356: l_card_length iby_cc_issuer_ranges.card_number_length%TYPE;
6357: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
6358:
6359: CURSOR c_instr_num(ci_trxnmid iby_trxn_summaries_all.trxnmid%TYPE)
6360: IS
6361: SELECT NULL, tx.instrnumber,

Line 6367: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

6363: seg.segment_cipher_text, r.card_number_prefix,
6364: NVL(r.card_number_length,tx.instrnum_length), i.digit_check_flag
6365: FROM iby_trxn_summaries_all tx,
6366: iby_security_segments seg, iby_sys_security_subkeys k,
6367: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
6368: WHERE (tx.trxnmid = ci_trxnmid)
6369: AND (tx.instrnum_sec_segment_id = seg.sec_segment_id(+))
6370: AND (seg.sec_subkey_id = k.sec_subkey_id(+))
6371: AND (tx.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 6639: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

6635: i.digit_check_flag) ccnum,
6636: instrnum_sec_segment_id
6637: FROM iby_trxn_summaries_all tx,
6638: iby_security_segments seg, iby_sys_security_subkeys k,
6639: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
6640: WHERE
6641: /*
6642: (NOT instrnumber IS NULL)
6643: AND (DECODE(instrtype, 'PINLESSDEBITCARD','CREDITCARD',