APPS.IRC_IDT_SHD dependencies on IRC_DEFAULT_POSTINGS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_DEFAULT_POSTINGS_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 69: from irc_default_postings_tl

65: ,image_url
66: ,''
67: ,image_url_alt
68: ,''
69: from irc_default_postings_tl
70: where default_posting_id = p_default_posting_id
71: and language = p_language;
72: --
73: l_fct_ret boolean;

Line 168: from irc_default_postings_tl

164: ,image_url
165: ,''
166: ,image_url_alt
167: ,''
168: from irc_default_postings_tl
169: where default_posting_id = p_default_posting_id
170: and language = p_language
171: for update nowait;
172: --

Line 230: fnd_message.set_token('TABLE_NAME', 'irc_default_postings_tl');

226: -- The object is locked therefore we need to supply a meaningful
227: -- error message.
228: --
229: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
230: fnd_message.set_token('TABLE_NAME', 'irc_default_postings_tl');
231: fnd_message.raise_error;
232: End lck;
233: --
234: -- ----------------------------------------------------------------------------

Line 240: delete from IRC_DEFAULT_POSTINGS_TL T

236: -- ----------------------------------------------------------------------------
237: --
238: Procedure add_language is
239: begin
240: delete from IRC_DEFAULT_POSTINGS_TL T
241: where not exists
242: (select NULL
243: from IRC_DEFAULT_POSTINGS B
244: where B.DEFAULT_POSTING_ID = T.DEFAULT_POSTING_ID

Line 243: from IRC_DEFAULT_POSTINGS B

239: begin
240: delete from IRC_DEFAULT_POSTINGS_TL T
241: where not exists
242: (select NULL
243: from IRC_DEFAULT_POSTINGS B
244: where B.DEFAULT_POSTING_ID = T.DEFAULT_POSTING_ID
245: );
246:
247: update IRC_DEFAULT_POSTINGS_TL T set (

Line 247: update IRC_DEFAULT_POSTINGS_TL T set (

243: from IRC_DEFAULT_POSTINGS B
244: where B.DEFAULT_POSTING_ID = T.DEFAULT_POSTING_ID
245: );
246:
247: update IRC_DEFAULT_POSTINGS_TL T set (
248: ORG_NAME,
249: ORG_DESCRIPTION,
250: JOB_TITLE,
251: BRIEF_DESCRIPTION,

Line 265: from IRC_DEFAULT_POSTINGS_TL B

261: B.DETAILED_DESCRIPTION,
262: B.JOB_REQUIREMENTS,
263: B.ADDITIONAL_DETAILS,
264: B.HOW_TO_APPLY
265: from IRC_DEFAULT_POSTINGS_TL B
266: where B.DEFAULT_POSTING_ID = T.DEFAULT_POSTING_ID
267: and B.LANGUAGE = T.SOURCE_LANGUAGE)
268: where (
269: T.DEFAULT_POSTING_ID,

Line 274: from IRC_DEFAULT_POSTINGS_TL SUBB, IRC_DEFAULT_POSTINGS_TL SUBT

270: T.LANGUAGE
271: ) in (select
272: SUBT.DEFAULT_POSTING_ID,
273: SUBT.LANGUAGE
274: from IRC_DEFAULT_POSTINGS_TL SUBB, IRC_DEFAULT_POSTINGS_TL SUBT
275: where SUBB.DEFAULT_POSTING_ID = SUBT.DEFAULT_POSTING_ID
276: and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
277: and (SUBB.ORG_NAME <> SUBT.ORG_NAME
278: or (SUBB.ORG_NAME is null and SUBT.ORG_NAME is not null)

Line 303: insert into IRC_DEFAULT_POSTINGS_TL (

299: or (SUBB.HOW_TO_APPLY is null and SUBT.HOW_TO_APPLY is not null)
300: or (SUBB.HOW_TO_APPLY is not null and SUBT.HOW_TO_APPLY is null)
301: ));
302:
303: insert into IRC_DEFAULT_POSTINGS_TL (
304: HOW_TO_APPLY,
305: IMAGE_URL,
306: IMAGE_URL_ALT,
307: SOURCE_LANGUAGE,

Line 331: from IRC_DEFAULT_POSTINGS_TL B, FND_LANGUAGES L

327: B.ORG_DESCRIPTION,
328: B.JOB_TITLE,
329: B.BRIEF_DESCRIPTION,
330: L.LANGUAGE_CODE
331: from IRC_DEFAULT_POSTINGS_TL B, FND_LANGUAGES L
332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL

Line 336: from IRC_DEFAULT_POSTINGS_TL T

332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL
336: from IRC_DEFAULT_POSTINGS_TL T
337: where T.DEFAULT_POSTING_ID = B.DEFAULT_POSTING_ID
338: and T.LANGUAGE = L.LANGUAGE_CODE);
339: end ADD_LANGUAGE;
340:

Line 408: from irc_default_postings_tl

404: ,additional_details
405: ,how_to_apply
406: ,image_url
407: ,image_url_alt
408: from irc_default_postings_tl
409: where default_posting_id = p_rec.default_posting_id
410: and language = p_rec.language;
411: --
412: l_org_description clob;