APPS.BEN_HWF_UPD dependencies on HR_API

Line 128: When hr_api.check_integrity_violated Then

124: --
125: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: --
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
131: ben_hwf_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
131: ben_hwf_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_hwf_shd.constraint_error

Line 133: When hr_api.parent_integrity_violated Then

129: -- A check constraint has been violated
130: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
131: ben_hwf_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_hwf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_hwf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_hwf_shd.constraint_error

Line 138: When hr_api.unique_integrity_violated Then

134: -- Parent integrity has been violated
135: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_hwf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_hwf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_hwf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: ben_hwf_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;
146: End update_dml;

Line 341: when hr_api.cannot_find_prog_unit then

337: );
338: --
339: exception
340: --
341: when hr_api.cannot_find_prog_unit then
342: --
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'ben_hrs_wkd_in_perd_fctr'
345: ,p_hook_type => 'AU');

Line 343: hr_api.cannot_find_prog_unit_error

339: exception
340: --
341: when hr_api.cannot_find_prog_unit then
342: --
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'ben_hrs_wkd_in_perd_fctr'
345: ,p_hook_type => 'AU');
346: --
347: end;

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

407: -- p_rec plsql record structure
408: -- to see if a system default is being used. If a system default
409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.name = hr_api.g_varchar2) then
412: p_rec.name :=
413: ben_hwf_shd.g_old_rec.name;
414: End If;
415: If (p_rec.business_group_id = hr_api.g_number) then

Line 415: If (p_rec.business_group_id = hr_api.g_number) then

411: If (p_rec.name = hr_api.g_varchar2) then
412: p_rec.name :=
413: ben_hwf_shd.g_old_rec.name;
414: End If;
415: If (p_rec.business_group_id = hr_api.g_number) then
416: p_rec.business_group_id :=
417: ben_hwf_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.hrs_src_cd = hr_api.g_varchar2) then

Line 419: If (p_rec.hrs_src_cd = hr_api.g_varchar2) then

415: If (p_rec.business_group_id = hr_api.g_number) then
416: p_rec.business_group_id :=
417: ben_hwf_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.hrs_src_cd = hr_api.g_varchar2) then
420: p_rec.hrs_src_cd :=
421: ben_hwf_shd.g_old_rec.hrs_src_cd;
422: End If;
423: If (p_rec.rndg_cd = hr_api.g_varchar2) then

Line 423: If (p_rec.rndg_cd = hr_api.g_varchar2) then

419: If (p_rec.hrs_src_cd = hr_api.g_varchar2) then
420: p_rec.hrs_src_cd :=
421: ben_hwf_shd.g_old_rec.hrs_src_cd;
422: End If;
423: If (p_rec.rndg_cd = hr_api.g_varchar2) then
424: p_rec.rndg_cd :=
425: ben_hwf_shd.g_old_rec.rndg_cd;
426: End If;
427: If (p_rec.rndg_rl = hr_api.g_number) then

Line 427: If (p_rec.rndg_rl = hr_api.g_number) then

423: If (p_rec.rndg_cd = hr_api.g_varchar2) then
424: p_rec.rndg_cd :=
425: ben_hwf_shd.g_old_rec.rndg_cd;
426: End If;
427: If (p_rec.rndg_rl = hr_api.g_number) then
428: p_rec.rndg_rl :=
429: ben_hwf_shd.g_old_rec.rndg_rl;
430: End If;
431: If (p_rec.hrs_wkd_det_cd = hr_api.g_varchar2) then

Line 431: If (p_rec.hrs_wkd_det_cd = hr_api.g_varchar2) then

427: If (p_rec.rndg_rl = hr_api.g_number) then
428: p_rec.rndg_rl :=
429: ben_hwf_shd.g_old_rec.rndg_rl;
430: End If;
431: If (p_rec.hrs_wkd_det_cd = hr_api.g_varchar2) then
432: p_rec.hrs_wkd_det_cd :=
433: ben_hwf_shd.g_old_rec.hrs_wkd_det_cd;
434: End If;
435: If (p_rec.hrs_wkd_det_rl = hr_api.g_number) then

Line 435: If (p_rec.hrs_wkd_det_rl = hr_api.g_number) then

431: If (p_rec.hrs_wkd_det_cd = hr_api.g_varchar2) then
432: p_rec.hrs_wkd_det_cd :=
433: ben_hwf_shd.g_old_rec.hrs_wkd_det_cd;
434: End If;
435: If (p_rec.hrs_wkd_det_rl = hr_api.g_number) then
436: p_rec.hrs_wkd_det_rl :=
437: ben_hwf_shd.g_old_rec.hrs_wkd_det_rl;
438: End If;
439: If (p_rec.no_mn_hrs_wkd_flag = hr_api.g_varchar2) then

Line 439: If (p_rec.no_mn_hrs_wkd_flag = hr_api.g_varchar2) then

435: If (p_rec.hrs_wkd_det_rl = hr_api.g_number) then
436: p_rec.hrs_wkd_det_rl :=
437: ben_hwf_shd.g_old_rec.hrs_wkd_det_rl;
438: End If;
439: If (p_rec.no_mn_hrs_wkd_flag = hr_api.g_varchar2) then
440: p_rec.no_mn_hrs_wkd_flag :=
441: ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag;
442: End If;
443: If (p_rec.mx_hrs_num = hr_api.g_number) then

Line 443: If (p_rec.mx_hrs_num = hr_api.g_number) then

439: If (p_rec.no_mn_hrs_wkd_flag = hr_api.g_varchar2) then
440: p_rec.no_mn_hrs_wkd_flag :=
441: ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag;
442: End If;
443: If (p_rec.mx_hrs_num = hr_api.g_number) then
444: p_rec.mx_hrs_num :=
445: ben_hwf_shd.g_old_rec.mx_hrs_num;
446: End If;
447: If (p_rec.no_mx_hrs_wkd_flag = hr_api.g_varchar2) then

Line 447: If (p_rec.no_mx_hrs_wkd_flag = hr_api.g_varchar2) then

443: If (p_rec.mx_hrs_num = hr_api.g_number) then
444: p_rec.mx_hrs_num :=
445: ben_hwf_shd.g_old_rec.mx_hrs_num;
446: End If;
447: If (p_rec.no_mx_hrs_wkd_flag = hr_api.g_varchar2) then
448: p_rec.no_mx_hrs_wkd_flag :=
449: ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag;
450: End If;
451: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then

Line 451: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then

447: If (p_rec.no_mx_hrs_wkd_flag = hr_api.g_varchar2) then
448: p_rec.no_mx_hrs_wkd_flag :=
449: ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag;
450: End If;
451: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
452: p_rec.once_r_cntug_cd :=
453: ben_hwf_shd.g_old_rec.once_r_cntug_cd;
454: End If;
455: If (p_rec.mn_hrs_num = hr_api.g_number) then

Line 455: If (p_rec.mn_hrs_num = hr_api.g_number) then

451: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
452: p_rec.once_r_cntug_cd :=
453: ben_hwf_shd.g_old_rec.once_r_cntug_cd;
454: End If;
455: If (p_rec.mn_hrs_num = hr_api.g_number) then
456: p_rec.mn_hrs_num :=
457: ben_hwf_shd.g_old_rec.mn_hrs_num;
458: End If;
459: If (p_rec.hrs_alt_val_to_use_cd = hr_api.g_varchar2) then

Line 459: If (p_rec.hrs_alt_val_to_use_cd = hr_api.g_varchar2) then

455: If (p_rec.mn_hrs_num = hr_api.g_number) then
456: p_rec.mn_hrs_num :=
457: ben_hwf_shd.g_old_rec.mn_hrs_num;
458: End If;
459: If (p_rec.hrs_alt_val_to_use_cd = hr_api.g_varchar2) then
460: p_rec.hrs_alt_val_to_use_cd :=
461: ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd;
462: End If;
463: If (p_rec.pyrl_freq_cd = hr_api.g_varchar2) then

Line 463: If (p_rec.pyrl_freq_cd = hr_api.g_varchar2) then

459: If (p_rec.hrs_alt_val_to_use_cd = hr_api.g_varchar2) then
460: p_rec.hrs_alt_val_to_use_cd :=
461: ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd;
462: End If;
463: If (p_rec.pyrl_freq_cd = hr_api.g_varchar2) then
464: p_rec.pyrl_freq_cd :=
465: ben_hwf_shd.g_old_rec.pyrl_freq_cd;
466: End If;
467: If (p_rec.hrs_wkd_calc_rl = hr_api.g_number) then

Line 467: If (p_rec.hrs_wkd_calc_rl = hr_api.g_number) then

463: If (p_rec.pyrl_freq_cd = hr_api.g_varchar2) then
464: p_rec.pyrl_freq_cd :=
465: ben_hwf_shd.g_old_rec.pyrl_freq_cd;
466: End If;
467: If (p_rec.hrs_wkd_calc_rl = hr_api.g_number) then
468: p_rec.hrs_wkd_calc_rl :=
469: ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl;
470: End If;
471: If (p_rec.defined_balance_id = hr_api.g_number) then

Line 471: If (p_rec.defined_balance_id = hr_api.g_number) then

467: If (p_rec.hrs_wkd_calc_rl = hr_api.g_number) then
468: p_rec.hrs_wkd_calc_rl :=
469: ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl;
470: End If;
471: If (p_rec.defined_balance_id = hr_api.g_number) then
472: p_rec.defined_balance_id :=
473: ben_hwf_shd.g_old_rec.defined_balance_id;
474: End If;
475: If (p_rec.bnfts_bal_id = hr_api.g_number) then

Line 475: If (p_rec.bnfts_bal_id = hr_api.g_number) then

471: If (p_rec.defined_balance_id = hr_api.g_number) then
472: p_rec.defined_balance_id :=
473: ben_hwf_shd.g_old_rec.defined_balance_id;
474: End If;
475: If (p_rec.bnfts_bal_id = hr_api.g_number) then
476: p_rec.bnfts_bal_id :=
477: ben_hwf_shd.g_old_rec.bnfts_bal_id;
478: End If;
479: If (p_rec.hwf_attribute_category = hr_api.g_varchar2) then

Line 479: If (p_rec.hwf_attribute_category = hr_api.g_varchar2) then

475: If (p_rec.bnfts_bal_id = hr_api.g_number) then
476: p_rec.bnfts_bal_id :=
477: ben_hwf_shd.g_old_rec.bnfts_bal_id;
478: End If;
479: If (p_rec.hwf_attribute_category = hr_api.g_varchar2) then
480: p_rec.hwf_attribute_category :=
481: ben_hwf_shd.g_old_rec.hwf_attribute_category;
482: End If;
483: If (p_rec.hwf_attribute1 = hr_api.g_varchar2) then

Line 483: If (p_rec.hwf_attribute1 = hr_api.g_varchar2) then

479: If (p_rec.hwf_attribute_category = hr_api.g_varchar2) then
480: p_rec.hwf_attribute_category :=
481: ben_hwf_shd.g_old_rec.hwf_attribute_category;
482: End If;
483: If (p_rec.hwf_attribute1 = hr_api.g_varchar2) then
484: p_rec.hwf_attribute1 :=
485: ben_hwf_shd.g_old_rec.hwf_attribute1;
486: End If;
487: If (p_rec.hwf_attribute2 = hr_api.g_varchar2) then

Line 487: If (p_rec.hwf_attribute2 = hr_api.g_varchar2) then

483: If (p_rec.hwf_attribute1 = hr_api.g_varchar2) then
484: p_rec.hwf_attribute1 :=
485: ben_hwf_shd.g_old_rec.hwf_attribute1;
486: End If;
487: If (p_rec.hwf_attribute2 = hr_api.g_varchar2) then
488: p_rec.hwf_attribute2 :=
489: ben_hwf_shd.g_old_rec.hwf_attribute2;
490: End If;
491: If (p_rec.hwf_attribute3 = hr_api.g_varchar2) then

Line 491: If (p_rec.hwf_attribute3 = hr_api.g_varchar2) then

487: If (p_rec.hwf_attribute2 = hr_api.g_varchar2) then
488: p_rec.hwf_attribute2 :=
489: ben_hwf_shd.g_old_rec.hwf_attribute2;
490: End If;
491: If (p_rec.hwf_attribute3 = hr_api.g_varchar2) then
492: p_rec.hwf_attribute3 :=
493: ben_hwf_shd.g_old_rec.hwf_attribute3;
494: End If;
495: If (p_rec.hwf_attribute4 = hr_api.g_varchar2) then

Line 495: If (p_rec.hwf_attribute4 = hr_api.g_varchar2) then

491: If (p_rec.hwf_attribute3 = hr_api.g_varchar2) then
492: p_rec.hwf_attribute3 :=
493: ben_hwf_shd.g_old_rec.hwf_attribute3;
494: End If;
495: If (p_rec.hwf_attribute4 = hr_api.g_varchar2) then
496: p_rec.hwf_attribute4 :=
497: ben_hwf_shd.g_old_rec.hwf_attribute4;
498: End If;
499: If (p_rec.hwf_attribute5 = hr_api.g_varchar2) then

Line 499: If (p_rec.hwf_attribute5 = hr_api.g_varchar2) then

495: If (p_rec.hwf_attribute4 = hr_api.g_varchar2) then
496: p_rec.hwf_attribute4 :=
497: ben_hwf_shd.g_old_rec.hwf_attribute4;
498: End If;
499: If (p_rec.hwf_attribute5 = hr_api.g_varchar2) then
500: p_rec.hwf_attribute5 :=
501: ben_hwf_shd.g_old_rec.hwf_attribute5;
502: End If;
503: If (p_rec.hwf_attribute6 = hr_api.g_varchar2) then

Line 503: If (p_rec.hwf_attribute6 = hr_api.g_varchar2) then

499: If (p_rec.hwf_attribute5 = hr_api.g_varchar2) then
500: p_rec.hwf_attribute5 :=
501: ben_hwf_shd.g_old_rec.hwf_attribute5;
502: End If;
503: If (p_rec.hwf_attribute6 = hr_api.g_varchar2) then
504: p_rec.hwf_attribute6 :=
505: ben_hwf_shd.g_old_rec.hwf_attribute6;
506: End If;
507: If (p_rec.hwf_attribute7 = hr_api.g_varchar2) then

Line 507: If (p_rec.hwf_attribute7 = hr_api.g_varchar2) then

503: If (p_rec.hwf_attribute6 = hr_api.g_varchar2) then
504: p_rec.hwf_attribute6 :=
505: ben_hwf_shd.g_old_rec.hwf_attribute6;
506: End If;
507: If (p_rec.hwf_attribute7 = hr_api.g_varchar2) then
508: p_rec.hwf_attribute7 :=
509: ben_hwf_shd.g_old_rec.hwf_attribute7;
510: End If;
511: If (p_rec.hwf_attribute8 = hr_api.g_varchar2) then

Line 511: If (p_rec.hwf_attribute8 = hr_api.g_varchar2) then

507: If (p_rec.hwf_attribute7 = hr_api.g_varchar2) then
508: p_rec.hwf_attribute7 :=
509: ben_hwf_shd.g_old_rec.hwf_attribute7;
510: End If;
511: If (p_rec.hwf_attribute8 = hr_api.g_varchar2) then
512: p_rec.hwf_attribute8 :=
513: ben_hwf_shd.g_old_rec.hwf_attribute8;
514: End If;
515: If (p_rec.hwf_attribute9 = hr_api.g_varchar2) then

Line 515: If (p_rec.hwf_attribute9 = hr_api.g_varchar2) then

511: If (p_rec.hwf_attribute8 = hr_api.g_varchar2) then
512: p_rec.hwf_attribute8 :=
513: ben_hwf_shd.g_old_rec.hwf_attribute8;
514: End If;
515: If (p_rec.hwf_attribute9 = hr_api.g_varchar2) then
516: p_rec.hwf_attribute9 :=
517: ben_hwf_shd.g_old_rec.hwf_attribute9;
518: End If;
519: If (p_rec.hwf_attribute10 = hr_api.g_varchar2) then

Line 519: If (p_rec.hwf_attribute10 = hr_api.g_varchar2) then

515: If (p_rec.hwf_attribute9 = hr_api.g_varchar2) then
516: p_rec.hwf_attribute9 :=
517: ben_hwf_shd.g_old_rec.hwf_attribute9;
518: End If;
519: If (p_rec.hwf_attribute10 = hr_api.g_varchar2) then
520: p_rec.hwf_attribute10 :=
521: ben_hwf_shd.g_old_rec.hwf_attribute10;
522: End If;
523: If (p_rec.hwf_attribute11 = hr_api.g_varchar2) then

Line 523: If (p_rec.hwf_attribute11 = hr_api.g_varchar2) then

519: If (p_rec.hwf_attribute10 = hr_api.g_varchar2) then
520: p_rec.hwf_attribute10 :=
521: ben_hwf_shd.g_old_rec.hwf_attribute10;
522: End If;
523: If (p_rec.hwf_attribute11 = hr_api.g_varchar2) then
524: p_rec.hwf_attribute11 :=
525: ben_hwf_shd.g_old_rec.hwf_attribute11;
526: End If;
527: If (p_rec.hwf_attribute12 = hr_api.g_varchar2) then

Line 527: If (p_rec.hwf_attribute12 = hr_api.g_varchar2) then

523: If (p_rec.hwf_attribute11 = hr_api.g_varchar2) then
524: p_rec.hwf_attribute11 :=
525: ben_hwf_shd.g_old_rec.hwf_attribute11;
526: End If;
527: If (p_rec.hwf_attribute12 = hr_api.g_varchar2) then
528: p_rec.hwf_attribute12 :=
529: ben_hwf_shd.g_old_rec.hwf_attribute12;
530: End If;
531: If (p_rec.hwf_attribute13 = hr_api.g_varchar2) then

Line 531: If (p_rec.hwf_attribute13 = hr_api.g_varchar2) then

527: If (p_rec.hwf_attribute12 = hr_api.g_varchar2) then
528: p_rec.hwf_attribute12 :=
529: ben_hwf_shd.g_old_rec.hwf_attribute12;
530: End If;
531: If (p_rec.hwf_attribute13 = hr_api.g_varchar2) then
532: p_rec.hwf_attribute13 :=
533: ben_hwf_shd.g_old_rec.hwf_attribute13;
534: End If;
535: If (p_rec.hwf_attribute14 = hr_api.g_varchar2) then

Line 535: If (p_rec.hwf_attribute14 = hr_api.g_varchar2) then

531: If (p_rec.hwf_attribute13 = hr_api.g_varchar2) then
532: p_rec.hwf_attribute13 :=
533: ben_hwf_shd.g_old_rec.hwf_attribute13;
534: End If;
535: If (p_rec.hwf_attribute14 = hr_api.g_varchar2) then
536: p_rec.hwf_attribute14 :=
537: ben_hwf_shd.g_old_rec.hwf_attribute14;
538: End If;
539: If (p_rec.hwf_attribute15 = hr_api.g_varchar2) then

Line 539: If (p_rec.hwf_attribute15 = hr_api.g_varchar2) then

535: If (p_rec.hwf_attribute14 = hr_api.g_varchar2) then
536: p_rec.hwf_attribute14 :=
537: ben_hwf_shd.g_old_rec.hwf_attribute14;
538: End If;
539: If (p_rec.hwf_attribute15 = hr_api.g_varchar2) then
540: p_rec.hwf_attribute15 :=
541: ben_hwf_shd.g_old_rec.hwf_attribute15;
542: End If;
543: If (p_rec.hwf_attribute16 = hr_api.g_varchar2) then

Line 543: If (p_rec.hwf_attribute16 = hr_api.g_varchar2) then

539: If (p_rec.hwf_attribute15 = hr_api.g_varchar2) then
540: p_rec.hwf_attribute15 :=
541: ben_hwf_shd.g_old_rec.hwf_attribute15;
542: End If;
543: If (p_rec.hwf_attribute16 = hr_api.g_varchar2) then
544: p_rec.hwf_attribute16 :=
545: ben_hwf_shd.g_old_rec.hwf_attribute16;
546: End If;
547: If (p_rec.hwf_attribute17 = hr_api.g_varchar2) then

Line 547: If (p_rec.hwf_attribute17 = hr_api.g_varchar2) then

543: If (p_rec.hwf_attribute16 = hr_api.g_varchar2) then
544: p_rec.hwf_attribute16 :=
545: ben_hwf_shd.g_old_rec.hwf_attribute16;
546: End If;
547: If (p_rec.hwf_attribute17 = hr_api.g_varchar2) then
548: p_rec.hwf_attribute17 :=
549: ben_hwf_shd.g_old_rec.hwf_attribute17;
550: End If;
551: If (p_rec.hwf_attribute18 = hr_api.g_varchar2) then

Line 551: If (p_rec.hwf_attribute18 = hr_api.g_varchar2) then

547: If (p_rec.hwf_attribute17 = hr_api.g_varchar2) then
548: p_rec.hwf_attribute17 :=
549: ben_hwf_shd.g_old_rec.hwf_attribute17;
550: End If;
551: If (p_rec.hwf_attribute18 = hr_api.g_varchar2) then
552: p_rec.hwf_attribute18 :=
553: ben_hwf_shd.g_old_rec.hwf_attribute18;
554: End If;
555: If (p_rec.hwf_attribute19 = hr_api.g_varchar2) then

Line 555: If (p_rec.hwf_attribute19 = hr_api.g_varchar2) then

551: If (p_rec.hwf_attribute18 = hr_api.g_varchar2) then
552: p_rec.hwf_attribute18 :=
553: ben_hwf_shd.g_old_rec.hwf_attribute18;
554: End If;
555: If (p_rec.hwf_attribute19 = hr_api.g_varchar2) then
556: p_rec.hwf_attribute19 :=
557: ben_hwf_shd.g_old_rec.hwf_attribute19;
558: End If;
559: If (p_rec.hwf_attribute20 = hr_api.g_varchar2) then

Line 559: If (p_rec.hwf_attribute20 = hr_api.g_varchar2) then

555: If (p_rec.hwf_attribute19 = hr_api.g_varchar2) then
556: p_rec.hwf_attribute19 :=
557: ben_hwf_shd.g_old_rec.hwf_attribute19;
558: End If;
559: If (p_rec.hwf_attribute20 = hr_api.g_varchar2) then
560: p_rec.hwf_attribute20 :=
561: ben_hwf_shd.g_old_rec.hwf_attribute20;
562: End If;
563: If (p_rec.hwf_attribute21 = hr_api.g_varchar2) then

Line 563: If (p_rec.hwf_attribute21 = hr_api.g_varchar2) then

559: If (p_rec.hwf_attribute20 = hr_api.g_varchar2) then
560: p_rec.hwf_attribute20 :=
561: ben_hwf_shd.g_old_rec.hwf_attribute20;
562: End If;
563: If (p_rec.hwf_attribute21 = hr_api.g_varchar2) then
564: p_rec.hwf_attribute21 :=
565: ben_hwf_shd.g_old_rec.hwf_attribute21;
566: End If;
567: If (p_rec.hwf_attribute22 = hr_api.g_varchar2) then

Line 567: If (p_rec.hwf_attribute22 = hr_api.g_varchar2) then

563: If (p_rec.hwf_attribute21 = hr_api.g_varchar2) then
564: p_rec.hwf_attribute21 :=
565: ben_hwf_shd.g_old_rec.hwf_attribute21;
566: End If;
567: If (p_rec.hwf_attribute22 = hr_api.g_varchar2) then
568: p_rec.hwf_attribute22 :=
569: ben_hwf_shd.g_old_rec.hwf_attribute22;
570: End If;
571: If (p_rec.hwf_attribute23 = hr_api.g_varchar2) then

Line 571: If (p_rec.hwf_attribute23 = hr_api.g_varchar2) then

567: If (p_rec.hwf_attribute22 = hr_api.g_varchar2) then
568: p_rec.hwf_attribute22 :=
569: ben_hwf_shd.g_old_rec.hwf_attribute22;
570: End If;
571: If (p_rec.hwf_attribute23 = hr_api.g_varchar2) then
572: p_rec.hwf_attribute23 :=
573: ben_hwf_shd.g_old_rec.hwf_attribute23;
574: End If;
575: If (p_rec.hwf_attribute24 = hr_api.g_varchar2) then

Line 575: If (p_rec.hwf_attribute24 = hr_api.g_varchar2) then

571: If (p_rec.hwf_attribute23 = hr_api.g_varchar2) then
572: p_rec.hwf_attribute23 :=
573: ben_hwf_shd.g_old_rec.hwf_attribute23;
574: End If;
575: If (p_rec.hwf_attribute24 = hr_api.g_varchar2) then
576: p_rec.hwf_attribute24 :=
577: ben_hwf_shd.g_old_rec.hwf_attribute24;
578: End If;
579: If (p_rec.hwf_attribute25 = hr_api.g_varchar2) then

Line 579: If (p_rec.hwf_attribute25 = hr_api.g_varchar2) then

575: If (p_rec.hwf_attribute24 = hr_api.g_varchar2) then
576: p_rec.hwf_attribute24 :=
577: ben_hwf_shd.g_old_rec.hwf_attribute24;
578: End If;
579: If (p_rec.hwf_attribute25 = hr_api.g_varchar2) then
580: p_rec.hwf_attribute25 :=
581: ben_hwf_shd.g_old_rec.hwf_attribute25;
582: End If;
583: If (p_rec.hwf_attribute26 = hr_api.g_varchar2) then

Line 583: If (p_rec.hwf_attribute26 = hr_api.g_varchar2) then

579: If (p_rec.hwf_attribute25 = hr_api.g_varchar2) then
580: p_rec.hwf_attribute25 :=
581: ben_hwf_shd.g_old_rec.hwf_attribute25;
582: End If;
583: If (p_rec.hwf_attribute26 = hr_api.g_varchar2) then
584: p_rec.hwf_attribute26 :=
585: ben_hwf_shd.g_old_rec.hwf_attribute26;
586: End If;
587: If (p_rec.hwf_attribute27 = hr_api.g_varchar2) then

Line 587: If (p_rec.hwf_attribute27 = hr_api.g_varchar2) then

583: If (p_rec.hwf_attribute26 = hr_api.g_varchar2) then
584: p_rec.hwf_attribute26 :=
585: ben_hwf_shd.g_old_rec.hwf_attribute26;
586: End If;
587: If (p_rec.hwf_attribute27 = hr_api.g_varchar2) then
588: p_rec.hwf_attribute27 :=
589: ben_hwf_shd.g_old_rec.hwf_attribute27;
590: End If;
591: If (p_rec.hwf_attribute28 = hr_api.g_varchar2) then

Line 591: If (p_rec.hwf_attribute28 = hr_api.g_varchar2) then

587: If (p_rec.hwf_attribute27 = hr_api.g_varchar2) then
588: p_rec.hwf_attribute27 :=
589: ben_hwf_shd.g_old_rec.hwf_attribute27;
590: End If;
591: If (p_rec.hwf_attribute28 = hr_api.g_varchar2) then
592: p_rec.hwf_attribute28 :=
593: ben_hwf_shd.g_old_rec.hwf_attribute28;
594: End If;
595: If (p_rec.hwf_attribute29 = hr_api.g_varchar2) then

Line 595: If (p_rec.hwf_attribute29 = hr_api.g_varchar2) then

591: If (p_rec.hwf_attribute28 = hr_api.g_varchar2) then
592: p_rec.hwf_attribute28 :=
593: ben_hwf_shd.g_old_rec.hwf_attribute28;
594: End If;
595: If (p_rec.hwf_attribute29 = hr_api.g_varchar2) then
596: p_rec.hwf_attribute29 :=
597: ben_hwf_shd.g_old_rec.hwf_attribute29;
598: End If;
599: If (p_rec.hwf_attribute30 = hr_api.g_varchar2) then

Line 599: If (p_rec.hwf_attribute30 = hr_api.g_varchar2) then

595: If (p_rec.hwf_attribute29 = hr_api.g_varchar2) then
596: p_rec.hwf_attribute29 :=
597: ben_hwf_shd.g_old_rec.hwf_attribute29;
598: End If;
599: If (p_rec.hwf_attribute30 = hr_api.g_varchar2) then
600: p_rec.hwf_attribute30 :=
601: ben_hwf_shd.g_old_rec.hwf_attribute30;
602: End If;
603:

Line 662: p_name in varchar2 default hr_api.g_varchar2,

658: Procedure upd
659: (
660: p_effective_date in date,
661: p_hrs_wkd_in_perd_fctr_id in number,
662: p_name in varchar2 default hr_api.g_varchar2,
663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,

Line 663: p_business_group_id in number default hr_api.g_number,

659: (
660: p_effective_date in date,
661: p_hrs_wkd_in_perd_fctr_id in number,
662: p_name in varchar2 default hr_api.g_varchar2,
663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,

Line 664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,

660: p_effective_date in date,
661: p_hrs_wkd_in_perd_fctr_id in number,
662: p_name in varchar2 default hr_api.g_varchar2,
663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,

Line 665: p_rndg_cd in varchar2 default hr_api.g_varchar2,

661: p_hrs_wkd_in_perd_fctr_id in number,
662: p_name in varchar2 default hr_api.g_varchar2,
663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,

Line 666: p_rndg_rl in number default hr_api.g_number,

662: p_name in varchar2 default hr_api.g_varchar2,
663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,

Line 667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,

663: p_business_group_id in number default hr_api.g_number,
664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,

Line 668: p_hrs_wkd_det_rl in number default hr_api.g_number,

664: p_hrs_src_cd in varchar2 default hr_api.g_varchar2,
665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,

Line 669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,

665: p_rndg_cd in varchar2 default hr_api.g_varchar2,
666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,

Line 670: p_mx_hrs_num in number default hr_api.g_number,

666: p_rndg_rl in number default hr_api.g_number,
667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,

Line 671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,

667: p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2,
668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,

Line 672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,

668: p_hrs_wkd_det_rl in number default hr_api.g_number,
669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,

Line 673: p_mn_hrs_num in number default hr_api.g_number,

669: p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,

Line 674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,

670: p_mx_hrs_num in number default hr_api.g_number,
671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,

Line 675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,

671: p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,

Line 676: p_hrs_wkd_calc_rl in number default hr_api.g_number,

672: p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2,
673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,

Line 677: p_defined_balance_id in number default hr_api.g_number,

673: p_mn_hrs_num in number default hr_api.g_number,
674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,

Line 678: p_bnfts_bal_id in number default hr_api.g_number,

674: p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,

Line 679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,

675: p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2,
676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,

Line 680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,

676: p_hrs_wkd_calc_rl in number default hr_api.g_number,
677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,

Line 681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,

677: p_defined_balance_id in number default hr_api.g_number,
678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,

Line 682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,

678: p_bnfts_bal_id in number default hr_api.g_number,
679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,

Line 683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,

679: p_hwf_attribute_category in varchar2 default hr_api.g_varchar2,
680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,

Line 684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,

680: p_hwf_attribute1 in varchar2 default hr_api.g_varchar2,
681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,

Line 685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,

681: p_hwf_attribute2 in varchar2 default hr_api.g_varchar2,
682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,

Line 686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,

682: p_hwf_attribute3 in varchar2 default hr_api.g_varchar2,
683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,

Line 687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,

683: p_hwf_attribute4 in varchar2 default hr_api.g_varchar2,
684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,

Line 688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,

684: p_hwf_attribute5 in varchar2 default hr_api.g_varchar2,
685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,

Line 689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,

685: p_hwf_attribute6 in varchar2 default hr_api.g_varchar2,
686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,

Line 690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,

686: p_hwf_attribute7 in varchar2 default hr_api.g_varchar2,
687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,

Line 691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,

687: p_hwf_attribute8 in varchar2 default hr_api.g_varchar2,
688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,

Line 692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,

688: p_hwf_attribute9 in varchar2 default hr_api.g_varchar2,
689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,

Line 693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,

689: p_hwf_attribute10 in varchar2 default hr_api.g_varchar2,
690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,

Line 694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,

690: p_hwf_attribute11 in varchar2 default hr_api.g_varchar2,
691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,

Line 695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,

691: p_hwf_attribute12 in varchar2 default hr_api.g_varchar2,
692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,

Line 696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,

692: p_hwf_attribute13 in varchar2 default hr_api.g_varchar2,
693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,

Line 697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,

693: p_hwf_attribute14 in varchar2 default hr_api.g_varchar2,
694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,

Line 698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,

694: p_hwf_attribute15 in varchar2 default hr_api.g_varchar2,
695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,

Line 699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,

695: p_hwf_attribute16 in varchar2 default hr_api.g_varchar2,
696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,

Line 700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,

696: p_hwf_attribute17 in varchar2 default hr_api.g_varchar2,
697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,

Line 701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,

697: p_hwf_attribute18 in varchar2 default hr_api.g_varchar2,
698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,

Line 702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,

698: p_hwf_attribute19 in varchar2 default hr_api.g_varchar2,
699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,

Line 703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,

699: p_hwf_attribute20 in varchar2 default hr_api.g_varchar2,
700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,

Line 704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,

700: p_hwf_attribute21 in varchar2 default hr_api.g_varchar2,
701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,

Line 705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,

701: p_hwf_attribute22 in varchar2 default hr_api.g_varchar2,
702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,
709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,

Line 706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,

702: p_hwf_attribute23 in varchar2 default hr_api.g_varchar2,
703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,
709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,
710: p_object_version_number in out nocopy number

Line 707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,

703: p_hwf_attribute24 in varchar2 default hr_api.g_varchar2,
704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,
709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,
710: p_object_version_number in out nocopy number
711: ) is

Line 708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,

704: p_hwf_attribute25 in varchar2 default hr_api.g_varchar2,
705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,
709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,
710: p_object_version_number in out nocopy number
711: ) is
712: --

Line 709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,

705: p_hwf_attribute26 in varchar2 default hr_api.g_varchar2,
706: p_hwf_attribute27 in varchar2 default hr_api.g_varchar2,
707: p_hwf_attribute28 in varchar2 default hr_api.g_varchar2,
708: p_hwf_attribute29 in varchar2 default hr_api.g_varchar2,
709: p_hwf_attribute30 in varchar2 default hr_api.g_varchar2,
710: p_object_version_number in out nocopy number
711: ) is
712: --
713: l_rec ben_hwf_shd.g_rec_type;