APPS.HR_TIS_SHD dependencies on HR_KI_TOPIC_INTEGRATIONS

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

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

73: ,param_value9
74: ,param_name10
75: ,param_value10
76: ,object_version_number
77: from hr_ki_topic_integrations
78: where topic_integrations_id = p_topic_integrations_id;
79: --
80: l_fct_ret boolean;
81: --

Line 162: from hr_ki_topic_integrations

158: ,param_value9
159: ,param_name10
160: ,param_value10
161: ,object_version_number
162: from hr_ki_topic_integrations
163: where topic_integrations_id = p_topic_integrations_id
164: for update nowait;
165: --
166: l_proc varchar2(72) := g_package||'lck';

Line 210: fnd_message.set_token('TABLE_NAME', 'hr_ki_topic_integrations');

206: -- The object is locked therefore we need to supply a meaningful
207: -- error message.
208: --
209: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
210: fnd_message.set_token('TABLE_NAME', 'hr_ki_topic_integrations');
211: fnd_message.raise_error;
212: End lck;
213: --
214: -- ----------------------------------------------------------------------------