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

APPS.PER_VGR_UPD dependencies on HR_API

Line 107: When hr_api.check_integrity_violated Then

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));

Line 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

Line 112: When hr_api.parent_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
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 117: When hr_api.unique_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
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 281: when hr_api.cannot_find_prog_unit then

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'

Line 282: hr_api.cannot_find_prog_unit_error

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

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 539: Raise HR_Api.Validate_Enabled;

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

Line 544: When HR_Api.Validate_Enabled Then

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: --

Line 558: p_date_from in date default hr_api.g_date,

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,

Line 560: p_comments in varchar2 default hr_api.g_varchar2,

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,

Line 561: p_date_to in date default hr_api.g_date,

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,

Line 562: p_request_id in number default hr_api.g_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,
566: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 563: p_program_application_id in number default hr_api.g_number,

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,

Line 564: p_program_id in number default hr_api.g_number,

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,

Line 565: p_program_update_date in date default hr_api.g_date,

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,

Line 566: p_attribute_category 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,

Line 567: p_attribute1 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,

Line 568: p_attribute2 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,

Line 569: p_attribute3 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,

Line 570: p_attribute4 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,

Line 571: p_attribute5 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,

Line 572: p_attribute6 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,

Line 573: p_attribute7 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,

Line 574: p_attribute8 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,

Line 575: p_attribute9 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,

Line 576: p_attribute10 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,

Line 577: p_attribute11 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,

Line 578: p_attribute12 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,

Line 579: p_attribute13 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,

Line 580: p_attribute14 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,

Line 581: p_attribute15 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,

Line 582: p_attribute16 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,

Line 583: p_attribute17 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,

Line 584: p_attribute18 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,
588: p_validate in boolean default false

Line 585: p_attribute19 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
589: ) is

Line 586: p_attribute20 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
590: --

Line 604: hr_api.g_number,

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,

Line 605: hr_api.g_number,

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,

Line 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,

Line 610: 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,
614: p_program_update_date,