591:
592: PROCEDURE prepare_instr_data
593: (p_commit IN VARCHAR2,
594: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
592: PROCEDURE prepare_instr_data
593: (p_commit IN VARCHAR2,
594: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
593: (p_commit IN VARCHAR2,
594: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
594: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
603: );
596: p_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
603: );
604:
597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE,
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
603: );
604:
605: FUNCTION unencrypt_instr_num
598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%TYPE,
599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%TYPE,
600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE,
601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
603: );
604:
605: FUNCTION unencrypt_instr_num
606: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%TYPE
603: );
604:
605: FUNCTION unencrypt_instr_num
606: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,
607: p_payee_key IN iby_security_pkg.des3_key_type,
608: p_payee_subkey_cipher IN iby_payee_subkeys.subkey_cipher_text%TYPE,
609: p_sys_key IN RAW,
610: p_sys_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
613: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
614: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
615: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
616: )
617: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
618:
619: PROCEDURE unencrypt_instr_num
620: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
621: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
616: )
617: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
618:
619: PROCEDURE unencrypt_instr_num
620: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
621: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
622: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
623: );
624:
618:
619: PROCEDURE unencrypt_instr_num
620: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%TYPE,
621: master_key_in IN iby_security_pkg.DES3_KEY_TYPE,
622: instr_num_out OUT NOCOPY iby_trxn_summaries_all.instrnumber%TYPE
623: );
624:
625: --secure data
626: PROCEDURE Encrypt_Setup_Data (