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 296: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

292: l_checksum_valid BOOLEAN := FALSE; -- whether the card number is valid.
293:
294: l_cc_type VARCHAR2(80);
295: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
296: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
297: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
298: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
299: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
300:

Line 890: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

886: l_instrtype iby_trxn_summaries_all.instrtype%type;
887: l_instrsubtype iby_trxn_summaries_all.instrsubtype%type;
888:
889: lx_cc_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
890: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
891: lx_instr_len iby_trxn_summaries_all.instrnum_length%TYPE;
892: lx_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
893: l_old_segment_id iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE;
894:

Line 6850: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,

6846: p_sys_key IN RAW,
6847: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6848: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6849: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6850: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
6851: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
6852: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6853: )
6854: RETURN iby_trxn_summaries_all.instrnumber%TYPE

Line 6851: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,

6847: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6848: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6849: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6850: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
6851: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
6852: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6853: )
6854: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6855: IS

Line 7136: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

7132: i.digit_check_flag) ccnum,
7133: instrnum_sec_segment_id
7134: FROM iby_trxn_summaries_all tx,
7135: iby_security_segments seg, iby_sys_security_subkeys k,
7136: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
7137: WHERE
7138: /*
7139: (NOT instrnumber IS NULL)
7140: AND (DECODE(instrtype, 'PINLESSDEBITCARD','CREDITCARD',