1 PACKAGE IBY_FD_USER_API_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyfduas.pls 120.13 2010/09/01 16:20:48 gmaheswa ship $*/
3
4 --
5 -- Declaring Global variables
6 --
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_FD_USER_API_PUB';
8
9 --
10 -- module name used for the application debugging framework
11 --
12 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FD_USER_API_PUB';
13
14
15 Type Int_Bank_Acc_Tab_Type is Table of NUMBER INDEX by BINARY_INTEGER;
16
17 Type Legal_Entity_Tab_Type is Table of NUMBER INDEX by BINARY_INTEGER;
18
19 Type Org_Rec_Type is Record(
20 org_id number,
21 org_type varchar2(30)
22 );
23
24 Type Org_Tab_Type is Table of Org_Rec_Type INDEX by BINARY_INTEGER;
25
26 Type Currency_Tab_Type is Table of VARCHAR2(10) INDEX by BINARY_INTEGER;
27
28 PROCEDURE Validate_Method_and_Profile (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
31 p_payment_method_code IN VARCHAR2,
32 p_ppp_id IN NUMBER,
33 p_payment_document_id IN NUMBER,
34 p_crt_instr_flag IN VARCHAR2,
35 p_int_bank_acc_arr IN Int_Bank_Acc_Tab_Type,
36 p_le_arr IN Legal_Entity_Tab_Type,
37 p_org_arr IN Org_Tab_Type,
38 p_curr_arr IN Currency_Tab_Type,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 FUNCTION Payment_Instruction_Action (
45 p_instruction_status IN VARCHAR2
46 ) RETURN VARCHAR2;
47
48 FUNCTION Pmt_Instr_Terminate_Enabled (
49 p_instruction_status IN VARCHAR2,
50 p_instruction_id IN NUMBER,
51 p_request_id IN NUMBER DEFAULT NULL
52 ) RETURN VARCHAR2;
53
54 FUNCTION Instr_Sec_Terminate_Enabled (
55 p_instruction_status IN VARCHAR2,
56 p_org_id IN NUMBER,
57 p_instruction_id IN NUMBER,
58 p_request_id IN NUMBER DEFAULT NULL
59 ) RETURN VARCHAR2;
60
61 FUNCTION Pmt_Instr_Action_Enabled (
62 p_instruction_status IN VARCHAR2,
63 p_org_id IN NUMBER,
64 p_instruction_id IN NUMBER,
65 p_request_id IN NUMBER DEFAULT NULL
66 ) RETURN VARCHAR2;
67
68 PROCEDURE retrieve_default_sra_format(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
71 p_instr_id IN NUMBER,
72 x_default_sra_format_code OUT NOCOPY VARCHAR2,
73 x_default_sra_format_name OUT NOCOPY VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 FUNCTION Is_Pmt_Instr_Complete (
80 p_instruction_id IN NUMBER
81 ) RETURN VARCHAR2;
82
83
84 FUNCTION Pmt_Instr_Terminate_Allowed (
85 p_instruction_id IN NUMBER
86 ) RETURN VARCHAR2;
87
88 FUNCTION Pmt_Instr_Sec_Term_Allowed (
89 p_instruction_status IN VARCHAR2,
90 p_process_type IN VARCHAR2,
91 p_instruction_id IN NUMBER,
92 p_org_id IN NUMBER,
93 p_pmt_complete_code IN VARCHAR2,
94 p_request_id IN NUMBER DEFAULT NULL,
95 p_msg_req IN VARCHAR2 DEFAULT 'Y'
96 ) RETURN VARCHAR2;
97
98 FUNCTION PPR_Sec_Term_Allowed (
99 p_pay_service_req_id IN NUMBER
100 ) RETURN VARCHAR2;
101
102 FUNCTION Is_transmitted_Pmt_Inst_Compl (
103 p_instruction_id IN NUMBER
104 ) RETURN VARCHAR2;
105
106 END IBY_FD_USER_API_PUB;