123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
128: -- A check constraint has been violated
129: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
130: ben_lsf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
133: -- Parent integrity has been violated
134: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
135: ben_lsf_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
140: ben_lsf_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: ben_lsf_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;
334: );
335: --
336: exception
337: --
338: when hr_api.cannot_find_prog_unit then
339: --
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'ben_los_fctr'
342: ,p_hook_type => 'AU');
336: exception
337: --
338: when hr_api.cannot_find_prog_unit then
339: --
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'ben_los_fctr'
342: ,p_hook_type => 'AU');
343: --
344: end;
404: -- p_rec plsql record structure
405: -- to see if a system default is being used. If a system default
406: -- is being used then we must set to the 'current' argument value.
407: --
408: If (p_rec.name = hr_api.g_varchar2) then
409: p_rec.name :=
410: ben_lsf_shd.g_old_rec.name;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
408: If (p_rec.name = hr_api.g_varchar2) then
409: p_rec.name :=
410: ben_lsf_shd.g_old_rec.name;
411: End If;
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_lsf_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.los_det_cd = hr_api.g_varchar2) then
412: If (p_rec.business_group_id = hr_api.g_number) then
413: p_rec.business_group_id :=
414: ben_lsf_shd.g_old_rec.business_group_id;
415: End If;
416: If (p_rec.los_det_cd = hr_api.g_varchar2) then
417: p_rec.los_det_cd :=
418: ben_lsf_shd.g_old_rec.los_det_cd;
419: End If;
420: If (p_rec.los_det_rl = hr_api.g_number) then
416: If (p_rec.los_det_cd = hr_api.g_varchar2) then
417: p_rec.los_det_cd :=
418: ben_lsf_shd.g_old_rec.los_det_cd;
419: End If;
420: If (p_rec.los_det_rl = hr_api.g_number) then
421: p_rec.los_det_rl :=
422: ben_lsf_shd.g_old_rec.los_det_rl;
423: End If;
424: If (p_rec.mn_los_num = hr_api.g_number) then
420: If (p_rec.los_det_rl = hr_api.g_number) then
421: p_rec.los_det_rl :=
422: ben_lsf_shd.g_old_rec.los_det_rl;
423: End If;
424: If (p_rec.mn_los_num = hr_api.g_number) then
425: p_rec.mn_los_num :=
426: ben_lsf_shd.g_old_rec.mn_los_num;
427: End If;
428: If (p_rec.mx_los_num = hr_api.g_number) then
424: If (p_rec.mn_los_num = hr_api.g_number) then
425: p_rec.mn_los_num :=
426: ben_lsf_shd.g_old_rec.mn_los_num;
427: End If;
428: If (p_rec.mx_los_num = hr_api.g_number) then
429: p_rec.mx_los_num :=
430: ben_lsf_shd.g_old_rec.mx_los_num;
431: End If;
432: If (p_rec.no_mx_los_num_apls_flag = hr_api.g_varchar2) then
428: If (p_rec.mx_los_num = hr_api.g_number) then
429: p_rec.mx_los_num :=
430: ben_lsf_shd.g_old_rec.mx_los_num;
431: End If;
432: If (p_rec.no_mx_los_num_apls_flag = hr_api.g_varchar2) then
433: p_rec.no_mx_los_num_apls_flag :=
434: ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag;
435: End If;
436: If (p_rec.no_mn_los_num_apls_flag = hr_api.g_varchar2) then
432: If (p_rec.no_mx_los_num_apls_flag = hr_api.g_varchar2) then
433: p_rec.no_mx_los_num_apls_flag :=
434: ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag;
435: End If;
436: If (p_rec.no_mn_los_num_apls_flag = hr_api.g_varchar2) then
437: p_rec.no_mn_los_num_apls_flag :=
438: ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag;
439: End If;
440: If (p_rec.rndg_cd = hr_api.g_varchar2) then
436: If (p_rec.no_mn_los_num_apls_flag = hr_api.g_varchar2) then
437: p_rec.no_mn_los_num_apls_flag :=
438: ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag;
439: End If;
440: If (p_rec.rndg_cd = hr_api.g_varchar2) then
441: p_rec.rndg_cd :=
442: ben_lsf_shd.g_old_rec.rndg_cd;
443: End If;
444: If (p_rec.rndg_rl = hr_api.g_number) then
440: If (p_rec.rndg_cd = hr_api.g_varchar2) then
441: p_rec.rndg_cd :=
442: ben_lsf_shd.g_old_rec.rndg_cd;
443: End If;
444: If (p_rec.rndg_rl = hr_api.g_number) then
445: p_rec.rndg_rl :=
446: ben_lsf_shd.g_old_rec.rndg_rl;
447: End If;
448: If (p_rec.los_dt_to_use_cd = hr_api.g_varchar2) then
444: If (p_rec.rndg_rl = hr_api.g_number) then
445: p_rec.rndg_rl :=
446: ben_lsf_shd.g_old_rec.rndg_rl;
447: End If;
448: If (p_rec.los_dt_to_use_cd = hr_api.g_varchar2) then
449: p_rec.los_dt_to_use_cd :=
450: ben_lsf_shd.g_old_rec.los_dt_to_use_cd;
451: End If;
452: If (p_rec.los_dt_to_use_rl = hr_api.g_number) then
448: If (p_rec.los_dt_to_use_cd = hr_api.g_varchar2) then
449: p_rec.los_dt_to_use_cd :=
450: ben_lsf_shd.g_old_rec.los_dt_to_use_cd;
451: End If;
452: If (p_rec.los_dt_to_use_rl = hr_api.g_number) then
453: p_rec.los_dt_to_use_rl :=
454: ben_lsf_shd.g_old_rec.los_dt_to_use_rl;
455: End If;
456: If (p_rec.los_uom = hr_api.g_varchar2) then
452: If (p_rec.los_dt_to_use_rl = hr_api.g_number) then
453: p_rec.los_dt_to_use_rl :=
454: ben_lsf_shd.g_old_rec.los_dt_to_use_rl;
455: End If;
456: If (p_rec.los_uom = hr_api.g_varchar2) then
457: p_rec.los_uom :=
458: ben_lsf_shd.g_old_rec.los_uom;
459: End If;
460: If (p_rec.los_calc_rl = hr_api.g_number) then
456: If (p_rec.los_uom = hr_api.g_varchar2) then
457: p_rec.los_uom :=
458: ben_lsf_shd.g_old_rec.los_uom;
459: End If;
460: If (p_rec.los_calc_rl = hr_api.g_number) then
461: p_rec.los_calc_rl :=
462: ben_lsf_shd.g_old_rec.los_calc_rl;
463: End If;
464: If (p_rec.los_alt_val_to_use_cd = hr_api.g_varchar2) then
460: If (p_rec.los_calc_rl = hr_api.g_number) then
461: p_rec.los_calc_rl :=
462: ben_lsf_shd.g_old_rec.los_calc_rl;
463: End If;
464: If (p_rec.los_alt_val_to_use_cd = hr_api.g_varchar2) then
465: p_rec.los_alt_val_to_use_cd :=
466: ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd;
467: End If;
468: If (p_rec.lsf_attribute_category = hr_api.g_varchar2) then
464: If (p_rec.los_alt_val_to_use_cd = hr_api.g_varchar2) then
465: p_rec.los_alt_val_to_use_cd :=
466: ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd;
467: End If;
468: If (p_rec.lsf_attribute_category = hr_api.g_varchar2) then
469: p_rec.lsf_attribute_category :=
470: ben_lsf_shd.g_old_rec.lsf_attribute_category;
471: End If;
472: If (p_rec.lsf_attribute1 = hr_api.g_varchar2) then
468: If (p_rec.lsf_attribute_category = hr_api.g_varchar2) then
469: p_rec.lsf_attribute_category :=
470: ben_lsf_shd.g_old_rec.lsf_attribute_category;
471: End If;
472: If (p_rec.lsf_attribute1 = hr_api.g_varchar2) then
473: p_rec.lsf_attribute1 :=
474: ben_lsf_shd.g_old_rec.lsf_attribute1;
475: End If;
476: If (p_rec.lsf_attribute2 = hr_api.g_varchar2) then
472: If (p_rec.lsf_attribute1 = hr_api.g_varchar2) then
473: p_rec.lsf_attribute1 :=
474: ben_lsf_shd.g_old_rec.lsf_attribute1;
475: End If;
476: If (p_rec.lsf_attribute2 = hr_api.g_varchar2) then
477: p_rec.lsf_attribute2 :=
478: ben_lsf_shd.g_old_rec.lsf_attribute2;
479: End If;
480: If (p_rec.lsf_attribute3 = hr_api.g_varchar2) then
476: If (p_rec.lsf_attribute2 = hr_api.g_varchar2) then
477: p_rec.lsf_attribute2 :=
478: ben_lsf_shd.g_old_rec.lsf_attribute2;
479: End If;
480: If (p_rec.lsf_attribute3 = hr_api.g_varchar2) then
481: p_rec.lsf_attribute3 :=
482: ben_lsf_shd.g_old_rec.lsf_attribute3;
483: End If;
484: If (p_rec.lsf_attribute4 = hr_api.g_varchar2) then
480: If (p_rec.lsf_attribute3 = hr_api.g_varchar2) then
481: p_rec.lsf_attribute3 :=
482: ben_lsf_shd.g_old_rec.lsf_attribute3;
483: End If;
484: If (p_rec.lsf_attribute4 = hr_api.g_varchar2) then
485: p_rec.lsf_attribute4 :=
486: ben_lsf_shd.g_old_rec.lsf_attribute4;
487: End If;
488: If (p_rec.lsf_attribute5 = hr_api.g_varchar2) then
484: If (p_rec.lsf_attribute4 = hr_api.g_varchar2) then
485: p_rec.lsf_attribute4 :=
486: ben_lsf_shd.g_old_rec.lsf_attribute4;
487: End If;
488: If (p_rec.lsf_attribute5 = hr_api.g_varchar2) then
489: p_rec.lsf_attribute5 :=
490: ben_lsf_shd.g_old_rec.lsf_attribute5;
491: End If;
492: If (p_rec.lsf_attribute6 = hr_api.g_varchar2) then
488: If (p_rec.lsf_attribute5 = hr_api.g_varchar2) then
489: p_rec.lsf_attribute5 :=
490: ben_lsf_shd.g_old_rec.lsf_attribute5;
491: End If;
492: If (p_rec.lsf_attribute6 = hr_api.g_varchar2) then
493: p_rec.lsf_attribute6 :=
494: ben_lsf_shd.g_old_rec.lsf_attribute6;
495: End If;
496: If (p_rec.lsf_attribute7 = hr_api.g_varchar2) then
492: If (p_rec.lsf_attribute6 = hr_api.g_varchar2) then
493: p_rec.lsf_attribute6 :=
494: ben_lsf_shd.g_old_rec.lsf_attribute6;
495: End If;
496: If (p_rec.lsf_attribute7 = hr_api.g_varchar2) then
497: p_rec.lsf_attribute7 :=
498: ben_lsf_shd.g_old_rec.lsf_attribute7;
499: End If;
500: If (p_rec.lsf_attribute8 = hr_api.g_varchar2) then
496: If (p_rec.lsf_attribute7 = hr_api.g_varchar2) then
497: p_rec.lsf_attribute7 :=
498: ben_lsf_shd.g_old_rec.lsf_attribute7;
499: End If;
500: If (p_rec.lsf_attribute8 = hr_api.g_varchar2) then
501: p_rec.lsf_attribute8 :=
502: ben_lsf_shd.g_old_rec.lsf_attribute8;
503: End If;
504: If (p_rec.lsf_attribute9 = hr_api.g_varchar2) then
500: If (p_rec.lsf_attribute8 = hr_api.g_varchar2) then
501: p_rec.lsf_attribute8 :=
502: ben_lsf_shd.g_old_rec.lsf_attribute8;
503: End If;
504: If (p_rec.lsf_attribute9 = hr_api.g_varchar2) then
505: p_rec.lsf_attribute9 :=
506: ben_lsf_shd.g_old_rec.lsf_attribute9;
507: End If;
508: If (p_rec.lsf_attribute10 = hr_api.g_varchar2) then
504: If (p_rec.lsf_attribute9 = hr_api.g_varchar2) then
505: p_rec.lsf_attribute9 :=
506: ben_lsf_shd.g_old_rec.lsf_attribute9;
507: End If;
508: If (p_rec.lsf_attribute10 = hr_api.g_varchar2) then
509: p_rec.lsf_attribute10 :=
510: ben_lsf_shd.g_old_rec.lsf_attribute10;
511: End If;
512: If (p_rec.lsf_attribute11 = hr_api.g_varchar2) then
508: If (p_rec.lsf_attribute10 = hr_api.g_varchar2) then
509: p_rec.lsf_attribute10 :=
510: ben_lsf_shd.g_old_rec.lsf_attribute10;
511: End If;
512: If (p_rec.lsf_attribute11 = hr_api.g_varchar2) then
513: p_rec.lsf_attribute11 :=
514: ben_lsf_shd.g_old_rec.lsf_attribute11;
515: End If;
516: If (p_rec.lsf_attribute12 = hr_api.g_varchar2) then
512: If (p_rec.lsf_attribute11 = hr_api.g_varchar2) then
513: p_rec.lsf_attribute11 :=
514: ben_lsf_shd.g_old_rec.lsf_attribute11;
515: End If;
516: If (p_rec.lsf_attribute12 = hr_api.g_varchar2) then
517: p_rec.lsf_attribute12 :=
518: ben_lsf_shd.g_old_rec.lsf_attribute12;
519: End If;
520: If (p_rec.lsf_attribute13 = hr_api.g_varchar2) then
516: If (p_rec.lsf_attribute12 = hr_api.g_varchar2) then
517: p_rec.lsf_attribute12 :=
518: ben_lsf_shd.g_old_rec.lsf_attribute12;
519: End If;
520: If (p_rec.lsf_attribute13 = hr_api.g_varchar2) then
521: p_rec.lsf_attribute13 :=
522: ben_lsf_shd.g_old_rec.lsf_attribute13;
523: End If;
524: If (p_rec.lsf_attribute14 = hr_api.g_varchar2) then
520: If (p_rec.lsf_attribute13 = hr_api.g_varchar2) then
521: p_rec.lsf_attribute13 :=
522: ben_lsf_shd.g_old_rec.lsf_attribute13;
523: End If;
524: If (p_rec.lsf_attribute14 = hr_api.g_varchar2) then
525: p_rec.lsf_attribute14 :=
526: ben_lsf_shd.g_old_rec.lsf_attribute14;
527: End If;
528: If (p_rec.lsf_attribute15 = hr_api.g_varchar2) then
524: If (p_rec.lsf_attribute14 = hr_api.g_varchar2) then
525: p_rec.lsf_attribute14 :=
526: ben_lsf_shd.g_old_rec.lsf_attribute14;
527: End If;
528: If (p_rec.lsf_attribute15 = hr_api.g_varchar2) then
529: p_rec.lsf_attribute15 :=
530: ben_lsf_shd.g_old_rec.lsf_attribute15;
531: End If;
532: If (p_rec.lsf_attribute16 = hr_api.g_varchar2) then
528: If (p_rec.lsf_attribute15 = hr_api.g_varchar2) then
529: p_rec.lsf_attribute15 :=
530: ben_lsf_shd.g_old_rec.lsf_attribute15;
531: End If;
532: If (p_rec.lsf_attribute16 = hr_api.g_varchar2) then
533: p_rec.lsf_attribute16 :=
534: ben_lsf_shd.g_old_rec.lsf_attribute16;
535: End If;
536: If (p_rec.lsf_attribute17 = hr_api.g_varchar2) then
532: If (p_rec.lsf_attribute16 = hr_api.g_varchar2) then
533: p_rec.lsf_attribute16 :=
534: ben_lsf_shd.g_old_rec.lsf_attribute16;
535: End If;
536: If (p_rec.lsf_attribute17 = hr_api.g_varchar2) then
537: p_rec.lsf_attribute17 :=
538: ben_lsf_shd.g_old_rec.lsf_attribute17;
539: End If;
540: If (p_rec.lsf_attribute18 = hr_api.g_varchar2) then
536: If (p_rec.lsf_attribute17 = hr_api.g_varchar2) then
537: p_rec.lsf_attribute17 :=
538: ben_lsf_shd.g_old_rec.lsf_attribute17;
539: End If;
540: If (p_rec.lsf_attribute18 = hr_api.g_varchar2) then
541: p_rec.lsf_attribute18 :=
542: ben_lsf_shd.g_old_rec.lsf_attribute18;
543: End If;
544: If (p_rec.lsf_attribute19 = hr_api.g_varchar2) then
540: If (p_rec.lsf_attribute18 = hr_api.g_varchar2) then
541: p_rec.lsf_attribute18 :=
542: ben_lsf_shd.g_old_rec.lsf_attribute18;
543: End If;
544: If (p_rec.lsf_attribute19 = hr_api.g_varchar2) then
545: p_rec.lsf_attribute19 :=
546: ben_lsf_shd.g_old_rec.lsf_attribute19;
547: End If;
548: If (p_rec.lsf_attribute20 = hr_api.g_varchar2) then
544: If (p_rec.lsf_attribute19 = hr_api.g_varchar2) then
545: p_rec.lsf_attribute19 :=
546: ben_lsf_shd.g_old_rec.lsf_attribute19;
547: End If;
548: If (p_rec.lsf_attribute20 = hr_api.g_varchar2) then
549: p_rec.lsf_attribute20 :=
550: ben_lsf_shd.g_old_rec.lsf_attribute20;
551: End If;
552: If (p_rec.lsf_attribute21 = hr_api.g_varchar2) then
548: If (p_rec.lsf_attribute20 = hr_api.g_varchar2) then
549: p_rec.lsf_attribute20 :=
550: ben_lsf_shd.g_old_rec.lsf_attribute20;
551: End If;
552: If (p_rec.lsf_attribute21 = hr_api.g_varchar2) then
553: p_rec.lsf_attribute21 :=
554: ben_lsf_shd.g_old_rec.lsf_attribute21;
555: End If;
556: If (p_rec.lsf_attribute22 = hr_api.g_varchar2) then
552: If (p_rec.lsf_attribute21 = hr_api.g_varchar2) then
553: p_rec.lsf_attribute21 :=
554: ben_lsf_shd.g_old_rec.lsf_attribute21;
555: End If;
556: If (p_rec.lsf_attribute22 = hr_api.g_varchar2) then
557: p_rec.lsf_attribute22 :=
558: ben_lsf_shd.g_old_rec.lsf_attribute22;
559: End If;
560: If (p_rec.lsf_attribute23 = hr_api.g_varchar2) then
556: If (p_rec.lsf_attribute22 = hr_api.g_varchar2) then
557: p_rec.lsf_attribute22 :=
558: ben_lsf_shd.g_old_rec.lsf_attribute22;
559: End If;
560: If (p_rec.lsf_attribute23 = hr_api.g_varchar2) then
561: p_rec.lsf_attribute23 :=
562: ben_lsf_shd.g_old_rec.lsf_attribute23;
563: End If;
564: If (p_rec.lsf_attribute24 = hr_api.g_varchar2) then
560: If (p_rec.lsf_attribute23 = hr_api.g_varchar2) then
561: p_rec.lsf_attribute23 :=
562: ben_lsf_shd.g_old_rec.lsf_attribute23;
563: End If;
564: If (p_rec.lsf_attribute24 = hr_api.g_varchar2) then
565: p_rec.lsf_attribute24 :=
566: ben_lsf_shd.g_old_rec.lsf_attribute24;
567: End If;
568: If (p_rec.lsf_attribute25 = hr_api.g_varchar2) then
564: If (p_rec.lsf_attribute24 = hr_api.g_varchar2) then
565: p_rec.lsf_attribute24 :=
566: ben_lsf_shd.g_old_rec.lsf_attribute24;
567: End If;
568: If (p_rec.lsf_attribute25 = hr_api.g_varchar2) then
569: p_rec.lsf_attribute25 :=
570: ben_lsf_shd.g_old_rec.lsf_attribute25;
571: End If;
572: If (p_rec.lsf_attribute26 = hr_api.g_varchar2) then
568: If (p_rec.lsf_attribute25 = hr_api.g_varchar2) then
569: p_rec.lsf_attribute25 :=
570: ben_lsf_shd.g_old_rec.lsf_attribute25;
571: End If;
572: If (p_rec.lsf_attribute26 = hr_api.g_varchar2) then
573: p_rec.lsf_attribute26 :=
574: ben_lsf_shd.g_old_rec.lsf_attribute26;
575: End If;
576: If (p_rec.lsf_attribute27 = hr_api.g_varchar2) then
572: If (p_rec.lsf_attribute26 = hr_api.g_varchar2) then
573: p_rec.lsf_attribute26 :=
574: ben_lsf_shd.g_old_rec.lsf_attribute26;
575: End If;
576: If (p_rec.lsf_attribute27 = hr_api.g_varchar2) then
577: p_rec.lsf_attribute27 :=
578: ben_lsf_shd.g_old_rec.lsf_attribute27;
579: End If;
580: If (p_rec.lsf_attribute28 = hr_api.g_varchar2) then
576: If (p_rec.lsf_attribute27 = hr_api.g_varchar2) then
577: p_rec.lsf_attribute27 :=
578: ben_lsf_shd.g_old_rec.lsf_attribute27;
579: End If;
580: If (p_rec.lsf_attribute28 = hr_api.g_varchar2) then
581: p_rec.lsf_attribute28 :=
582: ben_lsf_shd.g_old_rec.lsf_attribute28;
583: End If;
584: If (p_rec.lsf_attribute29 = hr_api.g_varchar2) then
580: If (p_rec.lsf_attribute28 = hr_api.g_varchar2) then
581: p_rec.lsf_attribute28 :=
582: ben_lsf_shd.g_old_rec.lsf_attribute28;
583: End If;
584: If (p_rec.lsf_attribute29 = hr_api.g_varchar2) then
585: p_rec.lsf_attribute29 :=
586: ben_lsf_shd.g_old_rec.lsf_attribute29;
587: End If;
588: If (p_rec.lsf_attribute30 = hr_api.g_varchar2) then
584: If (p_rec.lsf_attribute29 = hr_api.g_varchar2) then
585: p_rec.lsf_attribute29 :=
586: ben_lsf_shd.g_old_rec.lsf_attribute29;
587: End If;
588: If (p_rec.lsf_attribute30 = hr_api.g_varchar2) then
589: p_rec.lsf_attribute30 :=
590: ben_lsf_shd.g_old_rec.lsf_attribute30;
591: End If;
592: If (p_rec.use_overid_svc_dt_flag = hr_api.g_varchar2) then
588: If (p_rec.lsf_attribute30 = hr_api.g_varchar2) then
589: p_rec.lsf_attribute30 :=
590: ben_lsf_shd.g_old_rec.lsf_attribute30;
591: End If;
592: If (p_rec.use_overid_svc_dt_flag = hr_api.g_varchar2) then
593: p_rec.use_overid_svc_dt_flag :=
594: ben_lsf_shd.g_old_rec.use_overid_svc_dt_flag;
595: End If;
596: --
650: Procedure upd
651: (
652: p_effective_date in date,
653: p_los_fctr_id in number,
654: p_name in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
651: (
652: p_effective_date in date,
653: p_los_fctr_id in number,
654: p_name in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
652: p_effective_date in date,
653: p_los_fctr_id in number,
654: p_name in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
653: p_los_fctr_id in number,
654: p_name in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
654: p_name in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
655: p_business_group_id in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
656: p_los_det_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
657: p_los_det_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
658: p_mn_los_num in number default hr_api.g_number,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
659: p_mx_los_num in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
661: p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
663: p_rndg_rl in number default hr_api.g_number,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
665: p_los_dt_to_use_rl in number default hr_api.g_number,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
666: p_los_uom in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
667: p_los_calc_rl in number default hr_api.g_number,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
668: p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
669: p_lsf_attribute_category in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
670: p_lsf_attribute1 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
671: p_lsf_attribute2 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
672: p_lsf_attribute3 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
673: p_lsf_attribute4 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
674: p_lsf_attribute5 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
675: p_lsf_attribute6 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
676: p_lsf_attribute7 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
677: p_lsf_attribute8 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
678: p_lsf_attribute9 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
679: p_lsf_attribute10 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
680: p_lsf_attribute11 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
681: p_lsf_attribute12 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
682: p_lsf_attribute13 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
683: p_lsf_attribute14 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
684: p_lsf_attribute15 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
685: p_lsf_attribute16 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
686: p_lsf_attribute17 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
687: p_lsf_attribute18 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
688: p_lsf_attribute19 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
689: p_lsf_attribute20 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
690: p_lsf_attribute21 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
691: p_lsf_attribute22 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
692: p_lsf_attribute23 in varchar2 default hr_api.g_varchar2,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
700: p_object_version_number in out nocopy number,
693: p_lsf_attribute24 in varchar2 default hr_api.g_varchar2,
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
700: p_object_version_number in out nocopy number,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
694: p_lsf_attribute25 in varchar2 default hr_api.g_varchar2,
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
700: p_object_version_number in out nocopy number,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
702: ) is
695: p_lsf_attribute26 in varchar2 default hr_api.g_varchar2,
696: p_lsf_attribute27 in varchar2 default hr_api.g_varchar2,
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
700: p_object_version_number in out nocopy number,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
702: ) is
703: --
697: p_lsf_attribute28 in varchar2 default hr_api.g_varchar2,
698: p_lsf_attribute29 in varchar2 default hr_api.g_varchar2,
699: p_lsf_attribute30 in varchar2 default hr_api.g_varchar2,
700: p_object_version_number in out nocopy number,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
702: ) is
703: --
704: l_rec ben_lsf_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'upd';