eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_HWF_BUS dependencies on HR_API

Line 51: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)

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

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 126: if hr_api.not_exists_in_hr_lookups

122: and p_once_r_cntug_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: if hr_api.not_exists_in_hr_lookups
127: (p_lookup_type => 'BEN_ONCE_R_CNTNG',
128: p_lookup_code => p_once_r_cntug_cd,
129: p_effective_date => p_effective_date) then
130: --

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 195: if hr_api.not_exists_in_hr_lookups

191: and p_no_mx_hrs_wkd_flag is not null then
192: --
193: -- check if value of lookup falls within lookup type.
194: --
195: if hr_api.not_exists_in_hr_lookups
196: (p_lookup_type => 'YES_NO',
197: p_lookup_code => p_no_mx_hrs_wkd_flag,
198: p_effective_date => p_effective_date) then
199: --

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 262: if hr_api.not_exists_in_hr_lookups

258: and p_no_mn_hrs_wkd_flag is not null then
259: --
260: -- check if value of lookup falls within lookup type.
261: --
262: if hr_api.not_exists_in_hr_lookups
263: (p_lookup_type => 'YES_NO',
264: p_lookup_code => p_no_mn_hrs_wkd_flag,
265: p_effective_date => p_effective_date) then
266: --

Line 341: and nvl(p_hrs_wkd_det_rl,hr_api.g_number)

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

Line 370: if nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) <> 'RL' and p_hrs_wkd_det_rl is not null then

366: --
367: end if;
368: --
369: -- Unless Hours Worked Determination Code = Rule, Hours Worked Determination rule must be blank.
370: if nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) <> 'RL' and p_hrs_wkd_det_rl is not null then
371: --
372: fnd_message.set_name('BEN', 'BEN_91070_HRS_WKD_RL_NOT_NULL');
373: fnd_message.raise_error;
374: --

Line 375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then

371: --
372: fnd_message.set_name('BEN', 'BEN_91070_HRS_WKD_RL_NOT_NULL');
373: fnd_message.raise_error;
374: --
375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then
376: --
377: fnd_message.set_name('BEN', 'BEN_91097_HRS_WKD_RL_NULL');
378: fnd_message.raise_error;
379: --

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 436: if hr_api.not_exists_in_hr_lookups

432: and p_hrs_wkd_det_cd is not null then
433: --
434: -- check if value of lookup falls within lookup type.
435: --
436: if hr_api.not_exists_in_hr_lookups
437: (p_lookup_type => 'BEN_HRS_WKD_DET',
438: p_lookup_code => p_hrs_wkd_det_cd,
439: p_effective_date => p_effective_date) then
440: --

Line 515: and nvl(p_rndg_rl,hr_api.g_number)

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

Line 544: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then

540: --
541: end if;
542: --
543: -- Unless Rounding Code = Rule, Rounding rule must be blank.
544: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
545: --
546: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
547: fnd_message.raise_error;
548: --

Line 549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then

545: --
546: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
547: fnd_message.raise_error;
548: --
549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
550: --
551: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
552: fnd_message.raise_error;
553: --

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 611: if hr_api.not_exists_in_hr_lookups

607: and p_rndg_cd is not null then
608: --
609: -- check if value of lookup falls within lookup type.
610: --
611: if hr_api.not_exists_in_hr_lookups
612: (p_lookup_type => 'BEN_RNDG',
613: p_lookup_code => p_rndg_cd,
614: p_effective_date => p_effective_date) then
615: --

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 679: if hr_api.not_exists_in_hr_lookups

675: and p_hrs_src_cd is not null then
676: --
677: -- check if value of lookup falls within lookup type.
678: --
679: if hr_api.not_exists_in_hr_lookups
680: (p_lookup_type => 'BEN_HRS_WKD_SRC',
681: p_lookup_code => p_hrs_src_cd,
682: p_effective_date => p_effective_date) then
683: --

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 747: if hr_api.not_exists_in_hr_lookups

743: and p_hrs_alt_val_to_use_cd is not null then
744: --
745: -- check if value of lookup falls within lookup type.
746: --
747: if hr_api.not_exists_in_hr_lookups
748: (p_lookup_type => 'BEN_HRS_ALT_VAL_TO_USE',
749: p_lookup_code => p_hrs_alt_val_to_use_cd,
750: p_effective_date => p_effective_date) then
751: --

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 816: if hr_api.not_exists_in_hr_lookups

812: and p_pyrl_freq_cd is not null then
813: --
814: -- check if value of lookup falls within lookup type.
815: --
816: if hr_api.not_exists_in_hr_lookups
817: (p_lookup_type => 'BEN_FREQ',
818: p_lookup_code => p_pyrl_freq_cd,
819: p_effective_date => p_effective_date) then
820: --

Line 895: and nvl(p_hrs_wkd_calc_rl,hr_api.g_number)

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

Line 983: and nvl(p_name,hr_api.g_varchar2)

979: -- p_effective_date => p_effective_date,
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: --

Line 1246: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1242: --
1243: -- Call all supporting business operations
1244: --
1245: --
1246: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1247: --
1248: chk_hrs_wkd_in_perd_fctr_id
1249: (p_hrs_wkd_in_perd_fctr_id => p_rec.hrs_wkd_in_perd_fctr_id,
1250: p_object_version_number => p_rec.object_version_number);

Line 1361: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1357: --
1358: -- Call all supporting business operations
1359: --
1360: --
1361: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1362: --
1363: chk_hrs_wkd_in_perd_fctr_id
1364: (p_hrs_wkd_in_perd_fctr_id => p_rec.hrs_wkd_in_perd_fctr_id,
1365: p_object_version_number => p_rec.object_version_number);

Line 1507: hr_api.mandatory_arg_error(p_api_name => l_proc,

1503: hr_utility.set_location('Entering:'|| l_proc, 10);
1504: --
1505: -- Ensure that all the mandatory parameter are not null
1506: --
1507: hr_api.mandatory_arg_error(p_api_name => l_proc,
1508: p_argument => 'hrs_wkd_in_perd_fctr_id',
1509: p_argument_value => p_hrs_wkd_in_perd_fctr_id);
1510: --
1511: open csr_leg_code;