[Home] [Help]
143: l_proc varchar2(50) := g_package || 'get_parameters';
144:
145: begin
146:
147: hr_utility.set_location('Entering ' || l_proc, 10);
148:
149: hr_utility.set_location('Step ' || l_proc, 20);
150: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
151:
145: begin
146:
147: hr_utility.set_location('Entering ' || l_proc, 10);
148:
149: hr_utility.set_location('Step ' || l_proc, 20);
150: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
151:
152: open csr_parameter_info
153: (
146:
147: hr_utility.set_location('Entering ' || l_proc, 10);
148:
149: hr_utility.set_location('Step ' || l_proc, 20);
150: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
151:
152: open csr_parameter_info
153: (
154: p_payroll_action_id,
166: p_token_value := l_token_value;
167:
168: end if;
169:
170: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
171: hr_utility.set_location('Leaving ' || l_proc, 30);
172: --
173: exception
174: when others then
167:
168: end if;
169:
170: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
171: hr_utility.set_location('Leaving ' || l_proc, 30);
172: --
173: exception
174: when others then
175: p_token_value := null;
220: l_proc varchar2(50) := g_package || 'get_balance';
221:
222: begin
223:
224: hr_utility.set_location('Entering '|| l_proc,10);
225:
226: open csr_latest_asg_action;
227: fetch csr_latest_asg_action into l_latest_asg_action;
228: close csr_latest_asg_action;
226: open csr_latest_asg_action;
227: fetch csr_latest_asg_action into l_latest_asg_action;
228: close csr_latest_asg_action;
229:
230: hr_utility.set_location(g_package||'get_balance',20);
231:
232: -- Set the Payroll Action ID context to the last Payroll Action
233: -- that the assignment were processed in
234: pay_balance_pkg.set_context
253: and dim.balance_dimension_id = def.balance_dimension_id
254: and def.legislation_code = 'ZA';
255:
256:
257: hr_utility.set_location('Step ' || l_proc, 30);
258: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
259: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
260: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
261: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
254: and def.legislation_code = 'ZA';
255:
256:
257: hr_utility.set_location('Step ' || l_proc, 30);
258: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
259: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
260: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
261: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
262:
255:
256:
257: hr_utility.set_location('Step ' || l_proc, 30);
258: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
259: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
260: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
261: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
262:
263: --Bug 4140343
256:
257: hr_utility.set_location('Step ' || l_proc, 30);
258: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
259: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
260: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
261: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
262:
263: --Bug 4140343
264: --If an active or suspended assignment is not processed in a particular month then
257: hr_utility.set_location('Step ' || l_proc, 30);
258: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
259: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
260: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
261: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
262:
263: --Bug 4140343
264: --If an active or suspended assignment is not processed in a particular month then
265: --the balances values (dimension = _ASG_TAX_MTD ) are set to 0 and the employee is shown on the
271: p_defined_balance_id => l_defined_bal_id,
272: p_assignment_action_id => l_latest_asg_action
273: );
274:
275: hr_utility.set_location('l_balance_value = ' || l_balance_value, 40);
276:
277: else
278: l_balance_value := 0;
279:
282: return l_balance_value;
283:
284: exception
285: when others then
286: hr_utility.set_location(l_proc,50);
287: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
288: hr_utility.raise_error;
289:
290: end get_balance_value;
283:
284: exception
285: when others then
286: hr_utility.set_location(l_proc,50);
287: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
288: hr_utility.raise_error;
289:
290: end get_balance_value;
291:
284: exception
285: when others then
286: hr_utility.set_location(l_proc,50);
287: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
288: hr_utility.raise_error;
289:
290: end get_balance_value;
291:
292:
354: l_proc varchar2(50) := g_package || 'range_cursor';
355:
356: begin
357:
358: --hr_utility.trace_on(null, 'UIF');
359:
360: hr_utility.set_location('Entering ' || l_proc, 10);
361: hr_utility.trace('Entering ' || l_proc);
362:
356: begin
357:
358: --hr_utility.trace_on(null, 'UIF');
359:
360: hr_utility.set_location('Entering ' || l_proc, 10);
361: hr_utility.trace('Entering ' || l_proc);
362:
363: g_archive_pact := pactid; -- Payroll Action of the Archiver
364:
357:
358: --hr_utility.trace_on(null, 'UIF');
359:
360: hr_utility.set_location('Entering ' || l_proc, 10);
361: hr_utility.trace('Entering ' || l_proc);
362:
363: g_archive_pact := pactid; -- Payroll Action of the Archiver
364:
365: hr_utility.trace('g_archive_pact: ' || to_char(g_archive_pact));
361: hr_utility.trace('Entering ' || l_proc);
362:
363: g_archive_pact := pactid; -- Payroll Action of the Archiver
364:
365: hr_utility.trace('g_archive_pact: ' || to_char(g_archive_pact));
366:
367:
368: -- Get the effective date of the payroll action
369: open csr_archive_effective_date(pactid); -- Payroll Action of the Archiver
414: g_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
415:
416: g_business_group_id := l_bg_id;
417:
418: hr_utility.set_location('Step ' || l_proc, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
415:
416: g_business_group_id := l_bg_id;
417:
418: hr_utility.set_location('Step ' || l_proc, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
416: g_business_group_id := l_bg_id;
417:
418: hr_utility.set_location('Step ' || l_proc, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
417:
418: hr_utility.set_location('Step ' || l_proc, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
418: hr_utility.set_location('Step ' || l_proc, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
426: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
419: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
426: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
427: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
420: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
421: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
426: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
427: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
428:
422: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
426: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
427: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
428:
429:
430: -- Archive Creator Information that have not been archived yet for the specified UIF Month
423: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
424: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
425:
426: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
427: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
428:
429:
430: -- Archive Creator Information that have not been archived yet for the specified UIF Month
431: open csr_creator_info;
437:
438: if csr_creator_info%notfound
439: then
440:
441: hr_utility.set_location('ZA UIF CREATOR DETAILS does not exist', 21);
442:
443: else
444:
445: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
441: hr_utility.set_location('ZA UIF CREATOR DETAILS does not exist', 21);
442:
443: else
444:
445: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
446:
447: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
443: else
444:
445: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
446:
447: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
450: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
451: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
445: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
446:
447: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
450: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
451: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
452: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
453:
446:
447: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
450: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
451: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
452: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
453:
454: --Process UIF Ref. No.
447: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
450: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
451: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
452: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
453:
454: --Process UIF Ref. No.
455: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);
448:
449: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
450: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
451: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
452: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
453:
454: --Process UIF Ref. No.
455: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);
456:
453:
454: --Process UIF Ref. No.
455: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);
456:
457: hr_utility.set_location('l_creator_uif_reference_processed '||l_creator_uif_reference, 30);
458:
459: -- Archive 'ZA UIF CREATOR DETAILS'
460: pay_action_information_api.create_action_information
461: (
492: order by asg.person_id';
493:
494: sqlstr := sql_range;
495:
496: hr_utility.set_location('Leaving ' || l_proc, 10);
497:
498: --hr_utility.trace_off;
499: --
500: exception
494: sqlstr := sql_range;
495:
496: hr_utility.set_location('Leaving ' || l_proc, 10);
497:
498: --hr_utility.trace_off;
499: --
500: exception
501: when others then
502: sqlstr := null;
524: l_proc varchar2(50) := g_package || 'range_cursor_mag';
525:
526: begin
527:
528: --hr_utility.trace_on(null, 'UIF');
529:
530: hr_utility.set_location('Entering ' || l_proc, 10);
531:
532: sql_range :=
526: begin
527:
528: --hr_utility.trace_on(null, 'UIF');
529:
530: hr_utility.set_location('Entering ' || l_proc, 10);
531:
532: sql_range :=
533: 'select distinct asg.person_id
534: from per_assignments_f asg,
542: order by asg.person_id';
543:
544: sqlstr := sql_range;
545:
546: hr_utility.set_location('Leaving ' || l_proc, 10);
547:
548: --hr_utility.trace_off;
549: --
550: exception
544: sqlstr := sql_range;
545:
546: hr_utility.set_location('Leaving ' || l_proc, 10);
547:
548: --hr_utility.trace_off;
549: --
550: exception
551: when others then
552: sqlstr := null;
725: l_asgid number;
726:
727: begin
728:
729: --hr_utility.trace_on(null, 'UIF');
730:
731: hr_utility.set_location('Entering ' || l_proc, 10);
732:
733: select get_parameter('START_DATE', legislative_parameters)
727: begin
728:
729: --hr_utility.trace_on(null, 'UIF');
730:
731: hr_utility.set_location('Entering ' || l_proc, 10);
732:
733: select get_parameter('START_DATE', legislative_parameters)
734: into l_start_date
735: from pay_payroll_actions
757:
758: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
759: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
760:
761: hr_utility.set_location('pactid '||to_char(pactid), 10);
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
758: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
759: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
760:
761: hr_utility.set_location('pactid '||to_char(pactid), 10);
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
759: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
760:
761: hr_utility.set_location('pactid '||to_char(pactid), 10);
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
767: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
760:
761: hr_utility.set_location('pactid '||to_char(pactid), 10);
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
767: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
768:
761: hr_utility.set_location('pactid '||to_char(pactid), 10);
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
767: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
768:
769: if l_asg_set_id is not null then
762: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
767: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
768:
769: if l_asg_set_id is not null then
770: -- need to find out if assignments in assignment-set are set to Include or Exclude.
763: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
764: hr_utility.set_location('stperson '||to_char(stperson), 10);
765: hr_utility.set_location('endperson '||to_char(endperson), 10);
766: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
767: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
768:
769: if l_asg_set_id is not null then
770: -- need to find out if assignments in assignment-set are set to Include or Exclude.
771: begin
779: v_incl_sw := 'I';
780: end;
781: end if;
782:
783: hr_utility.set_location('Before csr_get_asg', 20);
784:
785: for asgrec in csr_get_asg (pactid, stperson, endperson, l_canonical_start_date, l_canonical_end_date) loop
786:
787: hr_utility.set_location('ASG: ' || to_char(asgrec.assignment_id), 30);
783: hr_utility.set_location('Before csr_get_asg', 20);
784:
785: for asgrec in csr_get_asg (pactid, stperson, endperson, l_canonical_start_date, l_canonical_end_date) loop
786:
787: hr_utility.set_location('ASG: ' || to_char(asgrec.assignment_id), 30);
788:
789: asg_include := TRUE;
790:
791: -- Remove duplicate assignments
850: end if;
851:
852: end loop;
853:
854: hr_utility.set_location('Leaving ' || l_proc, 30);
855:
856: --hr_utility.trace_off;
857:
858: end action_creation;
852: end loop;
853:
854: hr_utility.set_location('Leaving ' || l_proc, 30);
855:
856: --hr_utility.trace_off;
857:
858: end action_creation;
859:
860:
1109: l_payroll_id number:=0; --Bug 4134166
1110:
1111: begin
1112:
1113: --hr_utility.trace_on(null, 'UIF');
1114:
1115: hr_utility.set_location('Entering ' || l_proc, 10);
1116:
1117: --get the Archive Effective Date
1111: begin
1112:
1113: --hr_utility.trace_on(null, 'UIF');
1114:
1115: hr_utility.set_location('Entering ' || l_proc, 10);
1116:
1117: --get the Archive Effective Date
1118: select ppa.effective_date,
1119: ppa.payroll_action_id
1363: p_token_name => 'PAYROLL_ID',
1364: p_token_value => l_payroll_id
1365: );
1366:
1367: hr_utility.set_location('l_payroll_id => '|| l_payroll_id, 100);
1368: hr_utility.set_location('l_pactid => '|| l_pactid, 100);
1369:
1370: --Added for Bug 4134166
1371: open csr_pay_periods_per_year(p_effective_date,l_payroll_id);
1364: p_token_value => l_payroll_id
1365: );
1366:
1367: hr_utility.set_location('l_payroll_id => '|| l_payroll_id, 100);
1368: hr_utility.set_location('l_pactid => '|| l_pactid, 100);
1369:
1370: --Added for Bug 4134166
1371: open csr_pay_periods_per_year(p_effective_date,l_payroll_id);
1372: fetch csr_pay_periods_per_year
1381: into l_pay_periods_per_month;
1382:
1383: close csr_pay_periods_per_month;
1384:
1385: hr_utility.set_location('l_pay_periods_per_year => '|| to_char(l_pay_periods_per_year), 100);
1386: hr_utility.set_location('l_pay_periods_per_month => '|| to_char(l_pay_periods_per_month), 100);
1387:
1388: open csr_uif_limit (p_effective_date);
1389:
1382:
1383: close csr_pay_periods_per_month;
1384:
1385: hr_utility.set_location('l_pay_periods_per_year => '|| to_char(l_pay_periods_per_year), 100);
1386: hr_utility.set_location('l_pay_periods_per_month => '|| to_char(l_pay_periods_per_month), 100);
1387:
1388: open csr_uif_limit (p_effective_date);
1389:
1390: fetch csr_uif_limit
1450: l_reason_non_contrib := '07';
1451: end if;
1452:
1453:
1454: hr_utility.set_location('Archiving ZA UIF EMPLOYEE DETAILS', 50);
1455:
1456: -- Only archive record if the Assignment's Legal Entity and the latter's
1457: -- Employer UIF Ref No exist
1458: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1456: -- Only archive record if the Assignment's Legal Entity and the latter's
1457: -- Employer UIF Ref No exist
1458: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1459:
1460: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1457: -- Employer UIF Ref No exist
1458: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1459:
1460: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1458: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1459:
1460: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1459:
1460: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1460: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1461: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1462: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1463: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1464: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1465: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1466: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1467: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1468: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1469: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1470: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1471: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1472: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1473: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1474: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1475: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1476: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1477: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1478: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1486: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1479: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1486: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1487:
1480: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1486: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1487:
1488:
1481: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1486: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1487:
1488:
1489: -- Archive the ZA UIF EMPLOYEE DETAILS
1482: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1483: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1484: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1485: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1486: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1487:
1488:
1489: -- Archive the ZA UIF EMPLOYEE DETAILS
1490: pay_action_information_api.create_action_information
1523: );
1524:
1525: end if;
1526:
1527: hr_utility.set_location('Leaving ' || l_proc, 60);
1528:
1529: --hr_utility.trace_off;
1530:
1531: end archive_data;
1525: end if;
1526:
1527: hr_utility.set_location('Leaving ' || l_proc, 60);
1528:
1529: --hr_utility.trace_off;
1530:
1531: end archive_data;
1532:
1533:
1549: l_temp_no varchar2(11) := '';
1550:
1551: begin
1552:
1553: hr_utility.set_location('Entering process_uif_ref_no', 10);
1554:
1555: l_employer_uif_ref_no := p_employer_uif_ref_no;
1556:
1557: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 20);
1553: hr_utility.set_location('Entering process_uif_ref_no', 10);
1554:
1555: l_employer_uif_ref_no := p_employer_uif_ref_no;
1556:
1557: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 20);
1558:
1559: if l_employer_uif_ref_no is not null then
1560:
1561: l_employer_uif_ref_no := ltrim(rtrim(l_employer_uif_ref_no));
1559: if l_employer_uif_ref_no is not null then
1560:
1561: l_employer_uif_ref_no := ltrim(rtrim(l_employer_uif_ref_no));
1562:
1563: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 25);
1564:
1565: l_length := to_number(length(l_employer_uif_ref_no));
1566:
1567: hr_utility.set_location('length_l_employer_uif_ref_no = '|| to_char(l_length), 30);
1563: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 25);
1564:
1565: l_length := to_number(length(l_employer_uif_ref_no));
1566:
1567: hr_utility.set_location('length_l_employer_uif_ref_no = '|| to_char(l_length), 30);
1568:
1569: for i in 1 .. l_length
1570:
1571: loop
1575: then
1576:
1577: l_temp_no := l_temp_no || substr(l_employer_uif_ref_no, i, 1);
1578:
1579: hr_utility.set_location('l_temp_no = '|| l_temp_no, 35);
1580:
1581: end if;
1582:
1583: end loop;
1585: end if;
1586:
1587: l_employer_uif_ref_no := ltrim(rtrim(l_temp_no));
1588:
1589: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED= '|| l_employer_uif_ref_no, 40);
1590:
1591: l_length := to_number(length(l_employer_uif_ref_no));
1592:
1593: if l_length > 9 then
1597: end if;
1598:
1599: l_employer_uif_ref_no := lpad(l_employer_uif_ref_no, 9, '0');
1600:
1601: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED_zero_padded= '|| l_employer_uif_ref_no, 50);
1602:
1603: return l_employer_uif_ref_no;
1604:
1605: end process_uif_ref_no;
1764: l_value varchar2(256);
1765:
1766: begin
1767:
1768: --hr_utility.trace_on(null, 'UIF');
1769:
1770: l_code := p_code;
1771:
1772: -- Remove any spaces
1872:
1873: end if;
1874:
1875:
1876: hr_utility.trace('DO(' || l_code || ',' || l_value || ',' || l_text || ')');
1877: --hr_utility.trace_off;
1878: return l_text;
1879:
1880: end;
1873: end if;
1874:
1875:
1876: hr_utility.trace('DO(' || l_code || ',' || l_value || ',' || l_text || ')');
1877: --hr_utility.trace_off;
1878: return l_text;
1879:
1880: end;
1881: