[Home] [Help]
PACKAGE: APPS.IBY_DISBURSEMENT_SETUP_PUB
Source
4 --
1 PACKAGE IBY_DISBURSEMENT_SETUP_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyfdsts.pls 120.11.12020000.1 2012/06/27 12:10:16 appldev ship $*/
3
5 -- Declaring Global variables
6 --
7
8 -- Package name
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_DISBURSEMENT_SETUP_PUB';
10
11 -- Module name used for the application debugging framework
12 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_DISBURSEMENT_SETUP_PUB';
13
14 -- Package constants
15 G_PMT_FLOW_DISBURSE CONSTANT VARCHAR2(80) := 'DISBURSEMENTS';
16
20 G_RC_INVALID_DATE_RANGE CONSTANT VARCHAR2(80) := 'INVALID_BEGIN_END_RANGE';
17 G_RC_SUCCESS CONSTANT VARCHAR2(80) := 'SUCCESS';
18 G_RC_INVALID_PAYEE CONSTANT VARCHAR2(80) := 'INVALID_PARTY_CONTEXT';
19 G_RC_INVALID_INSTRUMENT CONSTANT VARCHAR2(80) := 'INVALID_INSTRUMENT';
21 G_RC_INVALID_LOOKUP CONSTANT VARCHAR2(80) := 'INVALID_LOOKUP_VALUE';
22
23 G_PAYEE_LEVEL_PARTY CONSTANT VARCHAR2(80) := 'PARTY_LEVEL';
24 G_LE_LEVEL_PARTY CONSTANT VARCHAR2(80) := 'LE_LEVEL';
25 G_PAYEE_LEVEL_SITE CONSTANT VARCHAR2(80) := 'PARTY_SITE_LEVEL';
26 G_PAYEE_LEVEL_SITE_ORG CONSTANT VARCHAR2(80) := 'PARTY_SITE_ORG_LEVEL';
27 G_PAYEE_LEVEL_SUPP_SITE CONSTANT VARCHAR2(80) := 'SUPPLIER_SITE_LEVEL';
28 G_PAYEE_EMP_SITE CONSTANT VARCHAR2(80) := 'EMPLOYEE_SUPPLIER_SITE_LEVEL';
29 --
30 -- Data Structures needed by the APIs
31 --
32
33 -- External payee record and table
34 Type External_Payee_Rec_Type IS Record(
35 Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
36 Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
37 Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
38 Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
39 Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
40 Payer_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
41 Payer_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
42 Default_Pmt_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
43 ECE_TP_Loc_Code IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
44 Bank_Charge_Bearer IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
45 Bank_Instr1_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
46 Bank_Instr2_Code IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
47 Bank_Instr_Detail IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
48 Pay_Reason_Code IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
49 Pay_Reason_Com IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
50 Inactive_Date IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
51 Pay_Message1 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
52 Pay_Message2 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
53 Pay_Message3 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
54 Delivery_Channel IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
55 Pmt_Format IBY_FORMATS_B.format_code%TYPE,
56 Settlement_Priority IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE,
57 Remit_advice_delivery_method
58 IBY_EXTERNAL_PAYEES_ALL.remit_advice_delivery_method%TYPE,
59 Remit_advice_email IBY_EXTERNAL_PAYEES_ALL.remit_advice_email%TYPE,
60 edi_payment_format IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
61 edi_transaction_handling IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
62 edi_payment_method IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
63 edi_remittance_method IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
64 edi_remittance_instruction IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
65 remit_advice_fax IBY_EXTERNAL_PAYEES_ALL.REMIT_ADVICE_FAX%TYPE );
66
67 TYPE External_Payee_Tab_Type IS TABLE OF External_Payee_Rec_Type
68 INDEX BY BINARY_INTEGER;
69
70 -- External payee Id record and table
71 Type Ext_Payee_ID_Rec_Type IS Record(
72 Ext_Payee_ID IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE
73 );
74
75 TYPE Ext_Payee_ID_Tab_Type IS TABLE OF Ext_Payee_ID_Rec_Type
76 INDEX BY BINARY_INTEGER;
77
78 -- External payee creation record and table
79 Type Ext_Payee_Create_Rec_Type IS Record(
80 Payee_Creation_Status VARCHAR2(1),
81 Payee_Creation_Msg VARCHAR2(2000)
82 );
83
84 TYPE Ext_Payee_Create_Tab_Type IS TABLE OF Ext_Payee_Create_Rec_Type
85 INDEX BY BINARY_INTEGER;
86
87 -- Payee context record and table
88 TYPE PayeeContext_Rec_Type IS RECORD (
89 Payment_Function VARCHAR2(30),
90 Party_Id NUMBER,
91 Org_Type VARCHAR2(30),
92 Org_Id NUMBER,
93 Party_Site_id NUMBER,
94 Supplier_Site_id NUMBER
95 );
96
97 TYPE PayeeContext_Tab_Type IS TABLE OF PayeeContext_Rec_Type
98 INDEX BY BINARY_INTEGER;
99
100 -- External payee update record and table
101 Type Ext_Payee_Update_Rec_Type IS Record(
102 Payee_Update_Status VARCHAR2(1),
103 Payee_Update_Msg VARCHAR2(2000)
104 );
105
106 TYPE Ext_Payee_Update_Tab_Type IS TABLE OF Ext_Payee_Update_Rec_Type
107 INDEX BY BINARY_INTEGER;
108
109 --
110 -- Public API's
111 --
112
113 -- External Payee
114 PROCEDURE Create_External_Payee (
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
117 p_ext_payee_tab IN External_Payee_Tab_Type,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 x_ext_payee_id_tab OUT NOCOPY Ext_Payee_ID_Tab_Type,
122 x_ext_payee_status_tab OUT NOCOPY Ext_Payee_Create_Tab_Type
123 );
124
125 PROCEDURE Set_Payee_Instr_Assignment (
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128 p_commit IN VARCHAR2 := FND_API.G_TRUE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_payee IN PayeeContext_rec_type,
133 p_assignment_attribs IN IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type,
134 x_assign_id OUT NOCOPY NUMBER,
135 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
136 );
137
138 PROCEDURE Get_Payee_Instr_Assignments (
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_payee IN PayeeContext_rec_type,
145 x_assignments OUT NOCOPY IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_tbl_type,
146 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
147 );
148
149 PROCEDURE Get_Payee_All_Instruments (
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_party_id IN NUMBER,
156 x_instruments OUT NOCOPY IBY_FNDCPT_SETUP_PUB.PmtInstrument_tbl_type,
157 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
158 );
159
160 PROCEDURE Validate_External_Payee (
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
163 p_ext_payee_rec IN External_Payee_Rec_Type,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2
167 );
168
169 PROCEDURE Create_Temp_Ext_Bank_Acct (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_temp_ext_acct_id IN NUMBER,
176 x_bank_acc_id OUT NOCOPY Number,
177 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
178 );
179
180 PROCEDURE Create_Temp_Ext_Bank_Acct (
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_temp_ext_acct_id IN NUMBER,
187 p_association_level IN VARCHAR2,
188 p_supplier_site_id IN NUMBER,
189 p_party_site_id IN NUMBER,
190 p_org_id IN NUMBER,
191 p_org_type IN VARCHAR2 default NULL,
192 x_bank_acc_id OUT NOCOPY Number,
193 x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
194 );
195
196
197 PROCEDURE Validate_Temp_Ext_Bank_Acct (
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_temp_ext_acct_id IN NUMBER
204 );
205
206 --
207 -- Public API's
208 --
209
210 -- Update External Payee
211 PROCEDURE Update_External_Payee (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
214 p_ext_payee_tab IN External_Payee_Tab_Type,
215 p_ext_payee_id_tab IN Ext_Payee_ID_Tab_Type,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 x_ext_payee_status_tab OUT NOCOPY Ext_Payee_Update_Tab_Type
220 );
221
222
223 END IBY_DISBURSEMENT_SETUP_PUB;