APPS.HR_IPT_SHD dependencies on HR_ITEM_PROPERTIES_TL

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_ITEM_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_ITEM_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_ITEM_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 61: from hr_item_properties_tl

57: ,information_prompt
58: ,label
59: ,prompt_text
60: ,tooltip_text
61: from hr_item_properties_tl
62: where item_property_id = p_item_property_id
63: and language = p_language;
64: --
65: l_fct_ret boolean;

Line 131: from hr_item_properties_tl

127: ,information_prompt
128: ,label
129: ,prompt_text
130: ,tooltip_text
131: from hr_item_properties_tl
132: where item_property_id = p_item_property_id
133: and language = p_language
134: for update nowait;
135: --

Line 177: fnd_message.set_token('TABLE_NAME', 'hr_item_properties_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', 'hr_item_properties_tl');
178: fnd_message.raise_error;
179: End lck;
180: --
181: -- ----------------------------------------------------------------------------

Line 194: from hr_item_properties_tl ipt

190: ,ipt.label
191: ,ipt.prompt_text
192: ,ipt.tooltip_text
193: ,ipt.source_lang
194: from hr_item_properties_tl ipt
195: where ipt.language = userenv('LANG');
196: --
197: Begin
198: -- 115.8 after AOL recommendation the UPDATE and DELETE statements were removed