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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;
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';