APPS.IRC_IRT_SHD dependencies on IRC_ALL_RECRUITING_SITES

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

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

52: ,redirection_url
53: ,''
54: ,posting_url
55: ,''
56: from irc_all_recruiting_sites_tl
57: where recruiting_site_id = p_recruiting_site_id
58: and language = p_language;
59: --
60: l_fct_ret boolean;

Line 130: from irc_all_recruiting_sites_tl

126: ,redirection_url
127: ,''
128: ,posting_url
129: ,''
130: from irc_all_recruiting_sites_tl
131: where recruiting_site_id = p_recruiting_site_id
132: and language = p_language
133: for update nowait;
134: --

Line 180: fnd_message.set_token('TABLE_NAME', 'irc_all_recruiting_sites_tl');

176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
180: fnd_message.set_token('TABLE_NAME', 'irc_all_recruiting_sites_tl');
181: fnd_message.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------

Line 190: delete from IRC_ALL_RECRUITING_SITES_TL T

186: -- ----------------------------------------------------------------------------
187: -- ----------------------------------------------------------------------------
188: PROCEDURE add_language IS
189: Begin
190: delete from IRC_ALL_RECRUITING_SITES_TL T
191: where not exists
192: (select NULL
193: from IRC_ALL_RECRUITING_SITES B
194: where B.RECRUITING_SITE_ID = T.RECRUITING_SITE_ID

Line 193: from IRC_ALL_RECRUITING_SITES B

189: Begin
190: delete from IRC_ALL_RECRUITING_SITES_TL T
191: where not exists
192: (select NULL
193: from IRC_ALL_RECRUITING_SITES B
194: where B.RECRUITING_SITE_ID = T.RECRUITING_SITE_ID
195: );
196:
197: update IRC_ALL_RECRUITING_SITES_TL T set (

Line 197: update IRC_ALL_RECRUITING_SITES_TL T set (

193: from IRC_ALL_RECRUITING_SITES B
194: where B.RECRUITING_SITE_ID = T.RECRUITING_SITE_ID
195: );
196:
197: update IRC_ALL_RECRUITING_SITES_TL T set (
198: SITE_NAME,
199: REDIRECTION_URL,
200: POSTING_URL
201: ) = (select

Line 205: from IRC_ALL_RECRUITING_SITES_TL B

201: ) = (select
202: B.SITE_NAME,
203: B.REDIRECTION_URL,
204: B.POSTING_URL
205: from IRC_ALL_RECRUITING_SITES_TL B
206: where B.RECRUITING_SITE_ID = T.RECRUITING_SITE_ID
207: and B.LANGUAGE = T.SOURCE_LANG)
208: where (
209: T.RECRUITING_SITE_ID,

Line 214: from IRC_ALL_RECRUITING_SITES_TL SUBB, IRC_ALL_RECRUITING_SITES_TL SUBT

210: T.LANGUAGE
211: ) in (select
212: SUBT.RECRUITING_SITE_ID,
213: SUBT.LANGUAGE
214: from IRC_ALL_RECRUITING_SITES_TL SUBB, IRC_ALL_RECRUITING_SITES_TL SUBT
215: where SUBB.RECRUITING_SITE_ID = SUBT.RECRUITING_SITE_ID
216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.SITE_NAME <> SUBT.SITE_NAME
218: or dbms_lob.compare(SUBB.REDIRECTION_URL,SUBT.REDIRECTION_URL) <> 0

Line 226: insert into IRC_ALL_RECRUITING_SITES_TL (

222: or (SUBB.POSTING_URL is null and SUBT.POSTING_URL is not null)
223: or (SUBB.POSTING_URL is not null and SUBT.POSTING_URL is null)
224: ));
225:
226: insert into IRC_ALL_RECRUITING_SITES_TL (
227: SITE_NAME,
228: REDIRECTION_URL,
229: POSTING_URL,
230: RECRUITING_SITE_ID,

Line 240: from IRC_ALL_RECRUITING_SITES_TL B, FND_LANGUAGES L

236: B.POSTING_URL,
237: B.RECRUITING_SITE_ID,
238: L.LANGUAGE_CODE,
239: B.SOURCE_LANG
240: from IRC_ALL_RECRUITING_SITES_TL B, FND_LANGUAGES L
241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL

Line 245: from IRC_ALL_RECRUITING_SITES_TL T

241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL
245: from IRC_ALL_RECRUITING_SITES_TL T
246: where T.RECRUITING_SITE_ID = B.RECRUITING_SITE_ID
247: and T.LANGUAGE = L.LANGUAGE_CODE);
248: --
249: End add_language;