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_PKG

Line 140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,

136: END validate_open_batch;
137:
138: PROCEDURE prepare_instr_data
139: (p_commit IN VARCHAR2,
140: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
141: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
142: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
143: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
144: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,

Line 171: x_instr_hash := iby_security_pkg.get_hash(p_instrnum,FND_API.G_FALSE);

167: END IF;
168:
169: iby_cc_validate.Get_CC_Issuer_Range
170: (p_instrnum,x_instr_subtype,x_range_id,lx_cc_prefix,lx_digit_check);
171: x_instr_hash := iby_security_pkg.get_hash(p_instrnum,FND_API.G_FALSE);
172:
173: IF (x_range_id IS NULL) THEN
174: x_instr_len := LENGTH(p_instrnum);
175: x_instr_subtype := 'UNKNOWN';

Line 179: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)

175: x_instr_subtype := 'UNKNOWN';
176: END IF;
177:
178: IF (IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode() <>
179: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)
180: THEN
181: -- mask the instrument number
182: x_instrnum := LPAD('X',LENGTH(p_instrnum),'X');
183: -- assuming the number has already been validate- i.e. check digit

Line 186: (p_instrnum,lx_cc_prefix,lx_digit_check,IBY_SECURITY_PKG.G_MASK_ALL,0,

182: x_instrnum := LPAD('X',LENGTH(p_instrnum),'X');
183: -- assuming the number has already been validate- i.e. check digit
184: -- verified
185: iby_creditcard_pkg.Compress_CC_Number
186: (p_instrnum,lx_cc_prefix,lx_digit_check,IBY_SECURITY_PKG.G_MASK_ALL,0,
187: lx_instrnum,lx_unmask_digits);
188:
189: IF (LENGTH(lx_instrnum) > 0) THEN
190: l_segment_cipher :=

Line 191: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_instrnum,TRUE));

187: lx_instrnum,lx_unmask_digits);
188:
189: IF (LENGTH(lx_instrnum) > 0) THEN
190: l_segment_cipher :=
191: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_instrnum,TRUE));
192: IBY_SECURITY_PKG.Get_Sys_Subkey
193: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);
194:
195: l_segment_cipher :=

Line 192: IBY_SECURITY_PKG.Get_Sys_Subkey

188:
189: IF (LENGTH(lx_instrnum) > 0) THEN
190: l_segment_cipher :=
191: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_instrnum,TRUE));
192: IBY_SECURITY_PKG.Get_Sys_Subkey
193: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);
194:
195: l_segment_cipher :=
196: DBMS_OBFUSCATION_TOOLKIT.des3encrypt

Line 299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

295: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
296: payerid_in IN iby_trxn_summaries_all.payerid%type,
297: instrtype_in IN iby_trxn_summaries_all.instrType%type,
298: cvv2result_in IN iby_trxn_core.CVV2Result%type,
299: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
300: subkey_seed_in IN RAW,
301: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
302: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
303: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

Line 397: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)

393: -- sensitive. We need to encrypt those before inserting/updating the
394: -- record in IBY_TRXN_CORE
395:
396: IF ((IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode() <>
397: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)
398: AND ( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y'))
399: THEN
400: l_chname_sec_segment_id :=
401: IBY_SECURITY_PKG.encrypt_field_vals(instr_owner_name_in,

Line 401: IBY_SECURITY_PKG.encrypt_field_vals(instr_owner_name_in,

397: IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE)
398: AND ( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y'))
399: THEN
400: l_chname_sec_segment_id :=
401: IBY_SECURITY_PKG.encrypt_field_vals(instr_owner_name_in,
402: master_key_in,
403: null,
404: 'N'
405: );

Line 407: IBY_SECURITY_PKG.encrypt_date_field(l_expirydate,

403: null,
404: 'N'
405: );
406: l_expdate_sec_segment_id :=
407: IBY_SECURITY_PKG.encrypt_date_field(l_expirydate,
408: master_key_in,
409: null,
410: 'N'
411: );

Line 414: IBY_SECURITY_PKG.Mask_Data(instr_owner_name_in,

410: 'N'
411: );
412:
413: l_masked_chname :=
414: IBY_SECURITY_PKG.Mask_Data(instr_owner_name_in,
415: IBY_SECURITY_PKG.G_MASK_ALL,
416: 0,
417: 'X'
418: );

Line 415: IBY_SECURITY_PKG.G_MASK_ALL,

411: );
412:
413: l_masked_chname :=
414: IBY_SECURITY_PKG.Mask_Data(instr_owner_name_in,
415: IBY_SECURITY_PKG.G_MASK_ALL,
416: 0,
417: 'X'
418: );
419: l_encrypted := 'Y';

Line 495: iby_security_pkg.get_salt_version,'Y',sub_key_id_in);

491: fnd_global.login_id, 1, l_cc_type, trxnref_in,
492: org_type_in, payment_channel_code_in, factored_flag_in,
493: lx_range_id, lx_cc_hash, lx_instr_len, lx_segment_id,
494: l_payer_party_id, process_profile_code_in,
495: iby_security_pkg.get_salt_version,'Y',sub_key_id_in);
496:
497:
498: /*
499: * Fix for bug 5190504:

Line 708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

704: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
705: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
706: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
707: payerid_in IN iby_trxn_summaries_all.payerid%type,
708: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
709: subkey_seed_in IN RAW,
710: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
711: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
712: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

Line 891: iby_security_pkg.get_salt_version,'Y', settlement_date_in, settlement_due_date_in

887: fnd_global.login_id, 1, l_instrtype, l_instrsubtype, trxnref_in,
888: org_type_in, nvl(payment_channel_code_in, l_pmt_chnl_code), factored_flag_in,
889: lx_cc_hash, lx_instr_len, lx_range_id, lx_segment_id,
890: l_payer_party_id, l_process_profile_code,
891: iby_security_pkg.get_salt_version,'Y', settlement_date_in, settlement_due_date_in
892: );
893:
894: INSERT INTO iby_trxn_core
895: (TrxnMID, ReferenceCode, TraceNumber, InstrName,

Line 1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

1098: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
1099: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
1100: payerid_in IN iby_trxn_summaries_all.payerid%type,
1101: instrtype_in IN iby_trxn_summaries_all.instrType%type,
1102: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
1103: subkey_seed_in IN RAW,
1104: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
1105: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
1106: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 6287: p_payee_key IN iby_security_pkg.des3_key_type,

6283: END getTIDUniqueCheck;
6284:
6285: FUNCTION unencrypt_instr_num
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,

Line 6299: l_subkey_cleartxt iby_security_pkg.des3_key_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
6299: l_subkey_cleartxt iby_security_pkg.des3_key_type;
6300: l_subkey_raw RAW(24);
6301: l_number iby_trxn_summaries_all.instrnumber%TYPE;
6302: l_number_len NUMBER;
6303: BEGIN

Line 6330: IBY_SECURITY_PKG.Decode_Number(l_number,l_number_len,TRUE);

6326: -- if the rest of the number is in the unmasked digit, don't bother
6327: -- decompressing
6328: IF ( l_number_len > 0 ) THEN
6329: l_number :=
6330: IBY_SECURITY_PKG.Decode_Number(l_number,l_number_len,TRUE);
6331: ELSE
6332: l_number := '';
6333: END IF;
6334:

Line 6338: iby_security_pkg.G_MASK_ALL,0,'');

6334:
6335: RETURN
6336: IBY_CREDITCARD_PKG.Uncompress_CC_Number
6337: (l_number,l_number_len,p_card_prefix,p_digit_check,
6338: iby_security_pkg.G_MASK_ALL,0,'');
6339: ELSE
6340: RETURN iby_utility_pvt.decode64(p_instrnum);
6341: END IF;
6342: END unencrypt_instr_num;

Line 6346: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

6342: END unencrypt_instr_num;
6343:
6344: PROCEDURE unencrypt_instr_num
6345: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6346: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
6347: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
6348: )
6349: IS
6350: l_subkey_cipher iby_payee_subkeys.subkey_cipher_text%TYPE;

Line 6399: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

6395:
6396: FUNCTION unencrypt_instr_num
6397: (
6398: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6399: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6400: )
6401: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6402: IS
6403: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

Line 6412: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

6408:
6409: FUNCTION unencrypt_instr_num_ui_wrp
6410: (
6411: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
6412: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
6413: )
6414: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6415: IS
6416: l_instrnum iby_trxn_summaries_all.instrnumber%TYPE;

Line 6428: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE, x_err_code OUT NOCOPY VARCHAR2)

6424:
6425: END unencrypt_instr_num_ui_wrp;
6426:
6427: PROCEDURE Encrypt_CC_Data
6428: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE, x_err_code OUT NOCOPY VARCHAR2)
6429: IS
6430: -- types
6431: TYPE Num15Tab IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
6432: TYPE Char60Tab IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;

Line 6498: iby_security_pkg.G_ENCRYPT_MODE_NONE)

6494:
6495: BEGIN
6496:
6497: IF (iby_creditcard_pkg.Get_CC_Encrypt_Mode() =
6498: iby_security_pkg.G_ENCRYPT_MODE_NONE)
6499: THEN
6500: RETURN;
6501: END IF;
6502: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);

Line 6502: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);

6498: iby_security_pkg.G_ENCRYPT_MODE_NONE)
6499: THEN
6500: RETURN;
6501: END IF;
6502: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);
6503: IF (NOT x_err_code IS NULL) THEN
6504: RETURN;
6505: END IF;
6506:

Line 6569: IBY_SECURITY_PKG.encrypt_field_vals(core_rec.chname,

6565: -- present here need to be secured
6566: IF( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y') THEN
6567: FOR core_rec IN c_trxn_core LOOP
6568: l_chname_sec_segment_id :=
6569: IBY_SECURITY_PKG.encrypt_field_vals(core_rec.chname,
6570: p_sys_key,
6571: null,
6572: 'N'
6573: );

Line 6575: IBY_SECURITY_PKG.encrypt_date_field(core_rec.expdate,

6571: null,
6572: 'N'
6573: );
6574: l_expdate_sec_segment_id :=
6575: IBY_SECURITY_PKG.encrypt_date_field(core_rec.expdate,
6576: p_sys_key,
6577: null,
6578: 'N'
6579: );

Line 6581: IBY_SECURITY_PKG.Mask_Data(core_rec.chname,

6577: null,
6578: 'N'
6579: );
6580: l_masked_chname :=
6581: IBY_SECURITY_PKG.Mask_Data(core_rec.chname,
6582: IBY_SECURITY_PKG.G_MASK_ALL,
6583: 0,
6584: 'X'
6585: );

Line 6582: IBY_SECURITY_PKG.G_MASK_ALL,

6578: 'N'
6579: );
6580: l_masked_chname :=
6581: IBY_SECURITY_PKG.Mask_Data(core_rec.chname,
6582: IBY_SECURITY_PKG.G_MASK_ALL,
6583: 0,
6584: 'X'
6585: );
6586: l_encrypted := 'Y';

Line 6608: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE, x_err_code OUT NOCOPY VARCHAR2)

6604:
6605: END Encrypt_CC_Data;
6606:
6607: PROCEDURE Decrypt_CC_Data
6608: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE, x_err_code OUT NOCOPY VARCHAR2)
6609: IS
6610: -- types
6611: TYPE Num15Tab IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
6612: TYPE Char60Tab IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;

Line 6626: CURSOR c_tx_ccnumber(ci_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE)

6622: l_chname VARCHAR2(80);
6623: l_str_exp_date VARCHAR2(20);
6624: l_exp_date DATE;
6625:
6626: CURSOR c_tx_ccnumber(ci_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE)
6627: IS
6628: SELECT /*+ rowid(tx) */
6629: tx.trxnmid,
6630: iby_transactioncc_pkg.unencrypt_instr_num

Line 6670: iby_security_pkg.G_ENCRYPT_MODE_NONE)

6666: WHERE NVL(encrypted, 'N') = 'Y';
6667:
6668: BEGIN
6669: IF (iby_creditcard_pkg.Get_CC_Encrypt_Mode() =
6670: iby_security_pkg.G_ENCRYPT_MODE_NONE)
6671: THEN
6672: RETURN;
6673: END IF;
6674: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);

Line 6674: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);

6670: iby_security_pkg.G_ENCRYPT_MODE_NONE)
6671: THEN
6672: RETURN;
6673: END IF;
6674: iby_security_pkg.validate_sys_key(p_sys_key,x_err_code);
6675: IF (NOT x_err_code IS NULL) THEN
6676: RETURN;
6677: END IF;
6678:

Line 6728: l_exp_date := IBY_SECURITY_PKG.decrypt_date_field

6724:
6725: IF( IBY_CREDITCARD_PKG.Other_CC_Attribs_Encrypted = 'Y') THEN
6726: FOR core_rec IN c_trxn_core LOOP
6727: IF (core_rec.expiry_sec_segment_id IS NOT NULL) THEN
6728: l_exp_date := IBY_SECURITY_PKG.decrypt_date_field
6729: (core_rec.expiry_sec_segment_id,
6730: p_sys_key
6731: );
6732:

Line 6739: l_chname := IBY_SECURITY_PKG.decrypt_field_vals

6735: l_exp_date := core_rec.instr_expirydate;
6736: END IF;
6737:
6738: IF(core_rec.chname_sec_segment_id IS NOT NULL) THEN
6739: l_chname := IBY_SECURITY_PKG.decrypt_field_vals
6740: (core_rec.chname_sec_segment_id,
6741: p_sys_key
6742: );
6743: ELSE