[Home] [Help]
PACKAGE: APPS.IBY_ASSIGN_PUB
Source
1 PACKAGE IBY_ASSIGN_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibyasgns.pls 120.4.12020000.2 2012/07/12 14:44:28 sgogula ship $*/
3
4 --
5 --
6 TYPE updateDocAttributesRec IS RECORD (
7 payment_request_id
8 IBY_DOCS_PAYABLE_ALL.payment_service_request_id%TYPE,
9 int_bank_acct_id
10 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
11 pay_profile_id
12 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
13 bank_acct_flag
14 BOOLEAN,
15 pay_profile_flag
16 BOOLEAN
17 );
18
19 --
20 -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
21 --
22 --TYPE updateDocsTabType IS TABLE OF updateDocAttributesRec
23 -- INDEX BY BINARY_INTEGER;
24
25 --
26 --
27 --
28 TYPE unassignedDocRec IS RECORD (
29 document_id
30 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
31 payment_currency_code
32 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
33 org_id
34 IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
35 payment_method_code
36 IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
37 calling_app_id
38 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
39 calling_app_doc_id1
40 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
41 calling_app_doc_id2
42 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
43 calling_app_doc_id3
44 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
45 calling_app_doc_id4
46 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
47 calling_app_doc_id5
48 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
49 pay_proc_ttype_cd
50 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
51 int_bank_acct_id
52 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE := -1,
53 pay_profile_id
54 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE := -1
55 );
56
57 TYPE unassignedDocsTabType IS TABLE OF unassignedDocRec
58 INDEX BY BINARY_INTEGER;
59
60 --
61 --
62 TYPE assignCriteriaType IS RECORD (
63 document_id
64 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
65 calling_app_id
66 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
67 calling_app_doc_id1
68 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
69 calling_app_doc_id2
70 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
71 calling_app_doc_id3
72 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
73 calling_app_doc_id4
74 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
75 calling_app_doc_id5
76 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
77 pay_proc_ttype_cd
78 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
79 int_bank_acct_id
80 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
81 payment_profile_id
82 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
83 payment_currency
84 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
85 payment_method
86 IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
87 payment_format
88 IBY_DOCS_PAYABLE_ALL.payment_format_code%TYPE,
89 org_id
90 IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
91 org_type
92 IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
93 payment_date
94 IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
95 ext_payee_id
96 IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
97 );
98
99 --
100 -- Table of assignment criteria.
101 --
102 TYPE assignCriteriaTabType IS TABLE OF assignCriteriaType
103 INDEX BY BINARY_INTEGER;
104
105 --
106 -- Table of bank accounts. Used by dummy CE API is available
107 --
108 TYPE bankAccounts IS TABLE OF IBY_DOCS_PAYABLE_ALL.
109 internal_bank_account_id%TYPE INDEX BY BINARY_INTEGER;
110
111 --
112 --
113 --
114 TYPE setDocAttributesRec IS RECORD (
115 doc_id
116 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
117 ca_id
118 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
119 ca_doc_id1
120 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
121 ca_doc_id2
122 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
123 ca_doc_id3
124 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
125 ca_doc_id4
126 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
127 ca_doc_id5
128 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
129 pp_tt_cd
130 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
131 int_bank_acct_id
132 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
133 pay_profile_id
134 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
135 status
136 IBY_DOCS_PAYABLE_ALL.document_status%TYPE
137 );
138
139 --
140 -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
141 --
142 TYPE setDocAttribsTabType IS TABLE OF setDocAttributesRec
143 INDEX BY BINARY_INTEGER;
144
145
146 /*--------------------------------------------------------------------
147 | NAME:
148 | performAssignments
149 |
150 | PURPOSE:
151 |
152 |
153 |
154 | PARAMETERS:
155 | IN
156 |
157 |
158 | OUT
159 |
160 |
161 | RETURNS:
162 |
163 | NOTES:
164 |
165 *---------------------------------------------------------------------*/
166 PROCEDURE performAssignments(
167 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
168 payment_service_request_id%type,
169 x_return_status IN OUT NOCOPY VARCHAR2
170 );
171
172 /*--------------------------------------------------------------------
173 | NAME:
174 | getRequestAttributes
175 |
176 | PURPOSE:
177 |
178 |
179 |
180 | PARAMETERS:
181 | IN
182 |
183 |
184 | OUT
185 |
186 |
187 | RETURNS:
188 |
189 | NOTES:
190 |
191 *---------------------------------------------------------------------*/
192 PROCEDURE getRequestAttributes(
193 p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
194 x_caPayReqCd IN OUT NOCOPY
195 IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
196 x_caId IN OUT NOCOPY
197 IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
198 x_bankAcctId IN OUT NOCOPY
199 IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE,
200 x_profileId IN OUT NOCOPY
201 IBY_PAY_SERVICE_REQUESTS.payment_profile_id%TYPE
202 );
203
204 /*--------------------------------------------------------------------
205 | NAME:
206 | updateDocumentAssignments
207 |
208 | PURPOSE:
209 |
210 |
211 |
212 | PARAMETERS:
213 | IN
214 |
215 |
216 | OUT
217 |
218 |
219 | RETURNS:
220 |
221 | NOTES:
222 |
223 *---------------------------------------------------------------------*/
224 PROCEDURE updateDocumentAssignments(
225 p_updateDocsRec IN IBY_ASSIGN_PUB.updateDocAttributesRec
226 );
227
228 /*--------------------------------------------------------------------
229 | NAME:
230 | dummyCEAPI
231 |
232 | PURPOSE:
233 |
234 |
235 |
236 | PARAMETERS:
237 | IN
238 |
239 |
240 | OUT
241 |
242 |
243 | RETURNS:
244 |
245 | NOTES:
246 |
247 *---------------------------------------------------------------------*/
248 PROCEDURE dummyCEAPI(
249 p_payCurrency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
250 p_pmtDate IN IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
251 p_OrgID IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
252 x_bankAccounts IN OUT NOCOPY IBY_ASSIGN_PUB.bankAccounts
253 );
254
255 /*--------------------------------------------------------------------
256 | NAME:
257 | setDocumentAssignments
258 |
259 | PURPOSE:
260 |
261 |
262 |
263 | PARAMETERS:
264 | IN
265 |
266 |
267 | OUT
268 |
269 |
270 | RETURNS:
271 |
272 | NOTES:
273 |
274 *---------------------------------------------------------------------*/
275 PROCEDURE setDocumentAssignments(
276 p_setDocAttribsTab IN IBY_ASSIGN_PUB.setDocAttribsTabType
277 );
278
279 /*--------------------------------------------------------------------
280 | NAME:
281 | getProfileFromProfileDrivers
282 |
283 | PURPOSE:
284 |
285 |
286 |
287 | PARAMETERS:
288 | IN
289 |
290 |
291 | OUT
292 |
293 |
294 | RETURNS:
295 |
296 | NOTES:
297 |
298 *---------------------------------------------------------------------*/
299 FUNCTION getProfileFromProfileDrivers(
300 p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
301 p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
302 p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
303 p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
304 p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
305 ) RETURN NUMBER;
306
307 /*--------------------------------------------------------------------
308 | NAME:
309 | getProfileFromPayeeFormat
310 |
311 | PURPOSE:
312 |
313 |
314 |
315 | PARAMETERS:
316 | IN
317 |
318 |
319 | OUT
320 |
321 |
322 | RETURNS:
323 |
324 | NOTES:
325 |
326 *---------------------------------------------------------------------*/
327 FUNCTION getProfileFromPayeeFormat(
328 p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
329 ) RETURN NUMBER;
330
331 /*--------------------------------------------------------------------
332 | NAME:
333 | finalizeStatuses
334 |
335 | PURPOSE:
336 |
337 |
338 |
339 | PARAMETERS:
340 | IN
341 |
342 | OUT
343 |
344 |
345 | RETURNS:
346 |
347 | NOTES:
348 |
349 *---------------------------------------------------------------------*/
350 PROCEDURE finalizeStatuses(
351 p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
352 x_req_status IN OUT NOCOPY VARCHAR2
353 );
354
355 /*--------------------------------------------------------------------
356 | NAME:
357 | updateRequestStatus
358 |
359 | PURPOSE:
360 |
361 |
362 |
363 | PARAMETERS:
364 | IN
365 |
366 | OUT
367 |
368 |
369 | RETURNS:
370 |
371 | NOTES:
372 |
373 *---------------------------------------------------------------------*/
374 PROCEDURE updateRequestStatus(
375 p_payReqID IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
376 x_req_status IN OUT NOCOPY VARCHAR2
377 );
378
379 /*--------------------------------------------------------------------
380 | NAME:
381 | dummyAsgnHook
382 |
383 | PURPOSE:
384 | Dummy hook; To be used for testing purposes.
385 |
386 |
387 | PARAMETERS:
388 | IN
389 |
390 | OUT
391 |
392 |
393 | RETURNS:
394 |
395 | NOTES:
396 |
397 *---------------------------------------------------------------------*/
398 PROCEDURE dummyAsgnHook(
399 x_unassgnDocsTab IN OUT NOCOPY IBY_ASSIGN_PUB.unassignedDocsTabType
400 );
401
402 /*--------------------------------------------------------------------
403 | NAME:
404 | populateDocAttributes
405 |
406 | PURPOSE:
407 |
408 |
409 | PARAMETERS:
410 | IN
411 |
412 | OUT
413 |
414 |
415 | RETURNS:
416 |
417 | NOTES:
418 |
419 *---------------------------------------------------------------------*/
420 PROCEDURE populateDocAttributes(
421 p_hookAsgnDocsTab IN IBY_ASSIGN_PUB.unassignedDocsTabType,
422 x_setDocAttribsTab IN OUT NOCOPY IBY_ASSIGN_PUB.setDocAttribsTabType
423 );
424
425 /*--------------------------------------------------------------------
426 | NAME:
427 | raiseBizEvents
428 |
429 | PURPOSE:
430 |
431 |
432 |
433 | PARAMETERS:
434 | IN
435 |
436 | OUT
437 |
438 |
439 | RETURNS:
440 |
441 | NOTES:
442 |
443 *---------------------------------------------------------------------*/
444 PROCEDURE raiseBizEvents(
445 p_payreq_id IN VARCHAR2,
446 p_cap_payreq_id IN VARCHAR2,
447 p_cap_id IN NUMBER
448 );
449
450 /*--------------------------------------------------------------------
451 | NAME:
452 | getXMLClob
453 |
454 | PURPOSE:
455 |
456 |
457 |
458 | PARAMETERS:
459 | IN
460 |
461 | OUT
462 |
463 |
464 | RETURNS:
465 |
466 | NOTES:
467 |
468 *---------------------------------------------------------------------*/
469 FUNCTION getXMLClob(
470 p_payreq_id IN VARCHAR2
471 )
472 RETURN CLOB;
473
474 END IBY_ASSIGN_PUB;