APPS.PAY_ESU_SHD dependencies on PAY_ELEMENT_SPAN_USAGES

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

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

Line 26: ElsIf (p_constraint_name = 'PAY_ELEMENT_SPAN_USAGES_UK1') 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 = 'PAY_ELEMENT_SPAN_USAGES_UK1') 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 62: from pay_element_span_usages

58: ,retro_component_usage_id
59: ,adjustment_type
60: ,retro_element_type_id
61: ,object_version_number
62: from pay_element_span_usages
63: where element_span_usage_id = p_element_span_usage_id;
64: --
65: l_fct_ret boolean;
66: --

Line 135: from pay_element_span_usages

131: ,retro_component_usage_id
132: ,adjustment_type
133: ,retro_element_type_id
134: ,object_version_number
135: from pay_element_span_usages
136: where element_span_usage_id = p_element_span_usage_id
137: for update nowait;
138: --
139: l_proc varchar2(72) := g_package||'lck';

Line 184: fnd_message.set_token('TABLE_NAME', 'pay_element_span_usages');

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