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_NOTIFICATION_DATA_PKG dependencies on HR_LOCATIONS_ALL

Line 345: ,hr_locations_all loc

341: || ';',
342: pe.location_id
343: from per_events pe
344: ,irc_interview_details iid
345: ,hr_locations_all loc
346: ,per_all_people_f ppf
347: ,hr_lookups hlk
348: ,hr_lookups hlk1
349: ,fnd_timezones_vl ft

Line 369: l_location_id hr_locations_all.location_id%Type;

365: l_flexinfo fnd_dflex.dflex_dr;
366: p_appl_short_name varchar2(10) := 'PER';
367: p_flexfield_name varchar2(50) :='Address Location';
368: segments fnd_dflex.segments_dr;
369: l_location_id hr_locations_all.location_id%Type;
370: loc_rec hr_locations_all%rowtype;
371: v_segment_name varchar2(100);
372: v_message varchar2(1000);
373: v_message1 varchar2(1000);

Line 370: loc_rec hr_locations_all%rowtype;

366: p_appl_short_name varchar2(10) := 'PER';
367: p_flexfield_name varchar2(50) :='Address Location';
368: segments fnd_dflex.segments_dr;
369: l_location_id hr_locations_all.location_id%Type;
370: loc_rec hr_locations_all%rowtype;
371: v_segment_name varchar2(100);
372: v_message varchar2(1000);
373: v_message1 varchar2(1000);
374: v_segment_name1 varchar2(100);

Line 386: select * into loc_rec from hr_locations_all

382: open csrInterviewDetails(p_interviewId, p_effectiveDate);
383: fetch csrInterviewDetails into l_interviewDetails,l_location_id;
384: close csrInterviewDetails;
385:
386: select * into loc_rec from hr_locations_all
387: where location_id=l_location_id;
388: fnd_dflex.get_flexfield(appl_short_name => p_appl_short_name,
389: flexfield_name => p_flexfield_name,
390: flexfield => l_flexfield,