DBA Data[Home] [Help]

APPS.BEN_HWF_BUS dependencies on BEN_HWF_SHD

Line 46: l_api_updating := ben_hwf_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_hwf_shd.api_updating
47: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_hwf_shd.g_old_rec.hrs_wkd_in_perd_fctr_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
52: <> ben_hwf_shd.g_old_rec.hrs_wkd_in_perd_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');

Line 56: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');

52: <> ben_hwf_shd.g_old_rec.hrs_wkd_in_perd_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');

62: if p_hrs_wkd_in_perd_fctr_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');
67: --
68: end if;
69: --
70: end if;

Line 114: l_api_updating := ben_hwf_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_hwf_shd.api_updating
115: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

Line 120: <> nvl(ben_hwf_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_once_r_cntug_cd
120: <> nvl(ben_hwf_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_once_r_cntug_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.

Line 183: l_api_updating := ben_hwf_shd.api_updating

179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_hwf_shd.api_updating
184: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating

Line 189: <> nvl(ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag,hr_api.g_varchar2)

185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating
188: and p_no_mx_hrs_wkd_flag
189: <> nvl(ben_hwf_shd.g_old_rec.no_mx_hrs_wkd_flag,hr_api.g_varchar2)
190: or not l_api_updating)
191: and p_no_mx_hrs_wkd_flag is not null then
192: --
193: -- check if value of lookup falls within lookup type.

Line 250: l_api_updating := ben_hwf_shd.api_updating

246: Begin
247: --
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: l_api_updating := ben_hwf_shd.api_updating
251: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
252: p_object_version_number => p_object_version_number);
253: --
254: if (l_api_updating

Line 256: <> nvl(ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag,hr_api.g_varchar2)

252: p_object_version_number => p_object_version_number);
253: --
254: if (l_api_updating
255: and p_no_mn_hrs_wkd_flag
256: <> nvl(ben_hwf_shd.g_old_rec.no_mn_hrs_wkd_flag,hr_api.g_varchar2)
257: or not l_api_updating)
258: and p_no_mn_hrs_wkd_flag is not null then
259: --
260: -- check if value of lookup falls within lookup type.

Line 336: l_api_updating := ben_hwf_shd.api_updating

332: Begin
333: --
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: l_api_updating := ben_hwf_shd.api_updating
337: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
338: p_object_version_number => p_object_version_number);
339: --
340: if (l_api_updating

Line 342: <> ben_hwf_shd.g_old_rec.hrs_wkd_det_rl

338: p_object_version_number => p_object_version_number);
339: --
340: if (l_api_updating
341: and nvl(p_hrs_wkd_det_rl,hr_api.g_number)
342: <> ben_hwf_shd.g_old_rec.hrs_wkd_det_rl
343: or not l_api_updating)
344: and p_hrs_wkd_det_rl is not null then
345: --
346: -- check if value of formula rule is valid.

Line 424: l_api_updating := ben_hwf_shd.api_updating

420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_hwf_shd.api_updating
425: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating

Line 430: <> nvl(ben_hwf_shd.g_old_rec.hrs_wkd_det_cd,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating
429: and p_hrs_wkd_det_cd
430: <> nvl(ben_hwf_shd.g_old_rec.hrs_wkd_det_cd,hr_api.g_varchar2)
431: or not l_api_updating)
432: and p_hrs_wkd_det_cd is not null then
433: --
434: -- check if value of lookup falls within lookup type.

Line 510: l_api_updating := ben_hwf_shd.api_updating

506: Begin
507: --
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: l_api_updating := ben_hwf_shd.api_updating
511: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating

Line 516: <> ben_hwf_shd.g_old_rec.rndg_rl

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and nvl(p_rndg_rl,hr_api.g_number)
516: <> ben_hwf_shd.g_old_rec.rndg_rl
517: or not l_api_updating)
518: and p_rndg_rl is not null then
519: --
520: -- check if value of formula rule is valid.

Line 599: l_api_updating := ben_hwf_shd.api_updating

595: Begin
596: --
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: l_api_updating := ben_hwf_shd.api_updating
600: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
601: p_object_version_number => p_object_version_number);
602: --
603: if (l_api_updating

Line 605: <> nvl(ben_hwf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

601: p_object_version_number => p_object_version_number);
602: --
603: if (l_api_updating
604: and p_rndg_cd
605: <> nvl(ben_hwf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
606: or not l_api_updating)
607: and p_rndg_cd is not null then
608: --
609: -- check if value of lookup falls within lookup type.

Line 667: l_api_updating := ben_hwf_shd.api_updating

663: Begin
664: --
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: l_api_updating := ben_hwf_shd.api_updating
668: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating

Line 673: <> nvl(ben_hwf_shd.g_old_rec.hrs_src_cd,hr_api.g_varchar2)

669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating
672: and p_hrs_src_cd
673: <> nvl(ben_hwf_shd.g_old_rec.hrs_src_cd,hr_api.g_varchar2)
674: or not l_api_updating)
675: and p_hrs_src_cd is not null then
676: --
677: -- check if value of lookup falls within lookup type.

Line 735: l_api_updating := ben_hwf_shd.api_updating

731: Begin
732: --
733: hr_utility.set_location('Entering:'||l_proc, 5);
734: --
735: l_api_updating := ben_hwf_shd.api_updating
736: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
737: p_object_version_number => p_object_version_number);
738: --
739: if (l_api_updating

Line 741: <> nvl(ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd,hr_api.g_varchar2)

737: p_object_version_number => p_object_version_number);
738: --
739: if (l_api_updating
740: and p_hrs_alt_val_to_use_cd
741: <> nvl(ben_hwf_shd.g_old_rec.hrs_alt_val_to_use_cd,hr_api.g_varchar2)
742: or not l_api_updating)
743: and p_hrs_alt_val_to_use_cd is not null then
744: --
745: -- check if value of lookup falls within lookup type.

Line 804: l_api_updating := ben_hwf_shd.api_updating

800: Begin
801: --
802: hr_utility.set_location('Entering:'||l_proc, 5);
803: --
804: l_api_updating := ben_hwf_shd.api_updating
805: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
806: p_object_version_number => p_object_version_number);
807: --
808: if (l_api_updating

Line 810: <> nvl(ben_hwf_shd.g_old_rec.pyrl_freq_cd,hr_api.g_varchar2)

806: p_object_version_number => p_object_version_number);
807: --
808: if (l_api_updating
809: and p_pyrl_freq_cd
810: <> nvl(ben_hwf_shd.g_old_rec.pyrl_freq_cd,hr_api.g_varchar2)
811: or not l_api_updating)
812: and p_pyrl_freq_cd is not null then
813: --
814: -- check if value of lookup falls within lookup type.

Line 890: l_api_updating := ben_hwf_shd.api_updating

886: Begin
887: --
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --
890: l_api_updating := ben_hwf_shd.api_updating
891: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
892: p_object_version_number => p_object_version_number);
893: --
894: if (l_api_updating

Line 896: <> ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl

892: p_object_version_number => p_object_version_number);
893: --
894: if (l_api_updating
895: and nvl(p_hrs_wkd_calc_rl,hr_api.g_number)
896: <> ben_hwf_shd.g_old_rec.hrs_wkd_calc_rl
897: or not l_api_updating)
898: and p_hrs_wkd_calc_rl is not null then
899: --
900: -- check if value of formula rule is valid.

Line 977: l_api_updating := ben_hwf_shd.api_updating

973: Begin
974: --
975: hr_utility.set_location('Entering:'||l_proc, 5);
976: --
977: l_api_updating := ben_hwf_shd.api_updating
978: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
979: -- p_effective_date => p_effective_date,
980: p_object_version_number => p_object_version_number);
981: --

Line 984: <> ben_hwf_shd.g_old_rec.name

980: p_object_version_number => p_object_version_number);
981: --
982: if (l_api_updating
983: and nvl(p_name,hr_api.g_varchar2)
984: <> ben_hwf_shd.g_old_rec.name
985: or not l_api_updating)
986: and p_name is not null then
987: --
988: -- check if name already used.

Line 1235: Procedure insert_validate(p_rec in ben_hwf_shd.g_rec_type

1231:
1232: -- ----------------------------------------------------------------------------
1233: -- |---------------------------< insert_validate >----------------------------|
1234: -- ----------------------------------------------------------------------------
1235: Procedure insert_validate(p_rec in ben_hwf_shd.g_rec_type
1236: ,p_effective_date in date) is
1237: --
1238: l_proc varchar2(72) := g_package||'insert_validate';
1239: --

Line 1350: Procedure update_validate(p_rec in ben_hwf_shd.g_rec_type

1346: --
1347: -- ----------------------------------------------------------------------------
1348: -- |---------------------------< update_validate >----------------------------|
1349: -- ----------------------------------------------------------------------------
1350: Procedure update_validate(p_rec in ben_hwf_shd.g_rec_type
1351: ,p_effective_date in date) is
1352: --
1353: l_proc varchar2(72) := g_package||'update_validate';
1354: --

Line 1465: Procedure delete_validate(p_rec in ben_hwf_shd.g_rec_type

1461: --
1462: -- ----------------------------------------------------------------------------
1463: -- |---------------------------< delete_validate >----------------------------|
1464: -- ----------------------------------------------------------------------------
1465: Procedure delete_validate(p_rec in ben_hwf_shd.g_rec_type
1466: ,p_effective_date in date) is
1467: --
1468: l_proc varchar2(72) := g_package||'delete_validate';
1469: --