APPS.IRC_IID_SHD dependencies on IRC_INTERVIEW_DETAILS

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

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

84: ,end_date
85: ,event_id
86: ,object_version_number
87: ,created_by
88: from irc_interview_details
89: where interview_details_id = p_interview_details_id;
90: --
91: l_fct_ret boolean;
92: --

Line 171: update irc_interview_details t

167: --
168: -- Update the specified datetrack row setting the effective
169: -- end date to the specified new effective end date.
170: --
171: update irc_interview_details t
172: set t.end_date = p_new_end_date
173: , t.object_version_number = l_object_version_number
174: where t.interview_details_id = p_interview_details_id
175: and p_effective_date

Line 239: from irc_interview_details

235: ,end_date
236: ,event_id
237: ,object_version_number
238: ,created_by
239: from irc_interview_details
240: where interview_details_id = p_interview_details_id
241: and sysdate between start_date and end_date
242: for update nowait;
243: --

Line 329: fnd_message.set_token('TABLE_NAME', 'irc_interview_details');

325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
329: fnd_message.set_token('TABLE_NAME', 'irc_interview_details');
330: fnd_message.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------

Line 433: from irc_interview_details t

429: -- get the next ovn
430: --
431: select nvl(max(t.object_version_number),0) + 1
432: into l_ovn
433: from irc_interview_details t
434: where t.interview_details_id = p_interview_details_id;
435: --
436: -- Return the new object_version_number.
437: --