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_IPT_SHD dependencies on IRC_POSTING_CONTENTS

Line 21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 63: from irc_posting_contents_tl

59: ,how_to_apply
60: ,benefit_info
61: ,image_url
62: ,image_url_alt
63: from irc_posting_contents_tl
64: where posting_content_id = p_posting_content_id
65: and language = p_language;
66: --
67: l_fct_ret boolean;

Line 166: from irc_posting_contents_tl

162: ,how_to_apply
163: ,benefit_info
164: ,image_url
165: ,image_url_alt
166: from irc_posting_contents_tl
167: where posting_content_id = p_posting_content_id
168: and language = p_language
169: for update nowait;
170: --

Line 239: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents_tl');

235: -- The object is locked therefore we need to supply a meaningful
236: -- error message.
237: --
238: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
239: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents_tl');
240: fnd_message.raise_error;
241: End lck;
242: --
243: -- ----------------------------------------------------------------------------

Line 249: delete from IRC_POSTING_CONTENTS_TL T

245: -- ----------------------------------------------------------------------------
246: procedure add_language
247: is
248: begin
249: delete from IRC_POSTING_CONTENTS_TL T
250: where not exists
251: (select NULL
252: from IRC_POSTING_CONTENTS B
253: where B.POSTING_CONTENT_ID = T.POSTING_CONTENT_ID

Line 252: from IRC_POSTING_CONTENTS B

248: begin
249: delete from IRC_POSTING_CONTENTS_TL T
250: where not exists
251: (select NULL
252: from IRC_POSTING_CONTENTS B
253: where B.POSTING_CONTENT_ID = T.POSTING_CONTENT_ID
254: );
255: update IRC_POSTING_CONTENTS_TL T set (
256: NAME,

Line 255: update IRC_POSTING_CONTENTS_TL T set (

251: (select NULL
252: from IRC_POSTING_CONTENTS B
253: where B.POSTING_CONTENT_ID = T.POSTING_CONTENT_ID
254: );
255: update IRC_POSTING_CONTENTS_TL T set (
256: NAME,
257: ORG_NAME,
258: ORG_DESCRIPTION,
259: JOB_TITLE,

Line 281: from IRC_POSTING_CONTENTS_TL B

277: B.HOW_TO_APPLY,
278: B.BENEFIT_INFO,
279: B.IMAGE_URL,
280: B.IMAGE_URL_ALT
281: from IRC_POSTING_CONTENTS_TL B
282: where B.POSTING_CONTENT_ID = T.POSTING_CONTENT_ID
283: and B.LANGUAGE = T.SOURCE_LANGUAGE)
284: where (
285: T.POSTING_CONTENT_ID,

Line 290: from IRC_POSTING_CONTENTS_TL SUBB, IRC_POSTING_CONTENTS_TL SUBT

286: T.LANGUAGE
287: ) in (select
288: SUBT.POSTING_CONTENT_ID,
289: SUBT.LANGUAGE
290: from IRC_POSTING_CONTENTS_TL SUBB, IRC_POSTING_CONTENTS_TL SUBT
291: where SUBB.POSTING_CONTENT_ID = SUBT.POSTING_CONTENT_ID
292: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
293: and (SUBB.NAME <> SUBT.NAME
294: or SUBB.ORG_NAME <> SUBT.ORG_NAME

Line 338: insert into IRC_POSTING_CONTENTS_TL (

334: or dbms_lob.compare(SUBB.IMAGE_URL_ALT , SUBT.IMAGE_URL_ALT) = 0
335: or (SUBB.IMAGE_URL_ALT is null and SUBT.IMAGE_URL_ALT is not null)
336: or (SUBB.IMAGE_URL_ALT is not null and SUBT.IMAGE_URL_ALT is null)
337: ));
338: insert into IRC_POSTING_CONTENTS_TL (
339: POSTING_CONTENT_ID,
340: SOURCE_LANGUAGE,
341: NAME,
342: ORG_NAME,

Line 370: from IRC_POSTING_CONTENTS_TL B, FND_LANGUAGES L

366: B.BENEFIT_INFO,
367: B.IMAGE_URL,
368: B.IMAGE_URL_ALT,
369: L.LANGUAGE_CODE
370: from IRC_POSTING_CONTENTS_TL B, FND_LANGUAGES L
371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL

Line 375: from IRC_POSTING_CONTENTS_TL T

371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL
375: from IRC_POSTING_CONTENTS_TL T
376: where T.POSTING_CONTENT_ID = B.POSTING_CONTENT_ID
377: and T.LANGUAGE = L.LANGUAGE_CODE);
378: end add_language;
379: -- ----------------------------------------------------------------------------

Line 449: from irc_posting_contents_tl

445: ,how_to_apply
446: ,benefit_info
447: ,image_url
448: ,image_url_alt
449: from irc_posting_contents_tl
450: where posting_content_id = p_rec.posting_content_id
451: and language = p_rec.language;
452: --
453: l_org_description irc_posting_contents_tl.org_description%type;

Line 453: l_org_description irc_posting_contents_tl.org_description%type;

449: from irc_posting_contents_tl
450: where posting_content_id = p_rec.posting_content_id
451: and language = p_rec.language;
452: --
453: l_org_description irc_posting_contents_tl.org_description%type;
454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;

Line 454: l_brief_description irc_posting_contents_tl.brief_description%type;

450: where posting_content_id = p_rec.posting_content_id
451: and language = p_rec.language;
452: --
453: l_org_description irc_posting_contents_tl.org_description%type;
454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;

Line 455: l_detailed_description irc_posting_contents_tl.detailed_description%type;

451: and language = p_rec.language;
452: --
453: l_org_description irc_posting_contents_tl.org_description%type;
454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;

Line 456: l_job_requirements irc_posting_contents_tl.job_requirements%type;

452: --
453: l_org_description irc_posting_contents_tl.org_description%type;
454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;

Line 457: l_additional_details irc_posting_contents_tl.additional_details%type;

453: l_org_description irc_posting_contents_tl.org_description%type;
454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;
461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;

Line 458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;

454: l_brief_description irc_posting_contents_tl.brief_description%type;
455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;
461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;
462: --

Line 459: l_benefit_info irc_posting_contents_tl.benefit_info%type;

455: l_detailed_description irc_posting_contents_tl.detailed_description%type;
456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;
461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;
462: --
463: l_api_updating boolean;

Line 460: l_image_url irc_posting_contents_tl.image_url%type;

456: l_job_requirements irc_posting_contents_tl.job_requirements%type;
457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;
461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;
462: --
463: l_api_updating boolean;
464: --

Line 461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;

457: l_additional_details irc_posting_contents_tl.additional_details%type;
458: l_how_to_apply irc_posting_contents_tl.how_to_apply%type;
459: l_benefit_info irc_posting_contents_tl.benefit_info%type;
460: l_image_url irc_posting_contents_tl.image_url%type;
461: l_image_url_alt irc_posting_contents_tl.image_url_alt%type;
462: --
463: l_api_updating boolean;
464: --
465: Begin