eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ICX_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_icx_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_icx_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_icx_shd.constraint_error

Line 119: When hr_api.parent_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: hr_icx_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_icx_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_icx_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_icx_shd.constraint_error

Line 124: When hr_api.unique_integrity_violated Then

120: -- Parent integrity has been violated
121: --
122: hr_icx_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_icx_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_icx_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_ITEM_CONTEXTS'
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_ITEM_CONTEXTS'
377: ,p_hook_type => 'AU');
378: --
379: end;

Line 438: If (p_rec.id_flex_num = 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.id_flex_num = hr_api.g_number) then
439: p_rec.id_flex_num :=
440: hr_icx_shd.g_old_rec.id_flex_num;
441: End If;
442: If (p_rec.summary_flag = hr_api.g_varchar2) then

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

438: If (p_rec.id_flex_num = hr_api.g_number) then
439: p_rec.id_flex_num :=
440: hr_icx_shd.g_old_rec.id_flex_num;
441: End If;
442: If (p_rec.summary_flag = hr_api.g_varchar2) then
443: p_rec.summary_flag :=
444: hr_icx_shd.g_old_rec.summary_flag;
445: End If;
446: If (p_rec.enabled_flag = hr_api.g_varchar2) then

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

442: If (p_rec.summary_flag = hr_api.g_varchar2) then
443: p_rec.summary_flag :=
444: hr_icx_shd.g_old_rec.summary_flag;
445: End If;
446: If (p_rec.enabled_flag = hr_api.g_varchar2) then
447: p_rec.enabled_flag :=
448: hr_icx_shd.g_old_rec.enabled_flag;
449: End If;
450: If (p_rec.start_date_active = hr_api.g_date) then

Line 450: If (p_rec.start_date_active = hr_api.g_date) then

446: If (p_rec.enabled_flag = hr_api.g_varchar2) then
447: p_rec.enabled_flag :=
448: hr_icx_shd.g_old_rec.enabled_flag;
449: End If;
450: If (p_rec.start_date_active = hr_api.g_date) then
451: p_rec.start_date_active :=
452: hr_icx_shd.g_old_rec.start_date_active;
453: End If;
454: If (p_rec.end_date_active = hr_api.g_date) then

Line 454: If (p_rec.end_date_active = hr_api.g_date) then

450: If (p_rec.start_date_active = hr_api.g_date) then
451: p_rec.start_date_active :=
452: hr_icx_shd.g_old_rec.start_date_active;
453: End If;
454: If (p_rec.end_date_active = hr_api.g_date) then
455: p_rec.end_date_active :=
456: hr_icx_shd.g_old_rec.end_date_active;
457: End If;
458: If (p_rec.segment1 = hr_api.g_varchar2) then

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

454: If (p_rec.end_date_active = hr_api.g_date) then
455: p_rec.end_date_active :=
456: hr_icx_shd.g_old_rec.end_date_active;
457: End If;
458: If (p_rec.segment1 = hr_api.g_varchar2) then
459: p_rec.segment1 :=
460: hr_icx_shd.g_old_rec.segment1;
461: End If;
462: If (p_rec.segment2 = hr_api.g_varchar2) then

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

458: If (p_rec.segment1 = hr_api.g_varchar2) then
459: p_rec.segment1 :=
460: hr_icx_shd.g_old_rec.segment1;
461: End If;
462: If (p_rec.segment2 = hr_api.g_varchar2) then
463: p_rec.segment2 :=
464: hr_icx_shd.g_old_rec.segment2;
465: End If;
466: If (p_rec.segment3 = hr_api.g_varchar2) then

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

462: If (p_rec.segment2 = hr_api.g_varchar2) then
463: p_rec.segment2 :=
464: hr_icx_shd.g_old_rec.segment2;
465: End If;
466: If (p_rec.segment3 = hr_api.g_varchar2) then
467: p_rec.segment3 :=
468: hr_icx_shd.g_old_rec.segment3;
469: End If;
470: If (p_rec.segment4 = hr_api.g_varchar2) then

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

466: If (p_rec.segment3 = hr_api.g_varchar2) then
467: p_rec.segment3 :=
468: hr_icx_shd.g_old_rec.segment3;
469: End If;
470: If (p_rec.segment4 = hr_api.g_varchar2) then
471: p_rec.segment4 :=
472: hr_icx_shd.g_old_rec.segment4;
473: End If;
474: If (p_rec.segment5 = hr_api.g_varchar2) then

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

470: If (p_rec.segment4 = hr_api.g_varchar2) then
471: p_rec.segment4 :=
472: hr_icx_shd.g_old_rec.segment4;
473: End If;
474: If (p_rec.segment5 = hr_api.g_varchar2) then
475: p_rec.segment5 :=
476: hr_icx_shd.g_old_rec.segment5;
477: End If;
478: If (p_rec.segment6 = hr_api.g_varchar2) then

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

474: If (p_rec.segment5 = hr_api.g_varchar2) then
475: p_rec.segment5 :=
476: hr_icx_shd.g_old_rec.segment5;
477: End If;
478: If (p_rec.segment6 = hr_api.g_varchar2) then
479: p_rec.segment6 :=
480: hr_icx_shd.g_old_rec.segment6;
481: End If;
482: If (p_rec.segment7 = hr_api.g_varchar2) then

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

478: If (p_rec.segment6 = hr_api.g_varchar2) then
479: p_rec.segment6 :=
480: hr_icx_shd.g_old_rec.segment6;
481: End If;
482: If (p_rec.segment7 = hr_api.g_varchar2) then
483: p_rec.segment7 :=
484: hr_icx_shd.g_old_rec.segment7;
485: End If;
486: If (p_rec.segment8 = hr_api.g_varchar2) then

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

482: If (p_rec.segment7 = hr_api.g_varchar2) then
483: p_rec.segment7 :=
484: hr_icx_shd.g_old_rec.segment7;
485: End If;
486: If (p_rec.segment8 = hr_api.g_varchar2) then
487: p_rec.segment8 :=
488: hr_icx_shd.g_old_rec.segment8;
489: End If;
490: If (p_rec.segment9 = hr_api.g_varchar2) then

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

486: If (p_rec.segment8 = hr_api.g_varchar2) then
487: p_rec.segment8 :=
488: hr_icx_shd.g_old_rec.segment8;
489: End If;
490: If (p_rec.segment9 = hr_api.g_varchar2) then
491: p_rec.segment9 :=
492: hr_icx_shd.g_old_rec.segment9;
493: End If;
494: If (p_rec.segment10 = hr_api.g_varchar2) then

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

490: If (p_rec.segment9 = hr_api.g_varchar2) then
491: p_rec.segment9 :=
492: hr_icx_shd.g_old_rec.segment9;
493: End If;
494: If (p_rec.segment10 = hr_api.g_varchar2) then
495: p_rec.segment10 :=
496: hr_icx_shd.g_old_rec.segment10;
497: End If;
498: If (p_rec.segment11 = hr_api.g_varchar2) then

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

494: If (p_rec.segment10 = hr_api.g_varchar2) then
495: p_rec.segment10 :=
496: hr_icx_shd.g_old_rec.segment10;
497: End If;
498: If (p_rec.segment11 = hr_api.g_varchar2) then
499: p_rec.segment11 :=
500: hr_icx_shd.g_old_rec.segment11;
501: End If;
502: If (p_rec.segment12 = hr_api.g_varchar2) then

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

498: If (p_rec.segment11 = hr_api.g_varchar2) then
499: p_rec.segment11 :=
500: hr_icx_shd.g_old_rec.segment11;
501: End If;
502: If (p_rec.segment12 = hr_api.g_varchar2) then
503: p_rec.segment12 :=
504: hr_icx_shd.g_old_rec.segment12;
505: End If;
506: If (p_rec.segment13 = hr_api.g_varchar2) then

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

502: If (p_rec.segment12 = hr_api.g_varchar2) then
503: p_rec.segment12 :=
504: hr_icx_shd.g_old_rec.segment12;
505: End If;
506: If (p_rec.segment13 = hr_api.g_varchar2) then
507: p_rec.segment13 :=
508: hr_icx_shd.g_old_rec.segment13;
509: End If;
510: If (p_rec.segment14 = hr_api.g_varchar2) then

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

506: If (p_rec.segment13 = hr_api.g_varchar2) then
507: p_rec.segment13 :=
508: hr_icx_shd.g_old_rec.segment13;
509: End If;
510: If (p_rec.segment14 = hr_api.g_varchar2) then
511: p_rec.segment14 :=
512: hr_icx_shd.g_old_rec.segment14;
513: End If;
514: If (p_rec.segment15 = hr_api.g_varchar2) then

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

510: If (p_rec.segment14 = hr_api.g_varchar2) then
511: p_rec.segment14 :=
512: hr_icx_shd.g_old_rec.segment14;
513: End If;
514: If (p_rec.segment15 = hr_api.g_varchar2) then
515: p_rec.segment15 :=
516: hr_icx_shd.g_old_rec.segment15;
517: End If;
518: If (p_rec.segment16 = hr_api.g_varchar2) then

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

514: If (p_rec.segment15 = hr_api.g_varchar2) then
515: p_rec.segment15 :=
516: hr_icx_shd.g_old_rec.segment15;
517: End If;
518: If (p_rec.segment16 = hr_api.g_varchar2) then
519: p_rec.segment16 :=
520: hr_icx_shd.g_old_rec.segment16;
521: End If;
522: If (p_rec.segment17 = hr_api.g_varchar2) then

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

518: If (p_rec.segment16 = hr_api.g_varchar2) then
519: p_rec.segment16 :=
520: hr_icx_shd.g_old_rec.segment16;
521: End If;
522: If (p_rec.segment17 = hr_api.g_varchar2) then
523: p_rec.segment17 :=
524: hr_icx_shd.g_old_rec.segment17;
525: End If;
526: If (p_rec.segment18 = hr_api.g_varchar2) then

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

522: If (p_rec.segment17 = hr_api.g_varchar2) then
523: p_rec.segment17 :=
524: hr_icx_shd.g_old_rec.segment17;
525: End If;
526: If (p_rec.segment18 = hr_api.g_varchar2) then
527: p_rec.segment18 :=
528: hr_icx_shd.g_old_rec.segment18;
529: End If;
530: If (p_rec.segment19 = hr_api.g_varchar2) then

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

526: If (p_rec.segment18 = hr_api.g_varchar2) then
527: p_rec.segment18 :=
528: hr_icx_shd.g_old_rec.segment18;
529: End If;
530: If (p_rec.segment19 = hr_api.g_varchar2) then
531: p_rec.segment19 :=
532: hr_icx_shd.g_old_rec.segment19;
533: End If;
534: If (p_rec.segment20 = hr_api.g_varchar2) then

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

530: If (p_rec.segment19 = hr_api.g_varchar2) then
531: p_rec.segment19 :=
532: hr_icx_shd.g_old_rec.segment19;
533: End If;
534: If (p_rec.segment20 = hr_api.g_varchar2) then
535: p_rec.segment20 :=
536: hr_icx_shd.g_old_rec.segment20;
537: End If;
538: If (p_rec.segment21 = hr_api.g_varchar2) then

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

534: If (p_rec.segment20 = hr_api.g_varchar2) then
535: p_rec.segment20 :=
536: hr_icx_shd.g_old_rec.segment20;
537: End If;
538: If (p_rec.segment21 = hr_api.g_varchar2) then
539: p_rec.segment21 :=
540: hr_icx_shd.g_old_rec.segment21;
541: End If;
542: If (p_rec.segment22 = hr_api.g_varchar2) then

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

538: If (p_rec.segment21 = hr_api.g_varchar2) then
539: p_rec.segment21 :=
540: hr_icx_shd.g_old_rec.segment21;
541: End If;
542: If (p_rec.segment22 = hr_api.g_varchar2) then
543: p_rec.segment22 :=
544: hr_icx_shd.g_old_rec.segment22;
545: End If;
546: If (p_rec.segment23 = hr_api.g_varchar2) then

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

542: If (p_rec.segment22 = hr_api.g_varchar2) then
543: p_rec.segment22 :=
544: hr_icx_shd.g_old_rec.segment22;
545: End If;
546: If (p_rec.segment23 = hr_api.g_varchar2) then
547: p_rec.segment23 :=
548: hr_icx_shd.g_old_rec.segment23;
549: End If;
550: If (p_rec.segment24 = hr_api.g_varchar2) then

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

546: If (p_rec.segment23 = hr_api.g_varchar2) then
547: p_rec.segment23 :=
548: hr_icx_shd.g_old_rec.segment23;
549: End If;
550: If (p_rec.segment24 = hr_api.g_varchar2) then
551: p_rec.segment24 :=
552: hr_icx_shd.g_old_rec.segment24;
553: End If;
554: If (p_rec.segment25 = hr_api.g_varchar2) then

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

550: If (p_rec.segment24 = hr_api.g_varchar2) then
551: p_rec.segment24 :=
552: hr_icx_shd.g_old_rec.segment24;
553: End If;
554: If (p_rec.segment25 = hr_api.g_varchar2) then
555: p_rec.segment25 :=
556: hr_icx_shd.g_old_rec.segment25;
557: End If;
558: If (p_rec.segment26 = hr_api.g_varchar2) then

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

554: If (p_rec.segment25 = hr_api.g_varchar2) then
555: p_rec.segment25 :=
556: hr_icx_shd.g_old_rec.segment25;
557: End If;
558: If (p_rec.segment26 = hr_api.g_varchar2) then
559: p_rec.segment26 :=
560: hr_icx_shd.g_old_rec.segment26;
561: End If;
562: If (p_rec.segment27 = hr_api.g_varchar2) then

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

558: If (p_rec.segment26 = hr_api.g_varchar2) then
559: p_rec.segment26 :=
560: hr_icx_shd.g_old_rec.segment26;
561: End If;
562: If (p_rec.segment27 = hr_api.g_varchar2) then
563: p_rec.segment27 :=
564: hr_icx_shd.g_old_rec.segment27;
565: End If;
566: If (p_rec.segment28 = hr_api.g_varchar2) then

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

562: If (p_rec.segment27 = hr_api.g_varchar2) then
563: p_rec.segment27 :=
564: hr_icx_shd.g_old_rec.segment27;
565: End If;
566: If (p_rec.segment28 = hr_api.g_varchar2) then
567: p_rec.segment28 :=
568: hr_icx_shd.g_old_rec.segment28;
569: End If;
570: If (p_rec.segment29 = hr_api.g_varchar2) then

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

566: If (p_rec.segment28 = hr_api.g_varchar2) then
567: p_rec.segment28 :=
568: hr_icx_shd.g_old_rec.segment28;
569: End If;
570: If (p_rec.segment29 = hr_api.g_varchar2) then
571: p_rec.segment29 :=
572: hr_icx_shd.g_old_rec.segment29;
573: End If;
574: If (p_rec.segment30 = hr_api.g_varchar2) then

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

570: If (p_rec.segment29 = hr_api.g_varchar2) then
571: p_rec.segment29 :=
572: hr_icx_shd.g_old_rec.segment29;
573: End If;
574: If (p_rec.segment30 = hr_api.g_varchar2) then
575: p_rec.segment30 :=
576: hr_icx_shd.g_old_rec.segment30;
577: End If;
578: --

Line 587: (p_segment1 in varchar2 default hr_api.g_varchar2,

583: -- |-------------------------------< upd_or_sel >-----------------------------|
584: -- ----------------------------------------------------------------------------
585: --
586: procedure upd_or_sel
587: (p_segment1 in varchar2 default hr_api.g_varchar2,
588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,

Line 588: p_segment2 in varchar2 default hr_api.g_varchar2,

584: -- ----------------------------------------------------------------------------
585: --
586: procedure upd_or_sel
587: (p_segment1 in varchar2 default hr_api.g_varchar2,
588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,

Line 589: p_segment3 in varchar2 default hr_api.g_varchar2,

585: --
586: procedure upd_or_sel
587: (p_segment1 in varchar2 default hr_api.g_varchar2,
588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,

Line 590: p_segment4 in varchar2 default hr_api.g_varchar2,

586: procedure upd_or_sel
587: (p_segment1 in varchar2 default hr_api.g_varchar2,
588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,

Line 591: p_segment5 in varchar2 default hr_api.g_varchar2,

587: (p_segment1 in varchar2 default hr_api.g_varchar2,
588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,

Line 592: p_segment6 in varchar2 default hr_api.g_varchar2,

588: p_segment2 in varchar2 default hr_api.g_varchar2,
589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,

Line 593: p_segment7 in varchar2 default hr_api.g_varchar2,

589: p_segment3 in varchar2 default hr_api.g_varchar2,
590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,

Line 594: p_segment8 in varchar2 default hr_api.g_varchar2,

590: p_segment4 in varchar2 default hr_api.g_varchar2,
591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,

Line 595: p_segment9 in varchar2 default hr_api.g_varchar2,

591: p_segment5 in varchar2 default hr_api.g_varchar2,
592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,

Line 596: p_segment10 in varchar2 default hr_api.g_varchar2,

592: p_segment6 in varchar2 default hr_api.g_varchar2,
593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,

Line 597: p_segment11 in varchar2 default hr_api.g_varchar2,

593: p_segment7 in varchar2 default hr_api.g_varchar2,
594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,

Line 598: p_segment12 in varchar2 default hr_api.g_varchar2,

594: p_segment8 in varchar2 default hr_api.g_varchar2,
595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,

Line 599: p_segment13 in varchar2 default hr_api.g_varchar2,

595: p_segment9 in varchar2 default hr_api.g_varchar2,
596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,

Line 600: p_segment14 in varchar2 default hr_api.g_varchar2,

596: p_segment10 in varchar2 default hr_api.g_varchar2,
597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,

Line 601: p_segment15 in varchar2 default hr_api.g_varchar2,

597: p_segment11 in varchar2 default hr_api.g_varchar2,
598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,

Line 602: p_segment16 in varchar2 default hr_api.g_varchar2,

598: p_segment12 in varchar2 default hr_api.g_varchar2,
599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,

Line 603: p_segment17 in varchar2 default hr_api.g_varchar2,

599: p_segment13 in varchar2 default hr_api.g_varchar2,
600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,

Line 604: p_segment18 in varchar2 default hr_api.g_varchar2,

600: p_segment14 in varchar2 default hr_api.g_varchar2,
601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,

Line 605: p_segment19 in varchar2 default hr_api.g_varchar2,

601: p_segment15 in varchar2 default hr_api.g_varchar2,
602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,

Line 606: p_segment20 in varchar2 default hr_api.g_varchar2,

602: p_segment16 in varchar2 default hr_api.g_varchar2,
603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,

Line 607: p_segment21 in varchar2 default hr_api.g_varchar2,

603: p_segment17 in varchar2 default hr_api.g_varchar2,
604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,

Line 608: p_segment22 in varchar2 default hr_api.g_varchar2,

604: p_segment18 in varchar2 default hr_api.g_varchar2,
605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,

Line 609: p_segment23 in varchar2 default hr_api.g_varchar2,

605: p_segment19 in varchar2 default hr_api.g_varchar2,
606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,

Line 610: p_segment24 in varchar2 default hr_api.g_varchar2,

606: p_segment20 in varchar2 default hr_api.g_varchar2,
607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,

Line 611: p_segment25 in varchar2 default hr_api.g_varchar2,

607: p_segment21 in varchar2 default hr_api.g_varchar2,
608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,

Line 612: p_segment26 in varchar2 default hr_api.g_varchar2,

608: p_segment22 in varchar2 default hr_api.g_varchar2,
609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,

Line 613: p_segment27 in varchar2 default hr_api.g_varchar2,

609: p_segment23 in varchar2 default hr_api.g_varchar2,
610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,
617: p_context_type in varchar2 default hr_api.g_varchar2,

Line 614: p_segment28 in varchar2 default hr_api.g_varchar2,

610: p_segment24 in varchar2 default hr_api.g_varchar2,
611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,
617: p_context_type in varchar2 default hr_api.g_varchar2,
618: p_item_context_id in out nocopy number,

Line 615: p_segment29 in varchar2 default hr_api.g_varchar2,

611: p_segment25 in varchar2 default hr_api.g_varchar2,
612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,
617: p_context_type in varchar2 default hr_api.g_varchar2,
618: p_item_context_id in out nocopy number,
619: p_object_version_number in out nocopy number,

Line 616: p_segment30 in varchar2 default hr_api.g_varchar2,

612: p_segment26 in varchar2 default hr_api.g_varchar2,
613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,
617: p_context_type in varchar2 default hr_api.g_varchar2,
618: p_item_context_id in out nocopy number,
619: p_object_version_number in out nocopy number,
620: p_concatenated_segments out nocopy varchar2

Line 617: p_context_type in varchar2 default hr_api.g_varchar2,

613: p_segment27 in varchar2 default hr_api.g_varchar2,
614: p_segment28 in varchar2 default hr_api.g_varchar2,
615: p_segment29 in varchar2 default hr_api.g_varchar2,
616: p_segment30 in varchar2 default hr_api.g_varchar2,
617: p_context_type in varchar2 default hr_api.g_varchar2,
618: p_item_context_id in out nocopy number,
619: p_object_version_number in out nocopy number,
620: p_concatenated_segments out nocopy varchar2
621: ) is

Line 647: If ((l_rec.segment1 = hr_api.g_varchar2) AND

643: FETCH cur_id_flex INTO l_id_flex_num;
644: CLOSE cur_id_flex;
645: --
646: -- Derive if any segments are changing
647: If ((l_rec.segment1 = hr_api.g_varchar2) AND
648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND

Line 648: (l_rec.segment2 = hr_api.g_varchar2) AND

644: CLOSE cur_id_flex;
645: --
646: -- Derive if any segments are changing
647: If ((l_rec.segment1 = hr_api.g_varchar2) AND
648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND

Line 649: (l_rec.segment3 = hr_api.g_varchar2) AND

645: --
646: -- Derive if any segments are changing
647: If ((l_rec.segment1 = hr_api.g_varchar2) AND
648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND

Line 650: (l_rec.segment4 = hr_api.g_varchar2) AND

646: -- Derive if any segments are changing
647: If ((l_rec.segment1 = hr_api.g_varchar2) AND
648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND

Line 651: (l_rec.segment5 = hr_api.g_varchar2) AND

647: If ((l_rec.segment1 = hr_api.g_varchar2) AND
648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND

Line 652: (l_rec.segment6 = hr_api.g_varchar2) AND

648: (l_rec.segment2 = hr_api.g_varchar2) AND
649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND

Line 653: (l_rec.segment7 = hr_api.g_varchar2) AND

649: (l_rec.segment3 = hr_api.g_varchar2) AND
650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND

Line 654: (l_rec.segment8 = hr_api.g_varchar2) AND

650: (l_rec.segment4 = hr_api.g_varchar2) AND
651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND

Line 655: (l_rec.segment9 = hr_api.g_varchar2) AND

651: (l_rec.segment5 = hr_api.g_varchar2) AND
652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND

Line 656: (l_rec.segment10 = hr_api.g_varchar2) AND

652: (l_rec.segment6 = hr_api.g_varchar2) AND
653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND

Line 657: (l_rec.segment11 = hr_api.g_varchar2) AND

653: (l_rec.segment7 = hr_api.g_varchar2) AND
654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND

Line 658: (l_rec.segment12 = hr_api.g_varchar2) AND

654: (l_rec.segment8 = hr_api.g_varchar2) AND
655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND

Line 659: (l_rec.segment13 = hr_api.g_varchar2) AND

655: (l_rec.segment9 = hr_api.g_varchar2) AND
656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND

Line 660: (l_rec.segment14 = hr_api.g_varchar2) AND

656: (l_rec.segment10 = hr_api.g_varchar2) AND
657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND

Line 661: (l_rec.segment15 = hr_api.g_varchar2) AND

657: (l_rec.segment11 = hr_api.g_varchar2) AND
658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND

Line 662: (l_rec.segment16 = hr_api.g_varchar2) AND

658: (l_rec.segment12 = hr_api.g_varchar2) AND
659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND

Line 663: (l_rec.segment17 = hr_api.g_varchar2) AND

659: (l_rec.segment13 = hr_api.g_varchar2) AND
660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND

Line 664: (l_rec.segment18 = hr_api.g_varchar2) AND

660: (l_rec.segment14 = hr_api.g_varchar2) AND
661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND

Line 665: (l_rec.segment19 = hr_api.g_varchar2) AND

661: (l_rec.segment15 = hr_api.g_varchar2) AND
662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND

Line 666: (l_rec.segment20 = hr_api.g_varchar2) AND

662: (l_rec.segment16 = hr_api.g_varchar2) AND
663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND

Line 667: (l_rec.segment21 = hr_api.g_varchar2) AND

663: (l_rec.segment17 = hr_api.g_varchar2) AND
664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND

Line 668: (l_rec.segment22 = hr_api.g_varchar2) AND

664: (l_rec.segment18 = hr_api.g_varchar2) AND
665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND

Line 669: (l_rec.segment23 = hr_api.g_varchar2) AND

665: (l_rec.segment19 = hr_api.g_varchar2) AND
666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND

Line 670: (l_rec.segment24 = hr_api.g_varchar2) AND

666: (l_rec.segment20 = hr_api.g_varchar2) AND
667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND

Line 671: (l_rec.segment25 = hr_api.g_varchar2) AND

667: (l_rec.segment21 = hr_api.g_varchar2) AND
668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND

Line 672: (l_rec.segment26 = hr_api.g_varchar2) AND

668: (l_rec.segment22 = hr_api.g_varchar2) AND
669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND
676: (l_rec.segment30 = hr_api.g_varchar2)) THEN

Line 673: (l_rec.segment27 = hr_api.g_varchar2) AND

669: (l_rec.segment23 = hr_api.g_varchar2) AND
670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND
676: (l_rec.segment30 = hr_api.g_varchar2)) THEN
677: l_segs_changed := true;

Line 674: (l_rec.segment28 = hr_api.g_varchar2) AND

670: (l_rec.segment24 = hr_api.g_varchar2) AND
671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND
676: (l_rec.segment30 = hr_api.g_varchar2)) THEN
677: l_segs_changed := true;
678: Else

Line 675: (l_rec.segment29 = hr_api.g_varchar2) AND

671: (l_rec.segment25 = hr_api.g_varchar2) AND
672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND
676: (l_rec.segment30 = hr_api.g_varchar2)) THEN
677: l_segs_changed := true;
678: Else
679: l_segs_changed := false;

Line 676: (l_rec.segment30 = hr_api.g_varchar2)) THEN

672: (l_rec.segment26 = hr_api.g_varchar2) AND
673: (l_rec.segment27 = hr_api.g_varchar2) AND
674: (l_rec.segment28 = hr_api.g_varchar2) AND
675: (l_rec.segment29 = hr_api.g_varchar2) AND
676: (l_rec.segment30 = hr_api.g_varchar2)) THEN
677: l_segs_changed := true;
678: Else
679: l_segs_changed := false;
680: End if;

Line 683: If (p_context_type = hr_api.g_varchar2)

679: l_segs_changed := false;
680: End if;
681: --
682: -- Do not need to go any further if there is nothing to do.
683: If (p_context_type = hr_api.g_varchar2)
684: AND (l_segs_changed = false) THEN
685: --
686: -- nothing to do
687: p_concatenated_segments := null;

Line 755: if (l_rec.segment1 = hr_api.g_varchar2) then

751: -- arguments if they are using a system default value
752: -- to null otherwise the segments will have the system default
753: -- values when being inserted
754: --
755: if (l_rec.segment1 = hr_api.g_varchar2) then
756: l_rec.segment1 := null;
757: end if;
758: if (l_rec.segment2 = hr_api.g_varchar2) then
759: l_rec.segment2 := null;

Line 758: if (l_rec.segment2 = hr_api.g_varchar2) then

754: --
755: if (l_rec.segment1 = hr_api.g_varchar2) then
756: l_rec.segment1 := null;
757: end if;
758: if (l_rec.segment2 = hr_api.g_varchar2) then
759: l_rec.segment2 := null;
760: end if;
761: if (l_rec.segment3 = hr_api.g_varchar2) then
762: l_rec.segment3 := null;

Line 761: if (l_rec.segment3 = hr_api.g_varchar2) then

757: end if;
758: if (l_rec.segment2 = hr_api.g_varchar2) then
759: l_rec.segment2 := null;
760: end if;
761: if (l_rec.segment3 = hr_api.g_varchar2) then
762: l_rec.segment3 := null;
763: end if;
764: if (l_rec.segment4 = hr_api.g_varchar2) then
765: l_rec.segment4 := null;

Line 764: if (l_rec.segment4 = hr_api.g_varchar2) then

760: end if;
761: if (l_rec.segment3 = hr_api.g_varchar2) then
762: l_rec.segment3 := null;
763: end if;
764: if (l_rec.segment4 = hr_api.g_varchar2) then
765: l_rec.segment4 := null;
766: end if;
767: if (l_rec.segment5 = hr_api.g_varchar2) then
768: l_rec.segment5 := null;

Line 767: if (l_rec.segment5 = hr_api.g_varchar2) then

763: end if;
764: if (l_rec.segment4 = hr_api.g_varchar2) then
765: l_rec.segment4 := null;
766: end if;
767: if (l_rec.segment5 = hr_api.g_varchar2) then
768: l_rec.segment5 := null;
769: end if;
770: if (l_rec.segment6 = hr_api.g_varchar2) then
771: l_rec.segment6 := null;

Line 770: if (l_rec.segment6 = hr_api.g_varchar2) then

766: end if;
767: if (l_rec.segment5 = hr_api.g_varchar2) then
768: l_rec.segment5 := null;
769: end if;
770: if (l_rec.segment6 = hr_api.g_varchar2) then
771: l_rec.segment6 := null;
772: end if;
773: if (l_rec.segment7 = hr_api.g_varchar2) then
774: l_rec.segment7 := null;

Line 773: if (l_rec.segment7 = hr_api.g_varchar2) then

769: end if;
770: if (l_rec.segment6 = hr_api.g_varchar2) then
771: l_rec.segment6 := null;
772: end if;
773: if (l_rec.segment7 = hr_api.g_varchar2) then
774: l_rec.segment7 := null;
775: end if;
776: if (l_rec.segment8 = hr_api.g_varchar2) then
777: l_rec.segment8 := null;

Line 776: if (l_rec.segment8 = hr_api.g_varchar2) then

772: end if;
773: if (l_rec.segment7 = hr_api.g_varchar2) then
774: l_rec.segment7 := null;
775: end if;
776: if (l_rec.segment8 = hr_api.g_varchar2) then
777: l_rec.segment8 := null;
778: end if;
779: if (l_rec.segment9 = hr_api.g_varchar2) then
780: l_rec.segment9 := null;

Line 779: if (l_rec.segment9 = hr_api.g_varchar2) then

775: end if;
776: if (l_rec.segment8 = hr_api.g_varchar2) then
777: l_rec.segment8 := null;
778: end if;
779: if (l_rec.segment9 = hr_api.g_varchar2) then
780: l_rec.segment9 := null;
781: end if;
782: if (l_rec.segment10 = hr_api.g_varchar2) then
783: l_rec.segment10 := null;

Line 782: if (l_rec.segment10 = hr_api.g_varchar2) then

778: end if;
779: if (l_rec.segment9 = hr_api.g_varchar2) then
780: l_rec.segment9 := null;
781: end if;
782: if (l_rec.segment10 = hr_api.g_varchar2) then
783: l_rec.segment10 := null;
784: end if;
785: if (l_rec.segment11 = hr_api.g_varchar2) then
786: l_rec.segment11 := null;

Line 785: if (l_rec.segment11 = hr_api.g_varchar2) then

781: end if;
782: if (l_rec.segment10 = hr_api.g_varchar2) then
783: l_rec.segment10 := null;
784: end if;
785: if (l_rec.segment11 = hr_api.g_varchar2) then
786: l_rec.segment11 := null;
787: end if;
788: if (l_rec.segment12 = hr_api.g_varchar2) then
789: l_rec.segment12 := null;

Line 788: if (l_rec.segment12 = hr_api.g_varchar2) then

784: end if;
785: if (l_rec.segment11 = hr_api.g_varchar2) then
786: l_rec.segment11 := null;
787: end if;
788: if (l_rec.segment12 = hr_api.g_varchar2) then
789: l_rec.segment12 := null;
790: end if;
791: if (l_rec.segment13 = hr_api.g_varchar2) then
792: l_rec.segment13 := null;

Line 791: if (l_rec.segment13 = hr_api.g_varchar2) then

787: end if;
788: if (l_rec.segment12 = hr_api.g_varchar2) then
789: l_rec.segment12 := null;
790: end if;
791: if (l_rec.segment13 = hr_api.g_varchar2) then
792: l_rec.segment13 := null;
793: end if;
794: if (l_rec.segment14 = hr_api.g_varchar2) then
795: l_rec.segment14 := null;

Line 794: if (l_rec.segment14 = hr_api.g_varchar2) then

790: end if;
791: if (l_rec.segment13 = hr_api.g_varchar2) then
792: l_rec.segment13 := null;
793: end if;
794: if (l_rec.segment14 = hr_api.g_varchar2) then
795: l_rec.segment14 := null;
796: end if;
797: if (l_rec.segment15 = hr_api.g_varchar2) then
798: l_rec.segment15 := null;

Line 797: if (l_rec.segment15 = hr_api.g_varchar2) then

793: end if;
794: if (l_rec.segment14 = hr_api.g_varchar2) then
795: l_rec.segment14 := null;
796: end if;
797: if (l_rec.segment15 = hr_api.g_varchar2) then
798: l_rec.segment15 := null;
799: end if;
800: if (l_rec.segment16 = hr_api.g_varchar2) then
801: l_rec.segment16 := null;

Line 800: if (l_rec.segment16 = hr_api.g_varchar2) then

796: end if;
797: if (l_rec.segment15 = hr_api.g_varchar2) then
798: l_rec.segment15 := null;
799: end if;
800: if (l_rec.segment16 = hr_api.g_varchar2) then
801: l_rec.segment16 := null;
802: end if;
803: if (l_rec.segment17 = hr_api.g_varchar2) then
804: l_rec.segment17 := null;

Line 803: if (l_rec.segment17 = hr_api.g_varchar2) then

799: end if;
800: if (l_rec.segment16 = hr_api.g_varchar2) then
801: l_rec.segment16 := null;
802: end if;
803: if (l_rec.segment17 = hr_api.g_varchar2) then
804: l_rec.segment17 := null;
805: end if;
806: if (l_rec.segment18 = hr_api.g_varchar2) then
807: l_rec.segment18 := null;

Line 806: if (l_rec.segment18 = hr_api.g_varchar2) then

802: end if;
803: if (l_rec.segment17 = hr_api.g_varchar2) then
804: l_rec.segment17 := null;
805: end if;
806: if (l_rec.segment18 = hr_api.g_varchar2) then
807: l_rec.segment18 := null;
808: end if;
809: if (l_rec.segment19 = hr_api.g_varchar2) then
810: l_rec.segment19 := null;

Line 809: if (l_rec.segment19 = hr_api.g_varchar2) then

805: end if;
806: if (l_rec.segment18 = hr_api.g_varchar2) then
807: l_rec.segment18 := null;
808: end if;
809: if (l_rec.segment19 = hr_api.g_varchar2) then
810: l_rec.segment19 := null;
811: end if;
812: if (l_rec.segment20 = hr_api.g_varchar2) then
813: l_rec.segment20 := null;

Line 812: if (l_rec.segment20 = hr_api.g_varchar2) then

808: end if;
809: if (l_rec.segment19 = hr_api.g_varchar2) then
810: l_rec.segment19 := null;
811: end if;
812: if (l_rec.segment20 = hr_api.g_varchar2) then
813: l_rec.segment20 := null;
814: end if;
815: if (l_rec.segment21 = hr_api.g_varchar2) then
816: l_rec.segment21 := null;

Line 815: if (l_rec.segment21 = hr_api.g_varchar2) then

811: end if;
812: if (l_rec.segment20 = hr_api.g_varchar2) then
813: l_rec.segment20 := null;
814: end if;
815: if (l_rec.segment21 = hr_api.g_varchar2) then
816: l_rec.segment21 := null;
817: end if;
818: if (l_rec.segment22 = hr_api.g_varchar2) then
819: l_rec.segment22 := null;

Line 818: if (l_rec.segment22 = hr_api.g_varchar2) then

814: end if;
815: if (l_rec.segment21 = hr_api.g_varchar2) then
816: l_rec.segment21 := null;
817: end if;
818: if (l_rec.segment22 = hr_api.g_varchar2) then
819: l_rec.segment22 := null;
820: end if;
821: if (l_rec.segment23 = hr_api.g_varchar2) then
822: l_rec.segment23 := null;

Line 821: if (l_rec.segment23 = hr_api.g_varchar2) then

817: end if;
818: if (l_rec.segment22 = hr_api.g_varchar2) then
819: l_rec.segment22 := null;
820: end if;
821: if (l_rec.segment23 = hr_api.g_varchar2) then
822: l_rec.segment23 := null;
823: end if;
824: if (l_rec.segment24 = hr_api.g_varchar2) then
825: l_rec.segment24 := null;

Line 824: if (l_rec.segment24 = hr_api.g_varchar2) then

820: end if;
821: if (l_rec.segment23 = hr_api.g_varchar2) then
822: l_rec.segment23 := null;
823: end if;
824: if (l_rec.segment24 = hr_api.g_varchar2) then
825: l_rec.segment24 := null;
826: end if;
827: if (l_rec.segment25 = hr_api.g_varchar2) then
828: l_rec.segment25 := null;

Line 827: if (l_rec.segment25 = hr_api.g_varchar2) then

823: end if;
824: if (l_rec.segment24 = hr_api.g_varchar2) then
825: l_rec.segment24 := null;
826: end if;
827: if (l_rec.segment25 = hr_api.g_varchar2) then
828: l_rec.segment25 := null;
829: end if;
830: if (l_rec.segment26 = hr_api.g_varchar2) then
831: l_rec.segment26 := null;

Line 830: if (l_rec.segment26 = hr_api.g_varchar2) then

826: end if;
827: if (l_rec.segment25 = hr_api.g_varchar2) then
828: l_rec.segment25 := null;
829: end if;
830: if (l_rec.segment26 = hr_api.g_varchar2) then
831: l_rec.segment26 := null;
832: end if;
833: if (l_rec.segment27 = hr_api.g_varchar2) then
834: l_rec.segment27 := null;

Line 833: if (l_rec.segment27 = hr_api.g_varchar2) then

829: end if;
830: if (l_rec.segment26 = hr_api.g_varchar2) then
831: l_rec.segment26 := null;
832: end if;
833: if (l_rec.segment27 = hr_api.g_varchar2) then
834: l_rec.segment27 := null;
835: end if;
836: if (l_rec.segment28 = hr_api.g_varchar2) then
837: l_rec.segment28 := null;

Line 836: if (l_rec.segment28 = hr_api.g_varchar2) then

832: end if;
833: if (l_rec.segment27 = hr_api.g_varchar2) then
834: l_rec.segment27 := null;
835: end if;
836: if (l_rec.segment28 = hr_api.g_varchar2) then
837: l_rec.segment28 := null;
838: end if;
839: if (l_rec.segment29 = hr_api.g_varchar2) then
840: l_rec.segment29 := null;

Line 839: if (l_rec.segment29 = hr_api.g_varchar2) then

835: end if;
836: if (l_rec.segment28 = hr_api.g_varchar2) then
837: l_rec.segment28 := null;
838: end if;
839: if (l_rec.segment29 = hr_api.g_varchar2) then
840: l_rec.segment29 := null;
841: end if;
842: if (l_rec.segment30 = hr_api.g_varchar2) then
843: l_rec.segment30 := null;

Line 842: if (l_rec.segment30 = hr_api.g_varchar2) then

838: end if;
839: if (l_rec.segment29 = hr_api.g_varchar2) then
840: l_rec.segment29 := null;
841: end if;
842: if (l_rec.segment30 = hr_api.g_varchar2) then
843: l_rec.segment30 := null;
844: end if;
845: if (p_context_type = hr_api.g_varchar2) then
846: l_context_type := null;

Line 845: if (p_context_type = hr_api.g_varchar2) then

841: end if;
842: if (l_rec.segment30 = hr_api.g_varchar2) then
843: l_rec.segment30 := null;
844: end if;
845: if (p_context_type = hr_api.g_varchar2) then
846: l_context_type := null;
847: else
848: l_context_type := p_context_type;
849: end if;

Line 956: ,p_id_flex_num in number default hr_api.g_number

952: Procedure upd
953: (p_effective_date in date
954: ,p_object_version_number in out nocopy number
955: ,p_item_context_id in number
956: ,p_id_flex_num in number default hr_api.g_number
957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date

Line 957: ,p_summary_flag in varchar2 default hr_api.g_varchar2

953: (p_effective_date in date
954: ,p_object_version_number in out nocopy number
955: ,p_item_context_id in number
956: ,p_id_flex_num in number default hr_api.g_number
957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

954: ,p_object_version_number in out nocopy number
955: ,p_item_context_id in number
956: ,p_id_flex_num in number default hr_api.g_number
957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 959: ,p_start_date_active in date default hr_api.g_date

955: ,p_item_context_id in number
956: ,p_id_flex_num in number default hr_api.g_number
957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 960: ,p_end_date_active in date default hr_api.g_date

956: ,p_id_flex_num in number default hr_api.g_number
957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 961: ,p_segment1 in varchar2 default hr_api.g_varchar2

957: ,p_summary_flag in varchar2 default hr_api.g_varchar2
958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 962: ,p_segment2 in varchar2 default hr_api.g_varchar2

958: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 963: ,p_segment3 in varchar2 default hr_api.g_varchar2

959: ,p_start_date_active in date default hr_api.g_date
960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 964: ,p_segment4 in varchar2 default hr_api.g_varchar2

960: ,p_end_date_active in date default hr_api.g_date
961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 965: ,p_segment5 in varchar2 default hr_api.g_varchar2

961: ,p_segment1 in varchar2 default hr_api.g_varchar2
962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 966: ,p_segment6 in varchar2 default hr_api.g_varchar2

962: ,p_segment2 in varchar2 default hr_api.g_varchar2
963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 967: ,p_segment7 in varchar2 default hr_api.g_varchar2

963: ,p_segment3 in varchar2 default hr_api.g_varchar2
964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 968: ,p_segment8 in varchar2 default hr_api.g_varchar2

964: ,p_segment4 in varchar2 default hr_api.g_varchar2
965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 969: ,p_segment9 in varchar2 default hr_api.g_varchar2

965: ,p_segment5 in varchar2 default hr_api.g_varchar2
966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 970: ,p_segment10 in varchar2 default hr_api.g_varchar2

966: ,p_segment6 in varchar2 default hr_api.g_varchar2
967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 971: ,p_segment11 in varchar2 default hr_api.g_varchar2

967: ,p_segment7 in varchar2 default hr_api.g_varchar2
968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 972: ,p_segment12 in varchar2 default hr_api.g_varchar2

968: ,p_segment8 in varchar2 default hr_api.g_varchar2
969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 973: ,p_segment13 in varchar2 default hr_api.g_varchar2

969: ,p_segment9 in varchar2 default hr_api.g_varchar2
970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 974: ,p_segment14 in varchar2 default hr_api.g_varchar2

970: ,p_segment10 in varchar2 default hr_api.g_varchar2
971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 975: ,p_segment15 in varchar2 default hr_api.g_varchar2

971: ,p_segment11 in varchar2 default hr_api.g_varchar2
972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 976: ,p_segment16 in varchar2 default hr_api.g_varchar2

972: ,p_segment12 in varchar2 default hr_api.g_varchar2
973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 977: ,p_segment17 in varchar2 default hr_api.g_varchar2

973: ,p_segment13 in varchar2 default hr_api.g_varchar2
974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 978: ,p_segment18 in varchar2 default hr_api.g_varchar2

974: ,p_segment14 in varchar2 default hr_api.g_varchar2
975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 979: ,p_segment19 in varchar2 default hr_api.g_varchar2

975: ,p_segment15 in varchar2 default hr_api.g_varchar2
976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 980: ,p_segment20 in varchar2 default hr_api.g_varchar2

976: ,p_segment16 in varchar2 default hr_api.g_varchar2
977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 981: ,p_segment21 in varchar2 default hr_api.g_varchar2

977: ,p_segment17 in varchar2 default hr_api.g_varchar2
978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 982: ,p_segment22 in varchar2 default hr_api.g_varchar2

978: ,p_segment18 in varchar2 default hr_api.g_varchar2
979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 983: ,p_segment23 in varchar2 default hr_api.g_varchar2

979: ,p_segment19 in varchar2 default hr_api.g_varchar2
980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 984: ,p_segment24 in varchar2 default hr_api.g_varchar2

980: ,p_segment20 in varchar2 default hr_api.g_varchar2
981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 985: ,p_segment25 in varchar2 default hr_api.g_varchar2

981: ,p_segment21 in varchar2 default hr_api.g_varchar2
982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 986: ,p_segment26 in varchar2 default hr_api.g_varchar2

982: ,p_segment22 in varchar2 default hr_api.g_varchar2
983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 987: ,p_segment27 in varchar2 default hr_api.g_varchar2

983: ,p_segment23 in varchar2 default hr_api.g_varchar2
984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2
991: ) is

Line 988: ,p_segment28 in varchar2 default hr_api.g_varchar2

984: ,p_segment24 in varchar2 default hr_api.g_varchar2
985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2
991: ) is
992: --

Line 989: ,p_segment29 in varchar2 default hr_api.g_varchar2

985: ,p_segment25 in varchar2 default hr_api.g_varchar2
986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2
991: ) is
992: --
993: l_rec hr_icx_shd.g_rec_type;

Line 990: ,p_segment30 in varchar2 default hr_api.g_varchar2

986: ,p_segment26 in varchar2 default hr_api.g_varchar2
987: ,p_segment27 in varchar2 default hr_api.g_varchar2
988: ,p_segment28 in varchar2 default hr_api.g_varchar2
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2
991: ) is
992: --
993: l_rec hr_icx_shd.g_rec_type;
994: l_proc varchar2(72) := g_package||'upd';