APPS.IRC_NOTIFICATION_DATA_PKG dependencies on FND_DFLEX

Line 364: l_flexfield fnd_dflex.dflex_r;

360: and (pe.type is null or hlk1.lookup_type = 'IRC_INTERVIEW_TYPE')
361: and ft.TIMEZONE_CODE(+) = loc.TIMEZONE_CODE;
362: l_interviewDetails varchar2(10000);
363: l_func varchar2(50) := 'getInterviewDetails';
364: l_flexfield fnd_dflex.dflex_r;
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;

Line 365: l_flexinfo fnd_dflex.dflex_dr;

361: and ft.TIMEZONE_CODE(+) = loc.TIMEZONE_CODE;
362: l_interviewDetails varchar2(10000);
363: l_func varchar2(50) := 'getInterviewDetails';
364: l_flexfield fnd_dflex.dflex_r;
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;

Line 368: segments fnd_dflex.segments_dr;

364: l_flexfield fnd_dflex.dflex_r;
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);

Line 388: fnd_dflex.get_flexfield(appl_short_name => p_appl_short_name,

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,
391: flexinfo => l_flexinfo);
392: l_table_name := l_flexinfo.table_name;

Line 393: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield => l_flexfield,

389: flexfield_name => p_flexfield_name,
390: flexfield => l_flexfield,
391: flexinfo => l_flexinfo);
392: l_table_name := l_flexinfo.table_name;
393: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield => l_flexfield,
394: context_code => loc_rec.style),
395: segments,
396: TRUE);
397: