APPS.IBY_TRANSACTIONCC_PKG dependencies on IBY_SECURITY_PKG

Line 236: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,

232: );
233:
234: PROCEDURE prepare_instr_data
235: (p_commit IN VARCHAR2,
236: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
237: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
238: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
239: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
240: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,

Line 293: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

289: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
290: payerid_in IN iby_trxn_summaries_all.payerid%type,
291: instrtype_in IN iby_trxn_summaries_all.instrType%type,
292: cvv2result_in IN iby_trxn_core.CVV2Result%type,
293: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
294: subkey_seed_in IN RAW,
295: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
296: dateofvoiceauth_in IN iby_trxn_core.date_of_voice_authorization%TYPE,
297: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,

Line 389: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

385: eft_auth_method_in IN iby_tangible.eft_auth_method%TYPE,
386: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
387: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
388: payerid_in IN iby_trxn_summaries_all.payerid%type,
389: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
390: subkey_seed_in IN RAW,
391: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
392: instr_expirydate_in IN iby_trxn_core.instr_expirydate%TYPE,
393: card_subtype_in IN iby_trxn_core.card_subtype_code%TYPE,

Line 443: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

439: payerinstrid_in IN iby_trxn_summaries_all.payerinstrid%type,
440: instrnum_in IN iby_trxn_summaries_all.instrnumber%type,
441: payerid_in IN iby_trxn_summaries_all.payerid%type,
442: instrtype_in IN iby_trxn_summaries_all.instrType%type,
443: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
444: subkey_seed_in IN RAW,
445: trxnref_in IN iby_trxn_summaries_all.trxnref%TYPE,
446: transaction_id_out OUT NOCOPY iby_trxn_summaries_all.TransactionID%TYPE,
447: transaction_mid_out OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE,

Line 816: p_payee_key IN iby_security_pkg.des3_key_type,

812:
813:
814: FUNCTION unencrypt_instr_num
815: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
816: p_payee_key IN iby_security_pkg.des3_key_type,
817: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
818: p_sys_key IN RAW,
819: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
820: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

Line 845: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,

841: * set then the applicable row in the table will not be updated
842: */
843: PROCEDURE unencrypt_instr_num
844: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
845: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
846: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
847: );
848:
849: /* Functional version of above procedure so that it can be used

Line 854: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

850: * 'in-line' in SQL statements.
851: */
852: FUNCTION unencrypt_instr_num
853: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
854: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
855: )
856: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
857:
858: /* Wrapper of above function for UI. In the UI the

Line 870: master_key_in IN iby_security_pkg.DES3_KEY_TYPE

866: */
867: FUNCTION unencrypt_instr_num_ui_wrp
868: (
869: trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
870: master_key_in IN iby_security_pkg.DES3_KEY_TYPE
871: )
872: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
873:
874: -- USE

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

874: -- USE
875: -- Encrypts (historical) transactional credit card data
876: --
877: PROCEDURE Encrypt_CC_Data
878: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,x_err_code OUT NOCOPY VARCHAR2);
879:
880: -- USE
881: -- Decrypts (historical) transactional credit card data
882: --

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

880: -- USE
881: -- Decrypts (historical) transactional credit card data
882: --
883: PROCEDURE Decrypt_CC_Data
884: (p_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE,x_err_code OUT NOCOPY VARCHAR2);
885:
886: /*
887: * USE: Checks if the number of transactions in the current open
888: * batch exceeds the max batch size.