APPS.PER_POS_UPD dependencies on HR_API

Line 123: When hr_api.check_integrity_violated Then

119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: --
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error

Line 128: When hr_api.parent_integrity_violated Then

124: -- A check constraint has been violated
125: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error

Line 133: When hr_api.unique_integrity_violated Then

129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: per_pos_shd.g_api_dml := false; -- Unset the api dml status
140: Raise;
141: End update_dml;

Line 362: when hr_api.cannot_find_prog_unit then

358: ,p_object_version_number_o
359: => per_pos_shd.g_old_rec.object_version_number
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error
364: (p_module_name => 'PER_POSITIONS'
365: ,p_hook_type => 'AU'
366: );

Line 363: hr_api.cannot_find_prog_unit_error

359: => per_pos_shd.g_old_rec.object_version_number
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error
364: (p_module_name => 'PER_POSITIONS'
365: ,p_hook_type => 'AU'
366: );
367: end;

Line 430: If (p_rec.business_group_id = hr_api.g_number) then

426: -- p_rec plsql record structure
427: -- to see if a system default is being used. If a system default
428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_pos_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.job_id = hr_api.g_number) then

Line 434: If (p_rec.job_id = hr_api.g_number) then

430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_pos_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.job_id = hr_api.g_number) then
435: p_rec.job_id :=
436: per_pos_shd.g_old_rec.job_id;
437: End If;
438: If (p_rec.organization_id = hr_api.g_number) then

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

434: If (p_rec.job_id = hr_api.g_number) then
435: p_rec.job_id :=
436: per_pos_shd.g_old_rec.job_id;
437: End If;
438: If (p_rec.organization_id = hr_api.g_number) then
439: p_rec.organization_id :=
440: per_pos_shd.g_old_rec.organization_id;
441: End If;
442: If (p_rec.successor_position_id = hr_api.g_number) then

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

438: If (p_rec.organization_id = hr_api.g_number) then
439: p_rec.organization_id :=
440: per_pos_shd.g_old_rec.organization_id;
441: End If;
442: If (p_rec.successor_position_id = hr_api.g_number) then
443: p_rec.successor_position_id :=
444: per_pos_shd.g_old_rec.successor_position_id;
445: End If;
446: If (p_rec.relief_position_id = hr_api.g_number) then

Line 446: If (p_rec.relief_position_id = hr_api.g_number) then

442: If (p_rec.successor_position_id = hr_api.g_number) then
443: p_rec.successor_position_id :=
444: per_pos_shd.g_old_rec.successor_position_id;
445: End If;
446: If (p_rec.relief_position_id = hr_api.g_number) then
447: p_rec.relief_position_id :=
448: per_pos_shd.g_old_rec.relief_position_id;
449: End If;
450: If (p_rec.location_id = hr_api.g_number) then

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

446: If (p_rec.relief_position_id = hr_api.g_number) then
447: p_rec.relief_position_id :=
448: per_pos_shd.g_old_rec.relief_position_id;
449: End If;
450: If (p_rec.location_id = hr_api.g_number) then
451: p_rec.location_id :=
452: per_pos_shd.g_old_rec.location_id;
453: End If;
454: If (p_rec.position_definition_id = hr_api.g_number) then

Line 454: If (p_rec.position_definition_id = hr_api.g_number) then

450: If (p_rec.location_id = hr_api.g_number) then
451: p_rec.location_id :=
452: per_pos_shd.g_old_rec.location_id;
453: End If;
454: If (p_rec.position_definition_id = hr_api.g_number) then
455: p_rec.position_definition_id :=
456: per_pos_shd.g_old_rec.position_definition_id;
457: End If;
458: If (p_rec.date_effective = hr_api.g_date) then

Line 458: If (p_rec.date_effective = hr_api.g_date) then

454: If (p_rec.position_definition_id = hr_api.g_number) then
455: p_rec.position_definition_id :=
456: per_pos_shd.g_old_rec.position_definition_id;
457: End If;
458: If (p_rec.date_effective = hr_api.g_date) then
459: p_rec.date_effective :=
460: per_pos_shd.g_old_rec.date_effective;
461: End If;
462: If (p_rec.comments = hr_api.g_varchar2) then

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

458: If (p_rec.date_effective = hr_api.g_date) then
459: p_rec.date_effective :=
460: per_pos_shd.g_old_rec.date_effective;
461: End If;
462: If (p_rec.comments = hr_api.g_varchar2) then
463: p_rec.comments :=
464: per_pos_shd.g_old_rec.comments;
465: End If;
466: If (p_rec.date_end = hr_api.g_date) then

Line 466: If (p_rec.date_end = hr_api.g_date) then

462: If (p_rec.comments = hr_api.g_varchar2) then
463: p_rec.comments :=
464: per_pos_shd.g_old_rec.comments;
465: End If;
466: If (p_rec.date_end = hr_api.g_date) then
467: p_rec.date_end :=
468: per_pos_shd.g_old_rec.date_end;
469: End If;
470: If (p_rec.frequency = hr_api.g_varchar2) then

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

466: If (p_rec.date_end = hr_api.g_date) then
467: p_rec.date_end :=
468: per_pos_shd.g_old_rec.date_end;
469: End If;
470: If (p_rec.frequency = hr_api.g_varchar2) then
471: p_rec.frequency :=
472: per_pos_shd.g_old_rec.frequency;
473: End If;
474: If (p_rec.name = hr_api.g_varchar2) then

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

470: If (p_rec.frequency = hr_api.g_varchar2) then
471: p_rec.frequency :=
472: per_pos_shd.g_old_rec.frequency;
473: End If;
474: If (p_rec.name = hr_api.g_varchar2) then
475: p_rec.name :=
476: per_pos_shd.g_old_rec.name;
477: End If;
478: If (p_rec.probation_period = hr_api.g_number) then

Line 478: If (p_rec.probation_period = hr_api.g_number) then

474: If (p_rec.name = hr_api.g_varchar2) then
475: p_rec.name :=
476: per_pos_shd.g_old_rec.name;
477: End If;
478: If (p_rec.probation_period = hr_api.g_number) then
479: p_rec.probation_period :=
480: per_pos_shd.g_old_rec.probation_period;
481: End If;
482: If (p_rec.probation_period_units = hr_api.g_varchar2) then

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

478: If (p_rec.probation_period = hr_api.g_number) then
479: p_rec.probation_period :=
480: per_pos_shd.g_old_rec.probation_period;
481: End If;
482: If (p_rec.probation_period_units = hr_api.g_varchar2) then
483: p_rec.probation_period_units :=
484: per_pos_shd.g_old_rec.probation_period_units;
485: End If;
486: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then

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

482: If (p_rec.probation_period_units = hr_api.g_varchar2) then
483: p_rec.probation_period_units :=
484: per_pos_shd.g_old_rec.probation_period_units;
485: End If;
486: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
487: p_rec.replacement_required_flag :=
488: per_pos_shd.g_old_rec.replacement_required_flag;
489: End If;
490: If (p_rec.time_normal_finish = hr_api.g_varchar2) then

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

486: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
487: p_rec.replacement_required_flag :=
488: per_pos_shd.g_old_rec.replacement_required_flag;
489: End If;
490: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
491: p_rec.time_normal_finish :=
492: per_pos_shd.g_old_rec.time_normal_finish;
493: End If;
494: If (p_rec.time_normal_start = hr_api.g_varchar2) then

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

490: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
491: p_rec.time_normal_finish :=
492: per_pos_shd.g_old_rec.time_normal_finish;
493: End If;
494: If (p_rec.time_normal_start = hr_api.g_varchar2) then
495: p_rec.time_normal_start :=
496: per_pos_shd.g_old_rec.time_normal_start;
497: End If;
498: If (p_rec.status = hr_api.g_varchar2) then

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

494: If (p_rec.time_normal_start = hr_api.g_varchar2) then
495: p_rec.time_normal_start :=
496: per_pos_shd.g_old_rec.time_normal_start;
497: End If;
498: If (p_rec.status = hr_api.g_varchar2) then
499: p_rec.status :=
500: per_pos_shd.g_old_rec.status;
501: End If;
502: If (p_rec.working_hours = hr_api.g_number) then

Line 502: If (p_rec.working_hours = hr_api.g_number) then

498: If (p_rec.status = hr_api.g_varchar2) then
499: p_rec.status :=
500: per_pos_shd.g_old_rec.status;
501: End If;
502: If (p_rec.working_hours = hr_api.g_number) then
503: p_rec.working_hours :=
504: per_pos_shd.g_old_rec.working_hours;
505: End If;
506: If (p_rec.request_id = hr_api.g_number) then

Line 506: If (p_rec.request_id = hr_api.g_number) then

502: If (p_rec.working_hours = hr_api.g_number) then
503: p_rec.working_hours :=
504: per_pos_shd.g_old_rec.working_hours;
505: End If;
506: If (p_rec.request_id = hr_api.g_number) then
507: p_rec.request_id :=
508: per_pos_shd.g_old_rec.request_id;
509: End If;
510: If (p_rec.program_application_id = hr_api.g_number) then

Line 510: If (p_rec.program_application_id = hr_api.g_number) then

506: If (p_rec.request_id = hr_api.g_number) then
507: p_rec.request_id :=
508: per_pos_shd.g_old_rec.request_id;
509: End If;
510: If (p_rec.program_application_id = hr_api.g_number) then
511: p_rec.program_application_id :=
512: per_pos_shd.g_old_rec.program_application_id;
513: End If;
514: If (p_rec.program_id = hr_api.g_number) then

Line 514: If (p_rec.program_id = hr_api.g_number) then

510: If (p_rec.program_application_id = hr_api.g_number) then
511: p_rec.program_application_id :=
512: per_pos_shd.g_old_rec.program_application_id;
513: End If;
514: If (p_rec.program_id = hr_api.g_number) then
515: p_rec.program_id :=
516: per_pos_shd.g_old_rec.program_id;
517: End If;
518: If (p_rec.program_update_date = hr_api.g_date) then

Line 518: If (p_rec.program_update_date = hr_api.g_date) then

514: If (p_rec.program_id = hr_api.g_number) then
515: p_rec.program_id :=
516: per_pos_shd.g_old_rec.program_id;
517: End If;
518: If (p_rec.program_update_date = hr_api.g_date) then
519: p_rec.program_update_date :=
520: per_pos_shd.g_old_rec.program_update_date;
521: End If;
522: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

518: If (p_rec.program_update_date = hr_api.g_date) then
519: p_rec.program_update_date :=
520: per_pos_shd.g_old_rec.program_update_date;
521: End If;
522: If (p_rec.attribute_category = hr_api.g_varchar2) then
523: p_rec.attribute_category :=
524: per_pos_shd.g_old_rec.attribute_category;
525: End If;
526: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

522: If (p_rec.attribute_category = hr_api.g_varchar2) then
523: p_rec.attribute_category :=
524: per_pos_shd.g_old_rec.attribute_category;
525: End If;
526: If (p_rec.attribute1 = hr_api.g_varchar2) then
527: p_rec.attribute1 :=
528: per_pos_shd.g_old_rec.attribute1;
529: End If;
530: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

526: If (p_rec.attribute1 = hr_api.g_varchar2) then
527: p_rec.attribute1 :=
528: per_pos_shd.g_old_rec.attribute1;
529: End If;
530: If (p_rec.attribute2 = hr_api.g_varchar2) then
531: p_rec.attribute2 :=
532: per_pos_shd.g_old_rec.attribute2;
533: End If;
534: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

530: If (p_rec.attribute2 = hr_api.g_varchar2) then
531: p_rec.attribute2 :=
532: per_pos_shd.g_old_rec.attribute2;
533: End If;
534: If (p_rec.attribute3 = hr_api.g_varchar2) then
535: p_rec.attribute3 :=
536: per_pos_shd.g_old_rec.attribute3;
537: End If;
538: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

534: If (p_rec.attribute3 = hr_api.g_varchar2) then
535: p_rec.attribute3 :=
536: per_pos_shd.g_old_rec.attribute3;
537: End If;
538: If (p_rec.attribute4 = hr_api.g_varchar2) then
539: p_rec.attribute4 :=
540: per_pos_shd.g_old_rec.attribute4;
541: End If;
542: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

538: If (p_rec.attribute4 = hr_api.g_varchar2) then
539: p_rec.attribute4 :=
540: per_pos_shd.g_old_rec.attribute4;
541: End If;
542: If (p_rec.attribute5 = hr_api.g_varchar2) then
543: p_rec.attribute5 :=
544: per_pos_shd.g_old_rec.attribute5;
545: End If;
546: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

542: If (p_rec.attribute5 = hr_api.g_varchar2) then
543: p_rec.attribute5 :=
544: per_pos_shd.g_old_rec.attribute5;
545: End If;
546: If (p_rec.attribute6 = hr_api.g_varchar2) then
547: p_rec.attribute6 :=
548: per_pos_shd.g_old_rec.attribute6;
549: End If;
550: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

546: If (p_rec.attribute6 = hr_api.g_varchar2) then
547: p_rec.attribute6 :=
548: per_pos_shd.g_old_rec.attribute6;
549: End If;
550: If (p_rec.attribute7 = hr_api.g_varchar2) then
551: p_rec.attribute7 :=
552: per_pos_shd.g_old_rec.attribute7;
553: End If;
554: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

550: If (p_rec.attribute7 = hr_api.g_varchar2) then
551: p_rec.attribute7 :=
552: per_pos_shd.g_old_rec.attribute7;
553: End If;
554: If (p_rec.attribute8 = hr_api.g_varchar2) then
555: p_rec.attribute8 :=
556: per_pos_shd.g_old_rec.attribute8;
557: End If;
558: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

554: If (p_rec.attribute8 = hr_api.g_varchar2) then
555: p_rec.attribute8 :=
556: per_pos_shd.g_old_rec.attribute8;
557: End If;
558: If (p_rec.attribute9 = hr_api.g_varchar2) then
559: p_rec.attribute9 :=
560: per_pos_shd.g_old_rec.attribute9;
561: End If;
562: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

558: If (p_rec.attribute9 = hr_api.g_varchar2) then
559: p_rec.attribute9 :=
560: per_pos_shd.g_old_rec.attribute9;
561: End If;
562: If (p_rec.attribute10 = hr_api.g_varchar2) then
563: p_rec.attribute10 :=
564: per_pos_shd.g_old_rec.attribute10;
565: End If;
566: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

562: If (p_rec.attribute10 = hr_api.g_varchar2) then
563: p_rec.attribute10 :=
564: per_pos_shd.g_old_rec.attribute10;
565: End If;
566: If (p_rec.attribute11 = hr_api.g_varchar2) then
567: p_rec.attribute11 :=
568: per_pos_shd.g_old_rec.attribute11;
569: End If;
570: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

566: If (p_rec.attribute11 = hr_api.g_varchar2) then
567: p_rec.attribute11 :=
568: per_pos_shd.g_old_rec.attribute11;
569: End If;
570: If (p_rec.attribute12 = hr_api.g_varchar2) then
571: p_rec.attribute12 :=
572: per_pos_shd.g_old_rec.attribute12;
573: End If;
574: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

570: If (p_rec.attribute12 = hr_api.g_varchar2) then
571: p_rec.attribute12 :=
572: per_pos_shd.g_old_rec.attribute12;
573: End If;
574: If (p_rec.attribute13 = hr_api.g_varchar2) then
575: p_rec.attribute13 :=
576: per_pos_shd.g_old_rec.attribute13;
577: End If;
578: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 578: If (p_rec.attribute14 = hr_api.g_varchar2) then

574: If (p_rec.attribute13 = hr_api.g_varchar2) then
575: p_rec.attribute13 :=
576: per_pos_shd.g_old_rec.attribute13;
577: End If;
578: If (p_rec.attribute14 = hr_api.g_varchar2) then
579: p_rec.attribute14 :=
580: per_pos_shd.g_old_rec.attribute14;
581: End If;
582: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 582: If (p_rec.attribute15 = hr_api.g_varchar2) then

578: If (p_rec.attribute14 = hr_api.g_varchar2) then
579: p_rec.attribute14 :=
580: per_pos_shd.g_old_rec.attribute14;
581: End If;
582: If (p_rec.attribute15 = hr_api.g_varchar2) then
583: p_rec.attribute15 :=
584: per_pos_shd.g_old_rec.attribute15;
585: End If;
586: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 586: If (p_rec.attribute16 = hr_api.g_varchar2) then

582: If (p_rec.attribute15 = hr_api.g_varchar2) then
583: p_rec.attribute15 :=
584: per_pos_shd.g_old_rec.attribute15;
585: End If;
586: If (p_rec.attribute16 = hr_api.g_varchar2) then
587: p_rec.attribute16 :=
588: per_pos_shd.g_old_rec.attribute16;
589: End If;
590: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 590: If (p_rec.attribute17 = hr_api.g_varchar2) then

586: If (p_rec.attribute16 = hr_api.g_varchar2) then
587: p_rec.attribute16 :=
588: per_pos_shd.g_old_rec.attribute16;
589: End If;
590: If (p_rec.attribute17 = hr_api.g_varchar2) then
591: p_rec.attribute17 :=
592: per_pos_shd.g_old_rec.attribute17;
593: End If;
594: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 594: If (p_rec.attribute18 = hr_api.g_varchar2) then

590: If (p_rec.attribute17 = hr_api.g_varchar2) then
591: p_rec.attribute17 :=
592: per_pos_shd.g_old_rec.attribute17;
593: End If;
594: If (p_rec.attribute18 = hr_api.g_varchar2) then
595: p_rec.attribute18 :=
596: per_pos_shd.g_old_rec.attribute18;
597: End If;
598: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 598: If (p_rec.attribute19 = hr_api.g_varchar2) then

594: If (p_rec.attribute18 = hr_api.g_varchar2) then
595: p_rec.attribute18 :=
596: per_pos_shd.g_old_rec.attribute18;
597: End If;
598: If (p_rec.attribute19 = hr_api.g_varchar2) then
599: p_rec.attribute19 :=
600: per_pos_shd.g_old_rec.attribute19;
601: End If;
602: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 602: If (p_rec.attribute20 = hr_api.g_varchar2) then

598: If (p_rec.attribute19 = hr_api.g_varchar2) then
599: p_rec.attribute19 :=
600: per_pos_shd.g_old_rec.attribute19;
601: End If;
602: If (p_rec.attribute20 = hr_api.g_varchar2) then
603: p_rec.attribute20 :=
604: per_pos_shd.g_old_rec.attribute20;
605: End If;
606: --

Line 667: Raise HR_Api.Validate_Enabled;

663: --
664: -- If we are validating then raise the Validate_Enabled exception
665: --
666: If p_validate then
667: Raise HR_Api.Validate_Enabled;
668: End If;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: Exception

Line 672: When HR_Api.Validate_Enabled Then

668: End If;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: Exception
672: When HR_Api.Validate_Enabled Then
673: --
674: -- As the Validate_Enabled exception has been raised
675: -- we must rollback to the savepoint
676: --

Line 686: p_successor_position_id in number default hr_api.g_number,

682: -- ----------------------------------------------------------------------------
683: Procedure upd
684: (
685: p_position_id in number,
686: p_successor_position_id in number default hr_api.g_number,
687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,

Line 687: p_relief_position_id in number default hr_api.g_number,

683: Procedure upd
684: (
685: p_position_id in number,
686: p_successor_position_id in number default hr_api.g_number,
687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,

Line 688: p_location_id in number default hr_api.g_number,

684: (
685: p_position_id in number,
686: p_successor_position_id in number default hr_api.g_number,
687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,

Line 689: p_position_definition_id in number default hr_api.g_number,

685: p_position_id in number,
686: p_successor_position_id in number default hr_api.g_number,
687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,

Line 690: p_date_effective in date default hr_api.g_date,

686: p_successor_position_id in number default hr_api.g_number,
687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,

Line 691: p_comments in varchar2 default hr_api.g_varchar2,

687: p_relief_position_id in number default hr_api.g_number,
688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,

Line 692: p_date_end in date default hr_api.g_date,

688: p_location_id in number default hr_api.g_number,
689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,

Line 693: p_frequency in varchar2 default hr_api.g_varchar2,

689: p_position_definition_id in number default hr_api.g_number,
690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,

Line 694: p_name in varchar2 default hr_api.g_varchar2,

690: p_date_effective in date default hr_api.g_date,
691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

Line 695: p_probation_period in number default hr_api.g_number,

691: p_comments in varchar2 default hr_api.g_varchar2,
692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,

Line 696: p_probation_period_units in varchar2 default hr_api.g_varchar2,

692: p_date_end in date default hr_api.g_date,
693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,

Line 697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,

693: p_frequency in varchar2 default hr_api.g_varchar2,
694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,

Line 698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

694: p_name in varchar2 default hr_api.g_varchar2,
695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,

Line 699: p_time_normal_start in varchar2 default hr_api.g_varchar2,

695: p_probation_period in number default hr_api.g_number,
696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,

Line 700: p_status in varchar2 default hr_api.g_varchar2,

696: p_probation_period_units in varchar2 default hr_api.g_varchar2,
697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,

Line 701: p_working_hours in number default hr_api.g_number,

697: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,

Line 702: p_request_id in number default hr_api.g_number,

698: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 703: p_program_application_id in number default hr_api.g_number,

699: p_time_normal_start in varchar2 default hr_api.g_varchar2,
700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 704: p_program_id in number default hr_api.g_number,

700: p_status in varchar2 default hr_api.g_varchar2,
701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 705: p_program_update_date in date default hr_api.g_date,

701: p_working_hours in number default hr_api.g_number,
702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 706: p_attribute_category in varchar2 default hr_api.g_varchar2,

702: p_request_id in number default hr_api.g_number,
703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 707: p_attribute1 in varchar2 default hr_api.g_varchar2,

703: p_program_application_id in number default hr_api.g_number,
704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 708: p_attribute2 in varchar2 default hr_api.g_varchar2,

704: p_program_id in number default hr_api.g_number,
705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 709: p_attribute3 in varchar2 default hr_api.g_varchar2,

705: p_program_update_date in date default hr_api.g_date,
706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 710: p_attribute4 in varchar2 default hr_api.g_varchar2,

706: p_attribute_category in varchar2 default hr_api.g_varchar2,
707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 711: p_attribute5 in varchar2 default hr_api.g_varchar2,

707: p_attribute1 in varchar2 default hr_api.g_varchar2,
708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 712: p_attribute6 in varchar2 default hr_api.g_varchar2,

708: p_attribute2 in varchar2 default hr_api.g_varchar2,
709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 713: p_attribute7 in varchar2 default hr_api.g_varchar2,

709: p_attribute3 in varchar2 default hr_api.g_varchar2,
710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 714: p_attribute8 in varchar2 default hr_api.g_varchar2,

710: p_attribute4 in varchar2 default hr_api.g_varchar2,
711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 715: p_attribute9 in varchar2 default hr_api.g_varchar2,

711: p_attribute5 in varchar2 default hr_api.g_varchar2,
712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 716: p_attribute10 in varchar2 default hr_api.g_varchar2,

712: p_attribute6 in varchar2 default hr_api.g_varchar2,
713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 717: p_attribute11 in varchar2 default hr_api.g_varchar2,

713: p_attribute7 in varchar2 default hr_api.g_varchar2,
714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 718: p_attribute12 in varchar2 default hr_api.g_varchar2,

714: p_attribute8 in varchar2 default hr_api.g_varchar2,
715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 719: p_attribute13 in varchar2 default hr_api.g_varchar2,

715: p_attribute9 in varchar2 default hr_api.g_varchar2,
716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 720: p_attribute14 in varchar2 default hr_api.g_varchar2,

716: p_attribute10 in varchar2 default hr_api.g_varchar2,
717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 721: p_attribute15 in varchar2 default hr_api.g_varchar2,

717: p_attribute11 in varchar2 default hr_api.g_varchar2,
718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 722: p_attribute16 in varchar2 default hr_api.g_varchar2,

718: p_attribute12 in varchar2 default hr_api.g_varchar2,
719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,
726: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 723: p_attribute17 in varchar2 default hr_api.g_varchar2,

719: p_attribute13 in varchar2 default hr_api.g_varchar2,
720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,
726: p_attribute20 in varchar2 default hr_api.g_varchar2,
727: p_object_version_number in out nocopy number,

Line 724: p_attribute18 in varchar2 default hr_api.g_varchar2,

720: p_attribute14 in varchar2 default hr_api.g_varchar2,
721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,
726: p_attribute20 in varchar2 default hr_api.g_varchar2,
727: p_object_version_number in out nocopy number,
728: p_validate in boolean default false

Line 725: p_attribute19 in varchar2 default hr_api.g_varchar2,

721: p_attribute15 in varchar2 default hr_api.g_varchar2,
722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,
726: p_attribute20 in varchar2 default hr_api.g_varchar2,
727: p_object_version_number in out nocopy number,
728: p_validate in boolean default false
729: ) is

Line 726: p_attribute20 in varchar2 default hr_api.g_varchar2,

722: p_attribute16 in varchar2 default hr_api.g_varchar2,
723: p_attribute17 in varchar2 default hr_api.g_varchar2,
724: p_attribute18 in varchar2 default hr_api.g_varchar2,
725: p_attribute19 in varchar2 default hr_api.g_varchar2,
726: p_attribute20 in varchar2 default hr_api.g_varchar2,
727: p_object_version_number in out nocopy number,
728: p_validate in boolean default false
729: ) is
730: --

Line 744: hr_api.g_number,

740: l_rec :=
741: per_pos_shd.convert_args
742: (
743: p_position_id,
744: hr_api.g_number,
745: hr_api.g_number,
746: hr_api.g_number,
747: p_successor_position_id,
748: p_relief_position_id,

Line 745: hr_api.g_number,

741: per_pos_shd.convert_args
742: (
743: p_position_id,
744: hr_api.g_number,
745: hr_api.g_number,
746: hr_api.g_number,
747: p_successor_position_id,
748: p_relief_position_id,
749: p_location_id,

Line 746: hr_api.g_number,

742: (
743: p_position_id,
744: hr_api.g_number,
745: hr_api.g_number,
746: hr_api.g_number,
747: p_successor_position_id,
748: p_relief_position_id,
749: p_location_id,
750: p_position_definition_id,