APPS.IRC_IRF_SHD dependencies on IRC_REFERRAL_INFO

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

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

96: ,irf_information10
97: ,object_created_by
98: ,created_by
99: ,object_version_number
100: from irc_referral_info
101: where referral_info_id = p_referral_info_id;
102: --
103: l_fct_ret boolean;
104: --

Line 183: update irc_referral_info t

179: --
180: -- Update the specified datetrack row setting the effective
181: -- end date to the specified new effective end date.
182: --
183: update irc_referral_info t
184: set t.end_date = p_new_end_date
185: , t.object_version_number = l_object_version_number
186: where t.referral_info_id = p_referral_info_id
187: and p_effective_date

Line 263: from irc_referral_info

259: ,irf_information10
260: ,object_created_by
261: ,created_by
262: ,object_version_number
263: from irc_referral_info
264: where referral_info_id = p_referral_info_id
265: and sysdate between start_date and end_date
266: for update nowait;
267: --

Line 353: fnd_message.set_token('TABLE_NAME', 'irc_referral_info');

349: -- The object is locked therefore we need to supply a meaningful
350: -- error message.
351: --
352: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
353: fnd_message.set_token('TABLE_NAME', 'irc_referral_info');
354: fnd_message.raise_error;
355: End lck;
356: --
357: -- ----------------------------------------------------------------------------

Line 481: from irc_referral_info t

477: -- get the next ovn
478: --
479: select nvl(max(t.object_version_number),0) + 1
480: into l_ovn
481: from irc_referral_info t
482: where t.referral_info_id = p_referral_info_id;
483: --
484: -- Return the new object_version_number.
485: --