DBA Data[Home] [Help]

APPS.BEN_AGF_UPD dependencies on HR_API

Line 124: When hr_api.check_integrity_violated Then

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

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

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

Line 129: When hr_api.parent_integrity_violated Then

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

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

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

Line 134: When hr_api.unique_integrity_violated Then

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

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

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

Line 329: when hr_api.cannot_find_prog_unit then

325: );
326: --
327: exception
328: --
329: when hr_api.cannot_find_prog_unit then
330: --
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'ben_age_fctr'
333: ,p_hook_type => 'AU');

Line 331: hr_api.cannot_find_prog_unit_error

327: exception
328: --
329: when hr_api.cannot_find_prog_unit then
330: --
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'ben_age_fctr'
333: ,p_hook_type => 'AU');
334: --
335: end;

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

395: -- p_rec plsql record structure
396: -- to see if a system default is being used. If a system default
397: -- is being used then we must set to the 'current' argument value.
398: --
399: If (p_rec.name = hr_api.g_varchar2) then
400: p_rec.name :=
401: ben_agf_shd.g_old_rec.name;
402: End If;
403: If (p_rec.mx_age_num = hr_api.g_number) then

Line 403: If (p_rec.mx_age_num = hr_api.g_number) then

399: If (p_rec.name = hr_api.g_varchar2) then
400: p_rec.name :=
401: ben_agf_shd.g_old_rec.name;
402: End If;
403: If (p_rec.mx_age_num = hr_api.g_number) then
404: p_rec.mx_age_num :=
405: ben_agf_shd.g_old_rec.mx_age_num;
406: End If;
407: If (p_rec.mn_age_num = hr_api.g_number) then

Line 407: If (p_rec.mn_age_num = hr_api.g_number) then

403: If (p_rec.mx_age_num = hr_api.g_number) then
404: p_rec.mx_age_num :=
405: ben_agf_shd.g_old_rec.mx_age_num;
406: End If;
407: If (p_rec.mn_age_num = hr_api.g_number) then
408: p_rec.mn_age_num :=
409: ben_agf_shd.g_old_rec.mn_age_num;
410: End If;
411: If (p_rec.age_uom = hr_api.g_varchar2) then

Line 411: If (p_rec.age_uom = hr_api.g_varchar2) then

407: If (p_rec.mn_age_num = hr_api.g_number) then
408: p_rec.mn_age_num :=
409: ben_agf_shd.g_old_rec.mn_age_num;
410: End If;
411: If (p_rec.age_uom = hr_api.g_varchar2) then
412: p_rec.age_uom :=
413: ben_agf_shd.g_old_rec.age_uom;
414: End If;
415: If (p_rec.no_mn_age_flag = hr_api.g_varchar2) then

Line 415: If (p_rec.no_mn_age_flag = hr_api.g_varchar2) then

411: If (p_rec.age_uom = hr_api.g_varchar2) then
412: p_rec.age_uom :=
413: ben_agf_shd.g_old_rec.age_uom;
414: End If;
415: If (p_rec.no_mn_age_flag = hr_api.g_varchar2) then
416: p_rec.no_mn_age_flag :=
417: ben_agf_shd.g_old_rec.no_mn_age_flag;
418: End If;
419: If (p_rec.no_mx_age_flag = hr_api.g_varchar2) then

Line 419: If (p_rec.no_mx_age_flag = hr_api.g_varchar2) then

415: If (p_rec.no_mn_age_flag = hr_api.g_varchar2) then
416: p_rec.no_mn_age_flag :=
417: ben_agf_shd.g_old_rec.no_mn_age_flag;
418: End If;
419: If (p_rec.no_mx_age_flag = hr_api.g_varchar2) then
420: p_rec.no_mx_age_flag :=
421: ben_agf_shd.g_old_rec.no_mx_age_flag;
422: End If;
423: If (p_rec.age_to_use_cd = hr_api.g_varchar2) then

Line 423: If (p_rec.age_to_use_cd = hr_api.g_varchar2) then

419: If (p_rec.no_mx_age_flag = hr_api.g_varchar2) then
420: p_rec.no_mx_age_flag :=
421: ben_agf_shd.g_old_rec.no_mx_age_flag;
422: End If;
423: If (p_rec.age_to_use_cd = hr_api.g_varchar2) then
424: p_rec.age_to_use_cd :=
425: ben_agf_shd.g_old_rec.age_to_use_cd;
426: End If;
427: If (p_rec.age_det_cd = hr_api.g_varchar2) then

Line 427: If (p_rec.age_det_cd = hr_api.g_varchar2) then

423: If (p_rec.age_to_use_cd = hr_api.g_varchar2) then
424: p_rec.age_to_use_cd :=
425: ben_agf_shd.g_old_rec.age_to_use_cd;
426: End If;
427: If (p_rec.age_det_cd = hr_api.g_varchar2) then
428: p_rec.age_det_cd :=
429: ben_agf_shd.g_old_rec.age_det_cd;
430: End If;
431: If (p_rec.age_det_rl = hr_api.g_number) then

Line 431: If (p_rec.age_det_rl = hr_api.g_number) then

427: If (p_rec.age_det_cd = hr_api.g_varchar2) then
428: p_rec.age_det_cd :=
429: ben_agf_shd.g_old_rec.age_det_cd;
430: End If;
431: If (p_rec.age_det_rl = hr_api.g_number) then
432: p_rec.age_det_rl :=
433: ben_agf_shd.g_old_rec.age_det_rl;
434: End If;
435: If (p_rec.rndg_cd = hr_api.g_varchar2) then

Line 435: If (p_rec.rndg_cd = hr_api.g_varchar2) then

431: If (p_rec.age_det_rl = hr_api.g_number) then
432: p_rec.age_det_rl :=
433: ben_agf_shd.g_old_rec.age_det_rl;
434: End If;
435: If (p_rec.rndg_cd = hr_api.g_varchar2) then
436: p_rec.rndg_cd :=
437: ben_agf_shd.g_old_rec.rndg_cd;
438: End If;
439: If (p_rec.rndg_rl = hr_api.g_number) then

Line 439: If (p_rec.rndg_rl = hr_api.g_number) then

435: If (p_rec.rndg_cd = hr_api.g_varchar2) then
436: p_rec.rndg_cd :=
437: ben_agf_shd.g_old_rec.rndg_cd;
438: End If;
439: If (p_rec.rndg_rl = hr_api.g_number) then
440: p_rec.rndg_rl :=
441: ben_agf_shd.g_old_rec.rndg_rl;
442: End If;
443: If (p_rec.age_calc_rl = hr_api.g_number) then

Line 443: If (p_rec.age_calc_rl = hr_api.g_number) then

439: If (p_rec.rndg_rl = hr_api.g_number) then
440: p_rec.rndg_rl :=
441: ben_agf_shd.g_old_rec.rndg_rl;
442: End If;
443: If (p_rec.age_calc_rl = hr_api.g_number) then
444: p_rec.age_calc_rl :=
445: ben_agf_shd.g_old_rec.age_calc_rl;
446: End If;
447: If (p_rec.business_group_id = hr_api.g_number) then

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

443: If (p_rec.age_calc_rl = hr_api.g_number) then
444: p_rec.age_calc_rl :=
445: ben_agf_shd.g_old_rec.age_calc_rl;
446: End If;
447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ben_agf_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.agf_attribute_category = hr_api.g_varchar2) then

Line 451: If (p_rec.agf_attribute_category = hr_api.g_varchar2) then

447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ben_agf_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.agf_attribute_category = hr_api.g_varchar2) then
452: p_rec.agf_attribute_category :=
453: ben_agf_shd.g_old_rec.agf_attribute_category;
454: End If;
455: If (p_rec.agf_attribute1 = hr_api.g_varchar2) then

Line 455: If (p_rec.agf_attribute1 = hr_api.g_varchar2) then

451: If (p_rec.agf_attribute_category = hr_api.g_varchar2) then
452: p_rec.agf_attribute_category :=
453: ben_agf_shd.g_old_rec.agf_attribute_category;
454: End If;
455: If (p_rec.agf_attribute1 = hr_api.g_varchar2) then
456: p_rec.agf_attribute1 :=
457: ben_agf_shd.g_old_rec.agf_attribute1;
458: End If;
459: If (p_rec.agf_attribute2 = hr_api.g_varchar2) then

Line 459: If (p_rec.agf_attribute2 = hr_api.g_varchar2) then

455: If (p_rec.agf_attribute1 = hr_api.g_varchar2) then
456: p_rec.agf_attribute1 :=
457: ben_agf_shd.g_old_rec.agf_attribute1;
458: End If;
459: If (p_rec.agf_attribute2 = hr_api.g_varchar2) then
460: p_rec.agf_attribute2 :=
461: ben_agf_shd.g_old_rec.agf_attribute2;
462: End If;
463: If (p_rec.agf_attribute3 = hr_api.g_varchar2) then

Line 463: If (p_rec.agf_attribute3 = hr_api.g_varchar2) then

459: If (p_rec.agf_attribute2 = hr_api.g_varchar2) then
460: p_rec.agf_attribute2 :=
461: ben_agf_shd.g_old_rec.agf_attribute2;
462: End If;
463: If (p_rec.agf_attribute3 = hr_api.g_varchar2) then
464: p_rec.agf_attribute3 :=
465: ben_agf_shd.g_old_rec.agf_attribute3;
466: End If;
467: If (p_rec.agf_attribute4 = hr_api.g_varchar2) then

Line 467: If (p_rec.agf_attribute4 = hr_api.g_varchar2) then

463: If (p_rec.agf_attribute3 = hr_api.g_varchar2) then
464: p_rec.agf_attribute3 :=
465: ben_agf_shd.g_old_rec.agf_attribute3;
466: End If;
467: If (p_rec.agf_attribute4 = hr_api.g_varchar2) then
468: p_rec.agf_attribute4 :=
469: ben_agf_shd.g_old_rec.agf_attribute4;
470: End If;
471: If (p_rec.agf_attribute5 = hr_api.g_varchar2) then

Line 471: If (p_rec.agf_attribute5 = hr_api.g_varchar2) then

467: If (p_rec.agf_attribute4 = hr_api.g_varchar2) then
468: p_rec.agf_attribute4 :=
469: ben_agf_shd.g_old_rec.agf_attribute4;
470: End If;
471: If (p_rec.agf_attribute5 = hr_api.g_varchar2) then
472: p_rec.agf_attribute5 :=
473: ben_agf_shd.g_old_rec.agf_attribute5;
474: End If;
475: If (p_rec.agf_attribute6 = hr_api.g_varchar2) then

Line 475: If (p_rec.agf_attribute6 = hr_api.g_varchar2) then

471: If (p_rec.agf_attribute5 = hr_api.g_varchar2) then
472: p_rec.agf_attribute5 :=
473: ben_agf_shd.g_old_rec.agf_attribute5;
474: End If;
475: If (p_rec.agf_attribute6 = hr_api.g_varchar2) then
476: p_rec.agf_attribute6 :=
477: ben_agf_shd.g_old_rec.agf_attribute6;
478: End If;
479: If (p_rec.agf_attribute7 = hr_api.g_varchar2) then

Line 479: If (p_rec.agf_attribute7 = hr_api.g_varchar2) then

475: If (p_rec.agf_attribute6 = hr_api.g_varchar2) then
476: p_rec.agf_attribute6 :=
477: ben_agf_shd.g_old_rec.agf_attribute6;
478: End If;
479: If (p_rec.agf_attribute7 = hr_api.g_varchar2) then
480: p_rec.agf_attribute7 :=
481: ben_agf_shd.g_old_rec.agf_attribute7;
482: End If;
483: If (p_rec.agf_attribute8 = hr_api.g_varchar2) then

Line 483: If (p_rec.agf_attribute8 = hr_api.g_varchar2) then

479: If (p_rec.agf_attribute7 = hr_api.g_varchar2) then
480: p_rec.agf_attribute7 :=
481: ben_agf_shd.g_old_rec.agf_attribute7;
482: End If;
483: If (p_rec.agf_attribute8 = hr_api.g_varchar2) then
484: p_rec.agf_attribute8 :=
485: ben_agf_shd.g_old_rec.agf_attribute8;
486: End If;
487: If (p_rec.agf_attribute9 = hr_api.g_varchar2) then

Line 487: If (p_rec.agf_attribute9 = hr_api.g_varchar2) then

483: If (p_rec.agf_attribute8 = hr_api.g_varchar2) then
484: p_rec.agf_attribute8 :=
485: ben_agf_shd.g_old_rec.agf_attribute8;
486: End If;
487: If (p_rec.agf_attribute9 = hr_api.g_varchar2) then
488: p_rec.agf_attribute9 :=
489: ben_agf_shd.g_old_rec.agf_attribute9;
490: End If;
491: If (p_rec.agf_attribute10 = hr_api.g_varchar2) then

Line 491: If (p_rec.agf_attribute10 = hr_api.g_varchar2) then

487: If (p_rec.agf_attribute9 = hr_api.g_varchar2) then
488: p_rec.agf_attribute9 :=
489: ben_agf_shd.g_old_rec.agf_attribute9;
490: End If;
491: If (p_rec.agf_attribute10 = hr_api.g_varchar2) then
492: p_rec.agf_attribute10 :=
493: ben_agf_shd.g_old_rec.agf_attribute10;
494: End If;
495: If (p_rec.agf_attribute11 = hr_api.g_varchar2) then

Line 495: If (p_rec.agf_attribute11 = hr_api.g_varchar2) then

491: If (p_rec.agf_attribute10 = hr_api.g_varchar2) then
492: p_rec.agf_attribute10 :=
493: ben_agf_shd.g_old_rec.agf_attribute10;
494: End If;
495: If (p_rec.agf_attribute11 = hr_api.g_varchar2) then
496: p_rec.agf_attribute11 :=
497: ben_agf_shd.g_old_rec.agf_attribute11;
498: End If;
499: If (p_rec.agf_attribute12 = hr_api.g_varchar2) then

Line 499: If (p_rec.agf_attribute12 = hr_api.g_varchar2) then

495: If (p_rec.agf_attribute11 = hr_api.g_varchar2) then
496: p_rec.agf_attribute11 :=
497: ben_agf_shd.g_old_rec.agf_attribute11;
498: End If;
499: If (p_rec.agf_attribute12 = hr_api.g_varchar2) then
500: p_rec.agf_attribute12 :=
501: ben_agf_shd.g_old_rec.agf_attribute12;
502: End If;
503: If (p_rec.agf_attribute13 = hr_api.g_varchar2) then

Line 503: If (p_rec.agf_attribute13 = hr_api.g_varchar2) then

499: If (p_rec.agf_attribute12 = hr_api.g_varchar2) then
500: p_rec.agf_attribute12 :=
501: ben_agf_shd.g_old_rec.agf_attribute12;
502: End If;
503: If (p_rec.agf_attribute13 = hr_api.g_varchar2) then
504: p_rec.agf_attribute13 :=
505: ben_agf_shd.g_old_rec.agf_attribute13;
506: End If;
507: If (p_rec.agf_attribute14 = hr_api.g_varchar2) then

Line 507: If (p_rec.agf_attribute14 = hr_api.g_varchar2) then

503: If (p_rec.agf_attribute13 = hr_api.g_varchar2) then
504: p_rec.agf_attribute13 :=
505: ben_agf_shd.g_old_rec.agf_attribute13;
506: End If;
507: If (p_rec.agf_attribute14 = hr_api.g_varchar2) then
508: p_rec.agf_attribute14 :=
509: ben_agf_shd.g_old_rec.agf_attribute14;
510: End If;
511: If (p_rec.agf_attribute15 = hr_api.g_varchar2) then

Line 511: If (p_rec.agf_attribute15 = hr_api.g_varchar2) then

507: If (p_rec.agf_attribute14 = hr_api.g_varchar2) then
508: p_rec.agf_attribute14 :=
509: ben_agf_shd.g_old_rec.agf_attribute14;
510: End If;
511: If (p_rec.agf_attribute15 = hr_api.g_varchar2) then
512: p_rec.agf_attribute15 :=
513: ben_agf_shd.g_old_rec.agf_attribute15;
514: End If;
515: If (p_rec.agf_attribute16 = hr_api.g_varchar2) then

Line 515: If (p_rec.agf_attribute16 = hr_api.g_varchar2) then

511: If (p_rec.agf_attribute15 = hr_api.g_varchar2) then
512: p_rec.agf_attribute15 :=
513: ben_agf_shd.g_old_rec.agf_attribute15;
514: End If;
515: If (p_rec.agf_attribute16 = hr_api.g_varchar2) then
516: p_rec.agf_attribute16 :=
517: ben_agf_shd.g_old_rec.agf_attribute16;
518: End If;
519: If (p_rec.agf_attribute17 = hr_api.g_varchar2) then

Line 519: If (p_rec.agf_attribute17 = hr_api.g_varchar2) then

515: If (p_rec.agf_attribute16 = hr_api.g_varchar2) then
516: p_rec.agf_attribute16 :=
517: ben_agf_shd.g_old_rec.agf_attribute16;
518: End If;
519: If (p_rec.agf_attribute17 = hr_api.g_varchar2) then
520: p_rec.agf_attribute17 :=
521: ben_agf_shd.g_old_rec.agf_attribute17;
522: End If;
523: If (p_rec.agf_attribute18 = hr_api.g_varchar2) then

Line 523: If (p_rec.agf_attribute18 = hr_api.g_varchar2) then

519: If (p_rec.agf_attribute17 = hr_api.g_varchar2) then
520: p_rec.agf_attribute17 :=
521: ben_agf_shd.g_old_rec.agf_attribute17;
522: End If;
523: If (p_rec.agf_attribute18 = hr_api.g_varchar2) then
524: p_rec.agf_attribute18 :=
525: ben_agf_shd.g_old_rec.agf_attribute18;
526: End If;
527: If (p_rec.agf_attribute19 = hr_api.g_varchar2) then

Line 527: If (p_rec.agf_attribute19 = hr_api.g_varchar2) then

523: If (p_rec.agf_attribute18 = hr_api.g_varchar2) then
524: p_rec.agf_attribute18 :=
525: ben_agf_shd.g_old_rec.agf_attribute18;
526: End If;
527: If (p_rec.agf_attribute19 = hr_api.g_varchar2) then
528: p_rec.agf_attribute19 :=
529: ben_agf_shd.g_old_rec.agf_attribute19;
530: End If;
531: If (p_rec.agf_attribute20 = hr_api.g_varchar2) then

Line 531: If (p_rec.agf_attribute20 = hr_api.g_varchar2) then

527: If (p_rec.agf_attribute19 = hr_api.g_varchar2) then
528: p_rec.agf_attribute19 :=
529: ben_agf_shd.g_old_rec.agf_attribute19;
530: End If;
531: If (p_rec.agf_attribute20 = hr_api.g_varchar2) then
532: p_rec.agf_attribute20 :=
533: ben_agf_shd.g_old_rec.agf_attribute20;
534: End If;
535: If (p_rec.agf_attribute21 = hr_api.g_varchar2) then

Line 535: If (p_rec.agf_attribute21 = hr_api.g_varchar2) then

531: If (p_rec.agf_attribute20 = hr_api.g_varchar2) then
532: p_rec.agf_attribute20 :=
533: ben_agf_shd.g_old_rec.agf_attribute20;
534: End If;
535: If (p_rec.agf_attribute21 = hr_api.g_varchar2) then
536: p_rec.agf_attribute21 :=
537: ben_agf_shd.g_old_rec.agf_attribute21;
538: End If;
539: If (p_rec.agf_attribute22 = hr_api.g_varchar2) then

Line 539: If (p_rec.agf_attribute22 = hr_api.g_varchar2) then

535: If (p_rec.agf_attribute21 = hr_api.g_varchar2) then
536: p_rec.agf_attribute21 :=
537: ben_agf_shd.g_old_rec.agf_attribute21;
538: End If;
539: If (p_rec.agf_attribute22 = hr_api.g_varchar2) then
540: p_rec.agf_attribute22 :=
541: ben_agf_shd.g_old_rec.agf_attribute22;
542: End If;
543: If (p_rec.agf_attribute23 = hr_api.g_varchar2) then

Line 543: If (p_rec.agf_attribute23 = hr_api.g_varchar2) then

539: If (p_rec.agf_attribute22 = hr_api.g_varchar2) then
540: p_rec.agf_attribute22 :=
541: ben_agf_shd.g_old_rec.agf_attribute22;
542: End If;
543: If (p_rec.agf_attribute23 = hr_api.g_varchar2) then
544: p_rec.agf_attribute23 :=
545: ben_agf_shd.g_old_rec.agf_attribute23;
546: End If;
547: If (p_rec.agf_attribute24 = hr_api.g_varchar2) then

Line 547: If (p_rec.agf_attribute24 = hr_api.g_varchar2) then

543: If (p_rec.agf_attribute23 = hr_api.g_varchar2) then
544: p_rec.agf_attribute23 :=
545: ben_agf_shd.g_old_rec.agf_attribute23;
546: End If;
547: If (p_rec.agf_attribute24 = hr_api.g_varchar2) then
548: p_rec.agf_attribute24 :=
549: ben_agf_shd.g_old_rec.agf_attribute24;
550: End If;
551: If (p_rec.agf_attribute25 = hr_api.g_varchar2) then

Line 551: If (p_rec.agf_attribute25 = hr_api.g_varchar2) then

547: If (p_rec.agf_attribute24 = hr_api.g_varchar2) then
548: p_rec.agf_attribute24 :=
549: ben_agf_shd.g_old_rec.agf_attribute24;
550: End If;
551: If (p_rec.agf_attribute25 = hr_api.g_varchar2) then
552: p_rec.agf_attribute25 :=
553: ben_agf_shd.g_old_rec.agf_attribute25;
554: End If;
555: If (p_rec.agf_attribute26 = hr_api.g_varchar2) then

Line 555: If (p_rec.agf_attribute26 = hr_api.g_varchar2) then

551: If (p_rec.agf_attribute25 = hr_api.g_varchar2) then
552: p_rec.agf_attribute25 :=
553: ben_agf_shd.g_old_rec.agf_attribute25;
554: End If;
555: If (p_rec.agf_attribute26 = hr_api.g_varchar2) then
556: p_rec.agf_attribute26 :=
557: ben_agf_shd.g_old_rec.agf_attribute26;
558: End If;
559: If (p_rec.agf_attribute27 = hr_api.g_varchar2) then

Line 559: If (p_rec.agf_attribute27 = hr_api.g_varchar2) then

555: If (p_rec.agf_attribute26 = hr_api.g_varchar2) then
556: p_rec.agf_attribute26 :=
557: ben_agf_shd.g_old_rec.agf_attribute26;
558: End If;
559: If (p_rec.agf_attribute27 = hr_api.g_varchar2) then
560: p_rec.agf_attribute27 :=
561: ben_agf_shd.g_old_rec.agf_attribute27;
562: End If;
563: If (p_rec.agf_attribute28 = hr_api.g_varchar2) then

Line 563: If (p_rec.agf_attribute28 = hr_api.g_varchar2) then

559: If (p_rec.agf_attribute27 = hr_api.g_varchar2) then
560: p_rec.agf_attribute27 :=
561: ben_agf_shd.g_old_rec.agf_attribute27;
562: End If;
563: If (p_rec.agf_attribute28 = hr_api.g_varchar2) then
564: p_rec.agf_attribute28 :=
565: ben_agf_shd.g_old_rec.agf_attribute28;
566: End If;
567: If (p_rec.agf_attribute29 = hr_api.g_varchar2) then

Line 567: If (p_rec.agf_attribute29 = hr_api.g_varchar2) then

563: If (p_rec.agf_attribute28 = hr_api.g_varchar2) then
564: p_rec.agf_attribute28 :=
565: ben_agf_shd.g_old_rec.agf_attribute28;
566: End If;
567: If (p_rec.agf_attribute29 = hr_api.g_varchar2) then
568: p_rec.agf_attribute29 :=
569: ben_agf_shd.g_old_rec.agf_attribute29;
570: End If;
571: If (p_rec.agf_attribute30 = hr_api.g_varchar2) then

Line 571: If (p_rec.agf_attribute30 = hr_api.g_varchar2) then

567: If (p_rec.agf_attribute29 = hr_api.g_varchar2) then
568: p_rec.agf_attribute29 :=
569: ben_agf_shd.g_old_rec.agf_attribute29;
570: End If;
571: If (p_rec.agf_attribute30 = hr_api.g_varchar2) then
572: p_rec.agf_attribute30 :=
573: ben_agf_shd.g_old_rec.agf_attribute30;
574: End If;
575:

Line 634: p_name in varchar2 default hr_api.g_varchar2,

630: Procedure upd
631: (
632: p_effective_date in date,
633: p_age_fctr_id in number,
634: p_name in varchar2 default hr_api.g_varchar2,
635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,

Line 635: p_mx_age_num in number default hr_api.g_number,

631: (
632: p_effective_date in date,
633: p_age_fctr_id in number,
634: p_name in varchar2 default hr_api.g_varchar2,
635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,

Line 636: p_mn_age_num in number default hr_api.g_number,

632: p_effective_date in date,
633: p_age_fctr_id in number,
634: p_name in varchar2 default hr_api.g_varchar2,
635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,

Line 637: p_age_uom in varchar2 default hr_api.g_varchar2,

633: p_age_fctr_id in number,
634: p_name in varchar2 default hr_api.g_varchar2,
635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,

Line 638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,

634: p_name in varchar2 default hr_api.g_varchar2,
635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,

Line 639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,

635: p_mx_age_num in number default hr_api.g_number,
636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,

Line 640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,

636: p_mn_age_num in number default hr_api.g_number,
637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,

Line 641: p_age_det_cd in varchar2 default hr_api.g_varchar2,

637: p_age_uom in varchar2 default hr_api.g_varchar2,
638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,

Line 642: p_age_det_rl in number default hr_api.g_number,

638: p_no_mn_age_flag in varchar2 default hr_api.g_varchar2,
639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,

Line 643: p_rndg_cd in varchar2 default hr_api.g_varchar2,

639: p_no_mx_age_flag in varchar2 default hr_api.g_varchar2,
640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,

Line 644: p_rndg_rl in number default hr_api.g_number,

640: p_age_to_use_cd in varchar2 default hr_api.g_varchar2,
641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,

Line 645: p_age_calc_rl in number default hr_api.g_number,

641: p_age_det_cd in varchar2 default hr_api.g_varchar2,
642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,

Line 646: p_business_group_id in number default hr_api.g_number,

642: p_age_det_rl in number default hr_api.g_number,
643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,

Line 647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,

643: p_rndg_cd in varchar2 default hr_api.g_varchar2,
644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,

Line 648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,

644: p_rndg_rl in number default hr_api.g_number,
645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,

Line 649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,

645: p_age_calc_rl in number default hr_api.g_number,
646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,

Line 650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,

646: p_business_group_id in number default hr_api.g_number,
647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,

Line 651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,

647: p_agf_attribute_category in varchar2 default hr_api.g_varchar2,
648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,

Line 652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,

648: p_agf_attribute1 in varchar2 default hr_api.g_varchar2,
649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,

Line 653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,

649: p_agf_attribute2 in varchar2 default hr_api.g_varchar2,
650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,

Line 654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,

650: p_agf_attribute3 in varchar2 default hr_api.g_varchar2,
651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,

Line 655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,

651: p_agf_attribute4 in varchar2 default hr_api.g_varchar2,
652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,

Line 656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,

652: p_agf_attribute5 in varchar2 default hr_api.g_varchar2,
653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,

Line 657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,

653: p_agf_attribute6 in varchar2 default hr_api.g_varchar2,
654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,

Line 658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,

654: p_agf_attribute7 in varchar2 default hr_api.g_varchar2,
655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,

Line 659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,

655: p_agf_attribute8 in varchar2 default hr_api.g_varchar2,
656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,

Line 660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,

656: p_agf_attribute9 in varchar2 default hr_api.g_varchar2,
657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,

Line 661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,

657: p_agf_attribute10 in varchar2 default hr_api.g_varchar2,
658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,

Line 662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,

658: p_agf_attribute11 in varchar2 default hr_api.g_varchar2,
659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,

Line 663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,

659: p_agf_attribute12 in varchar2 default hr_api.g_varchar2,
660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,

Line 664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,

660: p_agf_attribute13 in varchar2 default hr_api.g_varchar2,
661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,

Line 665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,

661: p_agf_attribute14 in varchar2 default hr_api.g_varchar2,
662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,

Line 666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,

662: p_agf_attribute15 in varchar2 default hr_api.g_varchar2,
663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,

Line 667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,

663: p_agf_attribute16 in varchar2 default hr_api.g_varchar2,
664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,

Line 668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,

664: p_agf_attribute17 in varchar2 default hr_api.g_varchar2,
665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,

Line 669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,

665: p_agf_attribute18 in varchar2 default hr_api.g_varchar2,
666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,

Line 670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,

666: p_agf_attribute19 in varchar2 default hr_api.g_varchar2,
667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,

Line 671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,

667: p_agf_attribute20 in varchar2 default hr_api.g_varchar2,
668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,

Line 672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,

668: p_agf_attribute21 in varchar2 default hr_api.g_varchar2,
669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,

Line 673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,

669: p_agf_attribute22 in varchar2 default hr_api.g_varchar2,
670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,
677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,

Line 674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,

670: p_agf_attribute23 in varchar2 default hr_api.g_varchar2,
671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,
677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,
678: p_object_version_number in out nocopy number

Line 675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,

671: p_agf_attribute24 in varchar2 default hr_api.g_varchar2,
672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,
677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,
678: p_object_version_number in out nocopy number
679: ) is

Line 676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,

672: p_agf_attribute25 in varchar2 default hr_api.g_varchar2,
673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,
677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,
678: p_object_version_number in out nocopy number
679: ) is
680: --

Line 677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,

673: p_agf_attribute26 in varchar2 default hr_api.g_varchar2,
674: p_agf_attribute27 in varchar2 default hr_api.g_varchar2,
675: p_agf_attribute28 in varchar2 default hr_api.g_varchar2,
676: p_agf_attribute29 in varchar2 default hr_api.g_varchar2,
677: p_agf_attribute30 in varchar2 default hr_api.g_varchar2,
678: p_object_version_number in out nocopy number
679: ) is
680: --
681: l_rec ben_agf_shd.g_rec_type;