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_EAT_BUS dependencies on BEN_EAT_SHD

Line 46: l_api_updating := ben_eat_shd.api_updating

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

Line 52: <> ben_eat_shd.g_old_rec.actn_typ_id) then

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

Line 56: ben_eat_shd.constraint_error('BEN_ACTN_TYP_PK');

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

Line 66: ben_eat_shd.constraint_error('BEN_ACTN_TYP_PK');

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

Line 125: l_api_updating := ben_eat_shd.api_updating

121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: l_api_updating := ben_eat_shd.api_updating
126: (p_actn_typ_id => p_actn_typ_id,
127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating and

Line 130: ben_eat_shd.g_old_rec.type_cd in ('BNF', 'BNFADDNL', 'BNFADDR', 'BNFCTFN',

126: (p_actn_typ_id => p_actn_typ_id,
127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating and
130: ben_eat_shd.g_old_rec.type_cd in ('BNF', 'BNFADDNL', 'BNFADDR', 'BNFCTFN',
131: 'BNFDOB', 'BNFSSN','BNFTTEE', 'DD', 'DDADDNL','DDADDR','DDCTFN',
132: 'DDDOB', 'DDSSN', 'LEECTFN', 'WVPRTNCTFN', 'ENRTCTFN', 'PC', 'TA')
133: and nvl(p_type_cd,hr_api.g_varchar2) <> ben_eat_shd.g_old_rec.type_cd) then
134: -- The user is not allowed to change these System Enrollment Action TYPES

Line 133: and nvl(p_type_cd,hr_api.g_varchar2) <> ben_eat_shd.g_old_rec.type_cd) then

129: if (l_api_updating and
130: ben_eat_shd.g_old_rec.type_cd in ('BNF', 'BNFADDNL', 'BNFADDR', 'BNFCTFN',
131: 'BNFDOB', 'BNFSSN','BNFTTEE', 'DD', 'DDADDNL','DDADDR','DDCTFN',
132: 'DDDOB', 'DDSSN', 'LEECTFN', 'WVPRTNCTFN', 'ENRTCTFN', 'PC', 'TA')
133: and nvl(p_type_cd,hr_api.g_varchar2) <> ben_eat_shd.g_old_rec.type_cd) then
134: -- The user is not allowed to change these System Enrollment Action TYPES
135: --
136: fnd_message.set_name('BEN','BEN_91449_ACTN_TYP_CHG');
137: fnd_message.raise_error;

Line 141: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)

137: fnd_message.raise_error;
138: end if;
139:
140: if nvl(p_type_cd,hr_api.g_varchar2)
141: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)
142: and
143: p_type_cd in ('BNF', 'BNFADDNL', 'BNFADDR', 'BNFCTFN',
144: 'BNFDOB', 'BNFSSN', 'BNFTTEE', 'DD', 'DDADDNL','DDADDR','DDCTFN',
145: 'DDDOB', 'DDSSN', 'LEECTFN', 'WVPRTNCTFN', 'ENRTCTFN', 'PC', 'TA') then

Line 163: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)

159:
160:
161: if (l_api_updating
162: and p_type_cd
163: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)
164: or not l_api_updating)
165: and p_type_cd is not null then
166: --
167: -- check if value of lookup falls within lookup type.

Line 189: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)

185: -- Only allow the Type Code to change if the record is not being used in any
186: -- foreign keys. CAN change the type from null to something though.
187: if (l_api_updating
188: and nvl(p_type_cd,hr_api.g_varchar2)
189: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)
190: and ben_eat_shd.g_old_rec.type_cd is not null) then
191: null;
192: --
193: declare

Line 190: and ben_eat_shd.g_old_rec.type_cd is not null) then

186: -- foreign keys. CAN change the type from null to something though.
187: if (l_api_updating
188: and nvl(p_type_cd,hr_api.g_varchar2)
189: <> nvl(ben_eat_shd.g_old_rec.type_cd,hr_api.g_varchar2)
190: and ben_eat_shd.g_old_rec.type_cd is not null) then
191: null;
192: --
193: declare
194: cursor c1 is select null

Line 258: l_api_updating := ben_eat_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := ben_eat_shd.api_updating
259: (p_actn_typ_id => p_actn_typ_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating

Line 263: and p_name <> ben_eat_shd.g_old_rec.name) or

259: (p_actn_typ_id => p_actn_typ_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_name <> ben_eat_shd.g_old_rec.name) or
264: not l_api_updating then
265: --
266: -- check if name already exists
267: --

Line 332: l_api_updating := ben_eat_shd.api_updating

328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_eat_shd.api_updating
333: (p_actn_typ_id => p_actn_typ_id,
334: p_object_version_number => p_object_version_number);
335: --
336: open c_type_cd;

Line 363: Procedure insert_validate(p_rec in ben_eat_shd.g_rec_type

359: -- --
360: -- ----------------------------------------------------------------------------
361: -- |---------------------------< insert_validate >----------------------------|
362: -- ----------------------------------------------------------------------------
363: Procedure insert_validate(p_rec in ben_eat_shd.g_rec_type
364: ,p_effective_date in date) is
365: --
366: l_proc varchar2(72) := g_package||'insert_validate';
367: --

Line 403: Procedure update_validate(p_rec in ben_eat_shd.g_rec_type

399: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------< update_validate >----------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure update_validate(p_rec in ben_eat_shd.g_rec_type
404: ,p_effective_date in date) is
405: --
406: l_proc varchar2(72) := g_package||'update_validate';
407: --

Line 440: Procedure delete_validate(p_rec in ben_eat_shd.g_rec_type

436: --
437: -- ----------------------------------------------------------------------------
438: -- |---------------------------< delete_validate >----------------------------|
439: -- ----------------------------------------------------------------------------
440: Procedure delete_validate(p_rec in ben_eat_shd.g_rec_type
441: ,p_effective_date in date) is
442: --
443: l_proc varchar2(72) := g_package||'delete_validate';
444: --