[Home] [Help]
PACKAGE: APPS.PAY_PPMV4_UTILS_SS
Source
1 package pay_ppmv4_utils_ss AUTHID CURRENT_USER as
2 /* $Header: pyppmv4u.pkh 120.0.12010000.2 2009/09/26 06:32:52 pgongada ship $ */
3 ---------------------------------------------------------------------------
4 ---------------------------------- CONSTANTS ------------------------------
5 ---------------------------------------------------------------------------
6 -- Priority values to use.
7 --
8 C_MAX_PRIORITY constant number default 99;
9 C_MIN_PRIORITY constant number default 1;
10 C_NO_PRIORITY constant number default -1; -- Invalid value.
11 --
12 -- The API to be called for the PPM transactions.
13 --
14 C_PSS_API constant varchar2(2000) default
15 'PAY_PPMV4_SS.PROCESS_API';
16 --
17 -- Workflow constants.
18 --
19 C_PROCESSED_FLAG_ARG constant varchar2(2000) default 'P_PROCESSED_FLAG';
20 C_TX_STEP_ID_ARG constant varchar2(2000) default 'P_TRANSACTION_STEP_ID';
21 C_REVIEW_PROC_CALL_ARG constant varchar2(2000) default 'P_REVIEW_PROC_CALL';
22 C_REVIEW_ACTID_ARG constant varchar2(2000) default 'P_REVIEW_ACTID';
23 C_REVIEW_REGION_ITEM constant varchar2(2000) default 'HR_REVIEW_REGION_ITEM';
24 C_ASSIGNMENT_ID constant varchar2(2000) default 'PAY_PSS_ASSIGNMENT_ID';
25 C_EFFECTIVE_DATE constant varchar2(2000) default
26 'PAY_PSS_EFFECTIVE_DATE';
27 ---------------------------------------------------------------------------
28 -------------------------------- DATA TYPES -------------------------------
29 ---------------------------------------------------------------------------
30 --
31 -- T_PPM
32 --
33 type t_ppmv4 is record
34 (transaction_id pay_pss_transaction_steps.transaction_id%type
35 ,transaction_step_id pay_pss_transaction_steps.transaction_step_id%type
36 ,source_table pay_pss_transaction_steps.source_table%type
37 ,state pay_pss_transaction_steps.state%type
38 ,personal_payment_method_id
39 pay_personal_payment_methods_f.personal_payment_method_id%type
40 ,update_ovn
41 pay_personal_payment_methods_f.object_version_number%type
42 ,delete_ovn
43 pay_personal_payment_methods_f.object_version_number%type
44 ,update_datetrack_mode pay_pss_transaction_steps.update_datetrack_mode%type
45 ,delete_datetrack_mode pay_pss_transaction_steps.delete_datetrack_mode%type
46 ,delete_disabled pay_pss_transaction_steps.delete_disabled%type
47 ,effective_date date
48 ,org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type
49 ,assignment_id pay_personal_payment_methods_f.assignment_id%type
50 ,payment_type pay_pss_transaction_steps.payment_type%type
51 ,currency_code pay_pss_transaction_steps.currency_code%type
52 ,territory_code pay_pss_transaction_steps.territory_code%type
53 --
54 -- Current data values.
55 --
56 ,real_priority pay_personal_payment_methods_f.priority%type
57 ,logical_priority pay_personal_payment_methods_f.priority%type
58 ,amount_type pay_pss_transaction_steps.amount_type%type
59 ,amount pay_personal_payment_methods_f.amount%type
60 ,external_account_id pay_external_accounts.external_account_id%type
61 ,attribute_category pay_personal_payment_methods_f.attribute_category%type
62 ,attribute1 pay_personal_payment_methods_f.attribute1%type
63 ,attribute2 pay_personal_payment_methods_f.attribute2%type
64 ,attribute3 pay_personal_payment_methods_f.attribute3%type
65 ,attribute4 pay_personal_payment_methods_f.attribute4%type
66 ,attribute5 pay_personal_payment_methods_f.attribute5%type
67 ,attribute6 pay_personal_payment_methods_f.attribute6%type
68 ,attribute7 pay_personal_payment_methods_f.attribute7%type
69 ,attribute8 pay_personal_payment_methods_f.attribute8%type
70 ,attribute9 pay_personal_payment_methods_f.attribute9%type
71 ,attribute10 pay_personal_payment_methods_f.attribute10%type
72 ,attribute11 pay_personal_payment_methods_f.attribute11%type
73 ,attribute12 pay_personal_payment_methods_f.attribute12%type
74 ,attribute13 pay_personal_payment_methods_f.attribute13%type
75 ,attribute14 pay_personal_payment_methods_f.attribute14%type
76 ,attribute15 pay_personal_payment_methods_f.attribute15%type
77 ,attribute16 pay_personal_payment_methods_f.attribute16%type
78 ,attribute17 pay_personal_payment_methods_f.attribute17%type
79 ,attribute18 pay_personal_payment_methods_f.attribute18%type
80 ,attribute19 pay_personal_payment_methods_f.attribute19%type
81 ,attribute20 pay_personal_payment_methods_f.attribute20%type
82 --
83 -- Original data values.
84 --
85 ,o_real_priority pay_personal_payment_methods_f.priority%type
86 ,o_logical_priority pay_personal_payment_methods_f.priority%type
87 ,o_amount_type pay_pss_transaction_steps.o_amount_type%type
88 ,o_amount pay_personal_payment_methods_f.amount%type
89 ,o_external_account_id pay_external_accounts.external_account_id%type
90 ,o_attribute_category pay_personal_payment_methods_f.attribute_category%type
91 ,o_attribute1 pay_personal_payment_methods_f.attribute1%type
92 ,o_attribute2 pay_personal_payment_methods_f.attribute2%type
93 ,o_attribute3 pay_personal_payment_methods_f.attribute3%type
94 ,o_attribute4 pay_personal_payment_methods_f.attribute4%type
95 ,o_attribute5 pay_personal_payment_methods_f.attribute5%type
96 ,o_attribute6 pay_personal_payment_methods_f.attribute6%type
97 ,o_attribute7 pay_personal_payment_methods_f.attribute7%type
98 ,o_attribute8 pay_personal_payment_methods_f.attribute8%type
99 ,o_attribute9 pay_personal_payment_methods_f.attribute9%type
100 ,o_attribute10 pay_personal_payment_methods_f.attribute10%type
101 ,o_attribute11 pay_personal_payment_methods_f.attribute11%type
102 ,o_attribute12 pay_personal_payment_methods_f.attribute12%type
103 ,o_attribute13 pay_personal_payment_methods_f.attribute13%type
104 ,o_attribute14 pay_personal_payment_methods_f.attribute14%type
105 ,o_attribute15 pay_personal_payment_methods_f.attribute15%type
106 ,o_attribute16 pay_personal_payment_methods_f.attribute16%type
107 ,o_attribute17 pay_personal_payment_methods_f.attribute17%type
108 ,o_attribute18 pay_personal_payment_methods_f.attribute18%type
109 ,o_attribute19 pay_personal_payment_methods_f.attribute19%type
110 ,o_attribute20 pay_personal_payment_methods_f.attribute20%type
111 ,run_type_id pay_personal_payment_methods_f.run_type_id%type
112
113 ,ppm_information_category pay_personal_payment_methods_f.ppm_information_category%type
114 ,ppm_information1 pay_personal_payment_methods_f.ppm_information1%type
115 ,ppm_information2 pay_personal_payment_methods_f.ppm_information2%type
116 ,ppm_information3 pay_personal_payment_methods_f.ppm_information3%type
117 ,ppm_information4 pay_personal_payment_methods_f.ppm_information4%type
118 ,ppm_information5 pay_personal_payment_methods_f.ppm_information5%type
119 ,ppm_information6 pay_personal_payment_methods_f.ppm_information6%type
120 ,ppm_information7 pay_personal_payment_methods_f.ppm_information7%type
121 ,ppm_information8 pay_personal_payment_methods_f.ppm_information8%type
122 ,ppm_information9 pay_personal_payment_methods_f.ppm_information9%type
123 ,ppm_information10 pay_personal_payment_methods_f.ppm_information10%type
124 ,ppm_information11 pay_personal_payment_methods_f.ppm_information11%type
125 ,ppm_information12 pay_personal_payment_methods_f.ppm_information12%type
126 ,ppm_information13 pay_personal_payment_methods_f.ppm_information13%type
127 ,ppm_information14 pay_personal_payment_methods_f.ppm_information14%type
128 ,ppm_information15 pay_personal_payment_methods_f.ppm_information15%type
129 ,ppm_information16 pay_personal_payment_methods_f.ppm_information16%type
130 ,ppm_information17 pay_personal_payment_methods_f.ppm_information17%type
131 ,ppm_information18 pay_personal_payment_methods_f.ppm_information18%type
132 ,ppm_information19 pay_personal_payment_methods_f.ppm_information19%type
133 ,ppm_information20 pay_personal_payment_methods_f.ppm_information20%type
134 ,ppm_information21 pay_personal_payment_methods_f.ppm_information21%type
135 ,ppm_information22 pay_personal_payment_methods_f.ppm_information22%type
136 ,ppm_information23 pay_personal_payment_methods_f.ppm_information23%type
137 ,ppm_information24 pay_personal_payment_methods_f.ppm_information24%type
138 ,ppm_information25 pay_personal_payment_methods_f.ppm_information25%type
139 ,ppm_information26 pay_personal_payment_methods_f.ppm_information26%type
140 ,ppm_information27 pay_personal_payment_methods_f.ppm_information27%type
141 ,ppm_information28 pay_personal_payment_methods_f.ppm_information28%type
142 ,ppm_information29 pay_personal_payment_methods_f.ppm_information29%type
143 ,ppm_information30 pay_personal_payment_methods_f.ppm_information30%type
144 ,o_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%type
145 ,o_ppm_information1 pay_personal_payment_methods_f.ppm_information1%type
146 ,o_ppm_information2 pay_personal_payment_methods_f.ppm_information2%type
147 ,o_ppm_information3 pay_personal_payment_methods_f.ppm_information3%type
148 ,o_ppm_information4 pay_personal_payment_methods_f.ppm_information4%type
149 ,o_ppm_information5 pay_personal_payment_methods_f.ppm_information5%type
150 ,o_ppm_information6 pay_personal_payment_methods_f.ppm_information6%type
151 ,o_ppm_information7 pay_personal_payment_methods_f.ppm_information7%type
152 ,o_ppm_information8 pay_personal_payment_methods_f.ppm_information8%type
153 ,o_ppm_information9 pay_personal_payment_methods_f.ppm_information9%type
154 ,o_ppm_information10 pay_personal_payment_methods_f.ppm_information10%type
155 ,o_ppm_information11 pay_personal_payment_methods_f.ppm_information11%type
156 ,o_ppm_information12 pay_personal_payment_methods_f.ppm_information12%type
157 ,o_ppm_information13 pay_personal_payment_methods_f.ppm_information13%type
158 ,o_ppm_information14 pay_personal_payment_methods_f.ppm_information14%type
159 ,o_ppm_information15 pay_personal_payment_methods_f.ppm_information15%type
160 ,o_ppm_information16 pay_personal_payment_methods_f.ppm_information16%type
161 ,o_ppm_information17 pay_personal_payment_methods_f.ppm_information17%type
162 ,o_ppm_information18 pay_personal_payment_methods_f.ppm_information18%type
163 ,o_ppm_information19 pay_personal_payment_methods_f.ppm_information19%type
164 ,o_ppm_information20 pay_personal_payment_methods_f.ppm_information20%type
165 ,o_ppm_information21 pay_personal_payment_methods_f.ppm_information21%type
166 ,o_ppm_information22 pay_personal_payment_methods_f.ppm_information22%type
167 ,o_ppm_information23 pay_personal_payment_methods_f.ppm_information23%type
168 ,o_ppm_information24 pay_personal_payment_methods_f.ppm_information24%type
169 ,o_ppm_information25 pay_personal_payment_methods_f.ppm_information25%type
170 ,o_ppm_information26 pay_personal_payment_methods_f.ppm_information26%type
171 ,o_ppm_information27 pay_personal_payment_methods_f.ppm_information27%type
172 ,o_ppm_information28 pay_personal_payment_methods_f.ppm_information28%type
173 ,o_ppm_information29 pay_personal_payment_methods_f.ppm_information29%type
174 ,o_ppm_information30 pay_personal_payment_methods_f.ppm_information30%type
175
176 );
177 --
178 -- T_PPM_TBL
179 --
180 type t_ppmv4_tbl is table of t_ppmv4 index by binary_integer;
181 --
182 -- T_BOOLEAN_TBL
183 --
184 type t_boolean_tbl is table of boolean index by binary_integer;
185 ---------------------------------------------------------------------------
186 ----------------------- FUNCTIONS AND PROCEDURES --------------------------
187 ---------------------------------------------------------------------------
188 -------------------------------< seterror >--------------------------------
189 --
190 -- {Start Of Comments}
191 --
192 -- Description:
193 -- Cover for hr_utility.set_location call.
194 -- SETERRORSTAGE
195 -- P_PROC - The procedure being called.
196 -- P_STAGE - Where in the code is at this moment.
197 -- P_LOC - Error location.
198 --
199 -- Prerequisites:
200 -- None.
201 --
202 -- Post Success:
203 --
204 -- Post Failure:
205 -- Not applicable.
206 --
207 -- Access Status:
208 -- Internal Development Use Only.
209 --
210 -- {End Of Comments}
211 --
212 procedure seterrorstage
213 (p_proc in varchar2
214 ,p_stage in varchar2
215 ,p_location in number
216 );
217 ------------------------------< ppm2hrtt >---------------------------------
218 --
219 -- {Start Of Comments}
220 --
221 -- Description:
222 -- Writes PPM information to HR transaction tables.
223 -- P_TRANSACTION_STEP_ID is from PAY_PSS_TRANSACTION_STEPS.
224 -- P_FORCE_NEW_TRANSACTION forces a new transaction to be created.
225 --
226 -- Prerequisites:
227 -- None.
228 --
229 -- Post Success:
230 -- The transaction table is populated.
231 --
232 -- Post Failure:
233 -- An exception is raised.
234 --
235 -- Access Status:
236 -- Internal Development Use Only.
237 --
238 -- {End Of Comments}
239 --
240 procedure ppm2hrtt
241 (p_item_type in varchar2
242 ,p_item_key in varchar2
243 ,p_activity_id in number
244 ,p_login_person_id in number
245 ,p_review_proc_call in varchar2
246 ,p_transaction_step_id in number
247 ,p_force_new_transaction in boolean
248 );
249 --------------------------------< ppm2tt >---------------------------------
250 --
251 -- {Start Of Comments}
252 --
253 -- Description:
254 -- Writes a T_PPM record to the transaction tables.
255 --
256 -- Prerequisites:
257 -- None.
258 --
259 -- Post Success:
260 -- The ppm values are saved to the transaction table. The save is committed.
261 --
262 -- Post Failure:
263 -- An exception is raised.
264 --
265 -- Access Status:
266 -- Internal Development Use Only.
267 --
268 -- {End Of Comments}
269 --
270 procedure ppm2tt
271 (p_ppm in out nocopy t_ppmv4
272 );
273 --------------------------------< tt2ppm >---------------------------------
274 --
275 -- {Start Of Comments}
276 --
277 -- Description:
278 -- Converts a transaction entry to a T_PPM record.
279 --
280 -- Prerequisites:
281 -- P_TRANSACTION_STEP_ID must point to a valid record.
282 --
283 -- Post Success:
284 -- The T_PPM record is populated using the supplied values.
285 --
286 -- Post Failure:
287 -- An exception is raised.
288 --
289 -- Access Status:
290 -- Internal Development Use Only.
291 --
292 -- {End Of Comments}
293 --
294 procedure tt2ppm
295 (p_transaction_step_id in number
296 ,p_ppm out nocopy t_ppmv4
297 );
298 -----------------------------< changedppm >------------------------
299 --
300 -- {Start Of Comments}
301 --
302 -- Description:
303 -- Detects whether or not a PPM has changed (original data values
304 -- differ from latest data values).
305 --
306 -- Prerequisites:
307 -- None.
308 --
309 -- Post Success:
310 -- P_CHANGES is set to true if there are any differences.
311 -- P_BANK is set to true if the Bank Details differ.
312 --
313 -- Post Failure:
314 -- Not applicable.
315 --
316 -- Access Status:
317 -- Internal Development Use Only.
318 --
319 -- {End Of Comments}
320 --
321 procedure changedppm
322 (p_ppm in t_ppmv4
323 ,p_changes out nocopy boolean
324 ,p_bank out nocopy boolean
325 );
329 -- Description:
326 -----------------------------< changedppm >------------------------
327 -- {Start Of Comments}
328 --
330 -- Overloaded version to use when comparing a new ppm with a saved
331 -- ppm. Differences in logical priority are overlooked in this
332 -- instance because it's used to compare an Added/Updated PPM with
333 -- a saved one to reduce unnecessary validation.
334 --
335 -- Post Success:
336 -- P_ORIGINAL:
337 -- TRUE - P_NEW_PPM differs from the original version of
338 -- P_SAVED_PPM.
339 -- FALSE - P_NEW_PPM is the same as the original version of
340 -- P_SAVED_PPM.
341 -- P_CURRENT:
342 -- TRUE - P_NEW_PPM differs from the current version of
343 -- P_SAVED_PPM.
344 -- FALSE - P_NEW_PPM is the same as the current version of
345 -- P_SAVED_PPM.
346 --
347 -- Access Status:
348 -- Internal Development Use Only.
349 --
350 -- {End Of Comments}
351 --
352 procedure changedppm
353 (p_new_ppm in t_ppmv4
354 ,p_saved_ppm in t_ppmv4
355 ,p_original out nocopy boolean
356 ,p_current out nocopy boolean
357 );
358 -----------------------------< nextentry >--------------------------
359 --
360 -- {Start Of Comments}
361 --
362 -- Description:
363 -- Gets the next entry from a list whose entries are separated by
364 -- a given character. May return NULL.
365 -- p_start is set to 0 when the last entry in the list is reached.
366 --
367 -- Prerequisites:
368 -- None.
369 --
370 -- Post Success:
371 -- The current list entry is returned. p_start is set to point at
372 -- the next entry in the list (or 0 if this list entry was the last
373 -- list entry).
374 --
375 -- Post Failure:
376 -- Not applicable.
377 --
378 -- Access Status:
379 -- Internal Development Use Only.
380 --
381 -- {End Of Comments}
382 --
383 function nextentry
384 (p_list in varchar2
385 ,p_separator in varchar2
386 ,p_start in out nocopy number
387 ) return varchar2;
388 ------------------------< read_wf_config_option >------------------------
389 --
390 -- {Start Of Comments}
391 --
392 -- Description:
393 -- Reads the value of an activity, or item attribute for the specified
394 -- workflow.
395 --
396 -- Prerequisites:
397 -- None.
398 --
399 -- Post Success:
400 -- The value of the attribute is returned.
401 --
402 -- Post Failure:
403 -- An exception is raised.
404 --
405 -- Access Status:
406 -- Internal Development Use Only.
407 --
408 -- {End Of Comments}
409 --
410 function read_wf_config_option
411 (p_item_type in varchar2
412 ,p_item_key in varchar2
413 ,p_activity_id in number default null
414 ,p_option in varchar2
415 ,p_number in boolean default false
416 ) return varchar2;
417 ----------------------< getpriorities >-----------------------
418 --
419 -- {Start Of Comments}
420 --
421 -- Description:
422 -- Returns a priority availability table that lists the PPM
423 -- priorities that are allocated to existing PPMs, and those
424 -- priorities that are free. Also, returns the first available
425 -- PPM priority.
426 --
427 -- Prerequisites:
428 -- None.
429 --
430 -- Post Success:
431 --
432 -- Post Failure:
433 -- Raises an exception.
434 --
435 -- Access Status:
436 -- Internal Development Use Only.
437 --
438 -- {End Of Comments}
439 --
440 procedure getpriorities
441 (p_assignment_id in number
442 ,p_effective_date in date
443 ,p_run_type_id in number default null
444 ,p_priority_tbl out nocopy t_boolean_tbl
445 ,p_first_available out nocopy number
446 );
447 -----------------------------< validateppm >------------------------
448 --
449 -- {Start Of Comments}
450 --
451 -- Description:
452 -- Checks that changes to a PPM for validity for INSERT/UPDATE of
453 -- a complete PPM record.
454 -- Delete validation and priority validation are not required since
455 -- the system prevalidates for those cases.
456 --
457 -- Prerequisites:
458 -- None.
459 --
460 -- Post Success:
461 -- If there are user errors then the hr_errors_api error table is
462 -- written to. The caller should call hr_errors_api.errorexists to
463 -- check for errors.
464 --
465 -- Post Failure:
466 -- An exception is raised.
467 --
468 -- Access Status:
469 -- Internal Development Use Only.
470 --
471 -- {End Of Comments}
472 --
473 procedure validateppm
474 (p_state in varchar2
475 ,p_personal_payment_method_id in number default null
476 ,p_object_version_number in number default null
477 ,p_update_datetrack_mode in varchar2 default null
478 ,p_effective_date in date default null
479 ,p_org_payment_method_id in number default null
480 ,p_assignment_id in number default null
481 ,p_run_type_id in number default null
485 ,p_amount in number default null
482 ,p_payment_type in varchar2 default null
483 ,p_territory_code in varchar2 default null
484 ,p_amount_type in varchar2 default null
486 ,p_external_account_id in number default null
487 ,p_attribute_category in varchar2 default null
488 ,p_attribute1 in varchar2 default null
489 ,p_attribute2 in varchar2 default null
490 ,p_attribute3 in varchar2 default null
491 ,p_attribute4 in varchar2 default null
492 ,p_attribute5 in varchar2 default null
493 ,p_attribute6 in varchar2 default null
494 ,p_attribute7 in varchar2 default null
495 ,p_attribute8 in varchar2 default null
496 ,p_attribute9 in varchar2 default null
497 ,p_attribute10 in varchar2 default null
498 ,p_attribute11 in varchar2 default null
499 ,p_attribute12 in varchar2 default null
500 ,p_attribute13 in varchar2 default null
501 ,p_attribute14 in varchar2 default null
502 ,p_attribute15 in varchar2 default null
503 ,p_attribute16 in varchar2 default null
504 ,p_attribute17 in varchar2 default null
505 ,p_attribute18 in varchar2 default null
506 ,p_attribute19 in varchar2 default null
507 ,p_attribute20 in varchar2 default null
508 ,p_segment1 in varchar2 default null
509 ,p_segment2 in varchar2 default null
510 ,p_segment3 in varchar2 default null
511 ,p_segment4 in varchar2 default null
512 ,p_segment5 in varchar2 default null
513 ,p_segment6 in varchar2 default null
514 ,p_segment7 in varchar2 default null
515 ,p_segment8 in varchar2 default null
516 ,p_segment9 in varchar2 default null
517 ,p_segment10 in varchar2 default null
518 ,p_segment11 in varchar2 default null
519 ,p_segment12 in varchar2 default null
520 ,p_segment13 in varchar2 default null
521 ,p_segment14 in varchar2 default null
522 ,p_segment15 in varchar2 default null
523 ,p_segment16 in varchar2 default null
524 ,p_segment17 in varchar2 default null
525 ,p_segment18 in varchar2 default null
526 ,p_segment19 in varchar2 default null
527 ,p_segment20 in varchar2 default null
528 ,p_segment21 in varchar2 default null
529 ,p_segment22 in varchar2 default null
530 ,p_segment23 in varchar2 default null
531 ,p_segment24 in varchar2 default null
532 ,p_segment25 in varchar2 default null
533 ,p_segment26 in varchar2 default null
534 ,p_segment27 in varchar2 default null
535 ,p_segment28 in varchar2 default null
536 ,p_segment29 in varchar2 default null
537 ,p_segment30 in varchar2 default null
538 ,p_ppm_information_category in varchar2 default null
539 ,p_ppm_information1 in varchar2 default null
540 ,p_ppm_information2 in varchar2 default null
541 ,p_ppm_information3 in varchar2 default null
542 ,p_ppm_information4 in varchar2 default null
543 ,p_ppm_information5 in varchar2 default null
544 ,p_ppm_information6 in varchar2 default null
545 ,p_ppm_information7 in varchar2 default null
546 ,p_ppm_information8 in varchar2 default null
547 ,p_ppm_information9 in varchar2 default null
548 ,p_ppm_information10 in varchar2 default null
549 ,p_ppm_information11 in varchar2 default null
550 ,p_ppm_information12 in varchar2 default null
551 ,p_ppm_information13 in varchar2 default null
552 ,p_ppm_information14 in varchar2 default null
553 ,p_ppm_information15 in varchar2 default null
554 ,p_ppm_information16 in varchar2 default null
555 ,p_ppm_information17 in varchar2 default null
556 ,p_ppm_information18 in varchar2 default null
557 ,p_ppm_information19 in varchar2 default null
558 ,p_ppm_information20 in varchar2 default null
559 ,p_ppm_information21 in varchar2 default null
560 ,p_ppm_information22 in varchar2 default null
561 ,p_ppm_information23 in varchar2 default null
562 ,p_ppm_information24 in varchar2 default null
563 ,p_ppm_information25 in varchar2 default null
564 ,p_ppm_information26 in varchar2 default null
565 ,p_ppm_information27 in varchar2 default null
566 ,p_ppm_information28 in varchar2 default null
567 ,p_ppm_information29 in varchar2 default null
568 ,p_ppm_information30 in varchar2 default null
569 ,p_return_status out nocopy varchar2
570 ,p_msg_count out nocopy number
571 ,p_msg_data out nocopy varchar2
572 );
573 -----------------------------< process_api >------------------------
574 --
575 -- {Start Of Comments}
576 --
577 -- Description:
581 -- None.
578 -- Internal call to the PPM APIs.
579 --
580 -- Prerequisites:
582 --
583 -- Post Success:
584 -- The API call is made.
585 --
586 -- Post Failure:
587 -- An exception is raised.
588 --
589 -- Access Status:
590 -- Internal Development Use Only.
591 --
592 -- {End Of Comments}
593 --
594 -----------------------------< process_api >------------------------
595 procedure process_api
596 (p_state in varchar2 default null
597 ,p_personal_payment_method_id in number default null
598 ,p_object_version_number in number default null
599 ,p_delete_ovn in number default null
600 ,p_update_datetrack_mode in varchar2 default null
601 ,p_delete_datetrack_mode in varchar2 default null
602 ,p_effective_date in date default null
603 ,p_org_payment_method_id in number default null
604 ,p_assignment_id in number default null
605 ,p_run_type_id in number default null
606 ,p_territory_code in varchar2 default null
607 ,p_real_priority in number default null
608 ,p_amount_type in varchar2 default null
609 ,p_amount in number default null
610 ,p_attribute_category in varchar2 default null
611 ,p_attribute1 in varchar2 default null
612 ,p_attribute2 in varchar2 default null
613 ,p_attribute3 in varchar2 default null
614 ,p_attribute4 in varchar2 default null
615 ,p_attribute5 in varchar2 default null
616 ,p_attribute6 in varchar2 default null
617 ,p_attribute7 in varchar2 default null
618 ,p_attribute8 in varchar2 default null
619 ,p_attribute9 in varchar2 default null
620 ,p_attribute10 in varchar2 default null
621 ,p_attribute11 in varchar2 default null
622 ,p_attribute12 in varchar2 default null
623 ,p_attribute13 in varchar2 default null
624 ,p_attribute14 in varchar2 default null
625 ,p_attribute15 in varchar2 default null
626 ,p_attribute16 in varchar2 default null
627 ,p_attribute17 in varchar2 default null
628 ,p_attribute18 in varchar2 default null
629 ,p_attribute19 in varchar2 default null
630 ,p_attribute20 in varchar2 default null
631 ,p_segment1 in varchar2 default null
632 ,p_segment2 in varchar2 default null
633 ,p_segment3 in varchar2 default null
634 ,p_segment4 in varchar2 default null
635 ,p_segment5 in varchar2 default null
636 ,p_segment6 in varchar2 default null
637 ,p_segment7 in varchar2 default null
638 ,p_segment8 in varchar2 default null
639 ,p_segment9 in varchar2 default null
640 ,p_segment10 in varchar2 default null
641 ,p_segment11 in varchar2 default null
642 ,p_segment12 in varchar2 default null
643 ,p_segment13 in varchar2 default null
644 ,p_segment14 in varchar2 default null
645 ,p_segment15 in varchar2 default null
646 ,p_segment16 in varchar2 default null
647 ,p_segment17 in varchar2 default null
648 ,p_segment18 in varchar2 default null
649 ,p_segment19 in varchar2 default null
650 ,p_segment20 in varchar2 default null
651 ,p_segment21 in varchar2 default null
652 ,p_segment22 in varchar2 default null
656 ,p_segment26 in varchar2 default null
653 ,p_segment23 in varchar2 default null
654 ,p_segment24 in varchar2 default null
655 ,p_segment25 in varchar2 default null
657 ,p_segment27 in varchar2 default null
658 ,p_segment28 in varchar2 default null
659 ,p_segment29 in varchar2 default null
660 ,p_segment30 in varchar2 default null
661 ,p_o_real_priority in number default null
662 ,p_validate in boolean default false
663 ,p_ppm_information_category in varchar2 default null
664 ,p_ppm_information1 in varchar2 default null
665 ,p_ppm_information2 in varchar2 default null
666 ,p_ppm_information3 in varchar2 default null
667 ,p_ppm_information4 in varchar2 default null
668 ,p_ppm_information5 in varchar2 default null
669 ,p_ppm_information6 in varchar2 default null
670 ,p_ppm_information7 in varchar2 default null
671 ,p_ppm_information8 in varchar2 default null
672 ,p_ppm_information9 in varchar2 default null
673 ,p_ppm_information10 in varchar2 default null
674 ,p_ppm_information11 in varchar2 default null
675 ,p_ppm_information12 in varchar2 default null
676 ,p_ppm_information13 in varchar2 default null
677 ,p_ppm_information14 in varchar2 default null
678 ,p_ppm_information15 in varchar2 default null
679 ,p_ppm_information16 in varchar2 default null
680 ,p_ppm_information17 in varchar2 default null
681 ,p_ppm_information18 in varchar2 default null
682 ,p_ppm_information19 in varchar2 default null
683 ,p_ppm_information20 in varchar2 default null
684 ,p_ppm_information21 in varchar2 default null
685 ,p_ppm_information22 in varchar2 default null
686 ,p_ppm_information23 in varchar2 default null
687 ,p_ppm_information24 in varchar2 default null
688 ,p_ppm_information25 in varchar2 default null
689 ,p_ppm_information26 in varchar2 default null
690 ,p_ppm_information27 in varchar2 default null
691 ,p_ppm_information28 in varchar2 default null
692 ,p_ppm_information29 in varchar2 default null
693 ,p_ppm_information30 in varchar2 default null
694 );
695 -------------------------< get_bank_segments >----------------------
696 --
697 -- {Start Of Comments}
698 --
699 -- Description:
700 -- Fetch the bank segments from PAY_EXTERNAL_ACCOUNTS.
701 --
702 -- Prerequisites:
703 -- None.
704 --
705 -- Post Success:
706 -- The OUT parameters are populated with the segment values.
707 --
708 -- Post Failure:
709 -- An exception is raised.
710 --
711 -- Access Status:
712 -- Internal Development Use Only.
713 --
714 -- {End Of Comments}
715 --
716 procedure get_bank_segments
717 (p_external_account_id in number
718 ,p_segment1 out nocopy varchar2
719 ,p_segment2 out nocopy varchar2
720 ,p_segment3 out nocopy varchar2
721 ,p_segment4 out nocopy varchar2
722 ,p_segment5 out nocopy varchar2
723 ,p_segment6 out nocopy varchar2
724 ,p_segment7 out nocopy varchar2
725 ,p_segment8 out nocopy varchar2
726 ,p_segment9 out nocopy varchar2
727 ,p_segment10 out nocopy varchar2
728 ,p_segment11 out nocopy varchar2
729 ,p_segment12 out nocopy varchar2
730 ,p_segment13 out nocopy varchar2
731 ,p_segment14 out nocopy varchar2
732 ,p_segment15 out nocopy varchar2
733 ,p_segment16 out nocopy varchar2
734 ,p_segment17 out nocopy varchar2
735 ,p_segment18 out nocopy varchar2
736 ,p_segment19 out nocopy varchar2
737 ,p_segment20 out nocopy varchar2
738 ,p_segment21 out nocopy varchar2
739 ,p_segment22 out nocopy varchar2
740 ,p_segment23 out nocopy varchar2
741 ,p_segment24 out nocopy varchar2
742 ,p_segment25 out nocopy varchar2
743 ,p_segment26 out nocopy varchar2
744 ,p_segment27 out nocopy varchar2
745 ,p_segment28 out nocopy varchar2
746 ,p_segment29 out nocopy varchar2
747 ,p_segment30 out nocopy varchar2
748 );
749 --
750 end pay_ppmv4_utils_ss;