APPS.HXC_ULT_SHD dependencies on HXC_LAYOUTS

Line 23: If (p_constraint_name = 'HXC_LAYOUTS_TL_FK1') Then

19: --
20: Begin
21: --
22:
23: If (p_constraint_name = 'HXC_LAYOUTS_TL_FK1') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;

Line 28: ElsIf (p_constraint_name = 'HXC_LAYOUTS_TL_PK') Then

24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: ElsIf (p_constraint_name = 'HXC_LAYOUTS_TL_PK') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;

Line 33: ElsIf (p_constraint_name = 'HXC_LAYOUTS_TL_UK1') Then

29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LAYOUTS_TL_UK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;

Line 64: from hxc_layouts_tl

60: layout_id
61: ,display_layout_name
62: ,language
63: ,source_lang
64: from hxc_layouts_tl
65: where layout_id = p_layout_id
66: AND language = p_language;
67: --
68: l_fct_ret boolean;

Line 127: from hxc_layouts_tl

123: layout_id
124: ,display_layout_name
125: ,language
126: ,source_lang
127: from hxc_layouts_tl
128: WHERE layout_id = p_layout_id
129: AND language = p_language
130: for update nowait;
131: --

Line 181: fnd_message.set_token('TABLE_NAME', 'hxc_layouts_tl');

177: -- The object is locked therefore we need to supply a meaningful
178: -- error message.
179: --
180: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
181: fnd_message.set_token('TABLE_NAME', 'hxc_layouts_tl');
182: fnd_message.raise_error;
183: End lck;
184: --
185: -- ----------------------------------------------------------------------------

Line 198: delete from hxc_layouts_tl t

194: -- ----------------------------------------------------------------------------
195: PROCEDURE add_language IS
196: Begin
197: --
198: delete from hxc_layouts_tl t
199: where not exists
200: (select null
201: from hxc_layouts b
202: where b.layout_id = t.layout_id

Line 201: from hxc_layouts b

197: --
198: delete from hxc_layouts_tl t
199: where not exists
200: (select null
201: from hxc_layouts b
202: where b.layout_id = t.layout_id
203: );
204: --
205: update hxc_layouts_tl t

Line 205: update hxc_layouts_tl t

201: from hxc_layouts b
202: where b.layout_id = t.layout_id
203: );
204: --
205: update hxc_layouts_tl t
206: set (display_layout_name) =
207: (select b.display_layout_name
208: from hxc_layouts_tl b
209: where b.layout_id = t.layout_id

Line 208: from hxc_layouts_tl b

204: --
205: update hxc_layouts_tl t
206: set (display_layout_name) =
207: (select b.display_layout_name
208: from hxc_layouts_tl b
209: where b.layout_id = t.layout_id
210: and b.language = t.source_lang)
211: where (t.layout_id
212: ,t.language)

Line 215: from hxc_layouts_tl subb

211: where (t.layout_id
212: ,t.language)
213: in (select subt.layout_id
214: ,subt.language
215: from hxc_layouts_tl subb
216: ,hxc_layouts_tl subt
217: where subb.layout_id = subt.layout_id
218: and subb.language = subt.source_lang
219: and subb.display_layout_name <> subt.display_layout_name

Line 216: ,hxc_layouts_tl subt

212: ,t.language)
213: in (select subt.layout_id
214: ,subt.language
215: from hxc_layouts_tl subb
216: ,hxc_layouts_tl subt
217: where subb.layout_id = subt.layout_id
218: and subb.language = subt.source_lang
219: and subb.display_layout_name <> subt.display_layout_name
220: );

Line 222: insert into hxc_layouts_tl

218: and subb.language = subt.source_lang
219: and subb.display_layout_name <> subt.display_layout_name
220: );
221: --
222: insert into hxc_layouts_tl
223: (layout_id
224: ,display_layout_name
225: ,language
226: ,source_lang

Line 242: from hxc_layouts_tl b

238: ,b.last_updated_by
239: ,b.last_update_login
240: ,b.created_by
241: ,b.creation_date
242: from hxc_layouts_tl b
243: ,fnd_languages l
244: where l.installed_flag in ('I', 'B')
245: and b.language = userenv('LANG')
246: and not exists

Line 248: from hxc_layouts_tl t

244: where l.installed_flag in ('I', 'B')
245: and b.language = userenv('LANG')
246: and not exists
247: (select null
248: from hxc_layouts_tl t
249: where t.layout_id = b.layout_id
250: and t.language = l.language_code
251: );
252: --