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 HR_API

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

47: (p_actn_typ_id => p_actn_typ_id,
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: --

Line 111: WHERE type_cd = nvl(p_type_cd, hr_api.g_varchar2)

107: --
108: cursor l_csr_eat is
109: SELECT 'x'
110: FROM ben_actn_typ
111: WHERE type_cd = nvl(p_type_cd, hr_api.g_varchar2)
112: AND business_group_id + 0 = p_business_group_id;
113: --
114: l_db_eat_row l_csr_eat%rowtype;
115: l_proc varchar2(72) := g_package||'chk_type_cd';

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 140: if nvl(p_type_cd,hr_api.g_varchar2)

136: fnd_message.set_name('BEN','BEN_91449_ACTN_TYP_CHG');
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',

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

165: and p_type_cd is not null then
166: --
167: -- check if value of lookup falls within lookup type.
168: --
169: if hr_api.not_exists_in_hr_lookups
170: (p_lookup_type => 'BEN_ACTN_TYP',
171: p_lookup_code => p_type_cd,
172: p_effective_date => p_effective_date) then
173: --

Line 188: and nvl(p_type_cd,hr_api.g_varchar2)

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

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 251: and p_actn_typ_id <> nvl(p_actn_typ_id, hr_api.g_number)

247: cursor c1 is
248: select null
249: from ben_actn_typ
250: where name = p_name
251: and p_actn_typ_id <> nvl(p_actn_typ_id, hr_api.g_number)
252: and business_group_id + 0 = p_business_group_id;
253: --
254: Begin
255: --

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

370: --
371: -- Call all supporting business operations
372: --
373: --
374: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
375: --
376: chk_actn_typ_id
377: (p_actn_typ_id => p_rec.actn_typ_id,
378: p_object_version_number => p_rec.object_version_number);

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

391: p_business_group_id => p_rec.business_group_id,
392: p_object_version_number => p_rec.object_version_number);
393:
394: --
395: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: End insert_validate;
399: --

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

410: --
411: -- Call all supporting business operations
412: --
413: --
414: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
415: --
416: chk_actn_typ_id
417: (p_actn_typ_id => p_rec.actn_typ_id,
418: p_object_version_number => p_rec.object_version_number);

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

481: hr_utility.set_location('Entering:'|| l_proc, 10);
482: --
483: -- Ensure that all the mandatory parameter are not null
484: --
485: hr_api.mandatory_arg_error(p_api_name => l_proc,
486: p_argument => 'actn_typ_id',
487: p_argument_value => p_actn_typ_id);
488: --
489: open csr_leg_code;