APPS.BEN_PIL_UPD dependencies on HR_API

Line 135: When hr_api.check_integrity_violated Then

131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: --
134: Exception
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
138: ben_pil_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
138: ben_pil_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
143: ben_pil_shd.constraint_error

Line 140: When hr_api.parent_integrity_violated Then

136: -- A check constraint has been violated
137: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
138: ben_pil_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
143: ben_pil_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
143: ben_pil_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
148: ben_pil_shd.constraint_error

Line 145: When hr_api.unique_integrity_violated Then

141: -- Parent integrity has been violated
142: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
143: ben_pil_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
148: ben_pil_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
148: ben_pil_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;
153: End update_dml;

Line 362: when hr_api.cannot_find_prog_unit then

358: );
359: --
360: exception
361: --
362: when hr_api.cannot_find_prog_unit then
363: --
364: hr_api.cannot_find_prog_unit_error
365: (p_module_name => 'ben_per_in_ler'
366: ,p_hook_type => 'AU');

Line 364: hr_api.cannot_find_prog_unit_error

360: exception
361: --
362: when hr_api.cannot_find_prog_unit then
363: --
364: hr_api.cannot_find_prog_unit_error
365: (p_module_name => 'ben_per_in_ler'
366: ,p_hook_type => 'AU');
367: --
368: end;

Line 432: If (p_rec.per_in_ler_stat_cd = hr_api.g_varchar2) then

428: -- p_rec plsql record structure
429: -- to see if a system default is being used. If a system default
430: -- is being used then we must set to the 'current' argument value.
431: --
432: If (p_rec.per_in_ler_stat_cd = hr_api.g_varchar2) then
433: p_rec.per_in_ler_stat_cd :=
434: ben_pil_shd.g_old_rec.per_in_ler_stat_cd;
435: End If;
436: If (p_rec.prvs_stat_cd = hr_api.g_varchar2) then

Line 436: If (p_rec.prvs_stat_cd = hr_api.g_varchar2) then

432: If (p_rec.per_in_ler_stat_cd = hr_api.g_varchar2) then
433: p_rec.per_in_ler_stat_cd :=
434: ben_pil_shd.g_old_rec.per_in_ler_stat_cd;
435: End If;
436: If (p_rec.prvs_stat_cd = hr_api.g_varchar2) then
437: p_rec.prvs_stat_cd :=
438: ben_pil_shd.g_old_rec.prvs_stat_cd ;
439: End If;
440: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

Line 440: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

436: If (p_rec.prvs_stat_cd = hr_api.g_varchar2) then
437: p_rec.prvs_stat_cd :=
438: ben_pil_shd.g_old_rec.prvs_stat_cd ;
439: End If;
440: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
441: p_rec.lf_evt_ocrd_dt :=
442: ben_pil_shd.g_old_rec.lf_evt_ocrd_dt;
443: End If;
444: If (p_rec.trgr_table_pk_id = hr_api.g_number) then

Line 444: If (p_rec.trgr_table_pk_id = hr_api.g_number) then

440: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
441: p_rec.lf_evt_ocrd_dt :=
442: ben_pil_shd.g_old_rec.lf_evt_ocrd_dt;
443: End If;
444: If (p_rec.trgr_table_pk_id = hr_api.g_number) then
445: p_rec.trgr_table_pk_id :=
446: ben_pil_shd.g_old_rec.trgr_table_pk_id;
447: End If;
448: If (p_rec.procd_dt = hr_api.g_date) then

Line 448: If (p_rec.procd_dt = hr_api.g_date) then

444: If (p_rec.trgr_table_pk_id = hr_api.g_number) then
445: p_rec.trgr_table_pk_id :=
446: ben_pil_shd.g_old_rec.trgr_table_pk_id;
447: End If;
448: If (p_rec.procd_dt = hr_api.g_date) then
449: p_rec.procd_dt :=
450: ben_pil_shd.g_old_rec.procd_dt;
451: End If;
452: If (p_rec.strtd_dt = hr_api.g_date) then

Line 452: If (p_rec.strtd_dt = hr_api.g_date) then

448: If (p_rec.procd_dt = hr_api.g_date) then
449: p_rec.procd_dt :=
450: ben_pil_shd.g_old_rec.procd_dt;
451: End If;
452: If (p_rec.strtd_dt = hr_api.g_date) then
453: p_rec.strtd_dt :=
454: ben_pil_shd.g_old_rec.strtd_dt;
455: End If;
456: If (p_rec.voidd_dt = hr_api.g_date) then

Line 456: If (p_rec.voidd_dt = hr_api.g_date) then

452: If (p_rec.strtd_dt = hr_api.g_date) then
453: p_rec.strtd_dt :=
454: ben_pil_shd.g_old_rec.strtd_dt;
455: End If;
456: If (p_rec.voidd_dt = hr_api.g_date) then
457: p_rec.voidd_dt :=
458: ben_pil_shd.g_old_rec.voidd_dt;
459: End If;
460: If (p_rec.bckt_dt = hr_api.g_date) then

Line 460: If (p_rec.bckt_dt = hr_api.g_date) then

456: If (p_rec.voidd_dt = hr_api.g_date) then
457: p_rec.voidd_dt :=
458: ben_pil_shd.g_old_rec.voidd_dt;
459: End If;
460: If (p_rec.bckt_dt = hr_api.g_date) then
461: p_rec.bckt_dt :=
462: ben_pil_shd.g_old_rec.bckt_dt;
463: End If;
464: If (p_rec.clsd_dt = hr_api.g_date) then

Line 464: If (p_rec.clsd_dt = hr_api.g_date) then

460: If (p_rec.bckt_dt = hr_api.g_date) then
461: p_rec.bckt_dt :=
462: ben_pil_shd.g_old_rec.bckt_dt;
463: End If;
464: If (p_rec.clsd_dt = hr_api.g_date) then
465: p_rec.clsd_dt :=
466: ben_pil_shd.g_old_rec.clsd_dt;
467: End If;
468: If (p_rec.ntfn_dt = hr_api.g_date) then

Line 468: If (p_rec.ntfn_dt = hr_api.g_date) then

464: If (p_rec.clsd_dt = hr_api.g_date) then
465: p_rec.clsd_dt :=
466: ben_pil_shd.g_old_rec.clsd_dt;
467: End If;
468: If (p_rec.ntfn_dt = hr_api.g_date) then
469: p_rec.ntfn_dt :=
470: ben_pil_shd.g_old_rec.ntfn_dt;
471: End If;
472: If (p_rec.ptnl_ler_for_per_id = hr_api.g_number) then

Line 472: If (p_rec.ptnl_ler_for_per_id = hr_api.g_number) then

468: If (p_rec.ntfn_dt = hr_api.g_date) then
469: p_rec.ntfn_dt :=
470: ben_pil_shd.g_old_rec.ntfn_dt;
471: End If;
472: If (p_rec.ptnl_ler_for_per_id = hr_api.g_number) then
473: p_rec.ptnl_ler_for_per_id :=
474: ben_pil_shd.g_old_rec.ptnl_ler_for_per_id;
475: End If;
476: If (p_rec.bckt_per_in_ler_id = hr_api.g_number) then

Line 476: If (p_rec.bckt_per_in_ler_id = hr_api.g_number) then

472: If (p_rec.ptnl_ler_for_per_id = hr_api.g_number) then
473: p_rec.ptnl_ler_for_per_id :=
474: ben_pil_shd.g_old_rec.ptnl_ler_for_per_id;
475: End If;
476: If (p_rec.bckt_per_in_ler_id = hr_api.g_number) then
477: p_rec.bckt_per_in_ler_id :=
478: ben_pil_shd.g_old_rec.bckt_per_in_ler_id ;
479: End If;
480: If (p_rec.ler_id = hr_api.g_number) then

Line 480: If (p_rec.ler_id = hr_api.g_number) then

476: If (p_rec.bckt_per_in_ler_id = hr_api.g_number) then
477: p_rec.bckt_per_in_ler_id :=
478: ben_pil_shd.g_old_rec.bckt_per_in_ler_id ;
479: End If;
480: If (p_rec.ler_id = hr_api.g_number) then
481: p_rec.ler_id :=
482: ben_pil_shd.g_old_rec.ler_id;
483: End If;
484: If (p_rec.person_id = hr_api.g_number) then

Line 484: If (p_rec.person_id = hr_api.g_number) then

480: If (p_rec.ler_id = hr_api.g_number) then
481: p_rec.ler_id :=
482: ben_pil_shd.g_old_rec.ler_id;
483: End If;
484: If (p_rec.person_id = hr_api.g_number) then
485: p_rec.person_id :=
486: ben_pil_shd.g_old_rec.person_id;
487: End If;
488: If (p_rec.business_group_id = hr_api.g_number) then

Line 488: If (p_rec.business_group_id = hr_api.g_number) then

484: If (p_rec.person_id = hr_api.g_number) then
485: p_rec.person_id :=
486: ben_pil_shd.g_old_rec.person_id;
487: End If;
488: If (p_rec.business_group_id = hr_api.g_number) then
489: p_rec.business_group_id :=
490: ben_pil_shd.g_old_rec.business_group_id;
491: End If;
492: If (p_rec.ASSIGNMENT_ID = hr_api.g_number) then

Line 492: If (p_rec.ASSIGNMENT_ID = hr_api.g_number) then

488: If (p_rec.business_group_id = hr_api.g_number) then
489: p_rec.business_group_id :=
490: ben_pil_shd.g_old_rec.business_group_id;
491: End If;
492: If (p_rec.ASSIGNMENT_ID = hr_api.g_number) then
493: p_rec.ASSIGNMENT_ID :=
494: ben_pil_shd.g_old_rec.ASSIGNMENT_ID;
495: End If;
496: If (p_rec.WS_MGR_ID = hr_api.g_number) then

Line 496: If (p_rec.WS_MGR_ID = hr_api.g_number) then

492: If (p_rec.ASSIGNMENT_ID = hr_api.g_number) then
493: p_rec.ASSIGNMENT_ID :=
494: ben_pil_shd.g_old_rec.ASSIGNMENT_ID;
495: End If;
496: If (p_rec.WS_MGR_ID = hr_api.g_number) then
497: p_rec.WS_MGR_ID :=
498: ben_pil_shd.g_old_rec.WS_MGR_ID;
499: End If;
500: If (p_rec.GROUP_PL_ID = hr_api.g_number) then

Line 500: If (p_rec.GROUP_PL_ID = hr_api.g_number) then

496: If (p_rec.WS_MGR_ID = hr_api.g_number) then
497: p_rec.WS_MGR_ID :=
498: ben_pil_shd.g_old_rec.WS_MGR_ID;
499: End If;
500: If (p_rec.GROUP_PL_ID = hr_api.g_number) then
501: p_rec.GROUP_PL_ID :=
502: ben_pil_shd.g_old_rec.GROUP_PL_ID;
503: End If;
504: If (p_rec.MGR_OVRID_PERSON_ID = hr_api.g_number) then

Line 504: If (p_rec.MGR_OVRID_PERSON_ID = hr_api.g_number) then

500: If (p_rec.GROUP_PL_ID = hr_api.g_number) then
501: p_rec.GROUP_PL_ID :=
502: ben_pil_shd.g_old_rec.GROUP_PL_ID;
503: End If;
504: If (p_rec.MGR_OVRID_PERSON_ID = hr_api.g_number) then
505: p_rec.MGR_OVRID_PERSON_ID :=
506: ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID;
507: End If;
508: If (p_rec.MGR_OVRID_DT = hr_api.g_date) then

Line 508: If (p_rec.MGR_OVRID_DT = hr_api.g_date) then

504: If (p_rec.MGR_OVRID_PERSON_ID = hr_api.g_number) then
505: p_rec.MGR_OVRID_PERSON_ID :=
506: ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID;
507: End If;
508: If (p_rec.MGR_OVRID_DT = hr_api.g_date) then
509: p_rec.MGR_OVRID_DT :=
510: ben_pil_shd.g_old_rec.MGR_OVRID_DT;
511: End If;
512: If (p_rec.pil_attribute_category = hr_api.g_varchar2) then

Line 512: If (p_rec.pil_attribute_category = hr_api.g_varchar2) then

508: If (p_rec.MGR_OVRID_DT = hr_api.g_date) then
509: p_rec.MGR_OVRID_DT :=
510: ben_pil_shd.g_old_rec.MGR_OVRID_DT;
511: End If;
512: If (p_rec.pil_attribute_category = hr_api.g_varchar2) then
513: p_rec.pil_attribute_category :=
514: ben_pil_shd.g_old_rec.pil_attribute_category;
515: End If;
516: If (p_rec.pil_attribute1 = hr_api.g_varchar2) then

Line 516: If (p_rec.pil_attribute1 = hr_api.g_varchar2) then

512: If (p_rec.pil_attribute_category = hr_api.g_varchar2) then
513: p_rec.pil_attribute_category :=
514: ben_pil_shd.g_old_rec.pil_attribute_category;
515: End If;
516: If (p_rec.pil_attribute1 = hr_api.g_varchar2) then
517: p_rec.pil_attribute1 :=
518: ben_pil_shd.g_old_rec.pil_attribute1;
519: End If;
520: If (p_rec.pil_attribute2 = hr_api.g_varchar2) then

Line 520: If (p_rec.pil_attribute2 = hr_api.g_varchar2) then

516: If (p_rec.pil_attribute1 = hr_api.g_varchar2) then
517: p_rec.pil_attribute1 :=
518: ben_pil_shd.g_old_rec.pil_attribute1;
519: End If;
520: If (p_rec.pil_attribute2 = hr_api.g_varchar2) then
521: p_rec.pil_attribute2 :=
522: ben_pil_shd.g_old_rec.pil_attribute2;
523: End If;
524: If (p_rec.pil_attribute3 = hr_api.g_varchar2) then

Line 524: If (p_rec.pil_attribute3 = hr_api.g_varchar2) then

520: If (p_rec.pil_attribute2 = hr_api.g_varchar2) then
521: p_rec.pil_attribute2 :=
522: ben_pil_shd.g_old_rec.pil_attribute2;
523: End If;
524: If (p_rec.pil_attribute3 = hr_api.g_varchar2) then
525: p_rec.pil_attribute3 :=
526: ben_pil_shd.g_old_rec.pil_attribute3;
527: End If;
528: If (p_rec.pil_attribute4 = hr_api.g_varchar2) then

Line 528: If (p_rec.pil_attribute4 = hr_api.g_varchar2) then

524: If (p_rec.pil_attribute3 = hr_api.g_varchar2) then
525: p_rec.pil_attribute3 :=
526: ben_pil_shd.g_old_rec.pil_attribute3;
527: End If;
528: If (p_rec.pil_attribute4 = hr_api.g_varchar2) then
529: p_rec.pil_attribute4 :=
530: ben_pil_shd.g_old_rec.pil_attribute4;
531: End If;
532: If (p_rec.pil_attribute5 = hr_api.g_varchar2) then

Line 532: If (p_rec.pil_attribute5 = hr_api.g_varchar2) then

528: If (p_rec.pil_attribute4 = hr_api.g_varchar2) then
529: p_rec.pil_attribute4 :=
530: ben_pil_shd.g_old_rec.pil_attribute4;
531: End If;
532: If (p_rec.pil_attribute5 = hr_api.g_varchar2) then
533: p_rec.pil_attribute5 :=
534: ben_pil_shd.g_old_rec.pil_attribute5;
535: End If;
536: If (p_rec.pil_attribute6 = hr_api.g_varchar2) then

Line 536: If (p_rec.pil_attribute6 = hr_api.g_varchar2) then

532: If (p_rec.pil_attribute5 = hr_api.g_varchar2) then
533: p_rec.pil_attribute5 :=
534: ben_pil_shd.g_old_rec.pil_attribute5;
535: End If;
536: If (p_rec.pil_attribute6 = hr_api.g_varchar2) then
537: p_rec.pil_attribute6 :=
538: ben_pil_shd.g_old_rec.pil_attribute6;
539: End If;
540: If (p_rec.pil_attribute7 = hr_api.g_varchar2) then

Line 540: If (p_rec.pil_attribute7 = hr_api.g_varchar2) then

536: If (p_rec.pil_attribute6 = hr_api.g_varchar2) then
537: p_rec.pil_attribute6 :=
538: ben_pil_shd.g_old_rec.pil_attribute6;
539: End If;
540: If (p_rec.pil_attribute7 = hr_api.g_varchar2) then
541: p_rec.pil_attribute7 :=
542: ben_pil_shd.g_old_rec.pil_attribute7;
543: End If;
544: If (p_rec.pil_attribute8 = hr_api.g_varchar2) then

Line 544: If (p_rec.pil_attribute8 = hr_api.g_varchar2) then

540: If (p_rec.pil_attribute7 = hr_api.g_varchar2) then
541: p_rec.pil_attribute7 :=
542: ben_pil_shd.g_old_rec.pil_attribute7;
543: End If;
544: If (p_rec.pil_attribute8 = hr_api.g_varchar2) then
545: p_rec.pil_attribute8 :=
546: ben_pil_shd.g_old_rec.pil_attribute8;
547: End If;
548: If (p_rec.pil_attribute9 = hr_api.g_varchar2) then

Line 548: If (p_rec.pil_attribute9 = hr_api.g_varchar2) then

544: If (p_rec.pil_attribute8 = hr_api.g_varchar2) then
545: p_rec.pil_attribute8 :=
546: ben_pil_shd.g_old_rec.pil_attribute8;
547: End If;
548: If (p_rec.pil_attribute9 = hr_api.g_varchar2) then
549: p_rec.pil_attribute9 :=
550: ben_pil_shd.g_old_rec.pil_attribute9;
551: End If;
552: If (p_rec.pil_attribute10 = hr_api.g_varchar2) then

Line 552: If (p_rec.pil_attribute10 = hr_api.g_varchar2) then

548: If (p_rec.pil_attribute9 = hr_api.g_varchar2) then
549: p_rec.pil_attribute9 :=
550: ben_pil_shd.g_old_rec.pil_attribute9;
551: End If;
552: If (p_rec.pil_attribute10 = hr_api.g_varchar2) then
553: p_rec.pil_attribute10 :=
554: ben_pil_shd.g_old_rec.pil_attribute10;
555: End If;
556: If (p_rec.pil_attribute11 = hr_api.g_varchar2) then

Line 556: If (p_rec.pil_attribute11 = hr_api.g_varchar2) then

552: If (p_rec.pil_attribute10 = hr_api.g_varchar2) then
553: p_rec.pil_attribute10 :=
554: ben_pil_shd.g_old_rec.pil_attribute10;
555: End If;
556: If (p_rec.pil_attribute11 = hr_api.g_varchar2) then
557: p_rec.pil_attribute11 :=
558: ben_pil_shd.g_old_rec.pil_attribute11;
559: End If;
560: If (p_rec.pil_attribute12 = hr_api.g_varchar2) then

Line 560: If (p_rec.pil_attribute12 = hr_api.g_varchar2) then

556: If (p_rec.pil_attribute11 = hr_api.g_varchar2) then
557: p_rec.pil_attribute11 :=
558: ben_pil_shd.g_old_rec.pil_attribute11;
559: End If;
560: If (p_rec.pil_attribute12 = hr_api.g_varchar2) then
561: p_rec.pil_attribute12 :=
562: ben_pil_shd.g_old_rec.pil_attribute12;
563: End If;
564: If (p_rec.pil_attribute13 = hr_api.g_varchar2) then

Line 564: If (p_rec.pil_attribute13 = hr_api.g_varchar2) then

560: If (p_rec.pil_attribute12 = hr_api.g_varchar2) then
561: p_rec.pil_attribute12 :=
562: ben_pil_shd.g_old_rec.pil_attribute12;
563: End If;
564: If (p_rec.pil_attribute13 = hr_api.g_varchar2) then
565: p_rec.pil_attribute13 :=
566: ben_pil_shd.g_old_rec.pil_attribute13;
567: End If;
568: If (p_rec.pil_attribute14 = hr_api.g_varchar2) then

Line 568: If (p_rec.pil_attribute14 = hr_api.g_varchar2) then

564: If (p_rec.pil_attribute13 = hr_api.g_varchar2) then
565: p_rec.pil_attribute13 :=
566: ben_pil_shd.g_old_rec.pil_attribute13;
567: End If;
568: If (p_rec.pil_attribute14 = hr_api.g_varchar2) then
569: p_rec.pil_attribute14 :=
570: ben_pil_shd.g_old_rec.pil_attribute14;
571: End If;
572: If (p_rec.pil_attribute15 = hr_api.g_varchar2) then

Line 572: If (p_rec.pil_attribute15 = hr_api.g_varchar2) then

568: If (p_rec.pil_attribute14 = hr_api.g_varchar2) then
569: p_rec.pil_attribute14 :=
570: ben_pil_shd.g_old_rec.pil_attribute14;
571: End If;
572: If (p_rec.pil_attribute15 = hr_api.g_varchar2) then
573: p_rec.pil_attribute15 :=
574: ben_pil_shd.g_old_rec.pil_attribute15;
575: End If;
576: If (p_rec.pil_attribute16 = hr_api.g_varchar2) then

Line 576: If (p_rec.pil_attribute16 = hr_api.g_varchar2) then

572: If (p_rec.pil_attribute15 = hr_api.g_varchar2) then
573: p_rec.pil_attribute15 :=
574: ben_pil_shd.g_old_rec.pil_attribute15;
575: End If;
576: If (p_rec.pil_attribute16 = hr_api.g_varchar2) then
577: p_rec.pil_attribute16 :=
578: ben_pil_shd.g_old_rec.pil_attribute16;
579: End If;
580: If (p_rec.pil_attribute17 = hr_api.g_varchar2) then

Line 580: If (p_rec.pil_attribute17 = hr_api.g_varchar2) then

576: If (p_rec.pil_attribute16 = hr_api.g_varchar2) then
577: p_rec.pil_attribute16 :=
578: ben_pil_shd.g_old_rec.pil_attribute16;
579: End If;
580: If (p_rec.pil_attribute17 = hr_api.g_varchar2) then
581: p_rec.pil_attribute17 :=
582: ben_pil_shd.g_old_rec.pil_attribute17;
583: End If;
584: If (p_rec.pil_attribute18 = hr_api.g_varchar2) then

Line 584: If (p_rec.pil_attribute18 = hr_api.g_varchar2) then

580: If (p_rec.pil_attribute17 = hr_api.g_varchar2) then
581: p_rec.pil_attribute17 :=
582: ben_pil_shd.g_old_rec.pil_attribute17;
583: End If;
584: If (p_rec.pil_attribute18 = hr_api.g_varchar2) then
585: p_rec.pil_attribute18 :=
586: ben_pil_shd.g_old_rec.pil_attribute18;
587: End If;
588: If (p_rec.pil_attribute19 = hr_api.g_varchar2) then

Line 588: If (p_rec.pil_attribute19 = hr_api.g_varchar2) then

584: If (p_rec.pil_attribute18 = hr_api.g_varchar2) then
585: p_rec.pil_attribute18 :=
586: ben_pil_shd.g_old_rec.pil_attribute18;
587: End If;
588: If (p_rec.pil_attribute19 = hr_api.g_varchar2) then
589: p_rec.pil_attribute19 :=
590: ben_pil_shd.g_old_rec.pil_attribute19;
591: End If;
592: If (p_rec.pil_attribute20 = hr_api.g_varchar2) then

Line 592: If (p_rec.pil_attribute20 = hr_api.g_varchar2) then

588: If (p_rec.pil_attribute19 = hr_api.g_varchar2) then
589: p_rec.pil_attribute19 :=
590: ben_pil_shd.g_old_rec.pil_attribute19;
591: End If;
592: If (p_rec.pil_attribute20 = hr_api.g_varchar2) then
593: p_rec.pil_attribute20 :=
594: ben_pil_shd.g_old_rec.pil_attribute20;
595: End If;
596: If (p_rec.pil_attribute21 = hr_api.g_varchar2) then

Line 596: If (p_rec.pil_attribute21 = hr_api.g_varchar2) then

592: If (p_rec.pil_attribute20 = hr_api.g_varchar2) then
593: p_rec.pil_attribute20 :=
594: ben_pil_shd.g_old_rec.pil_attribute20;
595: End If;
596: If (p_rec.pil_attribute21 = hr_api.g_varchar2) then
597: p_rec.pil_attribute21 :=
598: ben_pil_shd.g_old_rec.pil_attribute21;
599: End If;
600: If (p_rec.pil_attribute22 = hr_api.g_varchar2) then

Line 600: If (p_rec.pil_attribute22 = hr_api.g_varchar2) then

596: If (p_rec.pil_attribute21 = hr_api.g_varchar2) then
597: p_rec.pil_attribute21 :=
598: ben_pil_shd.g_old_rec.pil_attribute21;
599: End If;
600: If (p_rec.pil_attribute22 = hr_api.g_varchar2) then
601: p_rec.pil_attribute22 :=
602: ben_pil_shd.g_old_rec.pil_attribute22;
603: End If;
604: If (p_rec.pil_attribute23 = hr_api.g_varchar2) then

Line 604: If (p_rec.pil_attribute23 = hr_api.g_varchar2) then

600: If (p_rec.pil_attribute22 = hr_api.g_varchar2) then
601: p_rec.pil_attribute22 :=
602: ben_pil_shd.g_old_rec.pil_attribute22;
603: End If;
604: If (p_rec.pil_attribute23 = hr_api.g_varchar2) then
605: p_rec.pil_attribute23 :=
606: ben_pil_shd.g_old_rec.pil_attribute23;
607: End If;
608: If (p_rec.pil_attribute24 = hr_api.g_varchar2) then

Line 608: If (p_rec.pil_attribute24 = hr_api.g_varchar2) then

604: If (p_rec.pil_attribute23 = hr_api.g_varchar2) then
605: p_rec.pil_attribute23 :=
606: ben_pil_shd.g_old_rec.pil_attribute23;
607: End If;
608: If (p_rec.pil_attribute24 = hr_api.g_varchar2) then
609: p_rec.pil_attribute24 :=
610: ben_pil_shd.g_old_rec.pil_attribute24;
611: End If;
612: If (p_rec.pil_attribute25 = hr_api.g_varchar2) then

Line 612: If (p_rec.pil_attribute25 = hr_api.g_varchar2) then

608: If (p_rec.pil_attribute24 = hr_api.g_varchar2) then
609: p_rec.pil_attribute24 :=
610: ben_pil_shd.g_old_rec.pil_attribute24;
611: End If;
612: If (p_rec.pil_attribute25 = hr_api.g_varchar2) then
613: p_rec.pil_attribute25 :=
614: ben_pil_shd.g_old_rec.pil_attribute25;
615: End If;
616: If (p_rec.pil_attribute26 = hr_api.g_varchar2) then

Line 616: If (p_rec.pil_attribute26 = hr_api.g_varchar2) then

612: If (p_rec.pil_attribute25 = hr_api.g_varchar2) then
613: p_rec.pil_attribute25 :=
614: ben_pil_shd.g_old_rec.pil_attribute25;
615: End If;
616: If (p_rec.pil_attribute26 = hr_api.g_varchar2) then
617: p_rec.pil_attribute26 :=
618: ben_pil_shd.g_old_rec.pil_attribute26;
619: End If;
620: If (p_rec.pil_attribute27 = hr_api.g_varchar2) then

Line 620: If (p_rec.pil_attribute27 = hr_api.g_varchar2) then

616: If (p_rec.pil_attribute26 = hr_api.g_varchar2) then
617: p_rec.pil_attribute26 :=
618: ben_pil_shd.g_old_rec.pil_attribute26;
619: End If;
620: If (p_rec.pil_attribute27 = hr_api.g_varchar2) then
621: p_rec.pil_attribute27 :=
622: ben_pil_shd.g_old_rec.pil_attribute27;
623: End If;
624: If (p_rec.pil_attribute28 = hr_api.g_varchar2) then

Line 624: If (p_rec.pil_attribute28 = hr_api.g_varchar2) then

620: If (p_rec.pil_attribute27 = hr_api.g_varchar2) then
621: p_rec.pil_attribute27 :=
622: ben_pil_shd.g_old_rec.pil_attribute27;
623: End If;
624: If (p_rec.pil_attribute28 = hr_api.g_varchar2) then
625: p_rec.pil_attribute28 :=
626: ben_pil_shd.g_old_rec.pil_attribute28;
627: End If;
628: If (p_rec.pil_attribute29 = hr_api.g_varchar2) then

Line 628: If (p_rec.pil_attribute29 = hr_api.g_varchar2) then

624: If (p_rec.pil_attribute28 = hr_api.g_varchar2) then
625: p_rec.pil_attribute28 :=
626: ben_pil_shd.g_old_rec.pil_attribute28;
627: End If;
628: If (p_rec.pil_attribute29 = hr_api.g_varchar2) then
629: p_rec.pil_attribute29 :=
630: ben_pil_shd.g_old_rec.pil_attribute29;
631: End If;
632: If (p_rec.pil_attribute30 = hr_api.g_varchar2) then

Line 632: If (p_rec.pil_attribute30 = hr_api.g_varchar2) then

628: If (p_rec.pil_attribute29 = hr_api.g_varchar2) then
629: p_rec.pil_attribute29 :=
630: ben_pil_shd.g_old_rec.pil_attribute29;
631: End If;
632: If (p_rec.pil_attribute30 = hr_api.g_varchar2) then
633: p_rec.pil_attribute30 :=
634: ben_pil_shd.g_old_rec.pil_attribute30;
635: End If;
636: If (p_rec.request_id = hr_api.g_number) then

Line 636: If (p_rec.request_id = hr_api.g_number) then

632: If (p_rec.pil_attribute30 = hr_api.g_varchar2) then
633: p_rec.pil_attribute30 :=
634: ben_pil_shd.g_old_rec.pil_attribute30;
635: End If;
636: If (p_rec.request_id = hr_api.g_number) then
637: p_rec.request_id :=
638: ben_pil_shd.g_old_rec.request_id;
639: End If;
640: If (p_rec.program_application_id = hr_api.g_number) then

Line 640: If (p_rec.program_application_id = hr_api.g_number) then

636: If (p_rec.request_id = hr_api.g_number) then
637: p_rec.request_id :=
638: ben_pil_shd.g_old_rec.request_id;
639: End If;
640: If (p_rec.program_application_id = hr_api.g_number) then
641: p_rec.program_application_id :=
642: ben_pil_shd.g_old_rec.program_application_id;
643: End If;
644: If (p_rec.program_id = hr_api.g_number) then

Line 644: If (p_rec.program_id = hr_api.g_number) then

640: If (p_rec.program_application_id = hr_api.g_number) then
641: p_rec.program_application_id :=
642: ben_pil_shd.g_old_rec.program_application_id;
643: End If;
644: If (p_rec.program_id = hr_api.g_number) then
645: p_rec.program_id :=
646: ben_pil_shd.g_old_rec.program_id;
647: End If;
648: If (p_rec.program_update_date = hr_api.g_date) then

Line 648: If (p_rec.program_update_date = hr_api.g_date) then

644: If (p_rec.program_id = hr_api.g_number) then
645: p_rec.program_id :=
646: ben_pil_shd.g_old_rec.program_id;
647: End If;
648: If (p_rec.program_update_date = hr_api.g_date) then
649: p_rec.program_update_date :=
650: ben_pil_shd.g_old_rec.program_update_date;
651: End If;
652:

Line 725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,

721: Procedure upd
722: (
723: p_effective_date in date,
724: p_per_in_ler_id in number,
725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,
726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,

Line 726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,

722: (
723: p_effective_date in date,
724: p_per_in_ler_id in number,
725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,
726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,

Line 727: p_lf_evt_ocrd_dt in date default hr_api.g_date,

723: p_effective_date in date,
724: p_per_in_ler_id in number,
725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,
726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,

Line 728: p_trgr_table_pk_id in number default hr_api.g_number,

724: p_per_in_ler_id in number,
725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,
726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,

Line 729: p_procd_dt in date default hr_api.g_date,

725: p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2,
726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,

Line 730: p_strtd_dt in date default hr_api.g_date,

726: p_prvs_stat_cd in varchar2 default hr_api.g_varchar2,
727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,

Line 731: p_voidd_dt in date default hr_api.g_date,

727: p_lf_evt_ocrd_dt in date default hr_api.g_date,
728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,

Line 732: p_bckt_dt in date default hr_api.g_date,

728: p_trgr_table_pk_id in number default hr_api.g_number,
729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,

Line 733: p_clsd_dt in date default hr_api.g_date,

729: p_procd_dt in date default hr_api.g_date,
730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,

Line 734: p_ntfn_dt in date default hr_api.g_date,

730: p_strtd_dt in date default hr_api.g_date,
731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,

Line 735: p_ptnl_ler_for_per_id in number default hr_api.g_number,

731: p_voidd_dt in date default hr_api.g_date,
732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,

Line 736: p_bckt_per_in_ler_id in number default hr_api.g_number,

732: p_bckt_dt in date default hr_api.g_date,
733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,

Line 737: p_ler_id in number default hr_api.g_number,

733: p_clsd_dt in date default hr_api.g_date,
734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,

Line 738: p_person_id in number default hr_api.g_number,

734: p_ntfn_dt in date default hr_api.g_date,
735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,

Line 739: p_business_group_id in number default hr_api.g_number,

735: p_ptnl_ler_for_per_id in number default hr_api.g_number,
736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,

Line 740: p_ASSIGNMENT_ID in number default hr_api.g_number,

736: p_bckt_per_in_ler_id in number default hr_api.g_number,
737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,

Line 741: p_WS_MGR_ID in number default hr_api.g_number,

737: p_ler_id in number default hr_api.g_number,
738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,

Line 742: p_GROUP_PL_ID in number default hr_api.g_number,

738: p_person_id in number default hr_api.g_number,
739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,

Line 743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,

739: p_business_group_id in number default hr_api.g_number,
740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,

Line 744: p_MGR_OVRID_DT in date default hr_api.g_date,

740: p_ASSIGNMENT_ID in number default hr_api.g_number,
741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,

Line 745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,

741: p_WS_MGR_ID in number default hr_api.g_number,
742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,

Line 746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,

742: p_GROUP_PL_ID in number default hr_api.g_number,
743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,

Line 747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,

743: p_MGR_OVRID_PERSON_ID in number default hr_api.g_number,
744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,

Line 748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,

744: p_MGR_OVRID_DT in date default hr_api.g_date,
745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,

Line 749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,

745: p_pil_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,

Line 750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,

746: p_pil_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,

Line 751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,

747: p_pil_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,

Line 752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,

748: p_pil_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,

Line 753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,

749: p_pil_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,

Line 754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,

750: p_pil_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,

Line 755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,

751: p_pil_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,

Line 756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,

752: p_pil_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,

Line 757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,

753: p_pil_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,

Line 758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,

754: p_pil_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,

Line 759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,

755: p_pil_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,

Line 760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,

756: p_pil_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,

Line 761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,

757: p_pil_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,

Line 762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,

758: p_pil_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,

Line 763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,

759: p_pil_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,

Line 764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,

760: p_pil_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,

Line 765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,

761: p_pil_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,

Line 766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,

762: p_pil_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,

Line 767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,

763: p_pil_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,

Line 768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,

764: p_pil_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,

Line 769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,

765: p_pil_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,

Line 770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,

766: p_pil_attribute21 in varchar2 default hr_api.g_varchar2,
767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,

Line 771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,

767: p_pil_attribute22 in varchar2 default hr_api.g_varchar2,
768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,

Line 772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,

768: p_pil_attribute23 in varchar2 default hr_api.g_varchar2,
769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,

Line 773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,

769: p_pil_attribute24 in varchar2 default hr_api.g_varchar2,
770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,

Line 774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,

770: p_pil_attribute25 in varchar2 default hr_api.g_varchar2,
771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,

Line 775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,

771: p_pil_attribute26 in varchar2 default hr_api.g_varchar2,
772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,
779: p_program_update_date in date default hr_api.g_date,

Line 776: p_request_id in number default hr_api.g_number,

772: p_pil_attribute27 in varchar2 default hr_api.g_varchar2,
773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,
779: p_program_update_date in date default hr_api.g_date,
780: p_object_version_number in out nocopy number

Line 777: p_program_application_id in number default hr_api.g_number,

773: p_pil_attribute28 in varchar2 default hr_api.g_varchar2,
774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,
779: p_program_update_date in date default hr_api.g_date,
780: p_object_version_number in out nocopy number
781: ) is

Line 778: p_program_id in number default hr_api.g_number,

774: p_pil_attribute29 in varchar2 default hr_api.g_varchar2,
775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,
779: p_program_update_date in date default hr_api.g_date,
780: p_object_version_number in out nocopy number
781: ) is
782: --

Line 779: p_program_update_date in date default hr_api.g_date,

775: p_pil_attribute30 in varchar2 default hr_api.g_varchar2,
776: p_request_id in number default hr_api.g_number,
777: p_program_application_id in number default hr_api.g_number,
778: p_program_id in number default hr_api.g_number,
779: p_program_update_date in date default hr_api.g_date,
780: p_object_version_number in out nocopy number
781: ) is
782: --
783: l_rec ben_pil_shd.g_rec_type;