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_CC_ISSUER_RANGES

Line 153: lx_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

149: )
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;

Line 351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

347: l_checksum_valid BOOLEAN := FALSE; -- whether the card number is valid.
348:
349: l_cc_type VARCHAR2(80);
350: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
351: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
352: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
353: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
354: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
355:

Line 747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

743: l_instrtype iby_trxn_summaries_all.instrtype%type;
744: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
745:
746: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
747: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
748: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
749: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
750: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
751:

Line 6293: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,

6289: p_sys_key IN RAW,
6290: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%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

Line 6294: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,

6290: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%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

Line 6355: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

6351: l_cipher_instrnum iby_trxn_summaries_all.instrnumber%TYPE;
6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%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)

Line 6356: l_card_length iby_cc_issuer_ranges.card_number_length%TYPE;

6352: l_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%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

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',