APPS.BEN_EAT_SHD dependencies on BEN_ACTN_TYP

Line 36: If (p_constraint_name = 'BEN_ACTN_TYP_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTN_TYP_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;

Line 108: from ben_actn_typ

104: eat_attribute28,
105: eat_attribute29,
106: eat_attribute30,
107: object_version_number
108: from ben_actn_typ
109: where actn_typ_id = p_actn_typ_id;
110: --
111: l_proc varchar2(72) := g_package||'api_updating';
112: l_fct_ret boolean;

Line 214: from ben_actn_typ

210: eat_attribute28,
211: eat_attribute29,
212: eat_attribute30,
213: object_version_number
214: from ben_actn_typ
215: where actn_typ_id = p_actn_typ_id
216: for update nowait;
217: --
218: l_proc varchar2(72) := g_package||'lck';

Line 257: hr_utility.set_message_token('TABLE_NAME', 'ben_actn_typ');

253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
257: hr_utility.set_message_token('TABLE_NAME', 'ben_actn_typ');
258: hr_utility.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------

Line 366: delete from ben_actn_typ_tl t

362: -- ----------------------------------------------------------------------------
363: Procedure add_language
364: is
365: begin
366: delete from ben_actn_typ_tl t
367: where not exists
368: (select null
369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id

Line 369: from ben_actn_typ_tl b

365: begin
366: delete from ben_actn_typ_tl t
367: where not exists
368: (select null
369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id
371: );
372:
373: update ben_actn_typ_tl t set (

Line 373: update ben_actn_typ_tl t set (

369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id
371: );
372:
373: update ben_actn_typ_tl t set (
374: name,
375: description,
376: type_cd
377: ) = (select

Line 381: from ben_actn_typ_tl b

377: ) = (select
378: b.name,
379: b.description,
380: b.type_cd
381: from ben_actn_typ_tl b
382: where b.actn_typ_id = t.actn_typ_id
383: and b.language = t.source_lang)
384: where (
385: t.actn_typ_id,

Line 390: from ben_actn_typ_tl subb, ben_actn_typ_tl subt

386: t.language
387: ) in (select
388: subt.actn_typ_id,
389: subt.language
390: from ben_actn_typ_tl subb, ben_actn_typ_tl subt
391: where subb.actn_typ_id = subt.actn_typ_id
392: and subb.language = subt.source_lang
393: and (subb.name <> subt.name
394: or subb.description <> subt.description

Line 397: insert into ben_actn_typ_tl (

393: and (subb.name <> subt.name
394: or subb.description <> subt.description
395: or subb.type_cd <> subt.type_cd
396: ));
397: insert into ben_actn_typ_tl (
398: actn_typ_id,
399: name,
400: description,
401: language,

Line 421: from ben_actn_typ_tl b, fnd_languages l

417: b.last_updated_by,
418: b.last_update_login,
419: b.created_by,
420: b.creation_date
421: from ben_actn_typ_tl b, fnd_languages l
422: where l.installed_flag in ('I', 'B')
423: and b.language = userenv('LANG')
424: and not exists
425: (select null

Line 426: from ben_actn_typ_tl t

422: where l.installed_flag in ('I', 'B')
423: and b.language = userenv('LANG')
424: and not exists
425: (select null
426: from ben_actn_typ_tl t
427: where t.actn_typ_id = b.actn_typ_id
428: and t.language = l.language_code);
429: end add_language;
430: --