APPS.HR_WPT_SHD dependencies on HR_WINDOW_PROPERTIES_TL

Line 21: If (p_constraint_name = 'HR_WINDOW_PROPERTIES_TL_FK1') Then

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

Line 26: ElsIf (p_constraint_name = 'HR_WINDOW_PROPERTIES_TL_PK') Then

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

Line 57: from hr_window_properties_tl

53: window_property_id
54: ,language
55: ,source_lang
56: ,title
57: from hr_window_properties_tl
58: where window_property_id = p_window_property_id
59: and language = p_language;
60: --
61: l_fct_ret boolean;

Line 123: from hr_window_properties_tl

119: window_property_id
120: ,language
121: ,source_lang
122: ,title
123: from hr_window_properties_tl
124: where window_property_id = p_window_property_id
125: and language = p_language
126: for update nowait;
127: --

Line 169: fnd_message.set_token('TABLE_NAME', 'hr_window_properties_tl');

165: -- The object is locked therefore we need to supply a meaningful
166: -- error message.
167: --
168: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
169: fnd_message.set_token('TABLE_NAME', 'hr_window_properties_tl');
170: fnd_message.raise_error;
171: End lck;
172: --
173: -- ----------------------------------------------------------------------------

Line 182: from hr_window_properties_tl wpt

178: cursor csr_window_properties is
179: select wpt.window_property_id
180: ,wpt.title
181: ,wpt.source_lang
182: from hr_window_properties_tl wpt
183: where wpt.language = userenv('LANG');
184: --
185: Begin
186: --

Line 187: delete from hr_window_properties_tl t

183: where wpt.language = userenv('LANG');
184: --
185: Begin
186: --
187: delete from hr_window_properties_tl t
188: where not exists
189: ( select null
190: from hr_window_properties_b b
191: where b.window_property_id = t.window_property_id

Line 194: update hr_window_properties_tl t

190: from hr_window_properties_b b
191: where b.window_property_id = t.window_property_id
192: );
193:
194: update hr_window_properties_tl t
195: set ( title ) =
196: ( select b.title
197: from hr_window_properties_tl b
198: where b.window_property_id = t.window_property_id

Line 197: from hr_window_properties_tl b

193:
194: update hr_window_properties_tl t
195: set ( title ) =
196: ( select b.title
197: from hr_window_properties_tl b
198: where b.window_property_id = t.window_property_id
199: and b.language = t.source_lang )
200: where ( t.window_property_id,
201: t.language

Line 205: from hr_window_properties_tl subb, hr_window_properties_tl subt

201: t.language
202: ) in
203: ( select subt.window_property_id,
204: subt.language
205: from hr_window_properties_tl subb, hr_window_properties_tl subt
206: where subb.window_property_id = subt.window_property_id
207: and subb.language = subt.source_lang
208: and ( subb.title <> subt.title
209: or (subb.title is null and subt.title is not null)