eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IID_INS dependencies on IRC_INTERVIEW_DETAILS

Line 90: from irc_interview_details t

86: -- Cursor to select 'old' created AOL who column values
87: --
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from irc_interview_details t
91: where t.interview_details_id = p_rec.interview_details_id
92: and t.start_date =
93: irc_iid_shd.g_old_rec.start_date
94: and t.end_date = p_validation_start_date;

Line 98: l_creation_date irc_interview_details.creation_date%TYPE;

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_interview_details.creation_date%TYPE;
99: l_current_user_id integer;
100: l_temp_count integer;
101: --
102: Begin

Line 151: -- Insert the row into: irc_interview_details

147: End If;
148: --
149: --
150: --
151: -- Insert the row into: irc_interview_details
152: --
153: insert into irc_interview_details
154: (interview_details_id
155: ,status

Line 153: insert into irc_interview_details

149: --
150: --
151: -- Insert the row into: irc_interview_details
152: --
153: insert into irc_interview_details
154: (interview_details_id
155: ,status
156: ,feedback
157: ,notes

Line 315: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;

311: ,p_validation_start_date in date
312: ,p_validation_end_date in date
313: ) is
314: --
315: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
316: --
317: Cursor C_Sel2 is
318: Select null
319: from irc_interview_details

Line 319: from irc_interview_details

315: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
316: --
317: Cursor C_Sel2 is
318: Select null
319: from irc_interview_details
320: where interview_details_id =
321: irc_iid_ins.g_interview_details_id_i
322: and p_effective_date between start_date
323: and end_date;

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

339: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','irc_interview_details');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
347: --

Line 458: (p_module_name => 'IRC_INTERVIEW_DETAILS'

454: --
455: when hr_api.cannot_find_prog_unit then
456: --
457: hr_api.cannot_find_prog_unit_error
458: (p_module_name => 'IRC_INTERVIEW_DETAILS'
459: ,p_hook_type => 'AI');
460: --
461: end;
462: --