DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 109: Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,

105:
106:
107:
108: TYPE SettlementResult_rec_type IS RECORD (
109: Trxn_Extension_Id iby_fndcpt_tx_extensions.TRXN_EXTENSION_ID%TYPE,
110: Result IBY_FNDCPT_COMMON_PUB.Result_rec_type
111: );
112:
113:

Line 486: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,

482: --
483: PROCEDURE Encrypt_Security_Code
484: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
485: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
486: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
487: x_segment_id OUT NOCOPY NUMBER,
488: x_err_code OUT NOCOPY VARCHAR2
489: );
490:

Line 510: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,

506: -- Type : Private
507: -- Purpose : Gets the clear-text instrument security code
508: --
509: FUNCTION Get_Security_Code
510: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
511: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
512: )
513: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
514:

Line 513: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

509: FUNCTION Get_Security_Code
510: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
511: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
512: )
513: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
514:
515: -- 102.5
516: -- Function : Get_Security_Code
517: -- Type : Private

Line 524: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE

520: FUNCTION Get_Security_Code
521: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
522: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
523: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
524: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
525: )
526: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
527:
528: -- 103.

Line 526: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

522: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
523: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
524: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
525: )
526: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
527:
528: -- 103.
529: --
530: -- Function : Get_Tangible_Id

Line 539: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,

535: -- be used for new orders.
536: --
537: FUNCTION Get_Tangible_Id
538: (p_app_short_name IN fnd_application.application_short_name%TYPE,
539: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
540: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
541: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
542: )
543: RETURN iby_trxn_summaries_all.tangibleid%TYPE;

Line 540: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,

536: --
537: FUNCTION Get_Tangible_Id
538: (p_app_short_name IN fnd_application.application_short_name%TYPE,
539: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
540: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
541: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
542: )
543: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
544:

Line 541: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE

537: FUNCTION Get_Tangible_Id
538: (p_app_short_name IN fnd_application.application_short_name%TYPE,
539: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
540: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
541: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
542: )
543: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
544:
545: -- 104.

Line 555: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE

551: --
552: --Overloading this function for bug : 7628586
553: FUNCTION Get_Tangible_Id
554: (p_app_short_name IN fnd_application.application_short_name%TYPE,
555: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
556: )
557: RETURN iby_trxn_summaries_all.tangibleid%TYPE;
558:
559: /*--------------------------------------------------------------------