DBA Data[Home] [Help]

APPS.BEN_LSF_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

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));

Line 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

Line 132: When hr_api.parent_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
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 137: When hr_api.unique_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
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 338: when hr_api.cannot_find_prog_unit then

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');

Line 340: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 654: p_name in varchar2 default hr_api.g_varchar2,

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,

Line 655: p_business_group_id 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,

Line 656: p_los_det_cd in varchar2 default hr_api.g_varchar2,

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,

Line 657: p_los_det_rl in number default hr_api.g_number,

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,

Line 658: p_mn_los_num in number default hr_api.g_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,
662: p_rndg_cd in varchar2 default hr_api.g_varchar2,

Line 659: p_mx_los_num in number default hr_api.g_number,

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,

Line 660: p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2,

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,

Line 661: p_no_mn_los_num_apls_flag 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,

Line 662: p_rndg_cd in varchar2 default hr_api.g_varchar2,

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,

Line 663: p_rndg_rl 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,
667: p_los_calc_rl in number default hr_api.g_number,

Line 664: p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2,

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,

Line 665: p_los_dt_to_use_rl in number default hr_api.g_number,

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,

Line 666: p_los_uom 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,

Line 667: p_los_calc_rl in number default hr_api.g_number,

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,

Line 668: p_los_alt_val_to_use_cd 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,

Line 669: p_lsf_attribute_category 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,

Line 670: p_lsf_attribute1 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,

Line 671: p_lsf_attribute2 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,

Line 672: p_lsf_attribute3 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,

Line 673: p_lsf_attribute4 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,

Line 674: p_lsf_attribute5 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,

Line 675: p_lsf_attribute6 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,

Line 676: p_lsf_attribute7 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,

Line 677: p_lsf_attribute8 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,

Line 678: p_lsf_attribute9 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,

Line 679: p_lsf_attribute10 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,

Line 680: p_lsf_attribute11 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,

Line 681: p_lsf_attribute12 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,

Line 682: p_lsf_attribute13 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,

Line 683: p_lsf_attribute14 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,

Line 684: p_lsf_attribute15 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,

Line 685: p_lsf_attribute16 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,

Line 686: p_lsf_attribute17 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,

Line 687: p_lsf_attribute18 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,

Line 688: p_lsf_attribute19 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,

Line 689: p_lsf_attribute20 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,

Line 690: p_lsf_attribute21 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,

Line 691: p_lsf_attribute22 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,

Line 692: p_lsf_attribute23 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,

Line 693: p_lsf_attribute24 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,

Line 694: p_lsf_attribute25 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,

Line 695: p_lsf_attribute26 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,

Line 696: p_lsf_attribute27 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,

Line 697: p_lsf_attribute28 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,
701: p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2

Line 698: p_lsf_attribute29 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

Line 699: p_lsf_attribute30 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
703: --

Line 701: p_use_overid_svc_dt_flag 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: --
704: l_rec ben_lsf_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'upd';