APPS.BEN_EAT_BUS dependencies on BEN_ACTN_TYP

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 110: FROM ben_actn_typ

106: p_object_version_number in number) is
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;

Line 170: (p_lookup_type => 'BEN_ACTN_TYP',

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: --
174: -- raise error as does not exist as lookup

Line 178: fnd_message.set_token('TYPE','BEN_ACTN_TYP');

174: -- raise error as does not exist as lookup
175: --
176: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
177: fnd_message.set_token('FIELD','p_type_cd');
178: fnd_message.set_token('TYPE','BEN_ACTN_TYP');
179: fnd_message.raise_error;
180: --
181: end if;
182: --

Line 249: from ben_actn_typ

245: l_dummy varchar2(1);
246: --
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: --

Line 325: from ben_actn_typ

321: l_type_cd varchar2(30);
322: --
323: cursor c_type_cd is
324: select type_cd
325: from ben_actn_typ
326: where actn_typ_id = p_actn_typ_id;
327: --
328: Begin
329: --

Line 470: ben_actn_typ b

466: --
467: cursor csr_leg_code is
468: select a.legislation_code
469: from per_business_groups a,
470: ben_actn_typ b
471: where b.actn_typ_id = p_actn_typ_id
472: and a.business_group_id = b.business_group_id;
473: --
474: -- Declare local variables