[Home] [Help]
86: -- Cursor to select 'old' created AOL who column values
87: --
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from irc_referral_info t
91: where t.referral_info_id = p_rec.referral_info_id
92: and t.start_date =
93: irc_irf_shd.g_old_rec.start_date
94: and t.end_date = p_validation_start_date;
94: and t.end_date = p_validation_start_date;
95: --
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_creation_date irc_referral_info.creation_date%TYPE;
99: l_current_user_id integer;
100: l_temp_count integer;
101: --
102: Begin
147: End If;
148: --
149: --
150: --
151: -- Insert the row into: irc_referral_info
152: --
153: insert into irc_referral_info
154: (referral_info_id
155: ,object_id
149: --
150: --
151: -- Insert the row into: irc_referral_info
152: --
153: insert into irc_referral_info
154: (referral_info_id
155: ,object_id
156: ,object_type
157: ,start_date
337: ,p_validation_start_date in date
338: ,p_validation_end_date in date
339: ) is
340: --
341: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
342: --
343: Cursor C_Sel2 is
344: Select null
345: from irc_referral_info
341: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
342: --
343: Cursor C_Sel2 is
344: Select null
345: from irc_referral_info
346: where object_id = p_rec.object_id
347: and object_type = p_rec.object_type
348: and p_effective_date between start_date
349: and end_date;
364: --
365: -- The primary key values are already in use.
366: --
367: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
368: fnd_message.set_token('TABLE_NAME','irc_referral_info');
369: fnd_message.raise_error;
370: End If;
371: Close C_Sel2;
372: If (irc_irf_ins.g_referral_info_id_i is not null) Then
493: --
494: when hr_api.cannot_find_prog_unit then
495: --
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'IRC_REFERRAL_INFO'
498: ,p_hook_type => 'AI');
499: --
500: end;
501: --