APPS.HR_CTX_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

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

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

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

Line 117: When hr_api.parent_integrity_violated Then

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

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

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

Line 122: When hr_api.unique_integrity_violated Then

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

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

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

Line 353: when hr_api.cannot_find_prog_unit then

349: );
350: --
351: exception
352: --
353: when hr_api.cannot_find_prog_unit then
354: --
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'HR_KI_CONTEXTS'
357: ,p_hook_type => 'AU');

Line 355: hr_api.cannot_find_prog_unit_error

351: exception
352: --
353: when hr_api.cannot_find_prog_unit then
354: --
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'HR_KI_CONTEXTS'
357: ,p_hook_type => 'AU');
358: --
359: end;

Line 418: If (p_rec.view_name = hr_api.g_varchar2) then

414: -- p_rec plsql record structure
415: -- to see if a system default is being used. If a system default
416: -- is being used then we must set to the 'current' argument value.
417: --
418: If (p_rec.view_name = hr_api.g_varchar2) then
419: p_rec.view_name :=
420: hr_ctx_shd.g_old_rec.view_name;
421: End If;
422: If (p_rec.param_1 = hr_api.g_varchar2) then

Line 422: If (p_rec.param_1 = hr_api.g_varchar2) then

418: If (p_rec.view_name = hr_api.g_varchar2) then
419: p_rec.view_name :=
420: hr_ctx_shd.g_old_rec.view_name;
421: End If;
422: If (p_rec.param_1 = hr_api.g_varchar2) then
423: p_rec.param_1 :=
424: hr_ctx_shd.g_old_rec.param_1;
425: End If;
426: If (p_rec.param_2 = hr_api.g_varchar2) then

Line 426: If (p_rec.param_2 = hr_api.g_varchar2) then

422: If (p_rec.param_1 = hr_api.g_varchar2) then
423: p_rec.param_1 :=
424: hr_ctx_shd.g_old_rec.param_1;
425: End If;
426: If (p_rec.param_2 = hr_api.g_varchar2) then
427: p_rec.param_2 :=
428: hr_ctx_shd.g_old_rec.param_2;
429: End If;
430: If (p_rec.param_3 = hr_api.g_varchar2) then

Line 430: If (p_rec.param_3 = hr_api.g_varchar2) then

426: If (p_rec.param_2 = hr_api.g_varchar2) then
427: p_rec.param_2 :=
428: hr_ctx_shd.g_old_rec.param_2;
429: End If;
430: If (p_rec.param_3 = hr_api.g_varchar2) then
431: p_rec.param_3 :=
432: hr_ctx_shd.g_old_rec.param_3;
433: End If;
434: If (p_rec.param_4 = hr_api.g_varchar2) then

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

430: If (p_rec.param_3 = hr_api.g_varchar2) then
431: p_rec.param_3 :=
432: hr_ctx_shd.g_old_rec.param_3;
433: End If;
434: If (p_rec.param_4 = hr_api.g_varchar2) then
435: p_rec.param_4 :=
436: hr_ctx_shd.g_old_rec.param_4;
437: End If;
438: If (p_rec.param_5 = hr_api.g_varchar2) then

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

434: If (p_rec.param_4 = hr_api.g_varchar2) then
435: p_rec.param_4 :=
436: hr_ctx_shd.g_old_rec.param_4;
437: End If;
438: If (p_rec.param_5 = hr_api.g_varchar2) then
439: p_rec.param_5 :=
440: hr_ctx_shd.g_old_rec.param_5;
441: End If;
442: If (p_rec.param_6 = hr_api.g_varchar2) then

Line 442: If (p_rec.param_6 = hr_api.g_varchar2) then

438: If (p_rec.param_5 = hr_api.g_varchar2) then
439: p_rec.param_5 :=
440: hr_ctx_shd.g_old_rec.param_5;
441: End If;
442: If (p_rec.param_6 = hr_api.g_varchar2) then
443: p_rec.param_6 :=
444: hr_ctx_shd.g_old_rec.param_6;
445: End If;
446: If (p_rec.param_7 = hr_api.g_varchar2) then

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

442: If (p_rec.param_6 = hr_api.g_varchar2) then
443: p_rec.param_6 :=
444: hr_ctx_shd.g_old_rec.param_6;
445: End If;
446: If (p_rec.param_7 = hr_api.g_varchar2) then
447: p_rec.param_7 :=
448: hr_ctx_shd.g_old_rec.param_7;
449: End If;
450: If (p_rec.param_8 = hr_api.g_varchar2) then

Line 450: If (p_rec.param_8 = hr_api.g_varchar2) then

446: If (p_rec.param_7 = hr_api.g_varchar2) then
447: p_rec.param_7 :=
448: hr_ctx_shd.g_old_rec.param_7;
449: End If;
450: If (p_rec.param_8 = hr_api.g_varchar2) then
451: p_rec.param_8 :=
452: hr_ctx_shd.g_old_rec.param_8;
453: End If;
454: If (p_rec.param_9 = hr_api.g_varchar2) then

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

450: If (p_rec.param_8 = hr_api.g_varchar2) then
451: p_rec.param_8 :=
452: hr_ctx_shd.g_old_rec.param_8;
453: End If;
454: If (p_rec.param_9 = hr_api.g_varchar2) then
455: p_rec.param_9 :=
456: hr_ctx_shd.g_old_rec.param_9;
457: End If;
458: If (p_rec.param_10 = hr_api.g_varchar2) then

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

454: If (p_rec.param_9 = hr_api.g_varchar2) then
455: p_rec.param_9 :=
456: hr_ctx_shd.g_old_rec.param_9;
457: End If;
458: If (p_rec.param_10 = hr_api.g_varchar2) then
459: p_rec.param_10 :=
460: hr_ctx_shd.g_old_rec.param_10;
461: End If;
462: If (p_rec.param_11 = hr_api.g_varchar2) then

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

458: If (p_rec.param_10 = hr_api.g_varchar2) then
459: p_rec.param_10 :=
460: hr_ctx_shd.g_old_rec.param_10;
461: End If;
462: If (p_rec.param_11 = hr_api.g_varchar2) then
463: p_rec.param_11 :=
464: hr_ctx_shd.g_old_rec.param_11;
465: End If;
466: If (p_rec.param_12 = hr_api.g_varchar2) then

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

462: If (p_rec.param_11 = hr_api.g_varchar2) then
463: p_rec.param_11 :=
464: hr_ctx_shd.g_old_rec.param_11;
465: End If;
466: If (p_rec.param_12 = hr_api.g_varchar2) then
467: p_rec.param_12 :=
468: hr_ctx_shd.g_old_rec.param_12;
469: End If;
470: If (p_rec.param_13 = hr_api.g_varchar2) then

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

466: If (p_rec.param_12 = hr_api.g_varchar2) then
467: p_rec.param_12 :=
468: hr_ctx_shd.g_old_rec.param_12;
469: End If;
470: If (p_rec.param_13 = hr_api.g_varchar2) then
471: p_rec.param_13 :=
472: hr_ctx_shd.g_old_rec.param_13;
473: End If;
474: If (p_rec.param_14 = hr_api.g_varchar2) then

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

470: If (p_rec.param_13 = hr_api.g_varchar2) then
471: p_rec.param_13 :=
472: hr_ctx_shd.g_old_rec.param_13;
473: End If;
474: If (p_rec.param_14 = hr_api.g_varchar2) then
475: p_rec.param_14 :=
476: hr_ctx_shd.g_old_rec.param_14;
477: End If;
478: If (p_rec.param_15 = hr_api.g_varchar2) then

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

474: If (p_rec.param_14 = hr_api.g_varchar2) then
475: p_rec.param_14 :=
476: hr_ctx_shd.g_old_rec.param_14;
477: End If;
478: If (p_rec.param_15 = hr_api.g_varchar2) then
479: p_rec.param_15 :=
480: hr_ctx_shd.g_old_rec.param_15;
481: End If;
482: If (p_rec.param_16 = hr_api.g_varchar2) then

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

478: If (p_rec.param_15 = hr_api.g_varchar2) then
479: p_rec.param_15 :=
480: hr_ctx_shd.g_old_rec.param_15;
481: End If;
482: If (p_rec.param_16 = hr_api.g_varchar2) then
483: p_rec.param_16 :=
484: hr_ctx_shd.g_old_rec.param_16;
485: End If;
486: If (p_rec.param_17 = hr_api.g_varchar2) then

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

482: If (p_rec.param_16 = hr_api.g_varchar2) then
483: p_rec.param_16 :=
484: hr_ctx_shd.g_old_rec.param_16;
485: End If;
486: If (p_rec.param_17 = hr_api.g_varchar2) then
487: p_rec.param_17 :=
488: hr_ctx_shd.g_old_rec.param_17;
489: End If;
490: If (p_rec.param_18 = hr_api.g_varchar2) then

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

486: If (p_rec.param_17 = hr_api.g_varchar2) then
487: p_rec.param_17 :=
488: hr_ctx_shd.g_old_rec.param_17;
489: End If;
490: If (p_rec.param_18 = hr_api.g_varchar2) then
491: p_rec.param_18 :=
492: hr_ctx_shd.g_old_rec.param_18;
493: End If;
494: If (p_rec.param_19 = hr_api.g_varchar2) then

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

490: If (p_rec.param_18 = hr_api.g_varchar2) then
491: p_rec.param_18 :=
492: hr_ctx_shd.g_old_rec.param_18;
493: End If;
494: If (p_rec.param_19 = hr_api.g_varchar2) then
495: p_rec.param_19 :=
496: hr_ctx_shd.g_old_rec.param_19;
497: End If;
498: If (p_rec.param_20 = hr_api.g_varchar2) then

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

494: If (p_rec.param_19 = hr_api.g_varchar2) then
495: p_rec.param_19 :=
496: hr_ctx_shd.g_old_rec.param_19;
497: End If;
498: If (p_rec.param_20 = hr_api.g_varchar2) then
499: p_rec.param_20 :=
500: hr_ctx_shd.g_old_rec.param_20;
501: End If;
502: If (p_rec.param_21 = hr_api.g_varchar2) then

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

498: If (p_rec.param_20 = hr_api.g_varchar2) then
499: p_rec.param_20 :=
500: hr_ctx_shd.g_old_rec.param_20;
501: End If;
502: If (p_rec.param_21 = hr_api.g_varchar2) then
503: p_rec.param_21 :=
504: hr_ctx_shd.g_old_rec.param_21;
505: End If;
506: If (p_rec.param_22 = hr_api.g_varchar2) then

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

502: If (p_rec.param_21 = hr_api.g_varchar2) then
503: p_rec.param_21 :=
504: hr_ctx_shd.g_old_rec.param_21;
505: End If;
506: If (p_rec.param_22 = hr_api.g_varchar2) then
507: p_rec.param_22 :=
508: hr_ctx_shd.g_old_rec.param_22;
509: End If;
510: If (p_rec.param_23 = hr_api.g_varchar2) then

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

506: If (p_rec.param_22 = hr_api.g_varchar2) then
507: p_rec.param_22 :=
508: hr_ctx_shd.g_old_rec.param_22;
509: End If;
510: If (p_rec.param_23 = hr_api.g_varchar2) then
511: p_rec.param_23 :=
512: hr_ctx_shd.g_old_rec.param_23;
513: End If;
514: If (p_rec.param_24 = hr_api.g_varchar2) then

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

510: If (p_rec.param_23 = hr_api.g_varchar2) then
511: p_rec.param_23 :=
512: hr_ctx_shd.g_old_rec.param_23;
513: End If;
514: If (p_rec.param_24 = hr_api.g_varchar2) then
515: p_rec.param_24 :=
516: hr_ctx_shd.g_old_rec.param_24;
517: End If;
518: If (p_rec.param_25 = hr_api.g_varchar2) then

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

514: If (p_rec.param_24 = hr_api.g_varchar2) then
515: p_rec.param_24 :=
516: hr_ctx_shd.g_old_rec.param_24;
517: End If;
518: If (p_rec.param_25 = hr_api.g_varchar2) then
519: p_rec.param_25 :=
520: hr_ctx_shd.g_old_rec.param_25;
521: End If;
522: If (p_rec.param_26 = hr_api.g_varchar2) then

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

518: If (p_rec.param_25 = hr_api.g_varchar2) then
519: p_rec.param_25 :=
520: hr_ctx_shd.g_old_rec.param_25;
521: End If;
522: If (p_rec.param_26 = hr_api.g_varchar2) then
523: p_rec.param_26 :=
524: hr_ctx_shd.g_old_rec.param_26;
525: End If;
526: If (p_rec.param_27 = hr_api.g_varchar2) then

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

522: If (p_rec.param_26 = hr_api.g_varchar2) then
523: p_rec.param_26 :=
524: hr_ctx_shd.g_old_rec.param_26;
525: End If;
526: If (p_rec.param_27 = hr_api.g_varchar2) then
527: p_rec.param_27 :=
528: hr_ctx_shd.g_old_rec.param_27;
529: End If;
530: If (p_rec.param_28 = hr_api.g_varchar2) then

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

526: If (p_rec.param_27 = hr_api.g_varchar2) then
527: p_rec.param_27 :=
528: hr_ctx_shd.g_old_rec.param_27;
529: End If;
530: If (p_rec.param_28 = hr_api.g_varchar2) then
531: p_rec.param_28 :=
532: hr_ctx_shd.g_old_rec.param_28;
533: End If;
534: If (p_rec.param_29 = hr_api.g_varchar2) then

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

530: If (p_rec.param_28 = hr_api.g_varchar2) then
531: p_rec.param_28 :=
532: hr_ctx_shd.g_old_rec.param_28;
533: End If;
534: If (p_rec.param_29 = hr_api.g_varchar2) then
535: p_rec.param_29 :=
536: hr_ctx_shd.g_old_rec.param_29;
537: End If;
538: If (p_rec.param_30 = hr_api.g_varchar2) then

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

534: If (p_rec.param_29 = hr_api.g_varchar2) then
535: p_rec.param_29 :=
536: hr_ctx_shd.g_old_rec.param_29;
537: End If;
538: If (p_rec.param_30 = hr_api.g_varchar2) then
539: p_rec.param_30 :=
540: hr_ctx_shd.g_old_rec.param_30;
541: End If;
542: --

Line 602: ,p_view_name in varchar2 default hr_api.g_varchar2

598: -- ----------------------------------------------------------------------------
599: Procedure upd
600: (p_context_id in number
601: ,p_object_version_number in out nocopy number
602: ,p_view_name in varchar2 default hr_api.g_varchar2
603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2

Line 603: ,p_param_1 in varchar2 default hr_api.g_varchar2

599: Procedure upd
600: (p_context_id in number
601: ,p_object_version_number in out nocopy number
602: ,p_view_name in varchar2 default hr_api.g_varchar2
603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2

Line 604: ,p_param_2 in varchar2 default hr_api.g_varchar2

600: (p_context_id in number
601: ,p_object_version_number in out nocopy number
602: ,p_view_name in varchar2 default hr_api.g_varchar2
603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2

Line 605: ,p_param_3 in varchar2 default hr_api.g_varchar2

601: ,p_object_version_number in out nocopy number
602: ,p_view_name in varchar2 default hr_api.g_varchar2
603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2

Line 606: ,p_param_4 in varchar2 default hr_api.g_varchar2

602: ,p_view_name in varchar2 default hr_api.g_varchar2
603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2

Line 607: ,p_param_5 in varchar2 default hr_api.g_varchar2

603: ,p_param_1 in varchar2 default hr_api.g_varchar2
604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2

Line 608: ,p_param_6 in varchar2 default hr_api.g_varchar2

604: ,p_param_2 in varchar2 default hr_api.g_varchar2
605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2

Line 609: ,p_param_7 in varchar2 default hr_api.g_varchar2

605: ,p_param_3 in varchar2 default hr_api.g_varchar2
606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2

Line 610: ,p_param_8 in varchar2 default hr_api.g_varchar2

606: ,p_param_4 in varchar2 default hr_api.g_varchar2
607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2

Line 611: ,p_param_9 in varchar2 default hr_api.g_varchar2

607: ,p_param_5 in varchar2 default hr_api.g_varchar2
608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2

Line 612: ,p_param_10 in varchar2 default hr_api.g_varchar2

608: ,p_param_6 in varchar2 default hr_api.g_varchar2
609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2

Line 613: ,p_param_11 in varchar2 default hr_api.g_varchar2

609: ,p_param_7 in varchar2 default hr_api.g_varchar2
610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2

Line 614: ,p_param_12 in varchar2 default hr_api.g_varchar2

610: ,p_param_8 in varchar2 default hr_api.g_varchar2
611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2

Line 615: ,p_param_13 in varchar2 default hr_api.g_varchar2

611: ,p_param_9 in varchar2 default hr_api.g_varchar2
612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2

Line 616: ,p_param_14 in varchar2 default hr_api.g_varchar2

612: ,p_param_10 in varchar2 default hr_api.g_varchar2
613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2

Line 617: ,p_param_15 in varchar2 default hr_api.g_varchar2

613: ,p_param_11 in varchar2 default hr_api.g_varchar2
614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2

Line 618: ,p_param_16 in varchar2 default hr_api.g_varchar2

614: ,p_param_12 in varchar2 default hr_api.g_varchar2
615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2

Line 619: ,p_param_17 in varchar2 default hr_api.g_varchar2

615: ,p_param_13 in varchar2 default hr_api.g_varchar2
616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2

Line 620: ,p_param_18 in varchar2 default hr_api.g_varchar2

616: ,p_param_14 in varchar2 default hr_api.g_varchar2
617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2

Line 621: ,p_param_19 in varchar2 default hr_api.g_varchar2

617: ,p_param_15 in varchar2 default hr_api.g_varchar2
618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2

Line 622: ,p_param_20 in varchar2 default hr_api.g_varchar2

618: ,p_param_16 in varchar2 default hr_api.g_varchar2
619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2

Line 623: ,p_param_21 in varchar2 default hr_api.g_varchar2

619: ,p_param_17 in varchar2 default hr_api.g_varchar2
620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2

Line 624: ,p_param_22 in varchar2 default hr_api.g_varchar2

620: ,p_param_18 in varchar2 default hr_api.g_varchar2
621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2

Line 625: ,p_param_23 in varchar2 default hr_api.g_varchar2

621: ,p_param_19 in varchar2 default hr_api.g_varchar2
622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2

Line 626: ,p_param_24 in varchar2 default hr_api.g_varchar2

622: ,p_param_20 in varchar2 default hr_api.g_varchar2
623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2

Line 627: ,p_param_25 in varchar2 default hr_api.g_varchar2

623: ,p_param_21 in varchar2 default hr_api.g_varchar2
624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2

Line 628: ,p_param_26 in varchar2 default hr_api.g_varchar2

624: ,p_param_22 in varchar2 default hr_api.g_varchar2
625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2

Line 629: ,p_param_27 in varchar2 default hr_api.g_varchar2

625: ,p_param_23 in varchar2 default hr_api.g_varchar2
626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2
633: ) is

Line 630: ,p_param_28 in varchar2 default hr_api.g_varchar2

626: ,p_param_24 in varchar2 default hr_api.g_varchar2
627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2
633: ) is
634: --

Line 631: ,p_param_29 in varchar2 default hr_api.g_varchar2

627: ,p_param_25 in varchar2 default hr_api.g_varchar2
628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2
633: ) is
634: --
635: l_rec hr_ctx_shd.g_rec_type;

Line 632: ,p_param_30 in varchar2 default hr_api.g_varchar2

628: ,p_param_26 in varchar2 default hr_api.g_varchar2
629: ,p_param_27 in varchar2 default hr_api.g_varchar2
630: ,p_param_28 in varchar2 default hr_api.g_varchar2
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2
633: ) is
634: --
635: l_rec hr_ctx_shd.g_rec_type;
636: l_proc varchar2(72) := g_package||'upd';