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_ETW_BUS dependencies on BEN_ETW_SHD

Line 48: l_api_updating := ben_etw_shd.api_updating

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

Line 55: <> ben_etw_shd.g_old_rec.elig_per_wv_pl_typ_id) then

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

Line 59: ben_etw_shd.constraint_error('BEN_ELIG_PER_WV_PL_TYP_F_PK');

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

Line 69: ben_etw_shd.constraint_error('BEN_ELIG_PER_WV_PL_TYP_F_PK');

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

Line 117: l_api_updating := ben_etw_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_etw_shd.api_updating
118: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_etw_shd.g_old_rec.wvd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_wvd_flag
124: <> nvl(ben_etw_shd.g_old_rec.wvd_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_wvd_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 186: l_api_updating := ben_etw_shd.api_updating

182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_etw_shd.api_updating
187: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --

Line 193: <> nvl(ben_etw_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_wv_prtn_rsn_cd
193: <> nvl(ben_etw_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_wv_prtn_rsn_cd is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 255: l_api_updating := ben_etw_shd.api_updating

251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_etw_shd.api_updating
256: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
257: p_effective_date => p_effective_date,
258: p_object_version_number => p_object_version_number);
259: --

Line 262: <> nvl(ben_etw_shd.g_old_rec.wv_cftn_typ_cd,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_wv_cftn_typ_cd
262: <> nvl(ben_etw_shd.g_old_rec.wv_cftn_typ_cd,hr_api.g_varchar2)
263: or not l_api_updating)
264: and p_wv_cftn_typ_cd is not null then
265: --
266: -- check if value of lookup falls within lookup type.

Line 505: (p_rec in ben_etw_shd.g_rec_type,

501: -- ----------------------------------------------------------------------------
502: -- |---------------------------< insert_validate >----------------------------|
503: -- ----------------------------------------------------------------------------
504: Procedure insert_validate
505: (p_rec in ben_etw_shd.g_rec_type,
506: p_effective_date in date,
507: p_datetrack_mode in varchar2,
508: p_validation_start_date in date,
509: p_validation_end_date in date) is

Line 551: (p_rec in ben_etw_shd.g_rec_type,

547: -- ----------------------------------------------------------------------------
548: -- |---------------------------< update_validate >----------------------------|
549: -- ----------------------------------------------------------------------------
550: Procedure update_validate
551: (p_rec in ben_etw_shd.g_rec_type,
552: p_effective_date in date,
553: p_datetrack_mode in varchar2,
554: p_validation_start_date in date,
555: p_validation_end_date in date) is

Line 606: (p_rec in ben_etw_shd.g_rec_type,

602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< delete_validate >----------------------------|
604: -- ----------------------------------------------------------------------------
605: Procedure delete_validate
606: (p_rec in ben_etw_shd.g_rec_type,
607: p_effective_date in date,
608: p_datetrack_mode in varchar2,
609: p_validation_start_date in date,
610: p_validation_end_date in date) is