DBA Data[Home] [Help]

APPS.HR_WNP_UPD dependencies on HR_API

Line 115: When hr_api.check_integrity_violated Then

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

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

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

Line 120: When hr_api.parent_integrity_violated Then

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

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

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

Line 125: When hr_api.unique_integrity_violated Then

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

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

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

Line 376: when hr_api.cannot_find_prog_unit then

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

Line 378: hr_api.cannot_find_prog_unit_error

374: exception
375: --
376: when hr_api.cannot_find_prog_unit then
377: --
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'HR_WINDOW_PROPERTIES_B'
380: ,p_hook_type => 'AU');
381: --
382: end;

Line 441: If (p_rec.form_window_id = hr_api.g_number) then

437: -- p_rec plsql record structure
438: -- to see if a system default is being used. If a system default
439: -- is being used then we must set to the 'current' argument value.
440: --
441: If (p_rec.form_window_id = hr_api.g_number) then
442: p_rec.form_window_id :=
443: hr_wnp_shd.g_old_rec.form_window_id;
444: End If;
445: If (p_rec.template_window_id = hr_api.g_number) then

Line 445: If (p_rec.template_window_id = hr_api.g_number) then

441: If (p_rec.form_window_id = hr_api.g_number) then
442: p_rec.form_window_id :=
443: hr_wnp_shd.g_old_rec.form_window_id;
444: End If;
445: If (p_rec.template_window_id = hr_api.g_number) then
446: p_rec.template_window_id :=
447: hr_wnp_shd.g_old_rec.template_window_id;
448: End If;
449: If (p_rec.height = hr_api.g_number) then

Line 449: If (p_rec.height = hr_api.g_number) then

445: If (p_rec.template_window_id = hr_api.g_number) then
446: p_rec.template_window_id :=
447: hr_wnp_shd.g_old_rec.template_window_id;
448: End If;
449: If (p_rec.height = hr_api.g_number) then
450: p_rec.height :=
451: hr_wnp_shd.g_old_rec.height;
452: End If;
453: If (p_rec.width = hr_api.g_number) then

Line 453: If (p_rec.width = hr_api.g_number) then

449: If (p_rec.height = hr_api.g_number) then
450: p_rec.height :=
451: hr_wnp_shd.g_old_rec.height;
452: End If;
453: If (p_rec.width = hr_api.g_number) then
454: p_rec.width :=
455: hr_wnp_shd.g_old_rec.width;
456: End If;
457: If (p_rec.x_position = hr_api.g_number) then

Line 457: If (p_rec.x_position = hr_api.g_number) then

453: If (p_rec.width = hr_api.g_number) then
454: p_rec.width :=
455: hr_wnp_shd.g_old_rec.width;
456: End If;
457: If (p_rec.x_position = hr_api.g_number) then
458: p_rec.x_position :=
459: hr_wnp_shd.g_old_rec.x_position;
460: End If;
461: If (p_rec.y_position = hr_api.g_number) then

Line 461: If (p_rec.y_position = hr_api.g_number) then

457: If (p_rec.x_position = hr_api.g_number) then
458: p_rec.x_position :=
459: hr_wnp_shd.g_old_rec.x_position;
460: End If;
461: If (p_rec.y_position = hr_api.g_number) then
462: p_rec.y_position :=
463: hr_wnp_shd.g_old_rec.y_position;
464: End If;
465: If (p_rec.information_category = hr_api.g_varchar2) then

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

461: If (p_rec.y_position = hr_api.g_number) then
462: p_rec.y_position :=
463: hr_wnp_shd.g_old_rec.y_position;
464: End If;
465: If (p_rec.information_category = hr_api.g_varchar2) then
466: p_rec.information_category :=
467: hr_wnp_shd.g_old_rec.information_category;
468: End If;
469: If (p_rec.information1 = hr_api.g_varchar2) then

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

465: If (p_rec.information_category = hr_api.g_varchar2) then
466: p_rec.information_category :=
467: hr_wnp_shd.g_old_rec.information_category;
468: End If;
469: If (p_rec.information1 = hr_api.g_varchar2) then
470: p_rec.information1 :=
471: hr_wnp_shd.g_old_rec.information1;
472: End If;
473: If (p_rec.information2 = hr_api.g_varchar2) then

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

469: If (p_rec.information1 = hr_api.g_varchar2) then
470: p_rec.information1 :=
471: hr_wnp_shd.g_old_rec.information1;
472: End If;
473: If (p_rec.information2 = hr_api.g_varchar2) then
474: p_rec.information2 :=
475: hr_wnp_shd.g_old_rec.information2;
476: End If;
477: If (p_rec.information3 = hr_api.g_varchar2) then

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

473: If (p_rec.information2 = hr_api.g_varchar2) then
474: p_rec.information2 :=
475: hr_wnp_shd.g_old_rec.information2;
476: End If;
477: If (p_rec.information3 = hr_api.g_varchar2) then
478: p_rec.information3 :=
479: hr_wnp_shd.g_old_rec.information3;
480: End If;
481: If (p_rec.information4 = hr_api.g_varchar2) then

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

477: If (p_rec.information3 = hr_api.g_varchar2) then
478: p_rec.information3 :=
479: hr_wnp_shd.g_old_rec.information3;
480: End If;
481: If (p_rec.information4 = hr_api.g_varchar2) then
482: p_rec.information4 :=
483: hr_wnp_shd.g_old_rec.information4;
484: End If;
485: If (p_rec.information5 = hr_api.g_varchar2) then

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

481: If (p_rec.information4 = hr_api.g_varchar2) then
482: p_rec.information4 :=
483: hr_wnp_shd.g_old_rec.information4;
484: End If;
485: If (p_rec.information5 = hr_api.g_varchar2) then
486: p_rec.information5 :=
487: hr_wnp_shd.g_old_rec.information5;
488: End If;
489: If (p_rec.information6 = hr_api.g_varchar2) then

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

485: If (p_rec.information5 = hr_api.g_varchar2) then
486: p_rec.information5 :=
487: hr_wnp_shd.g_old_rec.information5;
488: End If;
489: If (p_rec.information6 = hr_api.g_varchar2) then
490: p_rec.information6 :=
491: hr_wnp_shd.g_old_rec.information6;
492: End If;
493: If (p_rec.information7 = hr_api.g_varchar2) then

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

489: If (p_rec.information6 = hr_api.g_varchar2) then
490: p_rec.information6 :=
491: hr_wnp_shd.g_old_rec.information6;
492: End If;
493: If (p_rec.information7 = hr_api.g_varchar2) then
494: p_rec.information7 :=
495: hr_wnp_shd.g_old_rec.information7;
496: End If;
497: If (p_rec.information8 = hr_api.g_varchar2) then

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

493: If (p_rec.information7 = hr_api.g_varchar2) then
494: p_rec.information7 :=
495: hr_wnp_shd.g_old_rec.information7;
496: End If;
497: If (p_rec.information8 = hr_api.g_varchar2) then
498: p_rec.information8 :=
499: hr_wnp_shd.g_old_rec.information8;
500: End If;
501: If (p_rec.information9 = hr_api.g_varchar2) then

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

497: If (p_rec.information8 = hr_api.g_varchar2) then
498: p_rec.information8 :=
499: hr_wnp_shd.g_old_rec.information8;
500: End If;
501: If (p_rec.information9 = hr_api.g_varchar2) then
502: p_rec.information9 :=
503: hr_wnp_shd.g_old_rec.information9;
504: End If;
505: If (p_rec.information10 = hr_api.g_varchar2) then

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

501: If (p_rec.information9 = hr_api.g_varchar2) then
502: p_rec.information9 :=
503: hr_wnp_shd.g_old_rec.information9;
504: End If;
505: If (p_rec.information10 = hr_api.g_varchar2) then
506: p_rec.information10 :=
507: hr_wnp_shd.g_old_rec.information10;
508: End If;
509: If (p_rec.information11 = hr_api.g_varchar2) then

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

505: If (p_rec.information10 = hr_api.g_varchar2) then
506: p_rec.information10 :=
507: hr_wnp_shd.g_old_rec.information10;
508: End If;
509: If (p_rec.information11 = hr_api.g_varchar2) then
510: p_rec.information11 :=
511: hr_wnp_shd.g_old_rec.information11;
512: End If;
513: If (p_rec.information12 = hr_api.g_varchar2) then

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

509: If (p_rec.information11 = hr_api.g_varchar2) then
510: p_rec.information11 :=
511: hr_wnp_shd.g_old_rec.information11;
512: End If;
513: If (p_rec.information12 = hr_api.g_varchar2) then
514: p_rec.information12 :=
515: hr_wnp_shd.g_old_rec.information12;
516: End If;
517: If (p_rec.information13 = hr_api.g_varchar2) then

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

513: If (p_rec.information12 = hr_api.g_varchar2) then
514: p_rec.information12 :=
515: hr_wnp_shd.g_old_rec.information12;
516: End If;
517: If (p_rec.information13 = hr_api.g_varchar2) then
518: p_rec.information13 :=
519: hr_wnp_shd.g_old_rec.information13;
520: End If;
521: If (p_rec.information14 = hr_api.g_varchar2) then

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

517: If (p_rec.information13 = hr_api.g_varchar2) then
518: p_rec.information13 :=
519: hr_wnp_shd.g_old_rec.information13;
520: End If;
521: If (p_rec.information14 = hr_api.g_varchar2) then
522: p_rec.information14 :=
523: hr_wnp_shd.g_old_rec.information14;
524: End If;
525: If (p_rec.information15 = hr_api.g_varchar2) then

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

521: If (p_rec.information14 = hr_api.g_varchar2) then
522: p_rec.information14 :=
523: hr_wnp_shd.g_old_rec.information14;
524: End If;
525: If (p_rec.information15 = hr_api.g_varchar2) then
526: p_rec.information15 :=
527: hr_wnp_shd.g_old_rec.information15;
528: End If;
529: If (p_rec.information16 = hr_api.g_varchar2) then

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

525: If (p_rec.information15 = hr_api.g_varchar2) then
526: p_rec.information15 :=
527: hr_wnp_shd.g_old_rec.information15;
528: End If;
529: If (p_rec.information16 = hr_api.g_varchar2) then
530: p_rec.information16 :=
531: hr_wnp_shd.g_old_rec.information16;
532: End If;
533: If (p_rec.information17 = hr_api.g_varchar2) then

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

529: If (p_rec.information16 = hr_api.g_varchar2) then
530: p_rec.information16 :=
531: hr_wnp_shd.g_old_rec.information16;
532: End If;
533: If (p_rec.information17 = hr_api.g_varchar2) then
534: p_rec.information17 :=
535: hr_wnp_shd.g_old_rec.information17;
536: End If;
537: If (p_rec.information18 = hr_api.g_varchar2) then

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

533: If (p_rec.information17 = hr_api.g_varchar2) then
534: p_rec.information17 :=
535: hr_wnp_shd.g_old_rec.information17;
536: End If;
537: If (p_rec.information18 = hr_api.g_varchar2) then
538: p_rec.information18 :=
539: hr_wnp_shd.g_old_rec.information18;
540: End If;
541: If (p_rec.information19 = hr_api.g_varchar2) then

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

537: If (p_rec.information18 = hr_api.g_varchar2) then
538: p_rec.information18 :=
539: hr_wnp_shd.g_old_rec.information18;
540: End If;
541: If (p_rec.information19 = hr_api.g_varchar2) then
542: p_rec.information19 :=
543: hr_wnp_shd.g_old_rec.information19;
544: End If;
545: If (p_rec.information20 = hr_api.g_varchar2) then

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

541: If (p_rec.information19 = hr_api.g_varchar2) then
542: p_rec.information19 :=
543: hr_wnp_shd.g_old_rec.information19;
544: End If;
545: If (p_rec.information20 = hr_api.g_varchar2) then
546: p_rec.information20 :=
547: hr_wnp_shd.g_old_rec.information20;
548: End If;
549: If (p_rec.information21 = hr_api.g_varchar2) then

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

545: If (p_rec.information20 = hr_api.g_varchar2) then
546: p_rec.information20 :=
547: hr_wnp_shd.g_old_rec.information20;
548: End If;
549: If (p_rec.information21 = hr_api.g_varchar2) then
550: p_rec.information21 :=
551: hr_wnp_shd.g_old_rec.information21;
552: End If;
553: If (p_rec.information22 = hr_api.g_varchar2) then

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

549: If (p_rec.information21 = hr_api.g_varchar2) then
550: p_rec.information21 :=
551: hr_wnp_shd.g_old_rec.information21;
552: End If;
553: If (p_rec.information22 = hr_api.g_varchar2) then
554: p_rec.information22 :=
555: hr_wnp_shd.g_old_rec.information22;
556: End If;
557: If (p_rec.information23 = hr_api.g_varchar2) then

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

553: If (p_rec.information22 = hr_api.g_varchar2) then
554: p_rec.information22 :=
555: hr_wnp_shd.g_old_rec.information22;
556: End If;
557: If (p_rec.information23 = hr_api.g_varchar2) then
558: p_rec.information23 :=
559: hr_wnp_shd.g_old_rec.information23;
560: End If;
561: If (p_rec.information24 = hr_api.g_varchar2) then

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

557: If (p_rec.information23 = hr_api.g_varchar2) then
558: p_rec.information23 :=
559: hr_wnp_shd.g_old_rec.information23;
560: End If;
561: If (p_rec.information24 = hr_api.g_varchar2) then
562: p_rec.information24 :=
563: hr_wnp_shd.g_old_rec.information24;
564: End If;
565: If (p_rec.information25 = hr_api.g_varchar2) then

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

561: If (p_rec.information24 = hr_api.g_varchar2) then
562: p_rec.information24 :=
563: hr_wnp_shd.g_old_rec.information24;
564: End If;
565: If (p_rec.information25 = hr_api.g_varchar2) then
566: p_rec.information25 :=
567: hr_wnp_shd.g_old_rec.information25;
568: End If;
569: If (p_rec.information26 = hr_api.g_varchar2) then

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

565: If (p_rec.information25 = hr_api.g_varchar2) then
566: p_rec.information25 :=
567: hr_wnp_shd.g_old_rec.information25;
568: End If;
569: If (p_rec.information26 = hr_api.g_varchar2) then
570: p_rec.information26 :=
571: hr_wnp_shd.g_old_rec.information26;
572: End If;
573: If (p_rec.information27 = hr_api.g_varchar2) then

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

569: If (p_rec.information26 = hr_api.g_varchar2) then
570: p_rec.information26 :=
571: hr_wnp_shd.g_old_rec.information26;
572: End If;
573: If (p_rec.information27 = hr_api.g_varchar2) then
574: p_rec.information27 :=
575: hr_wnp_shd.g_old_rec.information27;
576: End If;
577: If (p_rec.information28 = hr_api.g_varchar2) then

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

573: If (p_rec.information27 = hr_api.g_varchar2) then
574: p_rec.information27 :=
575: hr_wnp_shd.g_old_rec.information27;
576: End If;
577: If (p_rec.information28 = hr_api.g_varchar2) then
578: p_rec.information28 :=
579: hr_wnp_shd.g_old_rec.information28;
580: End If;
581: If (p_rec.information29 = hr_api.g_varchar2) then

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

577: If (p_rec.information28 = hr_api.g_varchar2) then
578: p_rec.information28 :=
579: hr_wnp_shd.g_old_rec.information28;
580: End If;
581: If (p_rec.information29 = hr_api.g_varchar2) then
582: p_rec.information29 :=
583: hr_wnp_shd.g_old_rec.information29;
584: End If;
585: If (p_rec.information30 = hr_api.g_varchar2) then

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

581: If (p_rec.information29 = hr_api.g_varchar2) then
582: p_rec.information29 :=
583: hr_wnp_shd.g_old_rec.information29;
584: End If;
585: If (p_rec.information30 = hr_api.g_varchar2) then
586: p_rec.information30 :=
587: hr_wnp_shd.g_old_rec.information30;
588: End If;
589: --

Line 641: ,p_form_window_id in number default hr_api.g_number

637: -- |---------------------------------< upd >----------------------------------|
638: -- ----------------------------------------------------------------------------
639: Procedure upd
640: (p_window_property_id in number
641: ,p_form_window_id in number default hr_api.g_number
642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number

Line 642: ,p_template_window_id in number default hr_api.g_number

638: -- ----------------------------------------------------------------------------
639: Procedure upd
640: (p_window_property_id in number
641: ,p_form_window_id in number default hr_api.g_number
642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number

Line 643: ,p_height in number default hr_api.g_number

639: Procedure upd
640: (p_window_property_id in number
641: ,p_form_window_id in number default hr_api.g_number
642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 644: ,p_width in number default hr_api.g_number

640: (p_window_property_id in number
641: ,p_form_window_id in number default hr_api.g_number
642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 645: ,p_x_position in number default hr_api.g_number

641: ,p_form_window_id in number default hr_api.g_number
642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 646: ,p_y_position in number default hr_api.g_number

642: ,p_template_window_id in number default hr_api.g_number
643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 647: ,p_information_category in varchar2 default hr_api.g_varchar2

643: ,p_height in number default hr_api.g_number
644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 648: ,p_information1 in varchar2 default hr_api.g_varchar2

644: ,p_width in number default hr_api.g_number
645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 649: ,p_information2 in varchar2 default hr_api.g_varchar2

645: ,p_x_position in number default hr_api.g_number
646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 650: ,p_information3 in varchar2 default hr_api.g_varchar2

646: ,p_y_position in number default hr_api.g_number
647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 651: ,p_information4 in varchar2 default hr_api.g_varchar2

647: ,p_information_category in varchar2 default hr_api.g_varchar2
648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 652: ,p_information5 in varchar2 default hr_api.g_varchar2

648: ,p_information1 in varchar2 default hr_api.g_varchar2
649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 653: ,p_information6 in varchar2 default hr_api.g_varchar2

649: ,p_information2 in varchar2 default hr_api.g_varchar2
650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 654: ,p_information7 in varchar2 default hr_api.g_varchar2

650: ,p_information3 in varchar2 default hr_api.g_varchar2
651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 655: ,p_information8 in varchar2 default hr_api.g_varchar2

651: ,p_information4 in varchar2 default hr_api.g_varchar2
652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 656: ,p_information9 in varchar2 default hr_api.g_varchar2

652: ,p_information5 in varchar2 default hr_api.g_varchar2
653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 657: ,p_information10 in varchar2 default hr_api.g_varchar2

653: ,p_information6 in varchar2 default hr_api.g_varchar2
654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 658: ,p_information11 in varchar2 default hr_api.g_varchar2

654: ,p_information7 in varchar2 default hr_api.g_varchar2
655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 659: ,p_information12 in varchar2 default hr_api.g_varchar2

655: ,p_information8 in varchar2 default hr_api.g_varchar2
656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 660: ,p_information13 in varchar2 default hr_api.g_varchar2

656: ,p_information9 in varchar2 default hr_api.g_varchar2
657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 661: ,p_information14 in varchar2 default hr_api.g_varchar2

657: ,p_information10 in varchar2 default hr_api.g_varchar2
658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 662: ,p_information15 in varchar2 default hr_api.g_varchar2

658: ,p_information11 in varchar2 default hr_api.g_varchar2
659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 663: ,p_information16 in varchar2 default hr_api.g_varchar2

659: ,p_information12 in varchar2 default hr_api.g_varchar2
660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 664: ,p_information17 in varchar2 default hr_api.g_varchar2

660: ,p_information13 in varchar2 default hr_api.g_varchar2
661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 665: ,p_information18 in varchar2 default hr_api.g_varchar2

661: ,p_information14 in varchar2 default hr_api.g_varchar2
662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 666: ,p_information19 in varchar2 default hr_api.g_varchar2

662: ,p_information15 in varchar2 default hr_api.g_varchar2
663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 667: ,p_information20 in varchar2 default hr_api.g_varchar2

663: ,p_information16 in varchar2 default hr_api.g_varchar2
664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 668: ,p_information21 in varchar2 default hr_api.g_varchar2

664: ,p_information17 in varchar2 default hr_api.g_varchar2
665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 669: ,p_information22 in varchar2 default hr_api.g_varchar2

665: ,p_information18 in varchar2 default hr_api.g_varchar2
666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 670: ,p_information23 in varchar2 default hr_api.g_varchar2

666: ,p_information19 in varchar2 default hr_api.g_varchar2
667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 671: ,p_information24 in varchar2 default hr_api.g_varchar2

667: ,p_information20 in varchar2 default hr_api.g_varchar2
668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 672: ,p_information25 in varchar2 default hr_api.g_varchar2

668: ,p_information21 in varchar2 default hr_api.g_varchar2
669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 673: ,p_information26 in varchar2 default hr_api.g_varchar2

669: ,p_information22 in varchar2 default hr_api.g_varchar2
670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 674: ,p_information27 in varchar2 default hr_api.g_varchar2

670: ,p_information23 in varchar2 default hr_api.g_varchar2
671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2
678: ) is

Line 675: ,p_information28 in varchar2 default hr_api.g_varchar2

671: ,p_information24 in varchar2 default hr_api.g_varchar2
672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2
678: ) is
679: --

Line 676: ,p_information29 in varchar2 default hr_api.g_varchar2

672: ,p_information25 in varchar2 default hr_api.g_varchar2
673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2
678: ) is
679: --
680: l_rec hr_wnp_shd.g_rec_type;

Line 677: ,p_information30 in varchar2 default hr_api.g_varchar2

673: ,p_information26 in varchar2 default hr_api.g_varchar2
674: ,p_information27 in varchar2 default hr_api.g_varchar2
675: ,p_information28 in varchar2 default hr_api.g_varchar2
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2
678: ) is
679: --
680: l_rec hr_wnp_shd.g_rec_type;
681: l_proc varchar2(72) := g_package||'upd';