APPS.HR_TPP_UPD dependencies on HR_API

Line 114: When hr_api.check_integrity_violated Then

110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_tpp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_tpp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_tpp_shd.constraint_error

Line 119: When hr_api.parent_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: hr_tpp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_tpp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_tpp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_tpp_shd.constraint_error

Line 124: When hr_api.unique_integrity_violated Then

120: -- Parent integrity has been violated
121: --
122: hr_tpp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_tpp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_tpp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
132: End update_dml;

Line 373: when hr_api.cannot_find_prog_unit then

369: );
370: --
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 => 'HR_TAB_PAGE_PROPERTIES_B'
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 => 'HR_TAB_PAGE_PROPERTIES_B'
377: ,p_hook_type => 'AU');
378: --
379: end;

Line 438: If (p_rec.form_tab_page_id = hr_api.g_number) then

434: -- p_rec plsql record structure
435: -- to see if a system default is being used. If a system default
436: -- is being used then we must set to the 'current' argument value.
437: --
438: If (p_rec.form_tab_page_id = hr_api.g_number) then
439: p_rec.form_tab_page_id :=
440: hr_tpp_shd.g_old_rec.form_tab_page_id;
441: End If;
442: If (p_rec.template_tab_page_id = hr_api.g_number) then

Line 442: If (p_rec.template_tab_page_id = hr_api.g_number) then

438: If (p_rec.form_tab_page_id = hr_api.g_number) then
439: p_rec.form_tab_page_id :=
440: hr_tpp_shd.g_old_rec.form_tab_page_id;
441: End If;
442: If (p_rec.template_tab_page_id = hr_api.g_number) then
443: p_rec.template_tab_page_id :=
444: hr_tpp_shd.g_old_rec.template_tab_page_id;
445: End If;
446: If (p_rec.navigation_direction = hr_api.g_varchar2) then

Line 446: If (p_rec.navigation_direction = hr_api.g_varchar2) then

442: If (p_rec.template_tab_page_id = hr_api.g_number) then
443: p_rec.template_tab_page_id :=
444: hr_tpp_shd.g_old_rec.template_tab_page_id;
445: End If;
446: If (p_rec.navigation_direction = hr_api.g_varchar2) then
447: p_rec.navigation_direction :=
448: hr_tpp_shd.g_old_rec.navigation_direction;
449: End If;
450: If (p_rec.visible = hr_api.g_number) then

Line 450: If (p_rec.visible = hr_api.g_number) then

446: If (p_rec.navigation_direction = hr_api.g_varchar2) then
447: p_rec.navigation_direction :=
448: hr_tpp_shd.g_old_rec.navigation_direction;
449: End If;
450: If (p_rec.visible = hr_api.g_number) then
451: p_rec.visible :=
452: hr_tpp_shd.g_old_rec.visible;
453: End If;
454: If (p_rec.information_category = hr_api.g_varchar2) then

Line 454: If (p_rec.information_category = hr_api.g_varchar2) then

450: If (p_rec.visible = hr_api.g_number) then
451: p_rec.visible :=
452: hr_tpp_shd.g_old_rec.visible;
453: End If;
454: If (p_rec.information_category = hr_api.g_varchar2) then
455: p_rec.information_category :=
456: hr_tpp_shd.g_old_rec.information_category;
457: End If;
458: If (p_rec.information1 = hr_api.g_varchar2) then

Line 458: If (p_rec.information1 = hr_api.g_varchar2) then

454: If (p_rec.information_category = hr_api.g_varchar2) then
455: p_rec.information_category :=
456: hr_tpp_shd.g_old_rec.information_category;
457: End If;
458: If (p_rec.information1 = hr_api.g_varchar2) then
459: p_rec.information1 :=
460: hr_tpp_shd.g_old_rec.information1;
461: End If;
462: If (p_rec.information2 = hr_api.g_varchar2) then

Line 462: If (p_rec.information2 = hr_api.g_varchar2) then

458: If (p_rec.information1 = hr_api.g_varchar2) then
459: p_rec.information1 :=
460: hr_tpp_shd.g_old_rec.information1;
461: End If;
462: If (p_rec.information2 = hr_api.g_varchar2) then
463: p_rec.information2 :=
464: hr_tpp_shd.g_old_rec.information2;
465: End If;
466: If (p_rec.information3 = hr_api.g_varchar2) then

Line 466: If (p_rec.information3 = hr_api.g_varchar2) then

462: If (p_rec.information2 = hr_api.g_varchar2) then
463: p_rec.information2 :=
464: hr_tpp_shd.g_old_rec.information2;
465: End If;
466: If (p_rec.information3 = hr_api.g_varchar2) then
467: p_rec.information3 :=
468: hr_tpp_shd.g_old_rec.information3;
469: End If;
470: If (p_rec.information4 = hr_api.g_varchar2) then

Line 470: If (p_rec.information4 = hr_api.g_varchar2) then

466: If (p_rec.information3 = hr_api.g_varchar2) then
467: p_rec.information3 :=
468: hr_tpp_shd.g_old_rec.information3;
469: End If;
470: If (p_rec.information4 = hr_api.g_varchar2) then
471: p_rec.information4 :=
472: hr_tpp_shd.g_old_rec.information4;
473: End If;
474: If (p_rec.information5 = hr_api.g_varchar2) then

Line 474: If (p_rec.information5 = hr_api.g_varchar2) then

470: If (p_rec.information4 = hr_api.g_varchar2) then
471: p_rec.information4 :=
472: hr_tpp_shd.g_old_rec.information4;
473: End If;
474: If (p_rec.information5 = hr_api.g_varchar2) then
475: p_rec.information5 :=
476: hr_tpp_shd.g_old_rec.information5;
477: End If;
478: If (p_rec.information6 = hr_api.g_varchar2) then

Line 478: If (p_rec.information6 = hr_api.g_varchar2) then

474: If (p_rec.information5 = hr_api.g_varchar2) then
475: p_rec.information5 :=
476: hr_tpp_shd.g_old_rec.information5;
477: End If;
478: If (p_rec.information6 = hr_api.g_varchar2) then
479: p_rec.information6 :=
480: hr_tpp_shd.g_old_rec.information6;
481: End If;
482: If (p_rec.information7 = hr_api.g_varchar2) then

Line 482: If (p_rec.information7 = hr_api.g_varchar2) then

478: If (p_rec.information6 = hr_api.g_varchar2) then
479: p_rec.information6 :=
480: hr_tpp_shd.g_old_rec.information6;
481: End If;
482: If (p_rec.information7 = hr_api.g_varchar2) then
483: p_rec.information7 :=
484: hr_tpp_shd.g_old_rec.information7;
485: End If;
486: If (p_rec.information8 = hr_api.g_varchar2) then

Line 486: If (p_rec.information8 = hr_api.g_varchar2) then

482: If (p_rec.information7 = hr_api.g_varchar2) then
483: p_rec.information7 :=
484: hr_tpp_shd.g_old_rec.information7;
485: End If;
486: If (p_rec.information8 = hr_api.g_varchar2) then
487: p_rec.information8 :=
488: hr_tpp_shd.g_old_rec.information8;
489: End If;
490: If (p_rec.information9 = hr_api.g_varchar2) then

Line 490: If (p_rec.information9 = hr_api.g_varchar2) then

486: If (p_rec.information8 = hr_api.g_varchar2) then
487: p_rec.information8 :=
488: hr_tpp_shd.g_old_rec.information8;
489: End If;
490: If (p_rec.information9 = hr_api.g_varchar2) then
491: p_rec.information9 :=
492: hr_tpp_shd.g_old_rec.information9;
493: End If;
494: If (p_rec.information10 = hr_api.g_varchar2) then

Line 494: If (p_rec.information10 = hr_api.g_varchar2) then

490: If (p_rec.information9 = hr_api.g_varchar2) then
491: p_rec.information9 :=
492: hr_tpp_shd.g_old_rec.information9;
493: End If;
494: If (p_rec.information10 = hr_api.g_varchar2) then
495: p_rec.information10 :=
496: hr_tpp_shd.g_old_rec.information10;
497: End If;
498: If (p_rec.information11 = hr_api.g_varchar2) then

Line 498: If (p_rec.information11 = hr_api.g_varchar2) then

494: If (p_rec.information10 = hr_api.g_varchar2) then
495: p_rec.information10 :=
496: hr_tpp_shd.g_old_rec.information10;
497: End If;
498: If (p_rec.information11 = hr_api.g_varchar2) then
499: p_rec.information11 :=
500: hr_tpp_shd.g_old_rec.information11;
501: End If;
502: If (p_rec.information12 = hr_api.g_varchar2) then

Line 502: If (p_rec.information12 = hr_api.g_varchar2) then

498: If (p_rec.information11 = hr_api.g_varchar2) then
499: p_rec.information11 :=
500: hr_tpp_shd.g_old_rec.information11;
501: End If;
502: If (p_rec.information12 = hr_api.g_varchar2) then
503: p_rec.information12 :=
504: hr_tpp_shd.g_old_rec.information12;
505: End If;
506: If (p_rec.information13 = hr_api.g_varchar2) then

Line 506: If (p_rec.information13 = hr_api.g_varchar2) then

502: If (p_rec.information12 = hr_api.g_varchar2) then
503: p_rec.information12 :=
504: hr_tpp_shd.g_old_rec.information12;
505: End If;
506: If (p_rec.information13 = hr_api.g_varchar2) then
507: p_rec.information13 :=
508: hr_tpp_shd.g_old_rec.information13;
509: End If;
510: If (p_rec.information14 = hr_api.g_varchar2) then

Line 510: If (p_rec.information14 = hr_api.g_varchar2) then

506: If (p_rec.information13 = hr_api.g_varchar2) then
507: p_rec.information13 :=
508: hr_tpp_shd.g_old_rec.information13;
509: End If;
510: If (p_rec.information14 = hr_api.g_varchar2) then
511: p_rec.information14 :=
512: hr_tpp_shd.g_old_rec.information14;
513: End If;
514: If (p_rec.information15 = hr_api.g_varchar2) then

Line 514: If (p_rec.information15 = hr_api.g_varchar2) then

510: If (p_rec.information14 = hr_api.g_varchar2) then
511: p_rec.information14 :=
512: hr_tpp_shd.g_old_rec.information14;
513: End If;
514: If (p_rec.information15 = hr_api.g_varchar2) then
515: p_rec.information15 :=
516: hr_tpp_shd.g_old_rec.information15;
517: End If;
518: If (p_rec.information16 = hr_api.g_varchar2) then

Line 518: If (p_rec.information16 = hr_api.g_varchar2) then

514: If (p_rec.information15 = hr_api.g_varchar2) then
515: p_rec.information15 :=
516: hr_tpp_shd.g_old_rec.information15;
517: End If;
518: If (p_rec.information16 = hr_api.g_varchar2) then
519: p_rec.information16 :=
520: hr_tpp_shd.g_old_rec.information16;
521: End If;
522: If (p_rec.information17 = hr_api.g_varchar2) then

Line 522: If (p_rec.information17 = hr_api.g_varchar2) then

518: If (p_rec.information16 = hr_api.g_varchar2) then
519: p_rec.information16 :=
520: hr_tpp_shd.g_old_rec.information16;
521: End If;
522: If (p_rec.information17 = hr_api.g_varchar2) then
523: p_rec.information17 :=
524: hr_tpp_shd.g_old_rec.information17;
525: End If;
526: If (p_rec.information18 = hr_api.g_varchar2) then

Line 526: If (p_rec.information18 = hr_api.g_varchar2) then

522: If (p_rec.information17 = hr_api.g_varchar2) then
523: p_rec.information17 :=
524: hr_tpp_shd.g_old_rec.information17;
525: End If;
526: If (p_rec.information18 = hr_api.g_varchar2) then
527: p_rec.information18 :=
528: hr_tpp_shd.g_old_rec.information18;
529: End If;
530: If (p_rec.information19 = hr_api.g_varchar2) then

Line 530: If (p_rec.information19 = hr_api.g_varchar2) then

526: If (p_rec.information18 = hr_api.g_varchar2) then
527: p_rec.information18 :=
528: hr_tpp_shd.g_old_rec.information18;
529: End If;
530: If (p_rec.information19 = hr_api.g_varchar2) then
531: p_rec.information19 :=
532: hr_tpp_shd.g_old_rec.information19;
533: End If;
534: If (p_rec.information20 = hr_api.g_varchar2) then

Line 534: If (p_rec.information20 = hr_api.g_varchar2) then

530: If (p_rec.information19 = hr_api.g_varchar2) then
531: p_rec.information19 :=
532: hr_tpp_shd.g_old_rec.information19;
533: End If;
534: If (p_rec.information20 = hr_api.g_varchar2) then
535: p_rec.information20 :=
536: hr_tpp_shd.g_old_rec.information20;
537: End If;
538: If (p_rec.information21 = hr_api.g_varchar2) then

Line 538: If (p_rec.information21 = hr_api.g_varchar2) then

534: If (p_rec.information20 = hr_api.g_varchar2) then
535: p_rec.information20 :=
536: hr_tpp_shd.g_old_rec.information20;
537: End If;
538: If (p_rec.information21 = hr_api.g_varchar2) then
539: p_rec.information21 :=
540: hr_tpp_shd.g_old_rec.information21;
541: End If;
542: If (p_rec.information22 = hr_api.g_varchar2) then

Line 542: If (p_rec.information22 = hr_api.g_varchar2) then

538: If (p_rec.information21 = hr_api.g_varchar2) then
539: p_rec.information21 :=
540: hr_tpp_shd.g_old_rec.information21;
541: End If;
542: If (p_rec.information22 = hr_api.g_varchar2) then
543: p_rec.information22 :=
544: hr_tpp_shd.g_old_rec.information22;
545: End If;
546: If (p_rec.information23 = hr_api.g_varchar2) then

Line 546: If (p_rec.information23 = hr_api.g_varchar2) then

542: If (p_rec.information22 = hr_api.g_varchar2) then
543: p_rec.information22 :=
544: hr_tpp_shd.g_old_rec.information22;
545: End If;
546: If (p_rec.information23 = hr_api.g_varchar2) then
547: p_rec.information23 :=
548: hr_tpp_shd.g_old_rec.information23;
549: End If;
550: If (p_rec.information24 = hr_api.g_varchar2) then

Line 550: If (p_rec.information24 = hr_api.g_varchar2) then

546: If (p_rec.information23 = hr_api.g_varchar2) then
547: p_rec.information23 :=
548: hr_tpp_shd.g_old_rec.information23;
549: End If;
550: If (p_rec.information24 = hr_api.g_varchar2) then
551: p_rec.information24 :=
552: hr_tpp_shd.g_old_rec.information24;
553: End If;
554: If (p_rec.information25 = hr_api.g_varchar2) then

Line 554: If (p_rec.information25 = hr_api.g_varchar2) then

550: If (p_rec.information24 = hr_api.g_varchar2) then
551: p_rec.information24 :=
552: hr_tpp_shd.g_old_rec.information24;
553: End If;
554: If (p_rec.information25 = hr_api.g_varchar2) then
555: p_rec.information25 :=
556: hr_tpp_shd.g_old_rec.information25;
557: End If;
558: If (p_rec.information26 = hr_api.g_varchar2) then

Line 558: If (p_rec.information26 = hr_api.g_varchar2) then

554: If (p_rec.information25 = hr_api.g_varchar2) then
555: p_rec.information25 :=
556: hr_tpp_shd.g_old_rec.information25;
557: End If;
558: If (p_rec.information26 = hr_api.g_varchar2) then
559: p_rec.information26 :=
560: hr_tpp_shd.g_old_rec.information26;
561: End If;
562: If (p_rec.information27 = hr_api.g_varchar2) then

Line 562: If (p_rec.information27 = hr_api.g_varchar2) then

558: If (p_rec.information26 = hr_api.g_varchar2) then
559: p_rec.information26 :=
560: hr_tpp_shd.g_old_rec.information26;
561: End If;
562: If (p_rec.information27 = hr_api.g_varchar2) then
563: p_rec.information27 :=
564: hr_tpp_shd.g_old_rec.information27;
565: End If;
566: If (p_rec.information28 = hr_api.g_varchar2) then

Line 566: If (p_rec.information28 = hr_api.g_varchar2) then

562: If (p_rec.information27 = hr_api.g_varchar2) then
563: p_rec.information27 :=
564: hr_tpp_shd.g_old_rec.information27;
565: End If;
566: If (p_rec.information28 = hr_api.g_varchar2) then
567: p_rec.information28 :=
568: hr_tpp_shd.g_old_rec.information28;
569: End If;
570: If (p_rec.information29 = hr_api.g_varchar2) then

Line 570: If (p_rec.information29 = hr_api.g_varchar2) then

566: If (p_rec.information28 = hr_api.g_varchar2) then
567: p_rec.information28 :=
568: hr_tpp_shd.g_old_rec.information28;
569: End If;
570: If (p_rec.information29 = hr_api.g_varchar2) then
571: p_rec.information29 :=
572: hr_tpp_shd.g_old_rec.information29;
573: End If;
574: If (p_rec.information30 = hr_api.g_varchar2) then

Line 574: If (p_rec.information30 = hr_api.g_varchar2) then

570: If (p_rec.information29 = hr_api.g_varchar2) then
571: p_rec.information29 :=
572: hr_tpp_shd.g_old_rec.information29;
573: End If;
574: If (p_rec.information30 = hr_api.g_varchar2) then
575: p_rec.information30 :=
576: hr_tpp_shd.g_old_rec.information30;
577: End If;
578: --

Line 636: ,p_form_tab_page_id in number default hr_api.g_number

632: Procedure upd
633: (p_effective_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_tab_page_property_id in number
636: ,p_form_tab_page_id in number default hr_api.g_number
637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 637: ,p_template_tab_page_id in number default hr_api.g_number

633: (p_effective_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_tab_page_property_id in number
636: ,p_form_tab_page_id in number default hr_api.g_number
637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2

634: ,p_object_version_number in out nocopy number
635: ,p_tab_page_property_id in number
636: ,p_form_tab_page_id in number default hr_api.g_number
637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 639: ,p_visible in number default hr_api.g_number

635: ,p_tab_page_property_id in number
636: ,p_form_tab_page_id in number default hr_api.g_number
637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 640: ,p_information_category in varchar2 default hr_api.g_varchar2

636: ,p_form_tab_page_id in number default hr_api.g_number
637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 641: ,p_information1 in varchar2 default hr_api.g_varchar2

637: ,p_template_tab_page_id in number default hr_api.g_number
638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 642: ,p_information2 in varchar2 default hr_api.g_varchar2

638: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 643: ,p_information3 in varchar2 default hr_api.g_varchar2

639: ,p_visible in number default hr_api.g_number
640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 644: ,p_information4 in varchar2 default hr_api.g_varchar2

640: ,p_information_category in varchar2 default hr_api.g_varchar2
641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 645: ,p_information5 in varchar2 default hr_api.g_varchar2

641: ,p_information1 in varchar2 default hr_api.g_varchar2
642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 646: ,p_information6 in varchar2 default hr_api.g_varchar2

642: ,p_information2 in varchar2 default hr_api.g_varchar2
643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 647: ,p_information7 in varchar2 default hr_api.g_varchar2

643: ,p_information3 in varchar2 default hr_api.g_varchar2
644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 648: ,p_information8 in varchar2 default hr_api.g_varchar2

644: ,p_information4 in varchar2 default hr_api.g_varchar2
645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 649: ,p_information9 in varchar2 default hr_api.g_varchar2

645: ,p_information5 in varchar2 default hr_api.g_varchar2
646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 650: ,p_information10 in varchar2 default hr_api.g_varchar2

646: ,p_information6 in varchar2 default hr_api.g_varchar2
647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 651: ,p_information11 in varchar2 default hr_api.g_varchar2

647: ,p_information7 in varchar2 default hr_api.g_varchar2
648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 652: ,p_information12 in varchar2 default hr_api.g_varchar2

648: ,p_information8 in varchar2 default hr_api.g_varchar2
649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 653: ,p_information13 in varchar2 default hr_api.g_varchar2

649: ,p_information9 in varchar2 default hr_api.g_varchar2
650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 654: ,p_information14 in varchar2 default hr_api.g_varchar2

650: ,p_information10 in varchar2 default hr_api.g_varchar2
651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 655: ,p_information15 in varchar2 default hr_api.g_varchar2

651: ,p_information11 in varchar2 default hr_api.g_varchar2
652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 656: ,p_information16 in varchar2 default hr_api.g_varchar2

652: ,p_information12 in varchar2 default hr_api.g_varchar2
653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 657: ,p_information17 in varchar2 default hr_api.g_varchar2

653: ,p_information13 in varchar2 default hr_api.g_varchar2
654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 658: ,p_information18 in varchar2 default hr_api.g_varchar2

654: ,p_information14 in varchar2 default hr_api.g_varchar2
655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 659: ,p_information19 in varchar2 default hr_api.g_varchar2

655: ,p_information15 in varchar2 default hr_api.g_varchar2
656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 660: ,p_information20 in varchar2 default hr_api.g_varchar2

656: ,p_information16 in varchar2 default hr_api.g_varchar2
657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 661: ,p_information21 in varchar2 default hr_api.g_varchar2

657: ,p_information17 in varchar2 default hr_api.g_varchar2
658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 662: ,p_information22 in varchar2 default hr_api.g_varchar2

658: ,p_information18 in varchar2 default hr_api.g_varchar2
659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 663: ,p_information23 in varchar2 default hr_api.g_varchar2

659: ,p_information19 in varchar2 default hr_api.g_varchar2
660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 664: ,p_information24 in varchar2 default hr_api.g_varchar2

660: ,p_information20 in varchar2 default hr_api.g_varchar2
661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 665: ,p_information25 in varchar2 default hr_api.g_varchar2

661: ,p_information21 in varchar2 default hr_api.g_varchar2
662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 666: ,p_information26 in varchar2 default hr_api.g_varchar2

662: ,p_information22 in varchar2 default hr_api.g_varchar2
663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 667: ,p_information27 in varchar2 default hr_api.g_varchar2

663: ,p_information23 in varchar2 default hr_api.g_varchar2
664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2
671: ) is

Line 668: ,p_information28 in varchar2 default hr_api.g_varchar2

664: ,p_information24 in varchar2 default hr_api.g_varchar2
665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2
671: ) is
672: --

Line 669: ,p_information29 in varchar2 default hr_api.g_varchar2

665: ,p_information25 in varchar2 default hr_api.g_varchar2
666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2
671: ) is
672: --
673: l_rec hr_tpp_shd.g_rec_type;

Line 670: ,p_information30 in varchar2 default hr_api.g_varchar2

666: ,p_information26 in varchar2 default hr_api.g_varchar2
667: ,p_information27 in varchar2 default hr_api.g_varchar2
668: ,p_information28 in varchar2 default hr_api.g_varchar2
669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2
671: ) is
672: --
673: l_rec hr_tpp_shd.g_rec_type;
674: l_proc varchar2(72) := g_package||'upd';