124:
125:
126:
127: TYPE SettlementResult_rec_type IS RECORD (
128: Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
129: Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
130: );
131:
132: TYPE ReversalResult_rec_type IS RECORD (
129: Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
130: );
131:
132: TYPE ReversalResult_rec_type IS RECORD (
133: Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
134: Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
135: );
136:
137:
282: );
283:
284: PROCEDURE Secure_Wipe_Segment
285: (
286: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE
287: );
288:
289: -- 6. Create_Authorization
290: --
567: --
568: PROCEDURE Encrypt_Security_Code
569: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
570: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
571: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
572: x_segment_id OUT NOCOPY NUMBER,
573: x_err_code OUT NOCOPY VARCHAR2
574: );
575:
593: -- for a given segment_id
594: --
595: FUNCTION Get_Security_Code
596: (
597: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE,
598: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE,
599: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
600: )
601: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
594: --
595: FUNCTION Get_Security_Code
596: (
597: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE,
598: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE,
599: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
600: )
601: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
602:
597: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE,
598: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE,
599: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
600: )
601: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
602:
603: -- 102.
604: --
605: -- Function : Get_Security_Code
608: -- for a given extension_id
609: --
610: FUNCTION Get_Security_Code
611: (
612: p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
613: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
614: )
615: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
616:
611: (
612: p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
613: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
614: )
615: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
616:
617: -- 102.5
618: -- Function : Get_Security_Code
619: -- Type : Private
622: FUNCTION Get_Security_Code
623: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
624: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
625: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
626: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
627: )
628: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
629:
630: -- 103.
624: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
625: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
626: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
627: )
628: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
629:
630: -- 103.
631: --
632: -- Function : Get_Tangible_Id
637: -- be used for new orders.
638: --
639: FUNCTION Get_Tangible_Id
640: (p_app_short_name IN fnd_application.application_short_name%TYPE,
641: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
642: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
643: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
644: )
645: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
638: --
639: FUNCTION Get_Tangible_Id
640: (p_app_short_name IN fnd_application.application_short_name%TYPE,
641: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
642: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
643: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
644: )
645: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
646:
639: FUNCTION Get_Tangible_Id
640: (p_app_short_name IN fnd_application.application_short_name%TYPE,
641: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
642: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
643: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
644: )
645: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
646:
647: -- 104.
653: --
654: --Overloading this function for bug : 7628586
655: FUNCTION Get_Tangible_Id
656: (p_app_short_name IN fnd_application.application_short_name%TYPE,
657: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
658: )
659: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
660:
661: /*--------------------------------------------------------------------