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_SECURITY_SEGMENTS

Line 156: l_segment_cipher iby_security_segments.segment_cipher_text%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;
159: BEGIN
160: IF (p_instrnum IS NULL) THEN RETURN; END IF;

Line 201: SELECT iby_security_segments_s.NEXTVAL

197: ( input => l_segment_cipher, key => lx_subkey,
198: which => dbms_obfuscation_toolkit.ThreeKeyMode
199: );
200:
201: SELECT iby_security_segments_s.NEXTVAL
202: INTO x_segment_id
203: FROM DUAL;
204:
205: INSERT INTO iby_security_segments

Line 205: INSERT INTO iby_security_segments

201: SELECT iby_security_segments_s.NEXTVAL
202: INTO x_segment_id
203: FROM DUAL;
204:
205: INSERT INTO iby_security_segments
206: (sec_segment_id, segment_cipher_text, sec_subkey_id, encoding_scheme,
207: created_by, creation_date, last_updated_by, last_update_date,
208: last_update_login, object_version_number
209: )

Line 366: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

362: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
363: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
364:
365: -- variables for CHNAME and EXPDATE encryption
366: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
367: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
368: l_masked_chname VARCHAR2(100) := NULL;
369: -- l_encrypted_date_format VARCHAR2(20);
370: l_encrypted VARCHAR2(1) := 'N';

Line 367: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

363: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
364:
365: -- variables for CHNAME and EXPDATE encryption
366: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
367: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
368: l_masked_chname VARCHAR2(100) := NULL;
369: -- l_encrypted_date_format VARCHAR2(20);
370: l_encrypted VARCHAR2(1) := 'N';
371:

Line 623: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;

619: payment_channel_code = payment_channel_code_in,
620: factored_flag = factored_flag_in
621: WHERE TrxnMID = l_trxn_mid;
622:
623: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
624:
625: UPDATE iby_trxn_core
626: SET AuthCode = authcode_in,
627: date_of_voice_authorization = dateofvoiceauth_in,

Line 980: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;

976: Created_By = fnd_global.user_id,
977: Object_Version_Number = object_version_number + 1
978: WHERE TrxnMID = l_trxn_mid;
979:
980: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
981:
982: UPDATE iby_trxn_core
983: SET ReferenceCode = referencecode_in,
984: TraceNumber = trace_number_in,

Line 6291: p_segment_id IN iby_security_segments.sec_segment_id%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,
6295: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE

Line 6292: p_segment_cipher IN iby_security_segments.segment_cipher_text%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,
6295: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6296: )

Line 6353: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

6349: IS
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;

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 6446: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

6442:
6443: l_index NUMBER;
6444:
6445: -- variables for CHNAME and EXPDATE encryption
6446: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6447: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6448: l_masked_chname VARCHAR2(100) := NULL;
6449: l_encrypted VARCHAR2(1) := 'N';
6450:

Line 6447: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

6443: l_index NUMBER;
6444:
6445: -- variables for CHNAME and EXPDATE encryption
6446: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6447: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6448: l_masked_chname VARCHAR2(100) := NULL;
6449: l_encrypted VARCHAR2(1) := 'N';
6450:
6451: CURSOR c_tx_ccnumber

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)

Line 6696: DELETE iby_security_segments

6692: instrnum_sec_segment_id = NULL
6693: WHERE trxnmid=l_trxnmid_tbl(i);
6694:
6695: FORALL i IN l_segmentid_tbl.first..l_segmentid_tbl.last
6696: DELETE iby_security_segments
6697: WHERE sec_segment_id = l_segmentid_tbl(i);
6698:
6699: COMMIT;
6700:

Line 6719: DELETE iby_security_segments

6715: instrnum_sec_segment_id = NULL
6716: WHERE trxnmid=l_trxnmid_tbl(i);
6717:
6718: FORALL i IN l_segmentid_tbl.first..l_segmentid_tbl.last
6719: DELETE iby_security_segments
6720: WHERE sec_segment_id = l_segmentid_tbl(i);
6721:
6722: COMMIT;
6723: END IF;