DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_SECURITY_PKG

Line 158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,

154: );
155:
156: PROCEDURE prepare_instr_data
157: (p_commit IN VARCHAR2,
158: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
159: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
160: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
161: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
162: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,

Line 215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

211: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
212: payerid_in IN iby_trxn_summaries_all.payerid%type,
213: instrtype_in IN iby_trxn_summaries_all.instrType%type,
214: cvv2result_in IN iby_trxn_core.CVV2Result%type,
215: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
216: subkey_seed_in IN RAW,
217: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
218: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
219: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

Line 288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

284: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
285: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
286: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
287: payerid_in IN iby_trxn_summaries_all.payerid%type,
288: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
289: subkey_seed_in IN RAW,
290: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
291: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
292: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

Line 340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

336: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
337: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
338: payerid_in IN iby_trxn_summaries_all.payerid%type,
339: instrtype_in IN iby_trxn_summaries_all.instrType%type,
340: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
341: subkey_seed_in IN RAW,
342: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
343: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
344: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 712: p_payee_key IN iby_security_pkg.des3_key_type,

708:
709:
710: FUNCTION unencrypt_instr_num
711: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
712: p_payee_key IN iby_security_pkg.des3_key_type,
713: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
714: p_sys_key IN RAW,
715: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
716: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

Line 741: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

737: * set then the applicable row in the table will not be updated
738: */
739: PROCEDURE unencrypt_instr_num
740: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
741: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
742: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
743: );
744:
745: /* Functional version of above procedure so that it can be used

Line 750: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

746: * 'in-line' in SQL statements.
747: */
748: FUNCTION unencrypt_instr_num
749: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
750: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
751: )
752: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
753:
754: /* Wrapper of above function for UI. In the UI the

Line 766: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

762: */
763: FUNCTION unencrypt_instr_num_ui_wrp
764: (
765: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
766: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
767: )
768: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
769:
770: -- USE

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

770: -- USE
771: -- Encrypts (historical) transactional credit card data
772: --
773: PROCEDURE Encrypt_CC_Data
774: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,x_err_code OUT NOCOPY VARCHAR2);
775:
776: -- USE
777: -- Decrypts (historical) transactional credit card data
778: --

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

776: -- USE
777: -- Decrypts (historical) transactional credit card data
778: --
779: PROCEDURE Decrypt_CC_Data
780: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,x_err_code OUT NOCOPY VARCHAR2);
781:
782: /*
783: * USE: Checks if the number of transactions in the current open
784: * batch exceeds the max batch size.