APPS.PER_PST_UPD dependencies on HR_API

Line 110: When hr_api.check_integrity_violated Then

106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error

Line 115: When hr_api.parent_integrity_violated Then

111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error

Line 120: When hr_api.unique_integrity_violated Then

116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: per_pst_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End update_dml;

Line 345: when hr_api.cannot_find_prog_unit then

341: );
342: --
343: exception
344: --
345: when hr_api.cannot_find_prog_unit then
346: --
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'PER_POSITION_STRUCTURES'
349: ,p_hook_type => 'AU');

Line 347: hr_api.cannot_find_prog_unit_error

343: exception
344: --
345: when hr_api.cannot_find_prog_unit then
346: --
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'PER_POSITION_STRUCTURES'
349: ,p_hook_type => 'AU');
350: --
351: end;

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

406: -- p_rec plsql record structure
407: -- to see if a system default is being used. If a system default
408: -- is being used then we must set to the 'current' argument value.
409: --
410: If (p_rec.business_group_id = hr_api.g_number) then
411: p_rec.business_group_id :=
412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then

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

410: If (p_rec.business_group_id = hr_api.g_number) then
411: p_rec.business_group_id :=
412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then

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

414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then

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

418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then

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

422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then

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

426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then

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

430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then

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

434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then
523: p_rec.attribute20 :=
524: per_pst_shd.g_old_rec.attribute20;
525: End If;
526: --

Line 584: ,p_business_group_id in number default hr_api.g_number

580: Procedure upd
581: (p_effective_date in date
582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number

Line 585: ,p_name in varchar2 default hr_api.g_varchar2

581: (p_effective_date in date
582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number

Line 586: ,p_comments in varchar2 default hr_api.g_varchar2

582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number

Line 587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2

583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date

Line 588: ,p_request_id in number default hr_api.g_number

584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 589: ,p_program_application_id in number default hr_api.g_number

585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 590: ,p_program_id in number default hr_api.g_number

586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 591: ,p_program_update_date in date default hr_api.g_date

587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 592: ,p_attribute_category in varchar2 default hr_api.g_varchar2

588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 593: ,p_attribute1 in varchar2 default hr_api.g_varchar2

589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 594: ,p_attribute2 in varchar2 default hr_api.g_varchar2

590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 595: ,p_attribute3 in varchar2 default hr_api.g_varchar2

591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 596: ,p_attribute4 in varchar2 default hr_api.g_varchar2

592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 597: ,p_attribute5 in varchar2 default hr_api.g_varchar2

593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 598: ,p_attribute6 in varchar2 default hr_api.g_varchar2

594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 599: ,p_attribute7 in varchar2 default hr_api.g_varchar2

595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 600: ,p_attribute8 in varchar2 default hr_api.g_varchar2

596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 601: ,p_attribute9 in varchar2 default hr_api.g_varchar2

597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 602: ,p_attribute10 in varchar2 default hr_api.g_varchar2

598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 603: ,p_attribute11 in varchar2 default hr_api.g_varchar2

599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 604: ,p_attribute12 in varchar2 default hr_api.g_varchar2

600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 605: ,p_attribute13 in varchar2 default hr_api.g_varchar2

601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 606: ,p_attribute14 in varchar2 default hr_api.g_varchar2

602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 607: ,p_attribute15 in varchar2 default hr_api.g_varchar2

603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 608: ,p_attribute16 in varchar2 default hr_api.g_varchar2

604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 609: ,p_attribute17 in varchar2 default hr_api.g_varchar2

605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is

Line 610: ,p_attribute18 in varchar2 default hr_api.g_varchar2

606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --

Line 611: ,p_attribute19 in varchar2 default hr_api.g_varchar2

607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
615: l_rec per_pst_shd.g_rec_type;

Line 612: ,p_attribute20 in varchar2 default hr_api.g_varchar2

608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
615: l_rec per_pst_shd.g_rec_type;
616: l_proc varchar2(72) := g_package||'upd';