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_SYS_SECURITY_SUBKEYS

Line 157: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%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;
159: BEGIN
160: IF (p_instrnum IS NULL) THEN RETURN; END IF;
161:

Line 158: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%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;
159: BEGIN
160: IF (p_instrnum IS NULL) THEN RETURN; END IF;
161:
162: x_instrnum := iby_utility_pvt.encode64(p_instrnum);

Line 6290: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

6286: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
6287: p_payee_key IN iby_security_pkg.des3_key_type,
6288: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%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,

Line 6354: l_sys_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%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:

Line 6366: iby_security_segments seg, iby_sys_security_subkeys k,

6362: tx.instrnum_sec_segment_id, k.subkey_cipher_text,
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(+))

Line 6638: iby_security_segments seg, iby_sys_security_subkeys k,

6634: NVL(r.card_number_length,tx.instrnum_length),
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)