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

307: l_voiceauth_flag iby_trxn_core.voiceauthflag%type;
308: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
309:
310: -- variables for CHNAME and EXPDATE encryption
311: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
312: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
313: l_masked_chname VARCHAR2(100) := NULL;
314: -- l_encrypted_date_format VARCHAR2(20);
315: l_encrypted VARCHAR2(1) := 'N';

Line 312: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

308: l_sub_key_id iby_trxn_summaries_all.sub_key_id%TYPE;
309:
310: -- variables for CHNAME and EXPDATE encryption
311: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
312: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
313: l_masked_chname VARCHAR2(100) := NULL;
314: -- l_encrypted_date_format VARCHAR2(20);
315: l_encrypted VARCHAR2(1) := 'N';
316:

Line 573: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;

569: payment_channel_code = payment_channel_code_in,
570: factored_flag = factored_flag_in
571: WHERE TrxnMID = l_trxn_mid;
572:
573: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
574:
575: UPDATE iby_trxn_core
576: SET AuthCode = authcode_in,
577: date_of_voice_authorization = dateofvoiceauth_in,

Line 1182: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;

1178: Created_By = fnd_global.user_id,
1179: Object_Version_Number = object_version_number + 1
1180: WHERE TrxnMID = l_trxn_mid;
1181:
1182: DELETE iby_security_segments WHERE sec_segment_id = l_old_segment_id;
1183:
1184: UPDATE iby_trxn_core
1185: SET ReferenceCode = referencecode_in,
1186: TraceNumber = trace_number_in,

Line 6848: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

6844: p_payee_key IN iby_security_pkg.des3_key_type,
6845: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%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

Line 6849: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

6845: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%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: )

Line 6934: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

6930:
6931: l_index NUMBER;
6932:
6933: -- variables for CHNAME and EXPDATE encryption
6934: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6935: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6936: l_masked_chname VARCHAR2(100) := NULL;
6937: l_encrypted VARCHAR2(1) := 'N';
6938:

Line 6935: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

6931: l_index NUMBER;
6932:
6933: -- variables for CHNAME and EXPDATE encryption
6934: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6935: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
6936: l_masked_chname VARCHAR2(100) := NULL;
6937: l_encrypted VARCHAR2(1) := 'N';
6938:
6939: CURSOR c_tx_ccnumber

Line 7135: iby_security_segments seg, iby_sys_security_subkeys k,

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

Line 7193: DELETE iby_security_segments

7189: instrnum_sec_segment_id = NULL
7190: WHERE trxnmid=l_trxnmid_tbl(i);
7191:
7192: FORALL i IN l_segmentid_tbl.first..l_segmentid_tbl.last
7193: DELETE iby_security_segments
7194: WHERE sec_segment_id = l_segmentid_tbl(i);
7195:
7196: COMMIT;
7197:

Line 7216: DELETE iby_security_segments

7212: instrnum_sec_segment_id = NULL
7213: WHERE trxnmid=l_trxnmid_tbl(i);
7214:
7215: FORALL i IN l_segmentid_tbl.first..l_segmentid_tbl.last
7216: DELETE iby_security_segments
7217: WHERE sec_segment_id = l_segmentid_tbl(i);
7218:
7219: COMMIT;
7220: END IF;