APPS.PER_NAA_SHD dependencies on PER_NL_ABSENCE_ACTIONS

Line 32: If (p_constraint_name = 'PER_NL_ABSENCE_ACTIONS_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_NL_ABSENCE_ACTIONS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 73: from per_nl_absence_actions

69: ,document_file_name
70: ,last_updated_by
71: ,object_version_number
72: ,enabled
73: from per_nl_absence_actions
74: where absence_action_id = p_absence_action_id;
75: --
76: l_fct_ret boolean;
77: --

Line 153: from per_nl_absence_actions

149: ,document_file_name
150: ,last_updated_by
151: ,object_version_number
152: ,enabled
153: from per_nl_absence_actions
154: where absence_action_id = p_absence_action_id
155: for update nowait;
156: --
157: l_proc varchar2(72) := g_package||'lck';

Line 202: fnd_message.set_token('TABLE_NAME', 'per_nl_absence_actions');

198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'per_nl_absence_actions');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------