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_HWR_BUS dependencies on BEN_HWR_SHD

Line 48: l_api_updating := ben_hwr_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_hwr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_rt_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_hrs_wkd_in_perd_rt_id,hr_api.g_number)
55: <> ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_PK');

Line 59: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_PK');

55: <> ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_PK');

65: if p_hrs_wkd_in_perd_rt_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_PK');
70: --
71: end if;
72: --
73: end if;

Line 123: l_api_updating := ben_hwr_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_hwr_shd.api_updating
124: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --
134: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_fctr table

Line 146: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_FK1');

142: --
143: -- raise error as FK does not relate to PK in ben_hrs_wkd_in_perd_fctr
144: -- table.
145: --
146: ben_hwr_shd.constraint_error('BEN_HRS_WORKED_IN_PERD_RT_FK1');
147: --
148: end if;
149: --
150: close c1;

Line 216: l_api_updating := ben_hwr_shd.api_updating

212: BEGIN
213: --
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: l_api_updating := ben_hwr_shd.api_updating
217: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
218: p_effective_date => p_effective_date,
219: p_object_version_number => p_object_version_number);
220: --

Line 222: and p_hrs_wkd_in_perd_fctr_id <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)

218: p_effective_date => p_effective_date,
219: p_object_version_number => p_object_version_number);
220: --
221: if (l_api_updating
222: and p_hrs_wkd_in_perd_fctr_id <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
223: or not l_api_updating) then
224:
225: open c_dup;
226: fetch c_dup into l_exists;

Line 348: l_api_updating := ben_hwr_shd.api_updating

344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_hwr_shd.api_updating
349: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
350: p_effective_date => p_effective_date,
351: p_object_version_number => p_object_version_number);
352: --

Line 355: <> nvl(ben_hwr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_excld_flag
355: <> nvl(ben_hwr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --

Line 640: (p_rec in ben_hwr_shd.g_rec_type,

636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< insert_validate >----------------------------|
638: -- ----------------------------------------------------------------------------
639: Procedure insert_validate
640: (p_rec in ben_hwr_shd.g_rec_type,
641: p_effective_date in date,
642: p_datetrack_mode in varchar2,
643: p_validation_start_date in date,
644: p_validation_end_date in date) is

Line 702: (p_rec in ben_hwr_shd.g_rec_type,

698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< update_validate >----------------------------|
700: -- ----------------------------------------------------------------------------
701: Procedure update_validate
702: (p_rec in ben_hwr_shd.g_rec_type,
703: p_effective_date in date,
704: p_datetrack_mode in varchar2,
705: p_validation_start_date in date,
706: p_validation_end_date in date) is

Line 772: (p_rec in ben_hwr_shd.g_rec_type,

768: -- ----------------------------------------------------------------------------
769: -- |---------------------------< delete_validate >----------------------------|
770: -- ----------------------------------------------------------------------------
771: Procedure delete_validate
772: (p_rec in ben_hwr_shd.g_rec_type,
773: p_effective_date in date,
774: p_datetrack_mode in varchar2,
775: p_validation_start_date in date,
776: p_validation_end_date in date) is