126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
131: -- A check constraint has been violated
132: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
133: ben_bnr_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
136: -- Parent integrity has been violated
137: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
138: ben_bnr_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
143: ben_bnr_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End update_dml;
319: );
320: --
321: exception
322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'ben_rptg_grp'
327: ,p_hook_type => 'AU');
321: exception
322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'ben_rptg_grp'
327: ,p_hook_type => 'AU');
328: --
329: end;
389: -- p_rec plsql record structure
390: -- to see if a system default is being used. If a system default
391: -- is being used then we must set to the 'current' argument value.
392: --
393: If (p_rec.name = hr_api.g_varchar2) then
394: p_rec.name :=
395: ben_bnr_shd.g_old_rec.name;
396: End If;
397: If (p_rec.business_group_id = hr_api.g_number) then
393: If (p_rec.name = hr_api.g_varchar2) then
394: p_rec.name :=
395: ben_bnr_shd.g_old_rec.name;
396: End If;
397: If (p_rec.business_group_id = hr_api.g_number) then
398: p_rec.business_group_id :=
399: ben_bnr_shd.g_old_rec.business_group_id;
400: End If;
401: If (p_rec.rptg_prps_cd = hr_api.g_varchar2) then
397: If (p_rec.business_group_id = hr_api.g_number) then
398: p_rec.business_group_id :=
399: ben_bnr_shd.g_old_rec.business_group_id;
400: End If;
401: If (p_rec.rptg_prps_cd = hr_api.g_varchar2) then
402: p_rec.rptg_prps_cd :=
403: ben_bnr_shd.g_old_rec.rptg_prps_cd;
404: End If;
405: If (p_rec.rpg_desc = hr_api.g_varchar2) then
401: If (p_rec.rptg_prps_cd = hr_api.g_varchar2) then
402: p_rec.rptg_prps_cd :=
403: ben_bnr_shd.g_old_rec.rptg_prps_cd;
404: End If;
405: If (p_rec.rpg_desc = hr_api.g_varchar2) then
406: p_rec.rpg_desc :=
407: ben_bnr_shd.g_old_rec.rpg_desc;
408: End If;
409: If (p_rec.bnr_attribute_category = hr_api.g_varchar2) then
405: If (p_rec.rpg_desc = hr_api.g_varchar2) then
406: p_rec.rpg_desc :=
407: ben_bnr_shd.g_old_rec.rpg_desc;
408: End If;
409: If (p_rec.bnr_attribute_category = hr_api.g_varchar2) then
410: p_rec.bnr_attribute_category :=
411: ben_bnr_shd.g_old_rec.bnr_attribute_category;
412: End If;
413: If (p_rec.bnr_attribute1 = hr_api.g_varchar2) then
409: If (p_rec.bnr_attribute_category = hr_api.g_varchar2) then
410: p_rec.bnr_attribute_category :=
411: ben_bnr_shd.g_old_rec.bnr_attribute_category;
412: End If;
413: If (p_rec.bnr_attribute1 = hr_api.g_varchar2) then
414: p_rec.bnr_attribute1 :=
415: ben_bnr_shd.g_old_rec.bnr_attribute1;
416: End If;
417: If (p_rec.bnr_attribute2 = hr_api.g_varchar2) then
413: If (p_rec.bnr_attribute1 = hr_api.g_varchar2) then
414: p_rec.bnr_attribute1 :=
415: ben_bnr_shd.g_old_rec.bnr_attribute1;
416: End If;
417: If (p_rec.bnr_attribute2 = hr_api.g_varchar2) then
418: p_rec.bnr_attribute2 :=
419: ben_bnr_shd.g_old_rec.bnr_attribute2;
420: End If;
421: If (p_rec.bnr_attribute3 = hr_api.g_varchar2) then
417: If (p_rec.bnr_attribute2 = hr_api.g_varchar2) then
418: p_rec.bnr_attribute2 :=
419: ben_bnr_shd.g_old_rec.bnr_attribute2;
420: End If;
421: If (p_rec.bnr_attribute3 = hr_api.g_varchar2) then
422: p_rec.bnr_attribute3 :=
423: ben_bnr_shd.g_old_rec.bnr_attribute3;
424: End If;
425: If (p_rec.bnr_attribute4 = hr_api.g_varchar2) then
421: If (p_rec.bnr_attribute3 = hr_api.g_varchar2) then
422: p_rec.bnr_attribute3 :=
423: ben_bnr_shd.g_old_rec.bnr_attribute3;
424: End If;
425: If (p_rec.bnr_attribute4 = hr_api.g_varchar2) then
426: p_rec.bnr_attribute4 :=
427: ben_bnr_shd.g_old_rec.bnr_attribute4;
428: End If;
429: If (p_rec.bnr_attribute5 = hr_api.g_varchar2) then
425: If (p_rec.bnr_attribute4 = hr_api.g_varchar2) then
426: p_rec.bnr_attribute4 :=
427: ben_bnr_shd.g_old_rec.bnr_attribute4;
428: End If;
429: If (p_rec.bnr_attribute5 = hr_api.g_varchar2) then
430: p_rec.bnr_attribute5 :=
431: ben_bnr_shd.g_old_rec.bnr_attribute5;
432: End If;
433: If (p_rec.bnr_attribute6 = hr_api.g_varchar2) then
429: If (p_rec.bnr_attribute5 = hr_api.g_varchar2) then
430: p_rec.bnr_attribute5 :=
431: ben_bnr_shd.g_old_rec.bnr_attribute5;
432: End If;
433: If (p_rec.bnr_attribute6 = hr_api.g_varchar2) then
434: p_rec.bnr_attribute6 :=
435: ben_bnr_shd.g_old_rec.bnr_attribute6;
436: End If;
437: If (p_rec.bnr_attribute7 = hr_api.g_varchar2) then
433: If (p_rec.bnr_attribute6 = hr_api.g_varchar2) then
434: p_rec.bnr_attribute6 :=
435: ben_bnr_shd.g_old_rec.bnr_attribute6;
436: End If;
437: If (p_rec.bnr_attribute7 = hr_api.g_varchar2) then
438: p_rec.bnr_attribute7 :=
439: ben_bnr_shd.g_old_rec.bnr_attribute7;
440: End If;
441: If (p_rec.bnr_attribute8 = hr_api.g_varchar2) then
437: If (p_rec.bnr_attribute7 = hr_api.g_varchar2) then
438: p_rec.bnr_attribute7 :=
439: ben_bnr_shd.g_old_rec.bnr_attribute7;
440: End If;
441: If (p_rec.bnr_attribute8 = hr_api.g_varchar2) then
442: p_rec.bnr_attribute8 :=
443: ben_bnr_shd.g_old_rec.bnr_attribute8;
444: End If;
445: If (p_rec.bnr_attribute9 = hr_api.g_varchar2) then
441: If (p_rec.bnr_attribute8 = hr_api.g_varchar2) then
442: p_rec.bnr_attribute8 :=
443: ben_bnr_shd.g_old_rec.bnr_attribute8;
444: End If;
445: If (p_rec.bnr_attribute9 = hr_api.g_varchar2) then
446: p_rec.bnr_attribute9 :=
447: ben_bnr_shd.g_old_rec.bnr_attribute9;
448: End If;
449: If (p_rec.bnr_attribute10 = hr_api.g_varchar2) then
445: If (p_rec.bnr_attribute9 = hr_api.g_varchar2) then
446: p_rec.bnr_attribute9 :=
447: ben_bnr_shd.g_old_rec.bnr_attribute9;
448: End If;
449: If (p_rec.bnr_attribute10 = hr_api.g_varchar2) then
450: p_rec.bnr_attribute10 :=
451: ben_bnr_shd.g_old_rec.bnr_attribute10;
452: End If;
453: If (p_rec.bnr_attribute11 = hr_api.g_varchar2) then
449: If (p_rec.bnr_attribute10 = hr_api.g_varchar2) then
450: p_rec.bnr_attribute10 :=
451: ben_bnr_shd.g_old_rec.bnr_attribute10;
452: End If;
453: If (p_rec.bnr_attribute11 = hr_api.g_varchar2) then
454: p_rec.bnr_attribute11 :=
455: ben_bnr_shd.g_old_rec.bnr_attribute11;
456: End If;
457: If (p_rec.bnr_attribute12 = hr_api.g_varchar2) then
453: If (p_rec.bnr_attribute11 = hr_api.g_varchar2) then
454: p_rec.bnr_attribute11 :=
455: ben_bnr_shd.g_old_rec.bnr_attribute11;
456: End If;
457: If (p_rec.bnr_attribute12 = hr_api.g_varchar2) then
458: p_rec.bnr_attribute12 :=
459: ben_bnr_shd.g_old_rec.bnr_attribute12;
460: End If;
461: If (p_rec.bnr_attribute13 = hr_api.g_varchar2) then
457: If (p_rec.bnr_attribute12 = hr_api.g_varchar2) then
458: p_rec.bnr_attribute12 :=
459: ben_bnr_shd.g_old_rec.bnr_attribute12;
460: End If;
461: If (p_rec.bnr_attribute13 = hr_api.g_varchar2) then
462: p_rec.bnr_attribute13 :=
463: ben_bnr_shd.g_old_rec.bnr_attribute13;
464: End If;
465: If (p_rec.bnr_attribute14 = hr_api.g_varchar2) then
461: If (p_rec.bnr_attribute13 = hr_api.g_varchar2) then
462: p_rec.bnr_attribute13 :=
463: ben_bnr_shd.g_old_rec.bnr_attribute13;
464: End If;
465: If (p_rec.bnr_attribute14 = hr_api.g_varchar2) then
466: p_rec.bnr_attribute14 :=
467: ben_bnr_shd.g_old_rec.bnr_attribute14;
468: End If;
469: If (p_rec.bnr_attribute15 = hr_api.g_varchar2) then
465: If (p_rec.bnr_attribute14 = hr_api.g_varchar2) then
466: p_rec.bnr_attribute14 :=
467: ben_bnr_shd.g_old_rec.bnr_attribute14;
468: End If;
469: If (p_rec.bnr_attribute15 = hr_api.g_varchar2) then
470: p_rec.bnr_attribute15 :=
471: ben_bnr_shd.g_old_rec.bnr_attribute15;
472: End If;
473: If (p_rec.bnr_attribute16 = hr_api.g_varchar2) then
469: If (p_rec.bnr_attribute15 = hr_api.g_varchar2) then
470: p_rec.bnr_attribute15 :=
471: ben_bnr_shd.g_old_rec.bnr_attribute15;
472: End If;
473: If (p_rec.bnr_attribute16 = hr_api.g_varchar2) then
474: p_rec.bnr_attribute16 :=
475: ben_bnr_shd.g_old_rec.bnr_attribute16;
476: End If;
477: If (p_rec.bnr_attribute17 = hr_api.g_varchar2) then
473: If (p_rec.bnr_attribute16 = hr_api.g_varchar2) then
474: p_rec.bnr_attribute16 :=
475: ben_bnr_shd.g_old_rec.bnr_attribute16;
476: End If;
477: If (p_rec.bnr_attribute17 = hr_api.g_varchar2) then
478: p_rec.bnr_attribute17 :=
479: ben_bnr_shd.g_old_rec.bnr_attribute17;
480: End If;
481: If (p_rec.bnr_attribute18 = hr_api.g_varchar2) then
477: If (p_rec.bnr_attribute17 = hr_api.g_varchar2) then
478: p_rec.bnr_attribute17 :=
479: ben_bnr_shd.g_old_rec.bnr_attribute17;
480: End If;
481: If (p_rec.bnr_attribute18 = hr_api.g_varchar2) then
482: p_rec.bnr_attribute18 :=
483: ben_bnr_shd.g_old_rec.bnr_attribute18;
484: End If;
485: If (p_rec.bnr_attribute19 = hr_api.g_varchar2) then
481: If (p_rec.bnr_attribute18 = hr_api.g_varchar2) then
482: p_rec.bnr_attribute18 :=
483: ben_bnr_shd.g_old_rec.bnr_attribute18;
484: End If;
485: If (p_rec.bnr_attribute19 = hr_api.g_varchar2) then
486: p_rec.bnr_attribute19 :=
487: ben_bnr_shd.g_old_rec.bnr_attribute19;
488: End If;
489: If (p_rec.bnr_attribute20 = hr_api.g_varchar2) then
485: If (p_rec.bnr_attribute19 = hr_api.g_varchar2) then
486: p_rec.bnr_attribute19 :=
487: ben_bnr_shd.g_old_rec.bnr_attribute19;
488: End If;
489: If (p_rec.bnr_attribute20 = hr_api.g_varchar2) then
490: p_rec.bnr_attribute20 :=
491: ben_bnr_shd.g_old_rec.bnr_attribute20;
492: End If;
493: If (p_rec.bnr_attribute21 = hr_api.g_varchar2) then
489: If (p_rec.bnr_attribute20 = hr_api.g_varchar2) then
490: p_rec.bnr_attribute20 :=
491: ben_bnr_shd.g_old_rec.bnr_attribute20;
492: End If;
493: If (p_rec.bnr_attribute21 = hr_api.g_varchar2) then
494: p_rec.bnr_attribute21 :=
495: ben_bnr_shd.g_old_rec.bnr_attribute21;
496: End If;
497: If (p_rec.bnr_attribute22 = hr_api.g_varchar2) then
493: If (p_rec.bnr_attribute21 = hr_api.g_varchar2) then
494: p_rec.bnr_attribute21 :=
495: ben_bnr_shd.g_old_rec.bnr_attribute21;
496: End If;
497: If (p_rec.bnr_attribute22 = hr_api.g_varchar2) then
498: p_rec.bnr_attribute22 :=
499: ben_bnr_shd.g_old_rec.bnr_attribute22;
500: End If;
501: If (p_rec.bnr_attribute23 = hr_api.g_varchar2) then
497: If (p_rec.bnr_attribute22 = hr_api.g_varchar2) then
498: p_rec.bnr_attribute22 :=
499: ben_bnr_shd.g_old_rec.bnr_attribute22;
500: End If;
501: If (p_rec.bnr_attribute23 = hr_api.g_varchar2) then
502: p_rec.bnr_attribute23 :=
503: ben_bnr_shd.g_old_rec.bnr_attribute23;
504: End If;
505: If (p_rec.bnr_attribute24 = hr_api.g_varchar2) then
501: If (p_rec.bnr_attribute23 = hr_api.g_varchar2) then
502: p_rec.bnr_attribute23 :=
503: ben_bnr_shd.g_old_rec.bnr_attribute23;
504: End If;
505: If (p_rec.bnr_attribute24 = hr_api.g_varchar2) then
506: p_rec.bnr_attribute24 :=
507: ben_bnr_shd.g_old_rec.bnr_attribute24;
508: End If;
509: If (p_rec.bnr_attribute25 = hr_api.g_varchar2) then
505: If (p_rec.bnr_attribute24 = hr_api.g_varchar2) then
506: p_rec.bnr_attribute24 :=
507: ben_bnr_shd.g_old_rec.bnr_attribute24;
508: End If;
509: If (p_rec.bnr_attribute25 = hr_api.g_varchar2) then
510: p_rec.bnr_attribute25 :=
511: ben_bnr_shd.g_old_rec.bnr_attribute25;
512: End If;
513: If (p_rec.bnr_attribute26 = hr_api.g_varchar2) then
509: If (p_rec.bnr_attribute25 = hr_api.g_varchar2) then
510: p_rec.bnr_attribute25 :=
511: ben_bnr_shd.g_old_rec.bnr_attribute25;
512: End If;
513: If (p_rec.bnr_attribute26 = hr_api.g_varchar2) then
514: p_rec.bnr_attribute26 :=
515: ben_bnr_shd.g_old_rec.bnr_attribute26;
516: End If;
517: If (p_rec.bnr_attribute27 = hr_api.g_varchar2) then
513: If (p_rec.bnr_attribute26 = hr_api.g_varchar2) then
514: p_rec.bnr_attribute26 :=
515: ben_bnr_shd.g_old_rec.bnr_attribute26;
516: End If;
517: If (p_rec.bnr_attribute27 = hr_api.g_varchar2) then
518: p_rec.bnr_attribute27 :=
519: ben_bnr_shd.g_old_rec.bnr_attribute27;
520: End If;
521: If (p_rec.bnr_attribute28 = hr_api.g_varchar2) then
517: If (p_rec.bnr_attribute27 = hr_api.g_varchar2) then
518: p_rec.bnr_attribute27 :=
519: ben_bnr_shd.g_old_rec.bnr_attribute27;
520: End If;
521: If (p_rec.bnr_attribute28 = hr_api.g_varchar2) then
522: p_rec.bnr_attribute28 :=
523: ben_bnr_shd.g_old_rec.bnr_attribute28;
524: End If;
525: If (p_rec.bnr_attribute29 = hr_api.g_varchar2) then
521: If (p_rec.bnr_attribute28 = hr_api.g_varchar2) then
522: p_rec.bnr_attribute28 :=
523: ben_bnr_shd.g_old_rec.bnr_attribute28;
524: End If;
525: If (p_rec.bnr_attribute29 = hr_api.g_varchar2) then
526: p_rec.bnr_attribute29 :=
527: ben_bnr_shd.g_old_rec.bnr_attribute29;
528: End If;
529: If (p_rec.bnr_attribute30 = hr_api.g_varchar2) then
525: If (p_rec.bnr_attribute29 = hr_api.g_varchar2) then
526: p_rec.bnr_attribute29 :=
527: ben_bnr_shd.g_old_rec.bnr_attribute29;
528: End If;
529: If (p_rec.bnr_attribute30 = hr_api.g_varchar2) then
530: p_rec.bnr_attribute30 :=
531: ben_bnr_shd.g_old_rec.bnr_attribute30;
532: End If;
533: --iRec
530: p_rec.bnr_attribute30 :=
531: ben_bnr_shd.g_old_rec.bnr_attribute30;
532: End If;
533: --iRec
534: If (p_rec.ordr_num = hr_api.g_number) then
535: p_rec.ordr_num :=
536: ben_bnr_shd.g_old_rec.ordr_num;
537: End If;
538: --iRec
593: Procedure upd
594: (
595: p_effective_date in date,
596: p_rptg_grp_id in number,
597: p_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
594: (
595: p_effective_date in date,
596: p_rptg_grp_id in number,
597: p_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
595: p_effective_date in date,
596: p_rptg_grp_id in number,
597: p_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
596: p_rptg_grp_id in number,
597: p_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
597: p_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
599: p_rptg_prps_cd in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
600: p_rpg_desc in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
601: p_bnr_attribute_category in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
602: p_bnr_attribute1 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
603: p_bnr_attribute2 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
604: p_bnr_attribute3 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
605: p_bnr_attribute4 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
606: p_bnr_attribute5 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
607: p_bnr_attribute6 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
608: p_bnr_attribute7 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
609: p_bnr_attribute8 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
610: p_bnr_attribute9 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
611: p_bnr_attribute10 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
612: p_bnr_attribute11 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
613: p_bnr_attribute12 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
614: p_bnr_attribute13 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
615: p_bnr_attribute14 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
616: p_bnr_attribute15 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
617: p_bnr_attribute16 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
618: p_bnr_attribute17 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
619: p_bnr_attribute18 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
620: p_bnr_attribute19 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
621: p_bnr_attribute20 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
622: p_bnr_attribute21 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
623: p_bnr_attribute22 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
624: p_bnr_attribute23 in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
625: p_bnr_attribute24 in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
626: p_bnr_attribute25 in varchar2 default hr_api.g_varchar2,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
627: p_bnr_attribute26 in varchar2 default hr_api.g_varchar2,
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_ordr_num in number default hr_api.g_number --iRec
628: p_bnr_attribute27 in varchar2 default hr_api.g_varchar2,
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_ordr_num in number default hr_api.g_number --iRec
636: ) is
629: p_bnr_attribute28 in varchar2 default hr_api.g_varchar2,
630: p_bnr_attribute29 in varchar2 default hr_api.g_varchar2,
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_ordr_num in number default hr_api.g_number --iRec
636: ) is
637: --
631: p_bnr_attribute30 in varchar2 default hr_api.g_varchar2,
632: p_function_code in varchar2 default hr_api.g_varchar2,
633: p_legislation_code in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_ordr_num in number default hr_api.g_number --iRec
636: ) is
637: --
638: l_rec ben_bnr_shd.g_rec_type;
639: l_proc varchar2(72) := g_package||'upd';