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_VACANCY_CONSIDERATIONS_API dependencies on IRC_POSTING_CONTENTS_TL

Line 92: , irc_posting_contents_tl pctl

88: , pctl.posting_content_id
89: , pctl.name
90: from per_recruitment_activity_for raf
91: , per_recruitment_activities ra
92: , irc_posting_contents_tl pctl
93: where raf.vacancy_id = p_vacancy_id
94: and raf.recruitment_activity_id = ra.recruitment_activity_id
95: and ra.posting_content_id = pctl.posting_content_id
96: and userenv('LANG') = pctl.language

Line 106: l_job_title irc_posting_contents_tl.job_title%type;

102: l_whole_url VARCHAR2(2000);
103: l_appl_first_name VARCHAR2(150);
104: l_recr_full_name VARCHAR2(150);
105: l_recr_job_name VARCHAR2(150);
106: l_job_title irc_posting_contents_tl.job_title%type;
107: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
108: l_posting_content_name irc_posting_contents_tl.name%type;
109: l_name VARCHAR2(240);
110: l_brief_description_v VARCHAR2(700) default '';

Line 107: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;

103: l_appl_first_name VARCHAR2(150);
104: l_recr_full_name VARCHAR2(150);
105: l_recr_job_name VARCHAR2(150);
106: l_job_title irc_posting_contents_tl.job_title%type;
107: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
108: l_posting_content_name irc_posting_contents_tl.name%type;
109: l_name VARCHAR2(240);
110: l_brief_description_v VARCHAR2(700) default '';
111: l_length NUMBER;

Line 108: l_posting_content_name irc_posting_contents_tl.name%type;

104: l_recr_full_name VARCHAR2(150);
105: l_recr_job_name VARCHAR2(150);
106: l_job_title irc_posting_contents_tl.job_title%type;
107: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
108: l_posting_content_name irc_posting_contents_tl.name%type;
109: l_name VARCHAR2(240);
110: l_brief_description_v VARCHAR2(700) default '';
111: l_length NUMBER;
112: l_user_name VARCHAR2(240) ;

Line 246: , irc_posting_contents_tl pctl

242: , pctl.posting_content_id
243: , pctl.name
244: from per_recruitment_activity_for raf
245: , per_recruitment_activities ra
246: , irc_posting_contents_tl pctl
247: where raf.vacancy_id = p_vacancy_id
248: and raf.recruitment_activity_id = ra.recruitment_activity_id
249: and ra.posting_content_id = pctl.posting_content_id
250: and userenv('LANG') = pctl.language

Line 260: l_job_title irc_posting_contents_tl.job_title%type;

256: l_whole_url VARCHAR2(2000);
257: l_appl_first_name VARCHAR2(150);
258: l_recr_full_name VARCHAR2(150);
259: l_recr_job_name VARCHAR2(150);
260: l_job_title irc_posting_contents_tl.job_title%type;
261: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
262: l_posting_content_name irc_posting_contents_tl.name%type;
263: l_name VARCHAR2(240);
264: l_brief_description_v VARCHAR2(700) default '';

Line 261: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;

257: l_appl_first_name VARCHAR2(150);
258: l_recr_full_name VARCHAR2(150);
259: l_recr_job_name VARCHAR2(150);
260: l_job_title irc_posting_contents_tl.job_title%type;
261: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
262: l_posting_content_name irc_posting_contents_tl.name%type;
263: l_name VARCHAR2(240);
264: l_brief_description_v VARCHAR2(700) default '';
265: l_length NUMBER;

Line 262: l_posting_content_name irc_posting_contents_tl.name%type;

258: l_recr_full_name VARCHAR2(150);
259: l_recr_job_name VARCHAR2(150);
260: l_job_title irc_posting_contents_tl.job_title%type;
261: l_posting_content_id irc_posting_contents_tl.posting_content_id%type;
262: l_posting_content_name irc_posting_contents_tl.name%type;
263: l_name VARCHAR2(240);
264: l_brief_description_v VARCHAR2(700) default '';
265: l_length NUMBER;
266: l_user_name VARCHAR2(240) ;

Line 383: , irc_posting_contents_tl pctl

379: cursor c_posting_details is
380: select null
381: from per_recruitment_activity_for raf
382: , per_recruitment_activities ra
383: , irc_posting_contents_tl pctl
384: where raf.vacancy_id = p_vacancy_id
385: and raf.recruitment_activity_id = ra.recruitment_activity_id
386: and ra.posting_content_id = pctl.posting_content_id
387: and userenv('LANG') = pctl.language