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.HXC_DTL_SHD dependencies on HXC_ALIAS_DEFINITIONS

Line 22: If (p_constraint_name = 'HXC_ALIAS_DEFINITIONS_TL_PK') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_DEFINITIONS_TL_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 55: from hxc_alias_definitions_tl

51: ,description
52: ,prompt
53: ,language
54: ,source_lang
55: from hxc_alias_definitions_tl
56: where alias_definition_id = p_alias_definition_id
57: and language = p_language;
58: --
59: l_fct_ret boolean;

Line 123: from hxc_alias_definitions_tl

119: ,description
120: ,prompt
121: ,language
122: ,source_lang
123: from hxc_alias_definitions_tl
124: where alias_definition_id = p_alias_definition_id
125: and language = p_language
126: for update nowait;
127: --

Line 177: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions_tl');

173: -- The object is locked therefore we need to supply a meaningful
174: -- error message.
175: --
176: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
177: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions_tl');
178: fnd_message.raise_error;
179: End lck;
180: --
181: -- ----------------------------------------------------------------------------

Line 194: delete from hxc_alias_definitions_tl t

190: -- ----------------------------------------------------------------------------
191: PROCEDURE add_language IS
192: Begin
193: --
194: delete from hxc_alias_definitions_tl t
195: where not exists
196: (select null
197: from hxc_alias_definitions b
198: where b.alias_definition_id = t.alias_definition_id

Line 197: from hxc_alias_definitions b

193: --
194: delete from hxc_alias_definitions_tl t
195: where not exists
196: (select null
197: from hxc_alias_definitions b
198: where b.alias_definition_id = t.alias_definition_id
199: );
200: --
201: update hxc_alias_definitions_tl t

Line 201: update hxc_alias_definitions_tl t

197: from hxc_alias_definitions b
198: where b.alias_definition_id = t.alias_definition_id
199: );
200: --
201: update hxc_alias_definitions_tl t
202: set (alias_definition_name
203: ,description)
204: =
205: (select b.alias_definition_name

Line 207: from hxc_alias_definitions_tl b

203: ,description)
204: =
205: (select b.alias_definition_name
206: ,b.description
207: from hxc_alias_definitions_tl b
208: where b.alias_definition_id = t.alias_definition_id
209: and b.language = t.source_lang)
210: where (t.alias_definition_id
211: ,t.language)

Line 214: from hxc_alias_definitions_tl subb

210: where (t.alias_definition_id
211: ,t.language)
212: in (select subt.alias_definition_id
213: ,subt.language
214: from hxc_alias_definitions_tl subb
215: ,hxc_alias_definitions_tl subt
216: where subb.alias_definition_id = subt.alias_definition_id
217: and subb.language = subt.source_lang
218: and (subb.alias_definition_name <> subt.alias_definition_name

Line 215: ,hxc_alias_definitions_tl subt

211: ,t.language)
212: in (select subt.alias_definition_id
213: ,subt.language
214: from hxc_alias_definitions_tl subb
215: ,hxc_alias_definitions_tl subt
216: where subb.alias_definition_id = subt.alias_definition_id
217: and subb.language = subt.source_lang
218: and (subb.alias_definition_name <> subt.alias_definition_name
219: or subb.description <> subt.description

Line 225: insert into hxc_alias_definitions_tl

221: or (subb.description is not null and subt.description is null)
222: )
223: );
224: --
225: insert into hxc_alias_definitions_tl
226: (ALIAS_DEFINITION_ID
227: ,ALIAS_DEFINITION_NAME
228: ,DESCRIPTION
229: ,PROMPT

Line 249: from hxc_alias_definitions_tl b

245: ,b.last_updated_by
246: ,b.last_update_login
247: ,b.created_by
248: ,b.creation_date
249: from hxc_alias_definitions_tl b
250: ,fnd_languages l
251: where l.installed_flag in ('I', 'B')
252: and b.language = userenv('LANG')
253: and not exists

Line 255: from hxc_alias_definitions_tl t

251: where l.installed_flag in ('I', 'B')
252: and b.language = userenv('LANG')
253: and not exists
254: (select null
255: from hxc_alias_definitions_tl t
256: where t.alias_definition_id = b.alias_definition_id
257: and t.language = l.language_code
258: );
259: --