APPS.PER_CAG_UPD dependencies on HR_API

Line 136: When hr_api.check_integrity_violated Then

132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_cag_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then

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

135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_cag_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: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 140: When hr_api.parent_integrity_violated Then

136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: per_cag_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: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then

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

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: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_cag_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: When hr_api.unique_integrity_violated Then

140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: per_cag_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_cag_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then

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

143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: per_cag_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: Raise;
150: End update_dml;
151: --

Line 359: when hr_api.cannot_find_prog_unit then

355: );
356: --
357: exception
358: --
359: when hr_api.cannot_find_prog_unit then
360: --
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'per_collective_agreements'
363: ,p_hook_type => 'AU');

Line 361: hr_api.cannot_find_prog_unit_error

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

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

426: -- p_rec plsql record structure
427: -- to see if a system default is being used. If a system default
428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_cag_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.name = hr_api.g_varchar2) then

Line 434: If (p_rec.name = hr_api.g_varchar2) then

430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_cag_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.name = hr_api.g_varchar2) then
435: p_rec.name :=
436: per_cag_shd.g_old_rec.name;
437: End If;
438: If (p_rec.status = hr_api.g_varchar2) then

Line 438: If (p_rec.status = hr_api.g_varchar2) then

434: If (p_rec.name = hr_api.g_varchar2) then
435: p_rec.name :=
436: per_cag_shd.g_old_rec.name;
437: End If;
438: If (p_rec.status = hr_api.g_varchar2) then
439: p_rec.status :=
440: per_cag_shd.g_old_rec.status;
441: End If;
442:

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

440: per_cag_shd.g_old_rec.status;
441: End If;
442:
443:
444: If (p_rec.cag_number = hr_api.g_number) then
445: p_rec.cag_number :=
446: per_cag_shd.g_old_rec.cag_number;
447: End If;
448: If (p_rec.description = hr_api.g_varchar2) then

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

444: If (p_rec.cag_number = hr_api.g_number) then
445: p_rec.cag_number :=
446: per_cag_shd.g_old_rec.cag_number;
447: End If;
448: If (p_rec.description = hr_api.g_varchar2) then
449: p_rec.description :=
450: per_cag_shd.g_old_rec.description;
451: End If;
452: If (p_rec.start_date = hr_api.g_date) then

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

448: If (p_rec.description = hr_api.g_varchar2) then
449: p_rec.description :=
450: per_cag_shd.g_old_rec.description;
451: End If;
452: If (p_rec.start_date = hr_api.g_date) then
453: p_rec.start_date :=
454: per_cag_shd.g_old_rec.start_date;
455: End If;
456: If (p_rec.end_date = hr_api.g_date) then

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

452: If (p_rec.start_date = hr_api.g_date) then
453: p_rec.start_date :=
454: per_cag_shd.g_old_rec.start_date;
455: End If;
456: If (p_rec.end_date = hr_api.g_date) then
457: p_rec.end_date :=
458: per_cag_shd.g_old_rec.end_date;
459: End If;
460: If (p_rec.employer_organization_id = hr_api.g_number) then

Line 460: If (p_rec.employer_organization_id = hr_api.g_number) then

456: If (p_rec.end_date = hr_api.g_date) then
457: p_rec.end_date :=
458: per_cag_shd.g_old_rec.end_date;
459: End If;
460: If (p_rec.employer_organization_id = hr_api.g_number) then
461: p_rec.employer_organization_id :=
462: per_cag_shd.g_old_rec.employer_organization_id;
463: End If;
464: If (p_rec.employer_signatory = hr_api.g_varchar2) then

Line 464: If (p_rec.employer_signatory = hr_api.g_varchar2) then

460: If (p_rec.employer_organization_id = hr_api.g_number) then
461: p_rec.employer_organization_id :=
462: per_cag_shd.g_old_rec.employer_organization_id;
463: End If;
464: If (p_rec.employer_signatory = hr_api.g_varchar2) then
465: p_rec.employer_signatory :=
466: per_cag_shd.g_old_rec.employer_signatory;
467: End If;
468: If (p_rec.bargaining_organization_id = hr_api.g_number) then

Line 468: If (p_rec.bargaining_organization_id = hr_api.g_number) then

464: If (p_rec.employer_signatory = hr_api.g_varchar2) then
465: p_rec.employer_signatory :=
466: per_cag_shd.g_old_rec.employer_signatory;
467: End If;
468: If (p_rec.bargaining_organization_id = hr_api.g_number) then
469: p_rec.bargaining_organization_id :=
470: per_cag_shd.g_old_rec.bargaining_organization_id;
471: End If;
472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then

Line 472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then

468: If (p_rec.bargaining_organization_id = hr_api.g_number) then
469: p_rec.bargaining_organization_id :=
470: per_cag_shd.g_old_rec.bargaining_organization_id;
471: End If;
472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then
473: p_rec.bargaining_unit_signatory :=
474: per_cag_shd.g_old_rec.bargaining_unit_signatory;
475: End If;
476: If (p_rec.jurisdiction = hr_api.g_varchar2) then

Line 476: If (p_rec.jurisdiction = hr_api.g_varchar2) then

472: If (p_rec.bargaining_unit_signatory = hr_api.g_varchar2) then
473: p_rec.bargaining_unit_signatory :=
474: per_cag_shd.g_old_rec.bargaining_unit_signatory;
475: End If;
476: If (p_rec.jurisdiction = hr_api.g_varchar2) then
477: p_rec.jurisdiction :=
478: per_cag_shd.g_old_rec.jurisdiction;
479: End If;
480: If (p_rec.authorizing_body = hr_api.g_varchar2) then

Line 480: If (p_rec.authorizing_body = hr_api.g_varchar2) then

476: If (p_rec.jurisdiction = hr_api.g_varchar2) then
477: p_rec.jurisdiction :=
478: per_cag_shd.g_old_rec.jurisdiction;
479: End If;
480: If (p_rec.authorizing_body = hr_api.g_varchar2) then
481: p_rec.authorizing_body :=
482: per_cag_shd.g_old_rec.authorizing_body;
483: End If;
484: If (p_rec.authorized_date = hr_api.g_date) then

Line 484: If (p_rec.authorized_date = hr_api.g_date) then

480: If (p_rec.authorizing_body = hr_api.g_varchar2) then
481: p_rec.authorizing_body :=
482: per_cag_shd.g_old_rec.authorizing_body;
483: End If;
484: If (p_rec.authorized_date = hr_api.g_date) then
485: p_rec.authorized_date :=
486: per_cag_shd.g_old_rec.authorized_date;
487: End If;
488: If (p_rec.cag_information_category = hr_api.g_varchar2) then

Line 488: If (p_rec.cag_information_category = hr_api.g_varchar2) then

484: If (p_rec.authorized_date = hr_api.g_date) then
485: p_rec.authorized_date :=
486: per_cag_shd.g_old_rec.authorized_date;
487: End If;
488: If (p_rec.cag_information_category = hr_api.g_varchar2) then
489: p_rec.cag_information_category :=
490: per_cag_shd.g_old_rec.cag_information_category;
491: End If;
492: If (p_rec.cag_information1 = hr_api.g_varchar2) then

Line 492: If (p_rec.cag_information1 = hr_api.g_varchar2) then

488: If (p_rec.cag_information_category = hr_api.g_varchar2) then
489: p_rec.cag_information_category :=
490: per_cag_shd.g_old_rec.cag_information_category;
491: End If;
492: If (p_rec.cag_information1 = hr_api.g_varchar2) then
493: p_rec.cag_information1 :=
494: per_cag_shd.g_old_rec.cag_information1;
495: End If;
496: If (p_rec.cag_information2 = hr_api.g_varchar2) then

Line 496: If (p_rec.cag_information2 = hr_api.g_varchar2) then

492: If (p_rec.cag_information1 = hr_api.g_varchar2) then
493: p_rec.cag_information1 :=
494: per_cag_shd.g_old_rec.cag_information1;
495: End If;
496: If (p_rec.cag_information2 = hr_api.g_varchar2) then
497: p_rec.cag_information2 :=
498: per_cag_shd.g_old_rec.cag_information2;
499: End If;
500: If (p_rec.cag_information3 = hr_api.g_varchar2) then

Line 500: If (p_rec.cag_information3 = hr_api.g_varchar2) then

496: If (p_rec.cag_information2 = hr_api.g_varchar2) then
497: p_rec.cag_information2 :=
498: per_cag_shd.g_old_rec.cag_information2;
499: End If;
500: If (p_rec.cag_information3 = hr_api.g_varchar2) then
501: p_rec.cag_information3 :=
502: per_cag_shd.g_old_rec.cag_information3;
503: End If;
504: If (p_rec.cag_information4 = hr_api.g_varchar2) then

Line 504: If (p_rec.cag_information4 = hr_api.g_varchar2) then

500: If (p_rec.cag_information3 = hr_api.g_varchar2) then
501: p_rec.cag_information3 :=
502: per_cag_shd.g_old_rec.cag_information3;
503: End If;
504: If (p_rec.cag_information4 = hr_api.g_varchar2) then
505: p_rec.cag_information4 :=
506: per_cag_shd.g_old_rec.cag_information4;
507: End If;
508: If (p_rec.cag_information5 = hr_api.g_varchar2) then

Line 508: If (p_rec.cag_information5 = hr_api.g_varchar2) then

504: If (p_rec.cag_information4 = hr_api.g_varchar2) then
505: p_rec.cag_information4 :=
506: per_cag_shd.g_old_rec.cag_information4;
507: End If;
508: If (p_rec.cag_information5 = hr_api.g_varchar2) then
509: p_rec.cag_information5 :=
510: per_cag_shd.g_old_rec.cag_information5;
511: End If;
512: If (p_rec.cag_information6 = hr_api.g_varchar2) then

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

508: If (p_rec.cag_information5 = hr_api.g_varchar2) then
509: p_rec.cag_information5 :=
510: per_cag_shd.g_old_rec.cag_information5;
511: End If;
512: If (p_rec.cag_information6 = hr_api.g_varchar2) then
513: p_rec.cag_information6 :=
514: per_cag_shd.g_old_rec.cag_information6;
515: End If;
516: If (p_rec.cag_information7 = hr_api.g_varchar2) then

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

512: If (p_rec.cag_information6 = hr_api.g_varchar2) then
513: p_rec.cag_information6 :=
514: per_cag_shd.g_old_rec.cag_information6;
515: End If;
516: If (p_rec.cag_information7 = hr_api.g_varchar2) then
517: p_rec.cag_information7 :=
518: per_cag_shd.g_old_rec.cag_information7;
519: End If;
520: If (p_rec.cag_information8 = hr_api.g_varchar2) then

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

516: If (p_rec.cag_information7 = hr_api.g_varchar2) then
517: p_rec.cag_information7 :=
518: per_cag_shd.g_old_rec.cag_information7;
519: End If;
520: If (p_rec.cag_information8 = hr_api.g_varchar2) then
521: p_rec.cag_information8 :=
522: per_cag_shd.g_old_rec.cag_information8;
523: End If;
524: If (p_rec.cag_information9 = hr_api.g_varchar2) then

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

520: If (p_rec.cag_information8 = hr_api.g_varchar2) then
521: p_rec.cag_information8 :=
522: per_cag_shd.g_old_rec.cag_information8;
523: End If;
524: If (p_rec.cag_information9 = hr_api.g_varchar2) then
525: p_rec.cag_information9 :=
526: per_cag_shd.g_old_rec.cag_information9;
527: End If;
528: If (p_rec.cag_information10 = hr_api.g_varchar2) then

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

524: If (p_rec.cag_information9 = hr_api.g_varchar2) then
525: p_rec.cag_information9 :=
526: per_cag_shd.g_old_rec.cag_information9;
527: End If;
528: If (p_rec.cag_information10 = hr_api.g_varchar2) then
529: p_rec.cag_information10 :=
530: per_cag_shd.g_old_rec.cag_information10;
531: End If;
532: If (p_rec.cag_information11 = hr_api.g_varchar2) then

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

528: If (p_rec.cag_information10 = hr_api.g_varchar2) then
529: p_rec.cag_information10 :=
530: per_cag_shd.g_old_rec.cag_information10;
531: End If;
532: If (p_rec.cag_information11 = hr_api.g_varchar2) then
533: p_rec.cag_information11 :=
534: per_cag_shd.g_old_rec.cag_information11;
535: End If;
536: If (p_rec.cag_information12 = hr_api.g_varchar2) then

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

532: If (p_rec.cag_information11 = hr_api.g_varchar2) then
533: p_rec.cag_information11 :=
534: per_cag_shd.g_old_rec.cag_information11;
535: End If;
536: If (p_rec.cag_information12 = hr_api.g_varchar2) then
537: p_rec.cag_information12 :=
538: per_cag_shd.g_old_rec.cag_information12;
539: End If;
540: If (p_rec.cag_information13 = hr_api.g_varchar2) then

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

536: If (p_rec.cag_information12 = hr_api.g_varchar2) then
537: p_rec.cag_information12 :=
538: per_cag_shd.g_old_rec.cag_information12;
539: End If;
540: If (p_rec.cag_information13 = hr_api.g_varchar2) then
541: p_rec.cag_information13 :=
542: per_cag_shd.g_old_rec.cag_information13;
543: End If;
544: If (p_rec.cag_information14 = hr_api.g_varchar2) then

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

540: If (p_rec.cag_information13 = hr_api.g_varchar2) then
541: p_rec.cag_information13 :=
542: per_cag_shd.g_old_rec.cag_information13;
543: End If;
544: If (p_rec.cag_information14 = hr_api.g_varchar2) then
545: p_rec.cag_information14 :=
546: per_cag_shd.g_old_rec.cag_information14;
547: End If;
548: If (p_rec.cag_information15 = hr_api.g_varchar2) then

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

544: If (p_rec.cag_information14 = hr_api.g_varchar2) then
545: p_rec.cag_information14 :=
546: per_cag_shd.g_old_rec.cag_information14;
547: End If;
548: If (p_rec.cag_information15 = hr_api.g_varchar2) then
549: p_rec.cag_information15 :=
550: per_cag_shd.g_old_rec.cag_information15;
551: End If;
552: If (p_rec.cag_information16 = hr_api.g_varchar2) then

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

548: If (p_rec.cag_information15 = hr_api.g_varchar2) then
549: p_rec.cag_information15 :=
550: per_cag_shd.g_old_rec.cag_information15;
551: End If;
552: If (p_rec.cag_information16 = hr_api.g_varchar2) then
553: p_rec.cag_information16 :=
554: per_cag_shd.g_old_rec.cag_information16;
555: End If;
556: If (p_rec.cag_information17 = hr_api.g_varchar2) then

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

552: If (p_rec.cag_information16 = hr_api.g_varchar2) then
553: p_rec.cag_information16 :=
554: per_cag_shd.g_old_rec.cag_information16;
555: End If;
556: If (p_rec.cag_information17 = hr_api.g_varchar2) then
557: p_rec.cag_information17 :=
558: per_cag_shd.g_old_rec.cag_information17;
559: End If;
560: If (p_rec.cag_information18 = hr_api.g_varchar2) then

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

556: If (p_rec.cag_information17 = hr_api.g_varchar2) then
557: p_rec.cag_information17 :=
558: per_cag_shd.g_old_rec.cag_information17;
559: End If;
560: If (p_rec.cag_information18 = hr_api.g_varchar2) then
561: p_rec.cag_information18 :=
562: per_cag_shd.g_old_rec.cag_information18;
563: End If;
564: If (p_rec.cag_information19 = hr_api.g_varchar2) then

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

560: If (p_rec.cag_information18 = hr_api.g_varchar2) then
561: p_rec.cag_information18 :=
562: per_cag_shd.g_old_rec.cag_information18;
563: End If;
564: If (p_rec.cag_information19 = hr_api.g_varchar2) then
565: p_rec.cag_information19 :=
566: per_cag_shd.g_old_rec.cag_information19;
567: End If;
568: If (p_rec.cag_information20 = hr_api.g_varchar2) then

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

564: If (p_rec.cag_information19 = hr_api.g_varchar2) then
565: p_rec.cag_information19 :=
566: per_cag_shd.g_old_rec.cag_information19;
567: End If;
568: If (p_rec.cag_information20 = hr_api.g_varchar2) then
569: p_rec.cag_information20 :=
570: per_cag_shd.g_old_rec.cag_information20;
571: End If;
572: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

568: If (p_rec.cag_information20 = hr_api.g_varchar2) then
569: p_rec.cag_information20 :=
570: per_cag_shd.g_old_rec.cag_information20;
571: End If;
572: If (p_rec.attribute_category = hr_api.g_varchar2) then
573: p_rec.attribute_category :=
574: per_cag_shd.g_old_rec.attribute_category;
575: End If;
576: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

572: If (p_rec.attribute_category = hr_api.g_varchar2) then
573: p_rec.attribute_category :=
574: per_cag_shd.g_old_rec.attribute_category;
575: End If;
576: If (p_rec.attribute1 = hr_api.g_varchar2) then
577: p_rec.attribute1 :=
578: per_cag_shd.g_old_rec.attribute1;
579: End If;
580: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

576: If (p_rec.attribute1 = hr_api.g_varchar2) then
577: p_rec.attribute1 :=
578: per_cag_shd.g_old_rec.attribute1;
579: End If;
580: If (p_rec.attribute2 = hr_api.g_varchar2) then
581: p_rec.attribute2 :=
582: per_cag_shd.g_old_rec.attribute2;
583: End If;
584: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

580: If (p_rec.attribute2 = hr_api.g_varchar2) then
581: p_rec.attribute2 :=
582: per_cag_shd.g_old_rec.attribute2;
583: End If;
584: If (p_rec.attribute3 = hr_api.g_varchar2) then
585: p_rec.attribute3 :=
586: per_cag_shd.g_old_rec.attribute3;
587: End If;
588: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

584: If (p_rec.attribute3 = hr_api.g_varchar2) then
585: p_rec.attribute3 :=
586: per_cag_shd.g_old_rec.attribute3;
587: End If;
588: If (p_rec.attribute4 = hr_api.g_varchar2) then
589: p_rec.attribute4 :=
590: per_cag_shd.g_old_rec.attribute4;
591: End If;
592: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

588: If (p_rec.attribute4 = hr_api.g_varchar2) then
589: p_rec.attribute4 :=
590: per_cag_shd.g_old_rec.attribute4;
591: End If;
592: If (p_rec.attribute5 = hr_api.g_varchar2) then
593: p_rec.attribute5 :=
594: per_cag_shd.g_old_rec.attribute5;
595: End If;
596: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

592: If (p_rec.attribute5 = hr_api.g_varchar2) then
593: p_rec.attribute5 :=
594: per_cag_shd.g_old_rec.attribute5;
595: End If;
596: If (p_rec.attribute6 = hr_api.g_varchar2) then
597: p_rec.attribute6 :=
598: per_cag_shd.g_old_rec.attribute6;
599: End If;
600: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

596: If (p_rec.attribute6 = hr_api.g_varchar2) then
597: p_rec.attribute6 :=
598: per_cag_shd.g_old_rec.attribute6;
599: End If;
600: If (p_rec.attribute7 = hr_api.g_varchar2) then
601: p_rec.attribute7 :=
602: per_cag_shd.g_old_rec.attribute7;
603: End If;
604: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

600: If (p_rec.attribute7 = hr_api.g_varchar2) then
601: p_rec.attribute7 :=
602: per_cag_shd.g_old_rec.attribute7;
603: End If;
604: If (p_rec.attribute8 = hr_api.g_varchar2) then
605: p_rec.attribute8 :=
606: per_cag_shd.g_old_rec.attribute8;
607: End If;
608: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

604: If (p_rec.attribute8 = hr_api.g_varchar2) then
605: p_rec.attribute8 :=
606: per_cag_shd.g_old_rec.attribute8;
607: End If;
608: If (p_rec.attribute9 = hr_api.g_varchar2) then
609: p_rec.attribute9 :=
610: per_cag_shd.g_old_rec.attribute9;
611: End If;
612: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

608: If (p_rec.attribute9 = hr_api.g_varchar2) then
609: p_rec.attribute9 :=
610: per_cag_shd.g_old_rec.attribute9;
611: End If;
612: If (p_rec.attribute10 = hr_api.g_varchar2) then
613: p_rec.attribute10 :=
614: per_cag_shd.g_old_rec.attribute10;
615: End If;
616: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

612: If (p_rec.attribute10 = hr_api.g_varchar2) then
613: p_rec.attribute10 :=
614: per_cag_shd.g_old_rec.attribute10;
615: End If;
616: If (p_rec.attribute11 = hr_api.g_varchar2) then
617: p_rec.attribute11 :=
618: per_cag_shd.g_old_rec.attribute11;
619: End If;
620: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

616: If (p_rec.attribute11 = hr_api.g_varchar2) then
617: p_rec.attribute11 :=
618: per_cag_shd.g_old_rec.attribute11;
619: End If;
620: If (p_rec.attribute12 = hr_api.g_varchar2) then
621: p_rec.attribute12 :=
622: per_cag_shd.g_old_rec.attribute12;
623: End If;
624: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

620: If (p_rec.attribute12 = hr_api.g_varchar2) then
621: p_rec.attribute12 :=
622: per_cag_shd.g_old_rec.attribute12;
623: End If;
624: If (p_rec.attribute13 = hr_api.g_varchar2) then
625: p_rec.attribute13 :=
626: per_cag_shd.g_old_rec.attribute13;
627: End If;
628: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

624: If (p_rec.attribute13 = hr_api.g_varchar2) then
625: p_rec.attribute13 :=
626: per_cag_shd.g_old_rec.attribute13;
627: End If;
628: If (p_rec.attribute14 = hr_api.g_varchar2) then
629: p_rec.attribute14 :=
630: per_cag_shd.g_old_rec.attribute14;
631: End If;
632: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

628: If (p_rec.attribute14 = hr_api.g_varchar2) then
629: p_rec.attribute14 :=
630: per_cag_shd.g_old_rec.attribute14;
631: End If;
632: If (p_rec.attribute15 = hr_api.g_varchar2) then
633: p_rec.attribute15 :=
634: per_cag_shd.g_old_rec.attribute15;
635: End If;
636: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 636: If (p_rec.attribute16 = hr_api.g_varchar2) then

632: If (p_rec.attribute15 = hr_api.g_varchar2) then
633: p_rec.attribute15 :=
634: per_cag_shd.g_old_rec.attribute15;
635: End If;
636: If (p_rec.attribute16 = hr_api.g_varchar2) then
637: p_rec.attribute16 :=
638: per_cag_shd.g_old_rec.attribute16;
639: End If;
640: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 640: If (p_rec.attribute17 = hr_api.g_varchar2) then

636: If (p_rec.attribute16 = hr_api.g_varchar2) then
637: p_rec.attribute16 :=
638: per_cag_shd.g_old_rec.attribute16;
639: End If;
640: If (p_rec.attribute17 = hr_api.g_varchar2) then
641: p_rec.attribute17 :=
642: per_cag_shd.g_old_rec.attribute17;
643: End If;
644: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 644: If (p_rec.attribute18 = hr_api.g_varchar2) then

640: If (p_rec.attribute17 = hr_api.g_varchar2) then
641: p_rec.attribute17 :=
642: per_cag_shd.g_old_rec.attribute17;
643: End If;
644: If (p_rec.attribute18 = hr_api.g_varchar2) then
645: p_rec.attribute18 :=
646: per_cag_shd.g_old_rec.attribute18;
647: End If;
648: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 648: If (p_rec.attribute19 = hr_api.g_varchar2) then

644: If (p_rec.attribute18 = hr_api.g_varchar2) then
645: p_rec.attribute18 :=
646: per_cag_shd.g_old_rec.attribute18;
647: End If;
648: If (p_rec.attribute19 = hr_api.g_varchar2) then
649: p_rec.attribute19 :=
650: per_cag_shd.g_old_rec.attribute19;
651: End If;
652: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 652: If (p_rec.attribute20 = hr_api.g_varchar2) then

648: If (p_rec.attribute19 = hr_api.g_varchar2) then
649: p_rec.attribute19 :=
650: per_cag_shd.g_old_rec.attribute19;
651: End If;
652: If (p_rec.attribute20 = hr_api.g_varchar2) then
653: p_rec.attribute20 :=
654: per_cag_shd.g_old_rec.attribute20;
655: End If;
656: --

Line 710: p_business_group_id in number default hr_api.g_number,

706: -- ----------------------------------------------------------------------------
707: Procedure upd
708: (
709: p_collective_agreement_id in number,
710: p_business_group_id in number default hr_api.g_number,
711: p_object_version_number in out nocopy number,
712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,

Line 712: p_name in varchar2 default hr_api.g_varchar2,

708: (
709: p_collective_agreement_id in number,
710: p_business_group_id in number default hr_api.g_number,
711: p_object_version_number in out nocopy number,
712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,

Line 713: p_status in varchar2 default hr_api.g_varchar2,

709: p_collective_agreement_id in number,
710: p_business_group_id in number default hr_api.g_number,
711: p_object_version_number in out nocopy number,
712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,

Line 714: p_cag_number in number default hr_api.g_number,

710: p_business_group_id in number default hr_api.g_number,
711: p_object_version_number in out nocopy number,
712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,

Line 715: p_description in varchar2 default hr_api.g_varchar2,

711: p_object_version_number in out nocopy number,
712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,

Line 716: p_start_date in date default hr_api.g_date,

712: p_name in varchar2 default hr_api.g_varchar2,
713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,

Line 717: p_end_date in date default hr_api.g_date,

713: p_status in varchar2 default hr_api.g_varchar2,
714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,

Line 718: p_employer_organization_id in number default hr_api.g_number,

714: p_cag_number in number default hr_api.g_number,
715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,

Line 719: p_employer_signatory in varchar2 default hr_api.g_varchar2,

715: p_description in varchar2 default hr_api.g_varchar2,
716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,

Line 720: p_bargaining_organization_id in number default hr_api.g_number,

716: p_start_date in date default hr_api.g_date,
717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,

Line 721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,

717: p_end_date in date default hr_api.g_date,
718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,

Line 722: p_jurisdiction in varchar2 default hr_api.g_varchar2,

718: p_employer_organization_id in number default hr_api.g_number,
719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,

Line 723: p_authorizing_body in varchar2 default hr_api.g_varchar2,

719: p_employer_signatory in varchar2 default hr_api.g_varchar2,
720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,

Line 724: p_authorized_date in date default hr_api.g_date,

720: p_bargaining_organization_id in number default hr_api.g_number,
721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,

Line 725: p_cag_information_category in varchar2 default hr_api.g_varchar2,

721: p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2,
722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,

Line 726: p_cag_information1 in varchar2 default hr_api.g_varchar2,

722: p_jurisdiction in varchar2 default hr_api.g_varchar2,
723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,

Line 727: p_cag_information2 in varchar2 default hr_api.g_varchar2,

723: p_authorizing_body in varchar2 default hr_api.g_varchar2,
724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,

Line 728: p_cag_information3 in varchar2 default hr_api.g_varchar2,

724: p_authorized_date in date default hr_api.g_date,
725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,

Line 729: p_cag_information4 in varchar2 default hr_api.g_varchar2,

725: p_cag_information_category in varchar2 default hr_api.g_varchar2,
726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,

Line 730: p_cag_information5 in varchar2 default hr_api.g_varchar2,

726: p_cag_information1 in varchar2 default hr_api.g_varchar2,
727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,

Line 731: p_cag_information6 in varchar2 default hr_api.g_varchar2,

727: p_cag_information2 in varchar2 default hr_api.g_varchar2,
728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,

Line 732: p_cag_information7 in varchar2 default hr_api.g_varchar2,

728: p_cag_information3 in varchar2 default hr_api.g_varchar2,
729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,

Line 733: p_cag_information8 in varchar2 default hr_api.g_varchar2,

729: p_cag_information4 in varchar2 default hr_api.g_varchar2,
730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,

Line 734: p_cag_information9 in varchar2 default hr_api.g_varchar2,

730: p_cag_information5 in varchar2 default hr_api.g_varchar2,
731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,

Line 735: p_cag_information10 in varchar2 default hr_api.g_varchar2,

731: p_cag_information6 in varchar2 default hr_api.g_varchar2,
732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,

Line 736: p_cag_information11 in varchar2 default hr_api.g_varchar2,

732: p_cag_information7 in varchar2 default hr_api.g_varchar2,
733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,

Line 737: p_cag_information12 in varchar2 default hr_api.g_varchar2,

733: p_cag_information8 in varchar2 default hr_api.g_varchar2,
734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,

Line 738: p_cag_information13 in varchar2 default hr_api.g_varchar2,

734: p_cag_information9 in varchar2 default hr_api.g_varchar2,
735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,

Line 739: p_cag_information14 in varchar2 default hr_api.g_varchar2,

735: p_cag_information10 in varchar2 default hr_api.g_varchar2,
736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,

Line 740: p_cag_information15 in varchar2 default hr_api.g_varchar2,

736: p_cag_information11 in varchar2 default hr_api.g_varchar2,
737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,

Line 741: p_cag_information16 in varchar2 default hr_api.g_varchar2,

737: p_cag_information12 in varchar2 default hr_api.g_varchar2,
738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,

Line 742: p_cag_information17 in varchar2 default hr_api.g_varchar2,

738: p_cag_information13 in varchar2 default hr_api.g_varchar2,
739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 743: p_cag_information18 in varchar2 default hr_api.g_varchar2,

739: p_cag_information14 in varchar2 default hr_api.g_varchar2,
740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 744: p_cag_information19 in varchar2 default hr_api.g_varchar2,

740: p_cag_information15 in varchar2 default hr_api.g_varchar2,
741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 745: p_cag_information20 in varchar2 default hr_api.g_varchar2,

741: p_cag_information16 in varchar2 default hr_api.g_varchar2,
742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 746: p_attribute_category in varchar2 default hr_api.g_varchar2,

742: p_cag_information17 in varchar2 default hr_api.g_varchar2,
743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 747: p_attribute1 in varchar2 default hr_api.g_varchar2,

743: p_cag_information18 in varchar2 default hr_api.g_varchar2,
744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 748: p_attribute2 in varchar2 default hr_api.g_varchar2,

744: p_cag_information19 in varchar2 default hr_api.g_varchar2,
745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 749: p_attribute3 in varchar2 default hr_api.g_varchar2,

745: p_cag_information20 in varchar2 default hr_api.g_varchar2,
746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 750: p_attribute4 in varchar2 default hr_api.g_varchar2,

746: p_attribute_category in varchar2 default hr_api.g_varchar2,
747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 751: p_attribute5 in varchar2 default hr_api.g_varchar2,

747: p_attribute1 in varchar2 default hr_api.g_varchar2,
748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 752: p_attribute6 in varchar2 default hr_api.g_varchar2,

748: p_attribute2 in varchar2 default hr_api.g_varchar2,
749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 753: p_attribute7 in varchar2 default hr_api.g_varchar2,

749: p_attribute3 in varchar2 default hr_api.g_varchar2,
750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 754: p_attribute8 in varchar2 default hr_api.g_varchar2,

750: p_attribute4 in varchar2 default hr_api.g_varchar2,
751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 755: p_attribute9 in varchar2 default hr_api.g_varchar2,

751: p_attribute5 in varchar2 default hr_api.g_varchar2,
752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 756: p_attribute10 in varchar2 default hr_api.g_varchar2,

752: p_attribute6 in varchar2 default hr_api.g_varchar2,
753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 757: p_attribute11 in varchar2 default hr_api.g_varchar2,

753: p_attribute7 in varchar2 default hr_api.g_varchar2,
754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 758: p_attribute12 in varchar2 default hr_api.g_varchar2,

754: p_attribute8 in varchar2 default hr_api.g_varchar2,
755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 759: p_attribute13 in varchar2 default hr_api.g_varchar2,

755: p_attribute9 in varchar2 default hr_api.g_varchar2,
756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 760: p_attribute14 in varchar2 default hr_api.g_varchar2,

756: p_attribute10 in varchar2 default hr_api.g_varchar2,
757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 761: p_attribute15 in varchar2 default hr_api.g_varchar2,

757: p_attribute11 in varchar2 default hr_api.g_varchar2,
758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 762: p_attribute16 in varchar2 default hr_api.g_varchar2,

758: p_attribute12 in varchar2 default hr_api.g_varchar2,
759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2

Line 763: p_attribute17 in varchar2 default hr_api.g_varchar2,

759: p_attribute13 in varchar2 default hr_api.g_varchar2,
760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2
767: ) is

Line 764: p_attribute18 in varchar2 default hr_api.g_varchar2,

760: p_attribute14 in varchar2 default hr_api.g_varchar2,
761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2
767: ) is
768: --

Line 765: p_attribute19 in varchar2 default hr_api.g_varchar2,

761: p_attribute15 in varchar2 default hr_api.g_varchar2,
762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2
767: ) is
768: --
769: l_rec per_cag_shd.g_rec_type;

Line 766: p_attribute20 in varchar2 default hr_api.g_varchar2

762: p_attribute16 in varchar2 default hr_api.g_varchar2,
763: p_attribute17 in varchar2 default hr_api.g_varchar2,
764: p_attribute18 in varchar2 default hr_api.g_varchar2,
765: p_attribute19 in varchar2 default hr_api.g_varchar2,
766: p_attribute20 in varchar2 default hr_api.g_varchar2
767: ) is
768: --
769: l_rec per_cag_shd.g_rec_type;
770: l_proc varchar2(72) := g_package||'upd';