DBA Data[Home] [Help]

APPS.IBY_SECURITY_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 595: p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,

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,

Line 596: p_instrtype IN iby_trxn_summaries_all.instrtype%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,

Line 597: x_instrnum OUT NOCOPY iby_trxn_summaries_all.instrnumber%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,

Line 598: x_instr_subtype OUT NOCOPY iby_trxn_summaries_all.instrsubtype%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

Line 599: x_instr_hash OUT NOCOPY iby_trxn_summaries_all.instrnum_hash%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: );

Line 600: x_range_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%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: );
604:

Line 601: x_instr_len OUT NOCOPY iby_trxn_summaries_all.instrnum_length%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:
605: FUNCTION unencrypt_instr_num

Line 602: x_segment_id OUT NOCOPY iby_trxn_summaries_all.instrnum_sec_segment_id%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
606: (p_instrnum IN iby_trxn_summaries_all.instrnumber%TYPE,

Line 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,

Line 617: RETURN iby_trxn_summaries_all.instrnumber%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,

Line 620: (trxnmid_in IN iby_trxn_summaries_all.trxnmid%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:

Line 622: instr_num_out OUT NOCOPY 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:
625: --secure data
626: PROCEDURE Encrypt_Setup_Data (