110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
117: ben_drr_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
117: ben_drr_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
122: ben_drr_shd.constraint_error
115: -- A check constraint has been violated
116: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
117: ben_drr_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
122: ben_drr_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
122: ben_drr_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
127: ben_drr_shd.constraint_error
120: -- Parent integrity has been violated
121: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
122: ben_drr_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
127: ben_drr_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
127: ben_drr_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_drr_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
132: End update_dml;
295: );
296: --
297: exception
298: --
299: when hr_api.cannot_find_prog_unit then
300: --
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'ben_dsgn_rqmt_rlshp_typ'
303: ,p_hook_type => 'AU');
297: exception
298: --
299: when hr_api.cannot_find_prog_unit then
300: --
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'ben_dsgn_rqmt_rlshp_typ'
303: ,p_hook_type => 'AU');
304: --
305: end;
365: -- p_rec plsql record structure
366: -- to see if a system default is being used. If a system default
367: -- is being used then we must set to the 'current' argument value.
368: --
369: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
370: p_rec.rlshp_typ_cd :=
371: ben_drr_shd.g_old_rec.rlshp_typ_cd;
372: End If;
373: If (p_rec.dsgn_rqmt_id = hr_api.g_number) then
369: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
370: p_rec.rlshp_typ_cd :=
371: ben_drr_shd.g_old_rec.rlshp_typ_cd;
372: End If;
373: If (p_rec.dsgn_rqmt_id = hr_api.g_number) then
374: p_rec.dsgn_rqmt_id :=
375: ben_drr_shd.g_old_rec.dsgn_rqmt_id;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
373: If (p_rec.dsgn_rqmt_id = hr_api.g_number) then
374: p_rec.dsgn_rqmt_id :=
375: ben_drr_shd.g_old_rec.dsgn_rqmt_id;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_drr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.drr_attribute_category = hr_api.g_varchar2) then
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_drr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.drr_attribute_category = hr_api.g_varchar2) then
382: p_rec.drr_attribute_category :=
383: ben_drr_shd.g_old_rec.drr_attribute_category;
384: End If;
385: If (p_rec.drr_attribute1 = hr_api.g_varchar2) then
381: If (p_rec.drr_attribute_category = hr_api.g_varchar2) then
382: p_rec.drr_attribute_category :=
383: ben_drr_shd.g_old_rec.drr_attribute_category;
384: End If;
385: If (p_rec.drr_attribute1 = hr_api.g_varchar2) then
386: p_rec.drr_attribute1 :=
387: ben_drr_shd.g_old_rec.drr_attribute1;
388: End If;
389: If (p_rec.drr_attribute2 = hr_api.g_varchar2) then
385: If (p_rec.drr_attribute1 = hr_api.g_varchar2) then
386: p_rec.drr_attribute1 :=
387: ben_drr_shd.g_old_rec.drr_attribute1;
388: End If;
389: If (p_rec.drr_attribute2 = hr_api.g_varchar2) then
390: p_rec.drr_attribute2 :=
391: ben_drr_shd.g_old_rec.drr_attribute2;
392: End If;
393: If (p_rec.drr_attribute3 = hr_api.g_varchar2) then
389: If (p_rec.drr_attribute2 = hr_api.g_varchar2) then
390: p_rec.drr_attribute2 :=
391: ben_drr_shd.g_old_rec.drr_attribute2;
392: End If;
393: If (p_rec.drr_attribute3 = hr_api.g_varchar2) then
394: p_rec.drr_attribute3 :=
395: ben_drr_shd.g_old_rec.drr_attribute3;
396: End If;
397: If (p_rec.drr_attribute4 = hr_api.g_varchar2) then
393: If (p_rec.drr_attribute3 = hr_api.g_varchar2) then
394: p_rec.drr_attribute3 :=
395: ben_drr_shd.g_old_rec.drr_attribute3;
396: End If;
397: If (p_rec.drr_attribute4 = hr_api.g_varchar2) then
398: p_rec.drr_attribute4 :=
399: ben_drr_shd.g_old_rec.drr_attribute4;
400: End If;
401: If (p_rec.drr_attribute5 = hr_api.g_varchar2) then
397: If (p_rec.drr_attribute4 = hr_api.g_varchar2) then
398: p_rec.drr_attribute4 :=
399: ben_drr_shd.g_old_rec.drr_attribute4;
400: End If;
401: If (p_rec.drr_attribute5 = hr_api.g_varchar2) then
402: p_rec.drr_attribute5 :=
403: ben_drr_shd.g_old_rec.drr_attribute5;
404: End If;
405: If (p_rec.drr_attribute6 = hr_api.g_varchar2) then
401: If (p_rec.drr_attribute5 = hr_api.g_varchar2) then
402: p_rec.drr_attribute5 :=
403: ben_drr_shd.g_old_rec.drr_attribute5;
404: End If;
405: If (p_rec.drr_attribute6 = hr_api.g_varchar2) then
406: p_rec.drr_attribute6 :=
407: ben_drr_shd.g_old_rec.drr_attribute6;
408: End If;
409: If (p_rec.drr_attribute7 = hr_api.g_varchar2) then
405: If (p_rec.drr_attribute6 = hr_api.g_varchar2) then
406: p_rec.drr_attribute6 :=
407: ben_drr_shd.g_old_rec.drr_attribute6;
408: End If;
409: If (p_rec.drr_attribute7 = hr_api.g_varchar2) then
410: p_rec.drr_attribute7 :=
411: ben_drr_shd.g_old_rec.drr_attribute7;
412: End If;
413: If (p_rec.drr_attribute8 = hr_api.g_varchar2) then
409: If (p_rec.drr_attribute7 = hr_api.g_varchar2) then
410: p_rec.drr_attribute7 :=
411: ben_drr_shd.g_old_rec.drr_attribute7;
412: End If;
413: If (p_rec.drr_attribute8 = hr_api.g_varchar2) then
414: p_rec.drr_attribute8 :=
415: ben_drr_shd.g_old_rec.drr_attribute8;
416: End If;
417: If (p_rec.drr_attribute9 = hr_api.g_varchar2) then
413: If (p_rec.drr_attribute8 = hr_api.g_varchar2) then
414: p_rec.drr_attribute8 :=
415: ben_drr_shd.g_old_rec.drr_attribute8;
416: End If;
417: If (p_rec.drr_attribute9 = hr_api.g_varchar2) then
418: p_rec.drr_attribute9 :=
419: ben_drr_shd.g_old_rec.drr_attribute9;
420: End If;
421: If (p_rec.drr_attribute10 = hr_api.g_varchar2) then
417: If (p_rec.drr_attribute9 = hr_api.g_varchar2) then
418: p_rec.drr_attribute9 :=
419: ben_drr_shd.g_old_rec.drr_attribute9;
420: End If;
421: If (p_rec.drr_attribute10 = hr_api.g_varchar2) then
422: p_rec.drr_attribute10 :=
423: ben_drr_shd.g_old_rec.drr_attribute10;
424: End If;
425: If (p_rec.drr_attribute11 = hr_api.g_varchar2) then
421: If (p_rec.drr_attribute10 = hr_api.g_varchar2) then
422: p_rec.drr_attribute10 :=
423: ben_drr_shd.g_old_rec.drr_attribute10;
424: End If;
425: If (p_rec.drr_attribute11 = hr_api.g_varchar2) then
426: p_rec.drr_attribute11 :=
427: ben_drr_shd.g_old_rec.drr_attribute11;
428: End If;
429: If (p_rec.drr_attribute12 = hr_api.g_varchar2) then
425: If (p_rec.drr_attribute11 = hr_api.g_varchar2) then
426: p_rec.drr_attribute11 :=
427: ben_drr_shd.g_old_rec.drr_attribute11;
428: End If;
429: If (p_rec.drr_attribute12 = hr_api.g_varchar2) then
430: p_rec.drr_attribute12 :=
431: ben_drr_shd.g_old_rec.drr_attribute12;
432: End If;
433: If (p_rec.drr_attribute13 = hr_api.g_varchar2) then
429: If (p_rec.drr_attribute12 = hr_api.g_varchar2) then
430: p_rec.drr_attribute12 :=
431: ben_drr_shd.g_old_rec.drr_attribute12;
432: End If;
433: If (p_rec.drr_attribute13 = hr_api.g_varchar2) then
434: p_rec.drr_attribute13 :=
435: ben_drr_shd.g_old_rec.drr_attribute13;
436: End If;
437: If (p_rec.drr_attribute14 = hr_api.g_varchar2) then
433: If (p_rec.drr_attribute13 = hr_api.g_varchar2) then
434: p_rec.drr_attribute13 :=
435: ben_drr_shd.g_old_rec.drr_attribute13;
436: End If;
437: If (p_rec.drr_attribute14 = hr_api.g_varchar2) then
438: p_rec.drr_attribute14 :=
439: ben_drr_shd.g_old_rec.drr_attribute14;
440: End If;
441: If (p_rec.drr_attribute15 = hr_api.g_varchar2) then
437: If (p_rec.drr_attribute14 = hr_api.g_varchar2) then
438: p_rec.drr_attribute14 :=
439: ben_drr_shd.g_old_rec.drr_attribute14;
440: End If;
441: If (p_rec.drr_attribute15 = hr_api.g_varchar2) then
442: p_rec.drr_attribute15 :=
443: ben_drr_shd.g_old_rec.drr_attribute15;
444: End If;
445: If (p_rec.drr_attribute16 = hr_api.g_varchar2) then
441: If (p_rec.drr_attribute15 = hr_api.g_varchar2) then
442: p_rec.drr_attribute15 :=
443: ben_drr_shd.g_old_rec.drr_attribute15;
444: End If;
445: If (p_rec.drr_attribute16 = hr_api.g_varchar2) then
446: p_rec.drr_attribute16 :=
447: ben_drr_shd.g_old_rec.drr_attribute16;
448: End If;
449: If (p_rec.drr_attribute17 = hr_api.g_varchar2) then
445: If (p_rec.drr_attribute16 = hr_api.g_varchar2) then
446: p_rec.drr_attribute16 :=
447: ben_drr_shd.g_old_rec.drr_attribute16;
448: End If;
449: If (p_rec.drr_attribute17 = hr_api.g_varchar2) then
450: p_rec.drr_attribute17 :=
451: ben_drr_shd.g_old_rec.drr_attribute17;
452: End If;
453: If (p_rec.drr_attribute18 = hr_api.g_varchar2) then
449: If (p_rec.drr_attribute17 = hr_api.g_varchar2) then
450: p_rec.drr_attribute17 :=
451: ben_drr_shd.g_old_rec.drr_attribute17;
452: End If;
453: If (p_rec.drr_attribute18 = hr_api.g_varchar2) then
454: p_rec.drr_attribute18 :=
455: ben_drr_shd.g_old_rec.drr_attribute18;
456: End If;
457: If (p_rec.drr_attribute19 = hr_api.g_varchar2) then
453: If (p_rec.drr_attribute18 = hr_api.g_varchar2) then
454: p_rec.drr_attribute18 :=
455: ben_drr_shd.g_old_rec.drr_attribute18;
456: End If;
457: If (p_rec.drr_attribute19 = hr_api.g_varchar2) then
458: p_rec.drr_attribute19 :=
459: ben_drr_shd.g_old_rec.drr_attribute19;
460: End If;
461: If (p_rec.drr_attribute20 = hr_api.g_varchar2) then
457: If (p_rec.drr_attribute19 = hr_api.g_varchar2) then
458: p_rec.drr_attribute19 :=
459: ben_drr_shd.g_old_rec.drr_attribute19;
460: End If;
461: If (p_rec.drr_attribute20 = hr_api.g_varchar2) then
462: p_rec.drr_attribute20 :=
463: ben_drr_shd.g_old_rec.drr_attribute20;
464: End If;
465: If (p_rec.drr_attribute21 = hr_api.g_varchar2) then
461: If (p_rec.drr_attribute20 = hr_api.g_varchar2) then
462: p_rec.drr_attribute20 :=
463: ben_drr_shd.g_old_rec.drr_attribute20;
464: End If;
465: If (p_rec.drr_attribute21 = hr_api.g_varchar2) then
466: p_rec.drr_attribute21 :=
467: ben_drr_shd.g_old_rec.drr_attribute21;
468: End If;
469: If (p_rec.drr_attribute22 = hr_api.g_varchar2) then
465: If (p_rec.drr_attribute21 = hr_api.g_varchar2) then
466: p_rec.drr_attribute21 :=
467: ben_drr_shd.g_old_rec.drr_attribute21;
468: End If;
469: If (p_rec.drr_attribute22 = hr_api.g_varchar2) then
470: p_rec.drr_attribute22 :=
471: ben_drr_shd.g_old_rec.drr_attribute22;
472: End If;
473: If (p_rec.drr_attribute23 = hr_api.g_varchar2) then
469: If (p_rec.drr_attribute22 = hr_api.g_varchar2) then
470: p_rec.drr_attribute22 :=
471: ben_drr_shd.g_old_rec.drr_attribute22;
472: End If;
473: If (p_rec.drr_attribute23 = hr_api.g_varchar2) then
474: p_rec.drr_attribute23 :=
475: ben_drr_shd.g_old_rec.drr_attribute23;
476: End If;
477: If (p_rec.drr_attribute24 = hr_api.g_varchar2) then
473: If (p_rec.drr_attribute23 = hr_api.g_varchar2) then
474: p_rec.drr_attribute23 :=
475: ben_drr_shd.g_old_rec.drr_attribute23;
476: End If;
477: If (p_rec.drr_attribute24 = hr_api.g_varchar2) then
478: p_rec.drr_attribute24 :=
479: ben_drr_shd.g_old_rec.drr_attribute24;
480: End If;
481: If (p_rec.drr_attribute25 = hr_api.g_varchar2) then
477: If (p_rec.drr_attribute24 = hr_api.g_varchar2) then
478: p_rec.drr_attribute24 :=
479: ben_drr_shd.g_old_rec.drr_attribute24;
480: End If;
481: If (p_rec.drr_attribute25 = hr_api.g_varchar2) then
482: p_rec.drr_attribute25 :=
483: ben_drr_shd.g_old_rec.drr_attribute25;
484: End If;
485: If (p_rec.drr_attribute26 = hr_api.g_varchar2) then
481: If (p_rec.drr_attribute25 = hr_api.g_varchar2) then
482: p_rec.drr_attribute25 :=
483: ben_drr_shd.g_old_rec.drr_attribute25;
484: End If;
485: If (p_rec.drr_attribute26 = hr_api.g_varchar2) then
486: p_rec.drr_attribute26 :=
487: ben_drr_shd.g_old_rec.drr_attribute26;
488: End If;
489: If (p_rec.drr_attribute27 = hr_api.g_varchar2) then
485: If (p_rec.drr_attribute26 = hr_api.g_varchar2) then
486: p_rec.drr_attribute26 :=
487: ben_drr_shd.g_old_rec.drr_attribute26;
488: End If;
489: If (p_rec.drr_attribute27 = hr_api.g_varchar2) then
490: p_rec.drr_attribute27 :=
491: ben_drr_shd.g_old_rec.drr_attribute27;
492: End If;
493: If (p_rec.drr_attribute28 = hr_api.g_varchar2) then
489: If (p_rec.drr_attribute27 = hr_api.g_varchar2) then
490: p_rec.drr_attribute27 :=
491: ben_drr_shd.g_old_rec.drr_attribute27;
492: End If;
493: If (p_rec.drr_attribute28 = hr_api.g_varchar2) then
494: p_rec.drr_attribute28 :=
495: ben_drr_shd.g_old_rec.drr_attribute28;
496: End If;
497: If (p_rec.drr_attribute29 = hr_api.g_varchar2) then
493: If (p_rec.drr_attribute28 = hr_api.g_varchar2) then
494: p_rec.drr_attribute28 :=
495: ben_drr_shd.g_old_rec.drr_attribute28;
496: End If;
497: If (p_rec.drr_attribute29 = hr_api.g_varchar2) then
498: p_rec.drr_attribute29 :=
499: ben_drr_shd.g_old_rec.drr_attribute29;
500: End If;
501: If (p_rec.drr_attribute30 = hr_api.g_varchar2) then
497: If (p_rec.drr_attribute29 = hr_api.g_varchar2) then
498: p_rec.drr_attribute29 :=
499: ben_drr_shd.g_old_rec.drr_attribute29;
500: End If;
501: If (p_rec.drr_attribute30 = hr_api.g_varchar2) then
502: p_rec.drr_attribute30 :=
503: ben_drr_shd.g_old_rec.drr_attribute30;
504: End If;
505:
560: Procedure upd
561: (
562: p_effective_date in date,
563: p_dsgn_rqmt_rlshp_typ_id in number,
564: p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
561: (
562: p_effective_date in date,
563: p_dsgn_rqmt_rlshp_typ_id in number,
564: p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
562: p_effective_date in date,
563: p_dsgn_rqmt_rlshp_typ_id in number,
564: p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
563: p_dsgn_rqmt_rlshp_typ_id in number,
564: p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
564: p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
565: p_dsgn_rqmt_id in number default hr_api.g_number,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
566: p_business_group_id in number default hr_api.g_number,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
567: p_drr_attribute_category in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
568: p_drr_attribute1 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
569: p_drr_attribute2 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
570: p_drr_attribute3 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
571: p_drr_attribute4 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
572: p_drr_attribute5 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
573: p_drr_attribute6 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
574: p_drr_attribute7 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
575: p_drr_attribute8 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
576: p_drr_attribute9 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
577: p_drr_attribute10 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
578: p_drr_attribute11 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
579: p_drr_attribute12 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
580: p_drr_attribute13 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
581: p_drr_attribute14 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
582: p_drr_attribute15 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
583: p_drr_attribute16 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
584: p_drr_attribute17 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
585: p_drr_attribute18 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
586: p_drr_attribute19 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
587: p_drr_attribute20 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
588: p_drr_attribute21 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
589: p_drr_attribute22 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
590: p_drr_attribute23 in varchar2 default hr_api.g_varchar2,
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
598: p_object_version_number in out nocopy number
591: p_drr_attribute24 in varchar2 default hr_api.g_varchar2,
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
598: p_object_version_number in out nocopy number
599: ) is
592: p_drr_attribute25 in varchar2 default hr_api.g_varchar2,
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
598: p_object_version_number in out nocopy number
599: ) is
600: --
593: p_drr_attribute26 in varchar2 default hr_api.g_varchar2,
594: p_drr_attribute27 in varchar2 default hr_api.g_varchar2,
595: p_drr_attribute28 in varchar2 default hr_api.g_varchar2,
596: p_drr_attribute29 in varchar2 default hr_api.g_varchar2,
597: p_drr_attribute30 in varchar2 default hr_api.g_varchar2,
598: p_object_version_number in out nocopy number
599: ) is
600: --
601: l_rec ben_drr_shd.g_rec_type;