APPS.BEN_CRT_UPD dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated Then

131: -- A check constraint has been violated
132: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
133: ben_crt_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_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.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated Then

136: -- Parent integrity has been violated
137: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
138: ben_crt_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_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.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
143: ben_crt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;

Line 373: when hr_api.cannot_find_prog_unit then

369: p_effective_date => p_effective_date );
370: End if ;
371: exception
372: --
373: when hr_api.cannot_find_prog_unit then
374: --
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'ben_crt_ordr'
377: ,p_hook_type => 'AU');

Line 375: hr_api.cannot_find_prog_unit_error

371: exception
372: --
373: when hr_api.cannot_find_prog_unit then
374: --
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'ben_crt_ordr'
377: ,p_hook_type => 'AU');
378: --
379: end;

Line 443: If (p_rec.crt_ordr_typ_cd = hr_api.g_varchar2) then

439: -- p_rec plsql record structure
440: -- to see if a system default is being used. If a system default
441: -- is being used then we must set to the 'current' argument value.
442: --
443: If (p_rec.crt_ordr_typ_cd = hr_api.g_varchar2) then
444: p_rec.crt_ordr_typ_cd :=
445: ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
446: End If;
447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then

Line 447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then

443: If (p_rec.crt_ordr_typ_cd = hr_api.g_varchar2) then
444: p_rec.crt_ordr_typ_cd :=
445: ben_crt_shd.g_old_rec.crt_ordr_typ_cd;
446: End If;
447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then
448: p_rec.apls_perd_endg_dt :=
449: ben_crt_shd.g_old_rec.apls_perd_endg_dt;
450: End If;
451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then

Line 451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then

447: If (p_rec.apls_perd_endg_dt = hr_api.g_date) then
448: p_rec.apls_perd_endg_dt :=
449: ben_crt_shd.g_old_rec.apls_perd_endg_dt;
450: End If;
451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then
452: p_rec.apls_perd_strtg_dt :=
453: ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
454: End If;
455: If (p_rec.crt_ident = hr_api.g_varchar2) then

Line 455: If (p_rec.crt_ident = hr_api.g_varchar2) then

451: If (p_rec.apls_perd_strtg_dt = hr_api.g_date) then
452: p_rec.apls_perd_strtg_dt :=
453: ben_crt_shd.g_old_rec.apls_perd_strtg_dt;
454: End If;
455: If (p_rec.crt_ident = hr_api.g_varchar2) then
456: p_rec.crt_ident :=
457: ben_crt_shd.g_old_rec.crt_ident;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then

Line 459: If (p_rec.description = hr_api.g_varchar2) then

455: If (p_rec.crt_ident = hr_api.g_varchar2) then
456: p_rec.crt_ident :=
457: ben_crt_shd.g_old_rec.crt_ident;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: ben_crt_shd.g_old_rec.description;
462: End If;
463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then

Line 463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then

459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: ben_crt_shd.g_old_rec.description;
462: End If;
463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then
464: p_rec.detd_qlfd_ordr_dt :=
465: ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt;
466: End If;
467: If (p_rec.issue_dt = hr_api.g_date) then

Line 467: If (p_rec.issue_dt = hr_api.g_date) then

463: If (p_rec.detd_qlfd_ordr_dt = hr_api.g_date) then
464: p_rec.detd_qlfd_ordr_dt :=
465: ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt;
466: End If;
467: If (p_rec.issue_dt = hr_api.g_date) then
468: p_rec.issue_dt :=
469: ben_crt_shd.g_old_rec.issue_dt;
470: End If;
471: If (p_rec.qdro_amt = hr_api.g_number) then

Line 471: If (p_rec.qdro_amt = hr_api.g_number) then

467: If (p_rec.issue_dt = hr_api.g_date) then
468: p_rec.issue_dt :=
469: ben_crt_shd.g_old_rec.issue_dt;
470: End If;
471: If (p_rec.qdro_amt = hr_api.g_number) then
472: p_rec.qdro_amt :=
473: ben_crt_shd.g_old_rec.qdro_amt;
474: End If;
475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then

Line 475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then

471: If (p_rec.qdro_amt = hr_api.g_number) then
472: p_rec.qdro_amt :=
473: ben_crt_shd.g_old_rec.qdro_amt;
474: End If;
475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then
476: p_rec.qdro_dstr_mthd_cd :=
477: ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd;
478: End If;
479: If (p_rec.qdro_pct = hr_api.g_number) then

Line 479: If (p_rec.qdro_pct = hr_api.g_number) then

475: If (p_rec.qdro_dstr_mthd_cd = hr_api.g_varchar2) then
476: p_rec.qdro_dstr_mthd_cd :=
477: ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd;
478: End If;
479: If (p_rec.qdro_pct = hr_api.g_number) then
480: p_rec.qdro_pct :=
481: ben_crt_shd.g_old_rec.qdro_pct;
482: End If;
483: If (p_rec.rcvd_dt = hr_api.g_date) then

Line 483: If (p_rec.rcvd_dt = hr_api.g_date) then

479: If (p_rec.qdro_pct = hr_api.g_number) then
480: p_rec.qdro_pct :=
481: ben_crt_shd.g_old_rec.qdro_pct;
482: End If;
483: If (p_rec.rcvd_dt = hr_api.g_date) then
484: p_rec.rcvd_dt :=
485: ben_crt_shd.g_old_rec.rcvd_dt;
486: End If;
487: If (p_rec.uom = hr_api.g_varchar2) then

Line 487: If (p_rec.uom = hr_api.g_varchar2) then

483: If (p_rec.rcvd_dt = hr_api.g_date) then
484: p_rec.rcvd_dt :=
485: ben_crt_shd.g_old_rec.rcvd_dt;
486: End If;
487: If (p_rec.uom = hr_api.g_varchar2) then
488: p_rec.uom :=
489: ben_crt_shd.g_old_rec.uom;
490: End If;
491: If (p_rec.crt_issng = hr_api.g_varchar2) then

Line 491: If (p_rec.crt_issng = hr_api.g_varchar2) then

487: If (p_rec.uom = hr_api.g_varchar2) then
488: p_rec.uom :=
489: ben_crt_shd.g_old_rec.uom;
490: End If;
491: If (p_rec.crt_issng = hr_api.g_varchar2) then
492: p_rec.crt_issng :=
493: ben_crt_shd.g_old_rec.crt_issng;
494: End If;
495: If (p_rec.pl_id = hr_api.g_number) then

Line 495: If (p_rec.pl_id = hr_api.g_number) then

491: If (p_rec.crt_issng = hr_api.g_varchar2) then
492: p_rec.crt_issng :=
493: ben_crt_shd.g_old_rec.crt_issng;
494: End If;
495: If (p_rec.pl_id = hr_api.g_number) then
496: p_rec.pl_id :=
497: ben_crt_shd.g_old_rec.pl_id;
498: End If;
499: If (p_rec.person_id = hr_api.g_number) then

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

495: If (p_rec.pl_id = hr_api.g_number) then
496: p_rec.pl_id :=
497: ben_crt_shd.g_old_rec.pl_id;
498: End If;
499: If (p_rec.person_id = hr_api.g_number) then
500: p_rec.person_id :=
501: ben_crt_shd.g_old_rec.person_id;
502: End If;
503: If (p_rec.business_group_id = hr_api.g_number) then

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

499: If (p_rec.person_id = hr_api.g_number) then
500: p_rec.person_id :=
501: ben_crt_shd.g_old_rec.person_id;
502: End If;
503: If (p_rec.business_group_id = hr_api.g_number) then
504: p_rec.business_group_id :=
505: ben_crt_shd.g_old_rec.business_group_id;
506: End If;
507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then

Line 507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then

503: If (p_rec.business_group_id = hr_api.g_number) then
504: p_rec.business_group_id :=
505: ben_crt_shd.g_old_rec.business_group_id;
506: End If;
507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then
508: p_rec.crt_attribute_category :=
509: ben_crt_shd.g_old_rec.crt_attribute_category;
510: End If;
511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then

Line 511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then

507: If (p_rec.crt_attribute_category = hr_api.g_varchar2) then
508: p_rec.crt_attribute_category :=
509: ben_crt_shd.g_old_rec.crt_attribute_category;
510: End If;
511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then
512: p_rec.crt_attribute1 :=
513: ben_crt_shd.g_old_rec.crt_attribute1;
514: End If;
515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then

Line 515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then

511: If (p_rec.crt_attribute1 = hr_api.g_varchar2) then
512: p_rec.crt_attribute1 :=
513: ben_crt_shd.g_old_rec.crt_attribute1;
514: End If;
515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then
516: p_rec.crt_attribute2 :=
517: ben_crt_shd.g_old_rec.crt_attribute2;
518: End If;
519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then

Line 519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then

515: If (p_rec.crt_attribute2 = hr_api.g_varchar2) then
516: p_rec.crt_attribute2 :=
517: ben_crt_shd.g_old_rec.crt_attribute2;
518: End If;
519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then
520: p_rec.crt_attribute3 :=
521: ben_crt_shd.g_old_rec.crt_attribute3;
522: End If;
523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then

Line 523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then

519: If (p_rec.crt_attribute3 = hr_api.g_varchar2) then
520: p_rec.crt_attribute3 :=
521: ben_crt_shd.g_old_rec.crt_attribute3;
522: End If;
523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then
524: p_rec.crt_attribute4 :=
525: ben_crt_shd.g_old_rec.crt_attribute4;
526: End If;
527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then

Line 527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then

523: If (p_rec.crt_attribute4 = hr_api.g_varchar2) then
524: p_rec.crt_attribute4 :=
525: ben_crt_shd.g_old_rec.crt_attribute4;
526: End If;
527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then
528: p_rec.crt_attribute5 :=
529: ben_crt_shd.g_old_rec.crt_attribute5;
530: End If;
531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then

Line 531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then

527: If (p_rec.crt_attribute5 = hr_api.g_varchar2) then
528: p_rec.crt_attribute5 :=
529: ben_crt_shd.g_old_rec.crt_attribute5;
530: End If;
531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then
532: p_rec.crt_attribute6 :=
533: ben_crt_shd.g_old_rec.crt_attribute6;
534: End If;
535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then

Line 535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then

531: If (p_rec.crt_attribute6 = hr_api.g_varchar2) then
532: p_rec.crt_attribute6 :=
533: ben_crt_shd.g_old_rec.crt_attribute6;
534: End If;
535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then
536: p_rec.crt_attribute7 :=
537: ben_crt_shd.g_old_rec.crt_attribute7;
538: End If;
539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then

Line 539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then

535: If (p_rec.crt_attribute7 = hr_api.g_varchar2) then
536: p_rec.crt_attribute7 :=
537: ben_crt_shd.g_old_rec.crt_attribute7;
538: End If;
539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then
540: p_rec.crt_attribute8 :=
541: ben_crt_shd.g_old_rec.crt_attribute8;
542: End If;
543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then

Line 543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then

539: If (p_rec.crt_attribute8 = hr_api.g_varchar2) then
540: p_rec.crt_attribute8 :=
541: ben_crt_shd.g_old_rec.crt_attribute8;
542: End If;
543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then
544: p_rec.crt_attribute9 :=
545: ben_crt_shd.g_old_rec.crt_attribute9;
546: End If;
547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then

Line 547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then

543: If (p_rec.crt_attribute9 = hr_api.g_varchar2) then
544: p_rec.crt_attribute9 :=
545: ben_crt_shd.g_old_rec.crt_attribute9;
546: End If;
547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then
548: p_rec.crt_attribute10 :=
549: ben_crt_shd.g_old_rec.crt_attribute10;
550: End If;
551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then

Line 551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then

547: If (p_rec.crt_attribute10 = hr_api.g_varchar2) then
548: p_rec.crt_attribute10 :=
549: ben_crt_shd.g_old_rec.crt_attribute10;
550: End If;
551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then
552: p_rec.crt_attribute11 :=
553: ben_crt_shd.g_old_rec.crt_attribute11;
554: End If;
555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then

Line 555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then

551: If (p_rec.crt_attribute11 = hr_api.g_varchar2) then
552: p_rec.crt_attribute11 :=
553: ben_crt_shd.g_old_rec.crt_attribute11;
554: End If;
555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then
556: p_rec.crt_attribute12 :=
557: ben_crt_shd.g_old_rec.crt_attribute12;
558: End If;
559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then

Line 559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then

555: If (p_rec.crt_attribute12 = hr_api.g_varchar2) then
556: p_rec.crt_attribute12 :=
557: ben_crt_shd.g_old_rec.crt_attribute12;
558: End If;
559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then
560: p_rec.crt_attribute13 :=
561: ben_crt_shd.g_old_rec.crt_attribute13;
562: End If;
563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then

Line 563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then

559: If (p_rec.crt_attribute13 = hr_api.g_varchar2) then
560: p_rec.crt_attribute13 :=
561: ben_crt_shd.g_old_rec.crt_attribute13;
562: End If;
563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then
564: p_rec.crt_attribute14 :=
565: ben_crt_shd.g_old_rec.crt_attribute14;
566: End If;
567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then

Line 567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then

563: If (p_rec.crt_attribute14 = hr_api.g_varchar2) then
564: p_rec.crt_attribute14 :=
565: ben_crt_shd.g_old_rec.crt_attribute14;
566: End If;
567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then
568: p_rec.crt_attribute15 :=
569: ben_crt_shd.g_old_rec.crt_attribute15;
570: End If;
571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then

Line 571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then

567: If (p_rec.crt_attribute15 = hr_api.g_varchar2) then
568: p_rec.crt_attribute15 :=
569: ben_crt_shd.g_old_rec.crt_attribute15;
570: End If;
571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then
572: p_rec.crt_attribute16 :=
573: ben_crt_shd.g_old_rec.crt_attribute16;
574: End If;
575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then

Line 575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then

571: If (p_rec.crt_attribute16 = hr_api.g_varchar2) then
572: p_rec.crt_attribute16 :=
573: ben_crt_shd.g_old_rec.crt_attribute16;
574: End If;
575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then
576: p_rec.crt_attribute17 :=
577: ben_crt_shd.g_old_rec.crt_attribute17;
578: End If;
579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then

Line 579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then

575: If (p_rec.crt_attribute17 = hr_api.g_varchar2) then
576: p_rec.crt_attribute17 :=
577: ben_crt_shd.g_old_rec.crt_attribute17;
578: End If;
579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then
580: p_rec.crt_attribute18 :=
581: ben_crt_shd.g_old_rec.crt_attribute18;
582: End If;
583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then

Line 583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then

579: If (p_rec.crt_attribute18 = hr_api.g_varchar2) then
580: p_rec.crt_attribute18 :=
581: ben_crt_shd.g_old_rec.crt_attribute18;
582: End If;
583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then
584: p_rec.crt_attribute19 :=
585: ben_crt_shd.g_old_rec.crt_attribute19;
586: End If;
587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then

Line 587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then

583: If (p_rec.crt_attribute19 = hr_api.g_varchar2) then
584: p_rec.crt_attribute19 :=
585: ben_crt_shd.g_old_rec.crt_attribute19;
586: End If;
587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then
588: p_rec.crt_attribute20 :=
589: ben_crt_shd.g_old_rec.crt_attribute20;
590: End If;
591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then

Line 591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then

587: If (p_rec.crt_attribute20 = hr_api.g_varchar2) then
588: p_rec.crt_attribute20 :=
589: ben_crt_shd.g_old_rec.crt_attribute20;
590: End If;
591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then
592: p_rec.crt_attribute21 :=
593: ben_crt_shd.g_old_rec.crt_attribute21;
594: End If;
595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then

Line 595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then

591: If (p_rec.crt_attribute21 = hr_api.g_varchar2) then
592: p_rec.crt_attribute21 :=
593: ben_crt_shd.g_old_rec.crt_attribute21;
594: End If;
595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then
596: p_rec.crt_attribute22 :=
597: ben_crt_shd.g_old_rec.crt_attribute22;
598: End If;
599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then

Line 599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then

595: If (p_rec.crt_attribute22 = hr_api.g_varchar2) then
596: p_rec.crt_attribute22 :=
597: ben_crt_shd.g_old_rec.crt_attribute22;
598: End If;
599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then
600: p_rec.crt_attribute23 :=
601: ben_crt_shd.g_old_rec.crt_attribute23;
602: End If;
603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then

Line 603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then

599: If (p_rec.crt_attribute23 = hr_api.g_varchar2) then
600: p_rec.crt_attribute23 :=
601: ben_crt_shd.g_old_rec.crt_attribute23;
602: End If;
603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then
604: p_rec.crt_attribute24 :=
605: ben_crt_shd.g_old_rec.crt_attribute24;
606: End If;
607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then

Line 607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then

603: If (p_rec.crt_attribute24 = hr_api.g_varchar2) then
604: p_rec.crt_attribute24 :=
605: ben_crt_shd.g_old_rec.crt_attribute24;
606: End If;
607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then
608: p_rec.crt_attribute25 :=
609: ben_crt_shd.g_old_rec.crt_attribute25;
610: End If;
611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then

Line 611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then

607: If (p_rec.crt_attribute25 = hr_api.g_varchar2) then
608: p_rec.crt_attribute25 :=
609: ben_crt_shd.g_old_rec.crt_attribute25;
610: End If;
611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then
612: p_rec.crt_attribute26 :=
613: ben_crt_shd.g_old_rec.crt_attribute26;
614: End If;
615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then

Line 615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then

611: If (p_rec.crt_attribute26 = hr_api.g_varchar2) then
612: p_rec.crt_attribute26 :=
613: ben_crt_shd.g_old_rec.crt_attribute26;
614: End If;
615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then
616: p_rec.crt_attribute27 :=
617: ben_crt_shd.g_old_rec.crt_attribute27;
618: End If;
619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then

Line 619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then

615: If (p_rec.crt_attribute27 = hr_api.g_varchar2) then
616: p_rec.crt_attribute27 :=
617: ben_crt_shd.g_old_rec.crt_attribute27;
618: End If;
619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then
620: p_rec.crt_attribute28 :=
621: ben_crt_shd.g_old_rec.crt_attribute28;
622: End If;
623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then

Line 623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then

619: If (p_rec.crt_attribute28 = hr_api.g_varchar2) then
620: p_rec.crt_attribute28 :=
621: ben_crt_shd.g_old_rec.crt_attribute28;
622: End If;
623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then
624: p_rec.crt_attribute29 :=
625: ben_crt_shd.g_old_rec.crt_attribute29;
626: End If;
627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then

Line 627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then

623: If (p_rec.crt_attribute29 = hr_api.g_varchar2) then
624: p_rec.crt_attribute29 :=
625: ben_crt_shd.g_old_rec.crt_attribute29;
626: End If;
627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then
628: p_rec.crt_attribute30 :=
629: ben_crt_shd.g_old_rec.crt_attribute30;
630: End If;
631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then

Line 631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then

627: If (p_rec.crt_attribute30 = hr_api.g_varchar2) then
628: p_rec.crt_attribute30 :=
629: ben_crt_shd.g_old_rec.crt_attribute30;
630: End If;
631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then
632: p_rec.qdro_num_pymt_val :=
633: ben_crt_shd.g_old_rec.qdro_num_pymt_val;
634: End If;
635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then

Line 635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then

631: If (p_rec.qdro_num_pymt_val = hr_api.g_number) then
632: p_rec.qdro_num_pymt_val :=
633: ben_crt_shd.g_old_rec.qdro_num_pymt_val;
634: End If;
635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then
636: p_rec.qdro_per_perd_cd :=
637: ben_crt_shd.g_old_rec.qdro_per_perd_cd;
638: End If;
639: If (p_rec.pl_typ_id = hr_api.g_number) then

Line 639: If (p_rec.pl_typ_id = hr_api.g_number) then

635: If (p_rec.qdro_per_perd_cd = hr_api.g_varchar2) then
636: p_rec.qdro_per_perd_cd :=
637: ben_crt_shd.g_old_rec.qdro_per_perd_cd;
638: End If;
639: If (p_rec.pl_typ_id = hr_api.g_number) then
640: p_rec.pl_typ_id :=
641: ben_crt_shd.g_old_rec.pl_typ_id;
642: End If;
643: --

Line 704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,

700: Procedure upd
701: (
702: p_effective_date in date,
703: p_crt_ordr_id in number,
704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,
705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,

Line 705: p_apls_perd_endg_dt in date default hr_api.g_date,

701: (
702: p_effective_date in date,
703: p_crt_ordr_id in number,
704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,
705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,

Line 706: p_apls_perd_strtg_dt in date default hr_api.g_date,

702: p_effective_date in date,
703: p_crt_ordr_id in number,
704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,
705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,

Line 707: p_crt_ident in varchar2 default hr_api.g_varchar2,

703: p_crt_ordr_id in number,
704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,
705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,

Line 708: p_description in varchar2 default hr_api.g_varchar2,

704: p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2,
705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,

Line 709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,

705: p_apls_perd_endg_dt in date default hr_api.g_date,
706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,

Line 710: p_issue_dt in date default hr_api.g_date,

706: p_apls_perd_strtg_dt in date default hr_api.g_date,
707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,

Line 711: p_qdro_amt in number default hr_api.g_number,

707: p_crt_ident in varchar2 default hr_api.g_varchar2,
708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,

Line 712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,

708: p_description in varchar2 default hr_api.g_varchar2,
709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,

Line 713: p_qdro_pct in number default hr_api.g_number,

709: p_detd_qlfd_ordr_dt in date default hr_api.g_date,
710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,

Line 714: p_rcvd_dt in date default hr_api.g_date,

710: p_issue_dt in date default hr_api.g_date,
711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,

Line 715: p_uom in varchar2 default hr_api.g_varchar2,

711: p_qdro_amt in number default hr_api.g_number,
712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,

Line 716: p_crt_issng in varchar2 default hr_api.g_varchar2,

712: p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2,
713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,

Line 717: p_pl_id in number default hr_api.g_number,

713: p_qdro_pct in number default hr_api.g_number,
714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,

Line 718: p_person_id in number default hr_api.g_number,

714: p_rcvd_dt in date default hr_api.g_date,
715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,

Line 719: p_business_group_id in number default hr_api.g_number,

715: p_uom in varchar2 default hr_api.g_varchar2,
716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,

Line 720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,

716: p_crt_issng in varchar2 default hr_api.g_varchar2,
717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,

Line 721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,

717: p_pl_id in number default hr_api.g_number,
718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,

Line 722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,

718: p_person_id in number default hr_api.g_number,
719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,

Line 723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,

719: p_business_group_id in number default hr_api.g_number,
720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,

Line 724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,

720: p_crt_attribute_category in varchar2 default hr_api.g_varchar2,
721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,

Line 725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,

721: p_crt_attribute1 in varchar2 default hr_api.g_varchar2,
722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,

Line 726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,

722: p_crt_attribute2 in varchar2 default hr_api.g_varchar2,
723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,

Line 727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,

723: p_crt_attribute3 in varchar2 default hr_api.g_varchar2,
724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,

Line 728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,

724: p_crt_attribute4 in varchar2 default hr_api.g_varchar2,
725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,

Line 729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,

725: p_crt_attribute5 in varchar2 default hr_api.g_varchar2,
726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,

Line 730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,

726: p_crt_attribute6 in varchar2 default hr_api.g_varchar2,
727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,

Line 731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,

727: p_crt_attribute7 in varchar2 default hr_api.g_varchar2,
728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,

Line 732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,

728: p_crt_attribute8 in varchar2 default hr_api.g_varchar2,
729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,

Line 733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,

729: p_crt_attribute9 in varchar2 default hr_api.g_varchar2,
730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,

Line 734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,

730: p_crt_attribute10 in varchar2 default hr_api.g_varchar2,
731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,

Line 735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,

731: p_crt_attribute11 in varchar2 default hr_api.g_varchar2,
732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,

Line 736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,

732: p_crt_attribute12 in varchar2 default hr_api.g_varchar2,
733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,

Line 737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,

733: p_crt_attribute13 in varchar2 default hr_api.g_varchar2,
734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,

Line 738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,

734: p_crt_attribute14 in varchar2 default hr_api.g_varchar2,
735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,

Line 739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,

735: p_crt_attribute15 in varchar2 default hr_api.g_varchar2,
736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,

Line 740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,

736: p_crt_attribute16 in varchar2 default hr_api.g_varchar2,
737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,

Line 741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,

737: p_crt_attribute17 in varchar2 default hr_api.g_varchar2,
738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,

Line 742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,

738: p_crt_attribute18 in varchar2 default hr_api.g_varchar2,
739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,

Line 743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,

739: p_crt_attribute19 in varchar2 default hr_api.g_varchar2,
740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,

Line 744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,

740: p_crt_attribute20 in varchar2 default hr_api.g_varchar2,
741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,

Line 745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,

741: p_crt_attribute21 in varchar2 default hr_api.g_varchar2,
742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,

Line 746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,

742: p_crt_attribute22 in varchar2 default hr_api.g_varchar2,
743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,

Line 747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,

743: p_crt_attribute23 in varchar2 default hr_api.g_varchar2,
744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,

Line 748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,

744: p_crt_attribute24 in varchar2 default hr_api.g_varchar2,
745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,

Line 749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,

745: p_crt_attribute25 in varchar2 default hr_api.g_varchar2,
746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,

Line 750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,

746: p_crt_attribute26 in varchar2 default hr_api.g_varchar2,
747: p_crt_attribute27 in varchar2 default hr_api.g_varchar2,
748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,
754: p_pl_typ_id in number default hr_api.g_number

Line 752: p_qdro_num_pymt_val in number default hr_api.g_number,

748: p_crt_attribute28 in varchar2 default hr_api.g_varchar2,
749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,
754: p_pl_typ_id in number default hr_api.g_number
755: ) is
756: --

Line 753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,

749: p_crt_attribute29 in varchar2 default hr_api.g_varchar2,
750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,
754: p_pl_typ_id in number default hr_api.g_number
755: ) is
756: --
757: l_rec ben_crt_shd.g_rec_type;

Line 754: p_pl_typ_id in number default hr_api.g_number

750: p_crt_attribute30 in varchar2 default hr_api.g_varchar2,
751: p_object_version_number in out nocopy number,
752: p_qdro_num_pymt_val in number default hr_api.g_number,
753: p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2,
754: p_pl_typ_id in number default hr_api.g_number
755: ) is
756: --
757: l_rec ben_crt_shd.g_rec_type;
758: l_proc varchar2(72) := g_package||'upd';