114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
119: -- A check constraint has been violated
120: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
121: ben_xcr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
124: -- Parent integrity has been violated
125: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
126: ben_xcr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
131: ben_xcr_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: ben_xcr_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End update_dml;
299: );
300: --
301: exception
302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'ben_ext_crit_prfl'
307: ,p_hook_type => 'AU');
301: exception
302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'ben_ext_crit_prfl'
307: ,p_hook_type => 'AU');
308: --
309: end;
369: -- p_rec plsql record structure
370: -- to see if a system default is being used. If a system default
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.name = hr_api.g_varchar2) then
374: p_rec.name :=
375: ben_xcr_shd.g_old_rec.name;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
373: If (p_rec.name = hr_api.g_varchar2) then
374: p_rec.name :=
375: ben_xcr_shd.g_old_rec.name;
376: End If;
377: If (p_rec.business_group_id = hr_api.g_number) then
378: p_rec.business_group_id :=
379: ben_xcr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.legislation_code = 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_xcr_shd.g_old_rec.business_group_id;
380: End If;
381: If (p_rec.legislation_code = hr_api.g_varchar2) then
382: p_rec.legislation_code :=
383: ben_xcr_shd.g_old_rec.legislation_code;
384: End If;
385: If (p_rec.xcr_attribute_category = hr_api.g_varchar2) then
381: If (p_rec.legislation_code = hr_api.g_varchar2) then
382: p_rec.legislation_code :=
383: ben_xcr_shd.g_old_rec.legislation_code;
384: End If;
385: If (p_rec.xcr_attribute_category = hr_api.g_varchar2) then
386: p_rec.xcr_attribute_category :=
387: ben_xcr_shd.g_old_rec.xcr_attribute_category;
388: End If;
389: If (p_rec.xcr_attribute1 = hr_api.g_varchar2) then
385: If (p_rec.xcr_attribute_category = hr_api.g_varchar2) then
386: p_rec.xcr_attribute_category :=
387: ben_xcr_shd.g_old_rec.xcr_attribute_category;
388: End If;
389: If (p_rec.xcr_attribute1 = hr_api.g_varchar2) then
390: p_rec.xcr_attribute1 :=
391: ben_xcr_shd.g_old_rec.xcr_attribute1;
392: End If;
393: If (p_rec.xcr_attribute2 = hr_api.g_varchar2) then
389: If (p_rec.xcr_attribute1 = hr_api.g_varchar2) then
390: p_rec.xcr_attribute1 :=
391: ben_xcr_shd.g_old_rec.xcr_attribute1;
392: End If;
393: If (p_rec.xcr_attribute2 = hr_api.g_varchar2) then
394: p_rec.xcr_attribute2 :=
395: ben_xcr_shd.g_old_rec.xcr_attribute2;
396: End If;
397: If (p_rec.xcr_attribute3 = hr_api.g_varchar2) then
393: If (p_rec.xcr_attribute2 = hr_api.g_varchar2) then
394: p_rec.xcr_attribute2 :=
395: ben_xcr_shd.g_old_rec.xcr_attribute2;
396: End If;
397: If (p_rec.xcr_attribute3 = hr_api.g_varchar2) then
398: p_rec.xcr_attribute3 :=
399: ben_xcr_shd.g_old_rec.xcr_attribute3;
400: End If;
401: If (p_rec.xcr_attribute4 = hr_api.g_varchar2) then
397: If (p_rec.xcr_attribute3 = hr_api.g_varchar2) then
398: p_rec.xcr_attribute3 :=
399: ben_xcr_shd.g_old_rec.xcr_attribute3;
400: End If;
401: If (p_rec.xcr_attribute4 = hr_api.g_varchar2) then
402: p_rec.xcr_attribute4 :=
403: ben_xcr_shd.g_old_rec.xcr_attribute4;
404: End If;
405: If (p_rec.xcr_attribute5 = hr_api.g_varchar2) then
401: If (p_rec.xcr_attribute4 = hr_api.g_varchar2) then
402: p_rec.xcr_attribute4 :=
403: ben_xcr_shd.g_old_rec.xcr_attribute4;
404: End If;
405: If (p_rec.xcr_attribute5 = hr_api.g_varchar2) then
406: p_rec.xcr_attribute5 :=
407: ben_xcr_shd.g_old_rec.xcr_attribute5;
408: End If;
409: If (p_rec.xcr_attribute6 = hr_api.g_varchar2) then
405: If (p_rec.xcr_attribute5 = hr_api.g_varchar2) then
406: p_rec.xcr_attribute5 :=
407: ben_xcr_shd.g_old_rec.xcr_attribute5;
408: End If;
409: If (p_rec.xcr_attribute6 = hr_api.g_varchar2) then
410: p_rec.xcr_attribute6 :=
411: ben_xcr_shd.g_old_rec.xcr_attribute6;
412: End If;
413: If (p_rec.xcr_attribute7 = hr_api.g_varchar2) then
409: If (p_rec.xcr_attribute6 = hr_api.g_varchar2) then
410: p_rec.xcr_attribute6 :=
411: ben_xcr_shd.g_old_rec.xcr_attribute6;
412: End If;
413: If (p_rec.xcr_attribute7 = hr_api.g_varchar2) then
414: p_rec.xcr_attribute7 :=
415: ben_xcr_shd.g_old_rec.xcr_attribute7;
416: End If;
417: If (p_rec.xcr_attribute8 = hr_api.g_varchar2) then
413: If (p_rec.xcr_attribute7 = hr_api.g_varchar2) then
414: p_rec.xcr_attribute7 :=
415: ben_xcr_shd.g_old_rec.xcr_attribute7;
416: End If;
417: If (p_rec.xcr_attribute8 = hr_api.g_varchar2) then
418: p_rec.xcr_attribute8 :=
419: ben_xcr_shd.g_old_rec.xcr_attribute8;
420: End If;
421: If (p_rec.xcr_attribute9 = hr_api.g_varchar2) then
417: If (p_rec.xcr_attribute8 = hr_api.g_varchar2) then
418: p_rec.xcr_attribute8 :=
419: ben_xcr_shd.g_old_rec.xcr_attribute8;
420: End If;
421: If (p_rec.xcr_attribute9 = hr_api.g_varchar2) then
422: p_rec.xcr_attribute9 :=
423: ben_xcr_shd.g_old_rec.xcr_attribute9;
424: End If;
425: If (p_rec.xcr_attribute10 = hr_api.g_varchar2) then
421: If (p_rec.xcr_attribute9 = hr_api.g_varchar2) then
422: p_rec.xcr_attribute9 :=
423: ben_xcr_shd.g_old_rec.xcr_attribute9;
424: End If;
425: If (p_rec.xcr_attribute10 = hr_api.g_varchar2) then
426: p_rec.xcr_attribute10 :=
427: ben_xcr_shd.g_old_rec.xcr_attribute10;
428: End If;
429: If (p_rec.xcr_attribute11 = hr_api.g_varchar2) then
425: If (p_rec.xcr_attribute10 = hr_api.g_varchar2) then
426: p_rec.xcr_attribute10 :=
427: ben_xcr_shd.g_old_rec.xcr_attribute10;
428: End If;
429: If (p_rec.xcr_attribute11 = hr_api.g_varchar2) then
430: p_rec.xcr_attribute11 :=
431: ben_xcr_shd.g_old_rec.xcr_attribute11;
432: End If;
433: If (p_rec.xcr_attribute12 = hr_api.g_varchar2) then
429: If (p_rec.xcr_attribute11 = hr_api.g_varchar2) then
430: p_rec.xcr_attribute11 :=
431: ben_xcr_shd.g_old_rec.xcr_attribute11;
432: End If;
433: If (p_rec.xcr_attribute12 = hr_api.g_varchar2) then
434: p_rec.xcr_attribute12 :=
435: ben_xcr_shd.g_old_rec.xcr_attribute12;
436: End If;
437: If (p_rec.xcr_attribute13 = hr_api.g_varchar2) then
433: If (p_rec.xcr_attribute12 = hr_api.g_varchar2) then
434: p_rec.xcr_attribute12 :=
435: ben_xcr_shd.g_old_rec.xcr_attribute12;
436: End If;
437: If (p_rec.xcr_attribute13 = hr_api.g_varchar2) then
438: p_rec.xcr_attribute13 :=
439: ben_xcr_shd.g_old_rec.xcr_attribute13;
440: End If;
441: If (p_rec.xcr_attribute14 = hr_api.g_varchar2) then
437: If (p_rec.xcr_attribute13 = hr_api.g_varchar2) then
438: p_rec.xcr_attribute13 :=
439: ben_xcr_shd.g_old_rec.xcr_attribute13;
440: End If;
441: If (p_rec.xcr_attribute14 = hr_api.g_varchar2) then
442: p_rec.xcr_attribute14 :=
443: ben_xcr_shd.g_old_rec.xcr_attribute14;
444: End If;
445: If (p_rec.xcr_attribute15 = hr_api.g_varchar2) then
441: If (p_rec.xcr_attribute14 = hr_api.g_varchar2) then
442: p_rec.xcr_attribute14 :=
443: ben_xcr_shd.g_old_rec.xcr_attribute14;
444: End If;
445: If (p_rec.xcr_attribute15 = hr_api.g_varchar2) then
446: p_rec.xcr_attribute15 :=
447: ben_xcr_shd.g_old_rec.xcr_attribute15;
448: End If;
449: If (p_rec.xcr_attribute16 = hr_api.g_varchar2) then
445: If (p_rec.xcr_attribute15 = hr_api.g_varchar2) then
446: p_rec.xcr_attribute15 :=
447: ben_xcr_shd.g_old_rec.xcr_attribute15;
448: End If;
449: If (p_rec.xcr_attribute16 = hr_api.g_varchar2) then
450: p_rec.xcr_attribute16 :=
451: ben_xcr_shd.g_old_rec.xcr_attribute16;
452: End If;
453: If (p_rec.xcr_attribute17 = hr_api.g_varchar2) then
449: If (p_rec.xcr_attribute16 = hr_api.g_varchar2) then
450: p_rec.xcr_attribute16 :=
451: ben_xcr_shd.g_old_rec.xcr_attribute16;
452: End If;
453: If (p_rec.xcr_attribute17 = hr_api.g_varchar2) then
454: p_rec.xcr_attribute17 :=
455: ben_xcr_shd.g_old_rec.xcr_attribute17;
456: End If;
457: If (p_rec.xcr_attribute18 = hr_api.g_varchar2) then
453: If (p_rec.xcr_attribute17 = hr_api.g_varchar2) then
454: p_rec.xcr_attribute17 :=
455: ben_xcr_shd.g_old_rec.xcr_attribute17;
456: End If;
457: If (p_rec.xcr_attribute18 = hr_api.g_varchar2) then
458: p_rec.xcr_attribute18 :=
459: ben_xcr_shd.g_old_rec.xcr_attribute18;
460: End If;
461: If (p_rec.xcr_attribute19 = hr_api.g_varchar2) then
457: If (p_rec.xcr_attribute18 = hr_api.g_varchar2) then
458: p_rec.xcr_attribute18 :=
459: ben_xcr_shd.g_old_rec.xcr_attribute18;
460: End If;
461: If (p_rec.xcr_attribute19 = hr_api.g_varchar2) then
462: p_rec.xcr_attribute19 :=
463: ben_xcr_shd.g_old_rec.xcr_attribute19;
464: End If;
465: If (p_rec.xcr_attribute20 = hr_api.g_varchar2) then
461: If (p_rec.xcr_attribute19 = hr_api.g_varchar2) then
462: p_rec.xcr_attribute19 :=
463: ben_xcr_shd.g_old_rec.xcr_attribute19;
464: End If;
465: If (p_rec.xcr_attribute20 = hr_api.g_varchar2) then
466: p_rec.xcr_attribute20 :=
467: ben_xcr_shd.g_old_rec.xcr_attribute20;
468: End If;
469: If (p_rec.xcr_attribute21 = hr_api.g_varchar2) then
465: If (p_rec.xcr_attribute20 = hr_api.g_varchar2) then
466: p_rec.xcr_attribute20 :=
467: ben_xcr_shd.g_old_rec.xcr_attribute20;
468: End If;
469: If (p_rec.xcr_attribute21 = hr_api.g_varchar2) then
470: p_rec.xcr_attribute21 :=
471: ben_xcr_shd.g_old_rec.xcr_attribute21;
472: End If;
473: If (p_rec.xcr_attribute22 = hr_api.g_varchar2) then
469: If (p_rec.xcr_attribute21 = hr_api.g_varchar2) then
470: p_rec.xcr_attribute21 :=
471: ben_xcr_shd.g_old_rec.xcr_attribute21;
472: End If;
473: If (p_rec.xcr_attribute22 = hr_api.g_varchar2) then
474: p_rec.xcr_attribute22 :=
475: ben_xcr_shd.g_old_rec.xcr_attribute22;
476: End If;
477: If (p_rec.xcr_attribute23 = hr_api.g_varchar2) then
473: If (p_rec.xcr_attribute22 = hr_api.g_varchar2) then
474: p_rec.xcr_attribute22 :=
475: ben_xcr_shd.g_old_rec.xcr_attribute22;
476: End If;
477: If (p_rec.xcr_attribute23 = hr_api.g_varchar2) then
478: p_rec.xcr_attribute23 :=
479: ben_xcr_shd.g_old_rec.xcr_attribute23;
480: End If;
481: If (p_rec.xcr_attribute24 = hr_api.g_varchar2) then
477: If (p_rec.xcr_attribute23 = hr_api.g_varchar2) then
478: p_rec.xcr_attribute23 :=
479: ben_xcr_shd.g_old_rec.xcr_attribute23;
480: End If;
481: If (p_rec.xcr_attribute24 = hr_api.g_varchar2) then
482: p_rec.xcr_attribute24 :=
483: ben_xcr_shd.g_old_rec.xcr_attribute24;
484: End If;
485: If (p_rec.xcr_attribute25 = hr_api.g_varchar2) then
481: If (p_rec.xcr_attribute24 = hr_api.g_varchar2) then
482: p_rec.xcr_attribute24 :=
483: ben_xcr_shd.g_old_rec.xcr_attribute24;
484: End If;
485: If (p_rec.xcr_attribute25 = hr_api.g_varchar2) then
486: p_rec.xcr_attribute25 :=
487: ben_xcr_shd.g_old_rec.xcr_attribute25;
488: End If;
489: If (p_rec.xcr_attribute26 = hr_api.g_varchar2) then
485: If (p_rec.xcr_attribute25 = hr_api.g_varchar2) then
486: p_rec.xcr_attribute25 :=
487: ben_xcr_shd.g_old_rec.xcr_attribute25;
488: End If;
489: If (p_rec.xcr_attribute26 = hr_api.g_varchar2) then
490: p_rec.xcr_attribute26 :=
491: ben_xcr_shd.g_old_rec.xcr_attribute26;
492: End If;
493: If (p_rec.xcr_attribute27 = hr_api.g_varchar2) then
489: If (p_rec.xcr_attribute26 = hr_api.g_varchar2) then
490: p_rec.xcr_attribute26 :=
491: ben_xcr_shd.g_old_rec.xcr_attribute26;
492: End If;
493: If (p_rec.xcr_attribute27 = hr_api.g_varchar2) then
494: p_rec.xcr_attribute27 :=
495: ben_xcr_shd.g_old_rec.xcr_attribute27;
496: End If;
497: If (p_rec.xcr_attribute28 = hr_api.g_varchar2) then
493: If (p_rec.xcr_attribute27 = hr_api.g_varchar2) then
494: p_rec.xcr_attribute27 :=
495: ben_xcr_shd.g_old_rec.xcr_attribute27;
496: End If;
497: If (p_rec.xcr_attribute28 = hr_api.g_varchar2) then
498: p_rec.xcr_attribute28 :=
499: ben_xcr_shd.g_old_rec.xcr_attribute28;
500: End If;
501: If (p_rec.xcr_attribute29 = hr_api.g_varchar2) then
497: If (p_rec.xcr_attribute28 = hr_api.g_varchar2) then
498: p_rec.xcr_attribute28 :=
499: ben_xcr_shd.g_old_rec.xcr_attribute28;
500: End If;
501: If (p_rec.xcr_attribute29 = hr_api.g_varchar2) then
502: p_rec.xcr_attribute29 :=
503: ben_xcr_shd.g_old_rec.xcr_attribute29;
504: End If;
505: If (p_rec.xcr_attribute30 = hr_api.g_varchar2) then
501: If (p_rec.xcr_attribute29 = hr_api.g_varchar2) then
502: p_rec.xcr_attribute29 :=
503: ben_xcr_shd.g_old_rec.xcr_attribute29;
504: End If;
505: If (p_rec.xcr_attribute30 = hr_api.g_varchar2) then
506: p_rec.xcr_attribute30 :=
507: ben_xcr_shd.g_old_rec.xcr_attribute30;
508: End If;
509:
506: p_rec.xcr_attribute30 :=
507: ben_xcr_shd.g_old_rec.xcr_attribute30;
508: End If;
509:
510: If (p_rec.ext_global_flag = hr_api.g_varchar2) then
511: p_rec.ext_global_flag :=
512: ben_xcr_shd.g_old_rec.ext_global_flag;
513: End If;
514:
565: -- ----------------------------------------------------------------------------
566: Procedure upd
567: (
568: p_ext_crit_prfl_id in number,
569: p_name in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
566: Procedure upd
567: (
568: p_ext_crit_prfl_id in number,
569: p_name in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
567: (
568: p_ext_crit_prfl_id in number,
569: p_name in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
568: p_ext_crit_prfl_id in number,
569: p_name in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
569: p_name in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
570: p_business_group_id in number default hr_api.g_number,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
571: p_legislation_code in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
572: p_xcr_attribute_category in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
573: p_xcr_attribute1 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
574: p_xcr_attribute2 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
575: p_xcr_attribute3 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
576: p_xcr_attribute4 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
577: p_xcr_attribute5 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
578: p_xcr_attribute6 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
579: p_xcr_attribute7 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
580: p_xcr_attribute8 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
581: p_xcr_attribute9 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
582: p_xcr_attribute10 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
583: p_xcr_attribute11 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
584: p_xcr_attribute12 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
585: p_xcr_attribute13 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
586: p_xcr_attribute14 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
587: p_xcr_attribute15 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
588: p_xcr_attribute16 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
589: p_xcr_attribute17 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
590: p_xcr_attribute18 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
591: p_xcr_attribute19 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
592: p_xcr_attribute20 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
593: p_xcr_attribute21 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
594: p_xcr_attribute22 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
595: p_xcr_attribute23 in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
596: p_xcr_attribute24 in varchar2 default hr_api.g_varchar2,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
597: p_xcr_attribute25 in varchar2 default hr_api.g_varchar2,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
598: p_xcr_attribute26 in varchar2 default hr_api.g_varchar2,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
599: p_xcr_attribute27 in varchar2 default hr_api.g_varchar2,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
600: p_xcr_attribute28 in varchar2 default hr_api.g_varchar2,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
608: p_created_by in number default hr_api.g_number,
601: p_xcr_attribute29 in varchar2 default hr_api.g_varchar2,
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
608: p_created_by in number default hr_api.g_number,
609: p_object_version_number in out nocopy number
602: p_xcr_attribute30 in varchar2 default hr_api.g_varchar2,
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
608: p_created_by in number default hr_api.g_number,
609: p_object_version_number in out nocopy number
610: ) is
603: p_ext_global_flag in varchar2 default hr_api.g_varchar2,
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
608: p_created_by in number default hr_api.g_number,
609: p_object_version_number in out nocopy number
610: ) is
611: --
604: p_last_update_date in date default hr_api.g_date,
605: p_creation_date in date default hr_api.g_date,
606: p_last_updated_by in number default hr_api.g_number,
607: p_last_update_login in number default hr_api.g_number,
608: p_created_by in number default hr_api.g_number,
609: p_object_version_number in out nocopy number
610: ) is
611: --
612: l_rec ben_xcr_shd.g_rec_type;