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_IRT_BUS dependencies on IRC_ALL_RECRUITING_SITES

Line 152: (p_site_name in irc_all_recruiting_sites_tl.site_name%TYPE

148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure chk_site_name
152: (p_site_name in irc_all_recruiting_sites_tl.site_name%TYPE
153: ,p_language in irc_all_recruiting_sites_tl.language%TYPE
154: ) IS
155: --
156: l_proc varchar2(72) := g_package || 'chk_site_name';

Line 153: ,p_language in irc_all_recruiting_sites_tl.language%TYPE

149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure chk_site_name
152: (p_site_name in irc_all_recruiting_sites_tl.site_name%TYPE
153: ,p_language in irc_all_recruiting_sites_tl.language%TYPE
154: ) IS
155: --
156: l_proc varchar2(72) := g_package || 'chk_site_name';
157: l_name varchar2(1);

Line 160: from irc_all_recruiting_sites_tl

156: l_proc varchar2(72) := g_package || 'chk_site_name';
157: l_name varchar2(1);
158: cursor csr_name is
159: select null
160: from irc_all_recruiting_sites_tl
161: where site_name = p_site_name
162: and language = p_language;
163: --
164: Begin

Line 191: (p_associated_column1 => 'irc_all_recruiting_sites_tl.site_name'

187: hr_utility.set_location(' Leaving:'||l_proc,35);
188: exception
189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'irc_all_recruiting_sites_tl.site_name'
192: )then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;

Line 226: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.recruiting_site_id%TYPE

222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure chk_redirection_url
225: (p_redirection_url in varchar2
226: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.recruiting_site_id%TYPE
227: ) IS
228: --
229: l_proc varchar2(72) := g_package || 'chk_redirection_url';
230: --

Line 231: l_third_party irc_all_recruiting_sites.third_party%TYPE;

227: ) IS
228: --
229: l_proc varchar2(72) := g_package || 'chk_redirection_url';
230: --
231: l_third_party irc_all_recruiting_sites.third_party%TYPE;
232: cursor csr_third_party
233: is select third_party
234: from irc_all_recruiting_sites
235: where recruiting_site_id = p_recruiting_site_id;

Line 234: from irc_all_recruiting_sites

230: --
231: l_third_party irc_all_recruiting_sites.third_party%TYPE;
232: cursor csr_third_party
233: is select third_party
234: from irc_all_recruiting_sites
235: where recruiting_site_id = p_recruiting_site_id;
236: --
237: begin
238: hr_utility.set_location('Entering:'||l_proc,10);

Line 268: 'IRC_ALL_RECRUITING_SITES_TL.REDIRECTION_URL'

264: exception
265: when app_exception.application_exception then
266: if hr_multi_message.exception_add
267: (p_associated_column1 =>
268: 'IRC_ALL_RECRUITING_SITES_TL.REDIRECTION_URL'
269: ) then
270: hr_utility.set_location(' Leaving:'||l_proc,80);
271: raise;
272: end if;

Line 304: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.recruiting_site_id%TYPE

300: -- {End Of Comments}
301: -- ----------------------------------------------------------------------------
302: Procedure chk_posting_url
303: (p_posting_url in varchar2
304: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.recruiting_site_id%TYPE
305: ) IS
306: --
307: l_proc varchar2(72) := g_package || 'chk_posting_url';
308: --

Line 309: l_third_party irc_all_recruiting_sites.third_party%TYPE;

305: ) IS
306: --
307: l_proc varchar2(72) := g_package || 'chk_posting_url';
308: --
309: l_third_party irc_all_recruiting_sites.third_party%TYPE;
310: cursor csr_third_party
311: is select third_party
312: from irc_all_recruiting_sites
313: where recruiting_site_id = p_recruiting_site_id;

Line 312: from irc_all_recruiting_sites

308: --
309: l_third_party irc_all_recruiting_sites.third_party%TYPE;
310: cursor csr_third_party
311: is select third_party
312: from irc_all_recruiting_sites
313: where recruiting_site_id = p_recruiting_site_id;
314: --
315: begin
316: hr_utility.set_location('Entering:'||l_proc,10);

Line 350: 'IRC_ALL_RECRUITING_SITES_TL.POSTING_URL'

346: exception
347: when app_exception.application_exception then
348: if hr_multi_message.exception_add
349: (p_associated_column1 =>
350: 'IRC_ALL_RECRUITING_SITES_TL.POSTING_URL'
351: ) then
352: hr_utility.set_location(' Leaving:'||l_proc,80);
353: raise;
354: end if;

Line 364: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.RECRUITING_SITE_ID%type

360: -- |---------------------------< insert_validate >----------------------------|
361: -- ----------------------------------------------------------------------------
362: Procedure insert_validate
363: (p_rec in irc_irt_shd.g_rec_type
364: ,p_recruiting_site_id in irc_all_recruiting_sites_tl.RECRUITING_SITE_ID%type
365: ) is
366: --
367: l_proc varchar2(72) := g_package||'insert_validate';
368: --