103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
110: per_vgr_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
110: per_vgr_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
115: per_vgr_shd.constraint_error
108: -- A check constraint has been violated
109: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
110: per_vgr_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
115: per_vgr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
115: per_vgr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
120: per_vgr_shd.constraint_error
113: -- Parent integrity has been violated
114: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
115: per_vgr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
120: per_vgr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
120: per_vgr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;
125: End update_dml;
277: ,p_object_version_number_o => per_vgr_shd.g_old_rec.object_version_number
278: );
279: --
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (
284: p_module_name => 'PER_VALID_GRADES',
285: p_hook_type => 'AU'
278: );
279: --
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (
284: p_module_name => 'PER_VALID_GRADES',
285: p_hook_type => 'AU'
286: );
345: -- p_rec plsql record structure
346: -- to see if a system default is being used. If a system default
347: -- is being used then we must set to the 'current' argument value.
348: --
349: If (p_rec.business_group_id = hr_api.g_number) then
350: p_rec.business_group_id :=
351: per_vgr_shd.g_old_rec.business_group_id;
352: End If;
353: If (p_rec.grade_id = hr_api.g_number) then
349: If (p_rec.business_group_id = hr_api.g_number) then
350: p_rec.business_group_id :=
351: per_vgr_shd.g_old_rec.business_group_id;
352: End If;
353: If (p_rec.grade_id = hr_api.g_number) then
354: p_rec.grade_id :=
355: per_vgr_shd.g_old_rec.grade_id;
356: End If;
357: If (p_rec.date_from = hr_api.g_date) then
353: If (p_rec.grade_id = hr_api.g_number) then
354: p_rec.grade_id :=
355: per_vgr_shd.g_old_rec.grade_id;
356: End If;
357: If (p_rec.date_from = hr_api.g_date) then
358: p_rec.date_from :=
359: per_vgr_shd.g_old_rec.date_from;
360: End If;
361: If (p_rec.comments = hr_api.g_varchar2) then
357: If (p_rec.date_from = hr_api.g_date) then
358: p_rec.date_from :=
359: per_vgr_shd.g_old_rec.date_from;
360: End If;
361: If (p_rec.comments = hr_api.g_varchar2) then
362: p_rec.comments :=
363: per_vgr_shd.g_old_rec.comments;
364: End If;
365: If (p_rec.date_to = hr_api.g_date) then
361: If (p_rec.comments = hr_api.g_varchar2) then
362: p_rec.comments :=
363: per_vgr_shd.g_old_rec.comments;
364: End If;
365: If (p_rec.date_to = hr_api.g_date) then
366: p_rec.date_to :=
367: per_vgr_shd.g_old_rec.date_to;
368: End If;
369: If (p_rec.job_id = hr_api.g_number) then
365: If (p_rec.date_to = hr_api.g_date) then
366: p_rec.date_to :=
367: per_vgr_shd.g_old_rec.date_to;
368: End If;
369: If (p_rec.job_id = hr_api.g_number) then
370: p_rec.job_id :=
371: per_vgr_shd.g_old_rec.job_id;
372: End If;
373: If (p_rec.position_id = hr_api.g_number) then
369: If (p_rec.job_id = hr_api.g_number) then
370: p_rec.job_id :=
371: per_vgr_shd.g_old_rec.job_id;
372: End If;
373: If (p_rec.position_id = hr_api.g_number) then
374: p_rec.position_id :=
375: per_vgr_shd.g_old_rec.position_id;
376: End If;
377: If (p_rec.request_id = hr_api.g_number) then
373: If (p_rec.position_id = hr_api.g_number) then
374: p_rec.position_id :=
375: per_vgr_shd.g_old_rec.position_id;
376: End If;
377: If (p_rec.request_id = hr_api.g_number) then
378: p_rec.request_id :=
379: per_vgr_shd.g_old_rec.request_id;
380: End If;
381: If (p_rec.program_application_id = hr_api.g_number) then
377: If (p_rec.request_id = hr_api.g_number) then
378: p_rec.request_id :=
379: per_vgr_shd.g_old_rec.request_id;
380: End If;
381: If (p_rec.program_application_id = hr_api.g_number) then
382: p_rec.program_application_id :=
383: per_vgr_shd.g_old_rec.program_application_id;
384: End If;
385: If (p_rec.program_id = hr_api.g_number) then
381: If (p_rec.program_application_id = hr_api.g_number) then
382: p_rec.program_application_id :=
383: per_vgr_shd.g_old_rec.program_application_id;
384: End If;
385: If (p_rec.program_id = hr_api.g_number) then
386: p_rec.program_id :=
387: per_vgr_shd.g_old_rec.program_id;
388: End If;
389: If (p_rec.program_update_date = hr_api.g_date) then
385: If (p_rec.program_id = hr_api.g_number) then
386: p_rec.program_id :=
387: per_vgr_shd.g_old_rec.program_id;
388: End If;
389: If (p_rec.program_update_date = hr_api.g_date) then
390: p_rec.program_update_date :=
391: per_vgr_shd.g_old_rec.program_update_date;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
389: If (p_rec.program_update_date = hr_api.g_date) then
390: p_rec.program_update_date :=
391: per_vgr_shd.g_old_rec.program_update_date;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: per_vgr_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: per_vgr_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: per_vgr_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: per_vgr_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: per_vgr_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: per_vgr_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: per_vgr_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: per_vgr_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: per_vgr_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: per_vgr_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: per_vgr_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: per_vgr_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: per_vgr_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: per_vgr_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: per_vgr_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: per_vgr_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: per_vgr_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: per_vgr_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: per_vgr_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: per_vgr_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: per_vgr_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: per_vgr_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: per_vgr_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: per_vgr_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: per_vgr_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: per_vgr_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: per_vgr_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: per_vgr_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: per_vgr_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: per_vgr_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: per_vgr_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: per_vgr_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: per_vgr_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: per_vgr_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: per_vgr_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: per_vgr_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: per_vgr_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: per_vgr_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: per_vgr_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: per_vgr_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: per_vgr_shd.g_old_rec.attribute20;
476: End If;
477:
535: --
536: -- If we are validating then raise the Validate_Enabled exception
537: --
538: If p_validate then
539: Raise HR_Api.Validate_Enabled;
540: End If;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: Exception
540: End If;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: Exception
544: When HR_Api.Validate_Enabled Then
545: --
546: -- As the Validate_Enabled exception has been raised
547: -- we must rollback to the savepoint
548: --
554: -- ----------------------------------------------------------------------------
555: Procedure upd
556: (
557: p_valid_grade_id in number,
558: p_date_from in date default hr_api.g_date,
559: p_effective_date in date, -- Added for Bug# 1760707
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
556: (
557: p_valid_grade_id in number,
558: p_date_from in date default hr_api.g_date,
559: p_effective_date in date, -- Added for Bug# 1760707
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
557: p_valid_grade_id in number,
558: p_date_from in date default hr_api.g_date,
559: p_effective_date in date, -- Added for Bug# 1760707
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
558: p_date_from in date default hr_api.g_date,
559: p_effective_date in date, -- Added for Bug# 1760707
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
559: p_effective_date in date, -- Added for Bug# 1760707
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
560: p_comments in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
561: p_date_to in date default hr_api.g_date,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
562: p_request_id in number default hr_api.g_number,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
563: p_program_application_id in number default hr_api.g_number,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
564: p_program_id in number default hr_api.g_number,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
565: p_program_update_date in date default hr_api.g_date,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
567: p_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
568: p_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
569: p_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
570: p_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
571: p_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
572: p_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
573: p_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
574: p_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
575: p_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
576: p_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
577: p_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
578: p_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_attribute20 in varchar2 default hr_api.g_varchar2,
579: p_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_object_version_number in out nocopy number,
580: p_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_object_version_number in out nocopy number,
588: p_validate in boolean default false
581: p_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_object_version_number in out nocopy number,
588: p_validate in boolean default false
589: ) is
582: p_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_object_version_number in out nocopy number,
588: p_validate in boolean default false
589: ) is
590: --
600: l_rec :=
601: per_vgr_shd.convert_args
602: (
603: p_valid_grade_id,
604: hr_api.g_number,
605: hr_api.g_number,
606: p_date_from,
607: p_comments,
608: p_date_to,
601: per_vgr_shd.convert_args
602: (
603: p_valid_grade_id,
604: hr_api.g_number,
605: hr_api.g_number,
606: p_date_from,
607: p_comments,
608: p_date_to,
609: hr_api.g_number,
605: hr_api.g_number,
606: p_date_from,
607: p_comments,
608: p_date_to,
609: hr_api.g_number,
610: hr_api.g_number,
611: p_request_id,
612: p_program_application_id,
613: p_program_id,
606: p_date_from,
607: p_comments,
608: p_date_to,
609: hr_api.g_number,
610: hr_api.g_number,
611: p_request_id,
612: p_program_application_id,
613: p_program_id,
614: p_program_update_date,