eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.POS_SBD_PKG

Source


1 PACKAGE POS_SBD_PKG AUTHID CURRENT_USER as
2 /*$Header: POSSBDS.pls 120.3.12020000.2 2013/04/07 13:53:22 pneralla ship $ */
3 
4 /* This procedure removes the account on buyer's request.
5  * It will be directy called from the AM.
6  */
7 PROCEDURE buyer_remove_account (
8   p_account_request_id	   IN NUMBER
9 , p_object_version_number  IN NUMBER
10 , x_status        out nocopy VARCHAR2
11 , x_exception_msg out nocopy VARCHAR2
12 );
13 
14 /* This procedure removes the account on supplier's request.
15  *
16  */
17 PROCEDURE supplier_remove_account (
18   p_account_request_id	   IN NUMBER
19 , p_object_version_number  IN NUMBER
20 , x_status        out nocopy VARCHAR2
21 , x_exception_msg out nocopy VARCHAR2
22 );
23 
24 /* This procedure removes the account.
25  *
26  */
27 PROCEDURE remove_account (
28   p_account_request_id	   IN NUMBER
29 , p_object_version_number  IN NUMBER
30 , x_status        out nocopy VARCHAR2
31 , x_exception_msg out nocopy VARCHAR2
32 );
33 
34 /* This procedure updates the payment preferences.
35  *
36  */
37 PROCEDURE update_payment_pref(
38   p_payment_preference_id     IN NUMBER
39 , p_party_id                  IN NUMBER
40 , p_party_site_id             IN NUMBER
41 , p_payment_currency_code     IN VARCHAR2
42 , p_invoice_currency_code     IN VARCHAR2
43 , p_payment_method            IN VARCHAR2
44 , p_notification_method       IN VARCHAR2
45 , p_object_version_number  IN NUMBER
46 , x_status        out nocopy VARCHAR2
47 , x_exception_msg out nocopy VARCHAR2
48 );
49 
50 /* This procedure creates an account as a supplier
51  * This is called when the supplier submits the request
52  * for a new Account.
53  */
54 
55 PROCEDURE supplier_create_account (
56   p_mapping_id in NUMBER
57 , p_request_type in varchar2
58 , p_address_request_id in number
59 , p_party_site_id in number
60 
61 -- Bank
62 , p_BANK_ID in NUMBER
63 , p_BANK_NAME in VARCHAR2
64 , p_BANK_NAME_ALT in varchar2
65 , p_BANK_NUMBER in VARCHAR2
66 , p_BANK_INSTITUTION in varchar2
67 , p_BANK_ADDRESS1 in VARCHAR2
68 , p_BANK_ADDRESS2 in VARCHAR2
69 , p_BANK_ADDRESS3 in VARCHAR2
70 , p_BANK_ADDRESS4 in VARCHAR2
71 , p_BANK_CITY in VARCHAR2
72 , p_BANK_COUNTY in VARCHAR2
73 , p_BANK_STATE VARCHAR2
74 , p_BANK_ZIP in VARCHAR2
75 , p_BANK_PROVINCE in VARCHAR2
76 , p_BANK_COUNTRY in VARCHAR2
77 
78 -- Branch
79 , p_BRANCH_ID in NUMBER
80 , p_BRANCH_NAME in VARCHAR2
81 , p_BRANCH_NAME_ALT in varchar2
82 , p_BRANCH_NUMBER in VARCHAR2
83 , p_BRANCH_TYPE in varchar2
84 , p_RFC_IDENTIFIER in varchar2
85 , p_BIC in varchar2
86 , p_BRANCH_ADDRESS1 in VARCHAR2
87 , p_BRANCH_ADDRESS2 in VARCHAR2
88 , p_BRANCH_ADDRESS3 in VARCHAR2
89 , p_BRANCH_ADDRESS4 in VARCHAR2
90 , p_BRANCH_CITY in VARCHAR2
91 , p_BRANCH_COUNTY in VARCHAR2
92 , p_BRANCH_STATE VARCHAR2
93 , p_BRANCH_ZIP in VARCHAR2
94 , p_BRANCH_PROVINCE in VARCHAR2
95 , p_BRANCH_COUNTRY in VARCHAR2
96 
97 -- Account
98 , p_EXT_BANK_ACCOUNT_ID in number
99 , p_bank_account_number in varchar2
100 , p_bank_account_name in varchar2
101 , p_bank_account_name_alt in varchar2
102 , p_check_digits in varchar2
103 , p_iban in varchar2
104 , p_currency_code in varchar2
105 , p_country_code in varchar2
106 , p_FOREIGN_PAYMENT_USE_FLAG in varchar2
107 , p_bank_account_type in varchar2
108 , p_account_description in varchar2
109 , p_end_date in date
110 , p_start_date in date
111 , p_agency_location_code in varchar2
112 , p_account_suffix in varchar2
113 , p_EXCHANGE_RATE_AGREEMENT_NUM in VARCHAR2
114 , P_EXCHANGE_RATE_AGREEMENT_TYPE in VARCHAR2
115 , p_EXCHANGE_RATE in NUMBER
116 , p_NOTES_FROM_SUPPLIER in VARCHAR2
117 , x_account_request_id	  out nocopy NUMBER
118 , x_status        out nocopy VARCHAR2
119 , x_exception_msg out nocopy VARCHAR2
120 );
121 
122 
123 /* This procedure edits an account as a supplier
124  *
125  */
126 
127 PROCEDURE supplier_update_account (
128   p_mapping_id in NUMBER
129 , p_account_request_id in number
130 , p_object_version_number in number
131 -- Bank
132 , p_BANK_ID in NUMBER
133 , p_BANK_NAME in VARCHAR2
134 , p_BANK_NAME_ALT in varchar2
135 , p_BANK_NUMBER in VARCHAR2
136 , p_BANK_INSTITUTION in varchar2
137 , p_BANK_ADDRESS1 in VARCHAR2
138 , p_BANK_ADDRESS2 in VARCHAR2
139 , p_BANK_ADDRESS3 in VARCHAR2
140 , p_BANK_ADDRESS4 in VARCHAR2
141 , p_BANK_CITY in VARCHAR2
142 , p_BANK_COUNTY in VARCHAR2
143 , p_BANK_STATE VARCHAR2
144 , p_BANK_ZIP in VARCHAR2
145 , p_BANK_PROVINCE in VARCHAR2
146 , p_BANK_COUNTRY in VARCHAR2
147 
148 -- Branch
149 , p_BRANCH_ID in NUMBER
150 , p_BRANCH_NAME in VARCHAR2
151 , p_BRANCH_NAME_ALT in varchar2
152 , p_BRANCH_NUMBER in VARCHAR2
153 , p_BRANCH_TYPE in varchar2
154 , p_RFC_IDENTIFIER in varchar2
155 , p_BIC in varchar2
156 , p_BRANCH_ADDRESS1 in VARCHAR2
157 , p_BRANCH_ADDRESS2 in VARCHAR2
158 , p_BRANCH_ADDRESS3 in VARCHAR2
159 , p_BRANCH_ADDRESS4 in VARCHAR2
160 , p_BRANCH_CITY in VARCHAR2
161 , p_BRANCH_COUNTY in VARCHAR2
162 , p_BRANCH_STATE VARCHAR2
163 , p_BRANCH_ZIP in VARCHAR2
164 , p_BRANCH_PROVINCE in VARCHAR2
165 , p_BRANCH_COUNTRY in VARCHAR2
166 
167 -- Account
168 , p_EXT_BANK_ACCOUNT_ID in number
169 , p_bank_account_number in varchar2
170 , p_bank_account_name in varchar2
171 , p_bank_account_name_alt in varchar2
172 , p_check_digits in varchar2
173 , p_iban in varchar2
174 , p_currency_code in varchar2
175 , p_country_code in varchar2
176 , p_FOREIGN_PAYMENT_USE_FLAG in varchar2
177 , p_bank_account_type in varchar2
178 , p_account_description in varchar2
179 , p_end_date in date
180 , p_start_date in date
181 , p_agency_location_code in varchar2
182 , p_account_suffix in varchar2
183 , p_EXCHANGE_RATE_AGREEMENT_NUM in VARCHAR2
184 , P_EXCHANGE_RATE_AGREEMENT_TYPE in VARCHAR2
185 , p_EXCHANGE_RATE in NUMBER
186 , p_NOTES_FROM_SUPPLIER in VARCHAR2
187 , x_account_request_id	  out nocopy NUMBER
188 , x_status        out nocopy VARCHAR2
189 , x_exception_msg out nocopy VARCHAR2
190 );
191 
192 
193 /* This procedure approves an account as a buyer
194  *
195  */
196 
197 PROCEDURE buyer_approve_account (
198   p_party_id in NUMBER
199 , p_account_request_id in number
200 , p_object_version_number in number
201 -- Bank
202 , p_BANK_ID in NUMBER
203 , p_BANK_NAME in VARCHAR2
204 , p_BANK_NAME_ALT in varchar2
205 , p_BANK_NUMBER in VARCHAR2
206 , p_BANK_INSTITUTION in varchar2
207 , p_BANK_ADDRESS1 in VARCHAR2
208 , p_BANK_ADDRESS2 in VARCHAR2
209 , p_BANK_ADDRESS3 in VARCHAR2
210 , p_BANK_ADDRESS4 in VARCHAR2
211 , p_BANK_CITY in VARCHAR2
212 , p_BANK_COUNTY in VARCHAR2
213 , p_BANK_STATE VARCHAR2
214 , p_BANK_ZIP in VARCHAR2
215 , p_BANK_PROVINCE in VARCHAR2
216 , p_BANK_COUNTRY in VARCHAR2
217 
218 -- Branch
219 , p_BRANCH_ID in NUMBER
220 , p_BRANCH_NAME in VARCHAR2
221 , p_BRANCH_NAME_ALT in varchar2
222 , p_BRANCH_NUMBER in VARCHAR2
223 , p_BRANCH_TYPE in varchar2
224 , p_RFC_IDENTIFIER in varchar2
225 , p_BIC in varchar2
226 , p_BRANCH_ADDRESS1 in VARCHAR2
227 , p_BRANCH_ADDRESS2 in VARCHAR2
228 , p_BRANCH_ADDRESS3 in VARCHAR2
229 , p_BRANCH_ADDRESS4 in VARCHAR2
230 , p_BRANCH_CITY in VARCHAR2
231 , p_BRANCH_COUNTY in VARCHAR2
232 , p_BRANCH_STATE VARCHAR2
233 , p_BRANCH_ZIP in VARCHAR2
234 , p_BRANCH_PROVINCE in VARCHAR2
235 , p_BRANCH_COUNTRY in VARCHAR2
236 
237 -- Account
238 , p_EXT_BANK_ACCOUNT_ID in number
239 , p_bank_account_number in varchar2
240 , p_bank_account_name in varchar2
241 , p_bank_account_name_alt in varchar2
242 , p_check_digits in varchar2
243 , p_iban in varchar2
244 , p_currency_code in varchar2
245 , p_country_code in varchar2
246 , p_FOREIGN_PAYMENT_USE_FLAG in varchar2
247 , p_bank_account_type in varchar2
248 , p_account_description in varchar2
249 , p_end_date in date
250 , p_start_date in date
251 , p_agency_location_code in varchar2
252 , p_account_suffix in varchar2
253 , p_EXCHANGE_RATE_AGREEMENT_NUM in VARCHAR2
254 , P_EXCHANGE_RATE_AGREEMENT_TYPE in VARCHAR2
255 , p_EXCHANGE_RATE in NUMBER
256 , p_NOTES_FROM_BUYER in VARCHAR2
257 , x_status        out nocopy VARCHAR2
258 , x_exception_msg out nocopy VARCHAR2
259 );
260 
261 /* This procedure prenotes an account as a buyer
262  *
263  */
264 PROCEDURE buyer_prenote_account (
265   p_party_id in NUMBER
266 , p_account_request_id in number
267 , p_object_version_number in number
268 , p_vendor_site_id in number
269 -- Bank
270 , p_BANK_ID in NUMBER
271 , p_BANK_NAME in VARCHAR2
272 , p_BANK_NAME_ALT in varchar2
273 , p_BANK_NUMBER in VARCHAR2
274 , p_BANK_INSTITUTION in varchar2
275 , p_BANK_ADDRESS1 in VARCHAR2
276 , p_BANK_ADDRESS2 in VARCHAR2
277 , p_BANK_ADDRESS3 in VARCHAR2
278 , p_BANK_ADDRESS4 in VARCHAR2
279 , p_BANK_CITY in VARCHAR2
280 , p_BANK_COUNTY in VARCHAR2
281 , p_BANK_STATE VARCHAR2
282 , p_BANK_ZIP in VARCHAR2
283 , p_BANK_PROVINCE in VARCHAR2
284 , p_BANK_COUNTRY in VARCHAR2
285 
286 -- Branch
287 , p_BRANCH_ID in NUMBER
288 , p_BRANCH_NAME in VARCHAR2
289 , p_BRANCH_NAME_ALT in varchar2
290 , p_BRANCH_NUMBER in VARCHAR2
291 , p_BRANCH_TYPE in varchar2
292 , p_RFC_IDENTIFIER in varchar2
293 , p_BIC in varchar2
294 , p_BRANCH_ADDRESS1 in VARCHAR2
295 , p_BRANCH_ADDRESS2 in VARCHAR2
296 , p_BRANCH_ADDRESS3 in VARCHAR2
297 , p_BRANCH_ADDRESS4 in VARCHAR2
298 , p_BRANCH_CITY in VARCHAR2
299 , p_BRANCH_COUNTY in VARCHAR2
300 , p_BRANCH_STATE VARCHAR2
301 , p_BRANCH_ZIP in VARCHAR2
302 , p_BRANCH_PROVINCE in VARCHAR2
303 , p_BRANCH_COUNTRY in VARCHAR2
304 
305 -- Account
306 , p_EXT_BANK_ACCOUNT_ID in number
307 , p_bank_account_number in varchar2
308 , p_bank_account_name in varchar2
309 , p_bank_account_name_alt in varchar2
310 , p_check_digits in varchar2
311 , p_iban in varchar2
312 , p_currency_code in varchar2
313 , p_country_code in varchar2
314 , p_FOREIGN_PAYMENT_USE_FLAG in varchar2
315 , p_bank_account_type in varchar2
316 , p_account_description in varchar2
317 , p_end_date in date
318 , p_start_date in date
319 , p_agency_location_code in varchar2
320 , p_account_suffix in varchar2
321 , p_EXCHANGE_RATE_AGREEMENT_NUM in VARCHAR2
322 , P_EXCHANGE_RATE_AGREEMENT_TYPE in VARCHAR2
323 , p_EXCHANGE_RATE in NUMBER
324 , p_NOTES_FROM_BUYER in VARCHAR2
325 , x_status        out nocopy VARCHAR2
326 , x_exception_msg out nocopy VARCHAR2
327 );
328 
329 /* This procedure rejects the account request
330  *
331  */
332 PROCEDURE buyer_reject_account (
333   p_account_request_id in NUMBER
334 , p_object_version_number in number
335 , p_note_from_buyer in varchar2
336 , x_status        out nocopy VARCHAR2
337 , x_exception_msg out nocopy VARCHAR2
338 );
339 
340 
341 /* This procedure approves the assignment request
342  *
343  */
344 
345 PROCEDURE buyer_approve_assignment (
346   p_party_id in NUMBER
347 , p_assignment_request_id in number
348 , p_object_version_number in number
349 , x_status        out nocopy VARCHAR2
353 /* This procedure rejects the assignment request
350 , x_exception_msg out nocopy VARCHAR2
351 );
352 
354  *
355  */
356 PROCEDURE buyer_reject_assignment (
357   p_party_id in NUMBER
358 , p_assignment_request_id in number
359 , p_object_version_number in number
360 , x_status        out nocopy VARCHAR2
361 , x_exception_msg out nocopy VARCHAR2
362 );
363 
364 /* This procedure adds an account assignment on supplier's request.
365  *
366  */
367 PROCEDURE supplier_add_account (
368   p_mapping_id             IN NUMBER
369 , p_account_request_id	   IN NUMBER
370 , p_ext_bank_account_id    IN NUMBER
371 , p_party_site_id          IN NUMBER
372 , p_address_request_id     IN NUMBER
373 , x_status        out nocopy VARCHAR2
374 , x_exception_msg out nocopy VARCHAR2
375 );
376 
377 
378 /* This procedure creates/update the account assignment on supplier's request.
379  *
380  */
381 PROCEDURE supplier_update_assignment (
382   p_assignment_id          IN NUMBER
383 , p_assignment_request_id  IN NUMBER
384 , p_object_version_number  IN NUMBER
385 , p_account_request_id	   IN NUMBER
386 , p_ext_bank_account_id    IN NUMBER
387 , p_request_type           IN VARCHAR2
388 , p_mapping_id             IN NUMBER
389 , p_party_site_id          IN NUMBER
390 , p_address_request_id     IN NUMBER
391 , p_priority               IN NUMBER
392 , p_start_date             IN DATE
393 , p_end_date               IN DATE
394 , x_status        out nocopy VARCHAR2
395 , x_exception_msg out nocopy VARCHAR2
396 );
397 
398 /* This procedure removes the account assignment request if all are current.
399  *
400  */
401 PROCEDURE supplier_reset_assignment(
402   p_mapping_id             IN NUMBER
403 , p_party_site_id          IN NUMBER
404 , p_address_request_id     IN NUMBER
405 , x_status        out nocopy VARCHAR2
406 , x_exception_msg out nocopy VARCHAR2
407 );
408 
409 /* This procedure removes the account assignment request if all are current.
410  *
411  */
412 PROCEDURE sbd_handle_address_apv(
413   p_address_request_id     IN NUMBER
414 , p_party_site_id          IN NUMBER
415 , x_status        out nocopy VARCHAR2
416 , x_exception_msg out nocopy VARCHAR2
417 );
418 
419 /* This procedure checks if any registered supplier has similar bank account.
420 *
421 */
422 PROCEDURE checkDupSupBankAcct(
423  p_mapping_id IN NUMBER
424 , p_BANK_ID IN NUMBER
425 , p_BRANCH_ID IN NUMBER
426 , p_EXT_BANK_ACCOUNT_ID IN number
427 , p_bank_account_number IN varchar2
428 , p_bank_account_name IN varchar2
429 , p_currency_code IN varchar2
430 , p_country_code IN varchar2
431 , x_status        OUT nocopy VARCHAR2
432 , x_exception_msg OUT nocopy VARCHAR2
433 );
434 
435 
436 END POS_SBD_PKG;