[Home] [Help]
PACKAGE BODY: APPS.HR_NZ_PERSONAL_PAY_METHOD_API
Source
1 PACKAGE BODY hr_nz_personal_pay_method_api AS
2 /* $Header: hrnzwrpp.pkb 120.2 2005/10/06 04:59:38 rpalli noship $ */
3 --
4 -- Package Variables
5 --
6 g_package VARCHAR2(33) := 'hr_nz_personal_pay_method_api.';
7
8 ------------------------------------------------------------
9 -- Private Procedures
10 ------------------------------------------------------------
11
12 PROCEDURE check_insert_legislation
13 (p_assignment_id IN NUMBER
14 ,p_effective_date IN OUT NOCOPY DATE
15 ,p_leg_code IN VARCHAR2
16 ) IS
17 --
18 -- Declare cursors and local variables
19 --
20 l_proc VARCHAR2(72) := g_package||'chk_insert_legislation';
21 l_valid VARCHAR2(150);
22 l_effective_date DATE;
23 --
24 CURSOR csr_legcode IS
25 SELECT pbg.legislation_code
26 FROM per_business_groups pbg,
27 per_assignments_f asg
28 WHERE pbg.business_group_id = asg.business_group_id
29 AND asg.assignment_id = p_assignment_id
30 AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
31
32 BEGIN
33 hr_utility.set_location('Entering:'|| l_proc, 5);
34 --
35 -- Check that p_assignment_id and p_effective_date are not null as they
36 -- are used by the cursor to validate the business group.
37 --
38 hr_api.mandatory_arg_error
39 (p_api_name => l_proc
40 ,p_argument => 'assignment_id'
41 ,p_argument_value => p_assignment_id);
42 --
43 hr_api.mandatory_arg_error
44 (p_api_name => l_proc
45 ,p_argument => 'effective_date'
46 ,p_argument_value => p_effective_date);
47 --
48 hr_utility.set_location(l_proc, 6);
49 --
50 -- Ensure that the legislation rule for the employee assignment
51 -- business group is that of p_leg_code.
52 --
53 OPEN csr_legcode;
54 FETCH csr_legcode INTO l_valid;
55 --
56 IF (csr_legcode%NOTFOUND)
57 THEN
58 CLOSE csr_legcode;
59 hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
60 hr_utility.raise_error;
61 END IF;
62 IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
63 THEN
64 CLOSE csr_legcode;
65 hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
66 hr_utility.raise_error;
67 END IF;
68 --
69 CLOSE csr_legcode;
70 hr_utility.set_location(l_proc, 7);
71 --
72 -- Assign out parameter after truncating the date by using a local
73 -- variable.
74 --
75 l_effective_date := TRUNC(p_effective_date);
76 p_effective_date := l_effective_date;
77 --
78 hr_utility.set_location('Leaving:'|| l_proc, 8);
79 --
80 END check_insert_legislation;
81
82
83 PROCEDURE check_update_legislation
84 (p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%TYPE
85 ,p_effective_date IN DATE
86 ,p_leg_code IN VARCHAR2
87 ) is
88 --
89 -- Declare cursors and local variables
90 --
91 l_proc VARCHAR2(72) := g_package||'check_update_legislation';
92 l_valid VARCHAR2(150);
93 --
94 CURSOR csr_legcode is
95 SELECT pbg.legislation_code
96 FROM per_business_groups pbg,
97 pay_personal_payment_methods_f ppm
98 WHERE pbg.business_group_id = ppm.business_group_id
99 AND ppm.personal_payment_method_id = p_personal_payment_method_id
100 AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
101 --
102 BEGIN
103 --
104 -- Ensure that the legislation rule for the employee assignment business
105 -- group is that of p_leg_code.
106 --
107 hr_utility.set_location('Entering:'|| l_proc, 10);
108 OPEN csr_legcode;
109 FETCH csr_legcode INTO l_valid;
110 --
111 IF (csr_legcode%NOTFOUND)
112 THEN
113 CLOSE csr_legcode;
114 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
115 hr_utility.raise_error;
116 END IF;
117 IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
118 THEN
119 hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
120 hr_utility.raise_error;
121 END IF;
122 CLOSE csr_legcode;
123 hr_utility.set_location('Leaving:'|| l_proc, 20);
124
125 END check_update_legislation;
126
127 ------------------------------------------------------------
128 -- Private Functions
129 ------------------------------------------------------------
130
131 ------------------------------------------------------------
132 -- Public Procedures
133 ------------------------------------------------------------
134
135 -------------------------------------------------------------
136 -- create_nz_personal_pay_method
137 -------------------------------------------------------------
138
139 PROCEDURE create_nz_personal_pay_method
140 (p_validate IN BOOLEAN DEFAULT FALSE
141 ,p_effective_date IN DATE
142 ,p_assignment_id IN NUMBER
143 ,p_run_type_id IN NUMBER DEFAULT NULL
144 ,p_org_payment_method_id IN NUMBER
145 ,p_bank_branch_number IN VARCHAR2
146 ,p_account_number IN VARCHAR2
147 ,p_account_suffix IN VARCHAR2
148 ,p_reference IN VARCHAR2 DEFAULT NULL
149 ,p_code IN VARCHAR2 DEFAULT NULL
150 ,p_third_party_particulars IN VARCHAR2 DEFAULT NULL
151 ,p_amount IN NUMBER DEFAULT NULL
152 ,p_percentage IN NUMBER DEFAULT NULL
153 ,p_priority IN NUMBER
154 ,p_comments IN VARCHAR2 DEFAULT NULL
155 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
156 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
157 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
158 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
159 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
160 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
161 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
162 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
163 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
164 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
165 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
166 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
167 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
168 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
169 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
170 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
171 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
172 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
173 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
174 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
175 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
176 ,p_concat_segments IN VARCHAR2 DEFAULT NULL
177 ,p_payee_type IN VARCHAR2 DEFAULT NULL
178 ,p_payee_id IN NUMBER DEFAULT NULL
179 ,p_ppm_information1 IN VARCHAR2 DEFAULT NULL
180 ,p_ppm_information2 IN VARCHAR2 DEFAULT NULL
181 ,p_ppm_information3 IN VARCHAR2 DEFAULT NULL
182 ,p_ppm_information4 IN VARCHAR2 DEFAULT NULL
183 ,p_ppm_information5 IN VARCHAR2 DEFAULT NULL
184 ,p_ppm_information6 IN VARCHAR2 DEFAULT NULL
185 ,p_ppm_information7 IN VARCHAR2 DEFAULT NULL
186 ,p_ppm_information8 IN VARCHAR2 DEFAULT NULL
187 ,p_ppm_information9 IN VARCHAR2 DEFAULT NULL
188 ,p_ppm_information10 IN VARCHAR2 DEFAULT NULL
189 ,p_ppm_information11 IN VARCHAR2 DEFAULT NULL
190 ,p_ppm_information12 IN VARCHAR2 DEFAULT NULL
191 ,p_ppm_information13 IN VARCHAR2 DEFAULT NULL
192 ,p_ppm_information14 IN VARCHAR2 DEFAULT NULL
193 ,p_ppm_information15 IN VARCHAR2 DEFAULT NULL
194 ,p_ppm_information16 IN VARCHAR2 DEFAULT NULL
195 ,p_ppm_information17 IN VARCHAR2 DEFAULT NULL
196 ,p_ppm_information18 IN VARCHAR2 DEFAULT NULL
197 ,p_ppm_information19 IN VARCHAR2 DEFAULT NULL
198 ,p_ppm_information20 IN VARCHAR2 DEFAULT NULL
199 ,p_ppm_information21 IN VARCHAR2 DEFAULT NULL
200 ,p_ppm_information22 IN VARCHAR2 DEFAULT NULL
201 ,p_ppm_information23 IN VARCHAR2 DEFAULT NULL
202 ,p_ppm_information24 IN VARCHAR2 DEFAULT NULL
203 ,p_ppm_information25 IN VARCHAR2 DEFAULT NULL
204 ,p_ppm_information26 IN VARCHAR2 DEFAULT NULL
205 ,p_ppm_information27 IN VARCHAR2 DEFAULT NULL
206 ,p_ppm_information28 IN VARCHAR2 DEFAULT NULL
207 ,p_ppm_information29 IN VARCHAR2 DEFAULT NULL
208 ,p_ppm_information30 IN VARCHAR2 DEFAULT NULL
209 ,p_personal_payment_method_id OUT NOCOPY NUMBER
210 ,p_external_account_id OUT NOCOPY NUMBER
211 ,p_object_version_number OUT NOCOPY NUMBER
212 ,p_effective_start_date OUT NOCOPY DATE
213 ,p_effective_end_date OUT NOCOPY DATE
214 ,p_comment_id OUT NOCOPY NUMBER
215 ) IS
216 --
217 -- Declare cursors and local variables
218 --
219 l_proc VARCHAR2(72) :=
220 g_package||'create_nz_personal_pay_method';
221 -- l_valid VARCHAR2(150);
222 l_effective_date DATE;
223 l_check_bank_acct VARCHAR2(5);
224 --
225 BEGIN
226 --
227 hr_utility.set_location('Entering:'|| l_proc, 5);
228 --
229 l_effective_date := TRUNC(p_effective_date);
230 --
231 hr_nz_personal_pay_method_api.check_insert_legislation
232 (p_assignment_id => p_assignment_id
233 ,p_effective_date => l_effective_date
234 ,p_leg_code => 'NZ');
235 --
236 hr_utility.set_location(l_proc, 7);
237
238 --
239 -- Call the business process to create the personal payment method
240 --
241 -- NOTE: p_segment6 is set to TRUE for the KFF cross-validation to work
242 -- A BEFORE API hook will fire the account validation and if it is OK the TRUE value is correct
243 -- otherwise if the validation fails the record will not be stored.
244 -- Reason :- p_segment6 is an IN parameter and cannot be changed after the validation
245
246 hr_personal_pay_method_api.create_personal_pay_method
247 (p_validate => p_validate
248 ,p_effective_date => l_effective_date
249 ,p_assignment_id => p_assignment_id
250 ,p_run_type_id => p_run_type_id
251 ,p_org_payment_method_id => p_org_payment_method_id
252 ,p_amount => p_amount
253 ,p_percentage => p_percentage
254 ,p_priority => p_priority
255 ,p_comments => p_comments
256 ,p_attribute_category => p_attribute_category
257 ,p_attribute1 => p_attribute1
258 ,p_attribute2 => p_attribute2
259 ,p_attribute3 => p_attribute3
260 ,p_attribute4 => p_attribute4
261 ,p_attribute5 => p_attribute5
262 ,p_attribute6 => p_attribute6
263 ,p_attribute7 => p_attribute7
264 ,p_attribute8 => p_attribute8
265 ,p_attribute9 => p_attribute9
266 ,p_attribute10 => p_attribute10
267 ,p_attribute11 => p_attribute11
268 ,p_attribute12 => p_attribute12
269 ,p_attribute13 => p_attribute13
270 ,p_attribute14 => p_attribute14
271 ,p_attribute15 => p_attribute15
272 ,p_attribute16 => p_attribute16
273 ,p_attribute17 => p_attribute17
274 ,p_attribute18 => p_attribute18
275 ,p_attribute19 => p_attribute19
276 ,p_attribute20 => p_attribute20
277 ,p_territory_code => 'NZ'
278 ,p_segment1 => p_bank_branch_number
279 ,p_segment2 => p_account_number
280 ,p_segment3 => p_account_suffix
281 ,p_segment4 => p_reference
282 ,p_segment5 => p_code
283 ,p_segment6 => 'TRUE'
284 ,p_segment7 => p_third_party_particulars
285 ,p_concat_segments => p_concat_segments
286 ,p_payee_type => p_payee_type
287 ,p_payee_id => p_payee_id
288 ,p_ppm_information1 => p_ppm_information1
289 ,p_ppm_information2 => p_ppm_information2
290 ,p_ppm_information3 => p_ppm_information3
291 ,p_ppm_information4 => p_ppm_information4
292 ,p_ppm_information5 => p_ppm_information5
293 ,p_ppm_information6 => p_ppm_information6
294 ,p_ppm_information7 => p_ppm_information7
295 ,p_ppm_information8 => p_ppm_information8
296 ,p_ppm_information9 => p_ppm_information9
297 ,p_ppm_information10 => p_ppm_information10
298 ,p_ppm_information11 => p_ppm_information11
299 ,p_ppm_information12 => p_ppm_information12
300 ,p_ppm_information13 => p_ppm_information13
301 ,p_ppm_information14 => p_ppm_information14
302 ,p_ppm_information15 => p_ppm_information15
303 ,p_ppm_information16 => p_ppm_information16
304 ,p_ppm_information17 => p_ppm_information17
305 ,p_ppm_information18 => p_ppm_information18
306 ,p_ppm_information19 => p_ppm_information19
307 ,p_ppm_information20 => p_ppm_information20
308 ,p_ppm_information21 => p_ppm_information21
309 ,p_ppm_information22 => p_ppm_information22
310 ,p_ppm_information23 => p_ppm_information23
311 ,p_ppm_information24 => p_ppm_information24
312 ,p_ppm_information25 => p_ppm_information25
313 ,p_ppm_information26 => p_ppm_information26
314 ,p_ppm_information27 => p_ppm_information27
315 ,p_ppm_information28 => p_ppm_information28
316 ,p_ppm_information29 => p_ppm_information29
317 ,p_ppm_information30 => p_ppm_information30
318 ,p_personal_payment_method_id => p_personal_payment_method_id
319 ,p_external_account_id => p_external_account_id
320 ,p_object_version_number => p_object_version_number
321 ,p_effective_start_date => p_effective_start_date
322 ,p_effective_end_date => p_effective_end_date
323 ,p_comment_id => p_comment_id
324 );
325 --
326 hr_utility.set_location(' Leaving:'||l_proc, 9);
327 END create_nz_personal_pay_method;
328
329
330 ------------------------------------------------------------------------------
331 -- update_nz_personal_pay_method
332 ------------------------------------------------------------------------------
333
334 PROCEDURE update_nz_personal_pay_method
335 (p_validate IN BOOLEAN DEFAULT FALSE
336 ,p_effective_date IN DATE
337 ,p_datetrack_update_mode IN VARCHAR2
338 ,p_personal_payment_method_id IN NUMBER
339 ,p_object_version_number IN OUT NOCOPY NUMBER
340 ,p_bank_branch_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
341 ,p_account_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
342 ,p_account_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
343 ,p_reference IN VARCHAR2 DEFAULT hr_api.g_varchar2
344 ,p_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
345 ,p_third_party_particulars IN VARCHAR2 DEFAULT hr_api.g_varchar2
349 ,p_priority IN NUMBER DEFAULT hr_api.g_number
346 ,p_amount IN NUMBER DEFAULT hr_api.g_number
347 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
348 ,p_percentage IN NUMBER DEFAULT hr_api.g_number
350 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
351 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
367 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
368 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
369 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
370 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
371 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
372 ,p_payee_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
373 ,p_payee_id IN NUMBER DEFAULT hr_api.g_number
374 ,p_ppm_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
375 ,p_ppm_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
376 ,p_ppm_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
377 ,p_ppm_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
378 ,p_ppm_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
379 ,p_ppm_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
380 ,p_ppm_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
381 ,p_ppm_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
382 ,p_ppm_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
383 ,p_ppm_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
384 ,p_ppm_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
385 ,p_ppm_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
386 ,p_ppm_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
387 ,p_ppm_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
388 ,p_ppm_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
389 ,p_ppm_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
390 ,p_ppm_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
391 ,p_ppm_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
392 ,p_ppm_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
393 ,p_ppm_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
394 ,p_ppm_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
395 ,p_ppm_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
396 ,p_ppm_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
397 ,p_ppm_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
398 ,p_ppm_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
399 ,p_ppm_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
400 ,p_ppm_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
401 ,p_ppm_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
402 ,p_ppm_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
403 ,p_ppm_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
404 ,p_comment_id OUT NOCOPY NUMBER
405 ,p_external_account_id OUT NOCOPY NUMBER
406 ,p_effective_start_date OUT NOCOPY DATE
407 ,p_effective_end_date OUT NOCOPY DATE
408 ) IS
409 --
410 -- Declare cursors and local variables
411 --
412 l_proc VARCHAR2(72) := g_package||'update_nz_personal_pay_method';
413 l_check_bank_acct VARCHAR2(5);
414 l_effective_date DATE;
415 --
416 BEGIN
417 hr_utility.set_location('Entering:'|| l_proc, 5);
418 --
419 l_effective_date := TRUNC(p_effective_date);
420 --
421 -- Ensure that the legislation rule for the employee assignment business
422 -- group is 'NZ'.
423 --
424
425 hr_nz_personal_pay_method_api.check_update_legislation
426 (p_personal_payment_method_id => p_personal_payment_method_id
427 ,p_effective_date => l_effective_date
428 ,p_leg_code => 'NZ');
429 --
430 hr_utility.set_location(l_proc, 6);
431
432 --
433 -- Call the business process to update the personal payment method
434 --
435 -- NOTE: p_segment6 is set to TRUE for the KFF cross-validation to work
436 -- A BEFORE API hook will fire the account validation and if it is OK the TRUE value is correct
437 -- otherwise if the validation fails the record will not be stored.
438 -- Reason :- p_segment6 is an IN parameter and cannot be changed after the validation
439
440 hr_personal_pay_method_api.update_personal_pay_method
441 (p_validate => p_validate
442 ,p_effective_date => l_effective_date
443 ,p_datetrack_update_mode => p_datetrack_update_mode
444 ,p_personal_payment_method_id => p_personal_payment_method_id
445 ,p_object_version_number => p_object_version_number
446 ,p_amount => p_amount
447 ,p_comments => p_comments
448 ,p_percentage => p_percentage
449 ,p_priority => p_priority
450 ,p_attribute_category => p_attribute_category
451 ,p_attribute1 => p_attribute1
452 ,p_attribute2 => p_attribute2
453 ,p_attribute3 => p_attribute3
454 ,p_attribute4 => p_attribute4
455 ,p_attribute5 => p_attribute5
456 ,p_attribute6 => p_attribute6
457 ,p_attribute7 => p_attribute7
458 ,p_attribute8 => p_attribute8
459 ,p_attribute9 => p_attribute9
460 ,p_attribute10 => p_attribute10
461 ,p_attribute11 => p_attribute11
462 ,p_attribute12 => p_attribute12
463 ,p_attribute13 => p_attribute13
464 ,p_attribute14 => p_attribute14
465 ,p_attribute15 => p_attribute15
466 ,p_attribute16 => p_attribute16
467 ,p_attribute17 => p_attribute17
468 ,p_attribute18 => p_attribute18
469 ,p_attribute19 => p_attribute19
470 ,p_attribute20 => p_attribute20
471 ,p_territory_code => 'NZ'
472 ,p_segment1 => p_bank_branch_number
473 ,p_segment2 => p_account_number
474 ,p_segment3 => p_account_suffix
475 ,p_segment4 => p_reference
476 ,p_segment5 => p_code
477 ,p_segment6 => 'TRUE'
478 ,p_segment7 => p_third_party_particulars
479 ,p_concat_segments => p_concat_segments
480 ,p_payee_type => p_payee_type
481 ,p_payee_id => p_payee_id
482 ,p_ppm_information1 => p_ppm_information1
483 ,p_ppm_information2 => p_ppm_information2
484 ,p_ppm_information3 => p_ppm_information3
485 ,p_ppm_information4 => p_ppm_information4
486 ,p_ppm_information5 => p_ppm_information5
487 ,p_ppm_information6 => p_ppm_information6
488 ,p_ppm_information7 => p_ppm_information7
489 ,p_ppm_information8 => p_ppm_information8
490 ,p_ppm_information9 => p_ppm_information9
491 ,p_ppm_information10 => p_ppm_information10
492 ,p_ppm_information11 => p_ppm_information11
493 ,p_ppm_information12 => p_ppm_information12
494 ,p_ppm_information13 => p_ppm_information13
495 ,p_ppm_information14 => p_ppm_information14
496 ,p_ppm_information15 => p_ppm_information15
497 ,p_ppm_information16 => p_ppm_information16
498 ,p_ppm_information17 => p_ppm_information17
499 ,p_ppm_information18 => p_ppm_information18
500 ,p_ppm_information19 => p_ppm_information19
501 ,p_ppm_information20 => p_ppm_information20
502 ,p_ppm_information21 => p_ppm_information21
503 ,p_ppm_information22 => p_ppm_information22
504 ,p_ppm_information23 => p_ppm_information23
505 ,p_ppm_information24 => p_ppm_information24
506 ,p_ppm_information25 => p_ppm_information25
507 ,p_ppm_information26 => p_ppm_information26
508 ,p_ppm_information27 => p_ppm_information27
509 ,p_ppm_information28 => p_ppm_information28
510 ,p_ppm_information29 => p_ppm_information29
511 ,p_ppm_information30 => p_ppm_information30
512 ,p_comment_id => p_comment_id
513 ,p_external_account_id => p_external_account_id
514 ,p_effective_start_date => p_effective_start_date
515 ,p_effective_end_date => p_effective_end_date
516 );
517 --
518 hr_utility.set_location(' Leaving:'||l_proc, 7);
519 END update_nz_personal_pay_method;
520
521 END hr_nz_personal_pay_method_api;