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_IRT_SHD

Line 44: (p_rec in irc_irt_shd.g_rec_type

40: --
41: -- {End Of Comments}
42: -- ----------------------------------------------------------------------------
43: Procedure chk_non_updateable_args
44: (p_rec in irc_irt_shd.g_rec_type
45: ) IS
46: --
47: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
48: --

Line 54: IF NOT irc_irt_shd.api_updating

50: --
51: -- Only proceed with the validation if a row exists for the current
52: -- record in the HR Schema.
53: --
54: IF NOT irc_irt_shd.api_updating
55: (p_recruiting_site_id => p_rec.recruiting_site_id
56: ,p_language => p_rec.language
57: ) THEN
58: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)

84: --
85: -- Only proceed with SQL validation if absolutely necessary
86: --
87:
88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)
89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)
91: <> nvl(p_language, hr_api.g_varchar2))) then
92: --

Line 89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null

85: -- Only proceed with SQL validation if absolutely necessary
86: --
87:
88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)
89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)
91: <> nvl(p_language, hr_api.g_varchar2))) then
92: --
93: hr_utility.set_location(l_proc,30);

Line 90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)

86: --
87:
88: if ((irc_irt_shd.g_old_rec.recruiting_site_id is null and p_language is not null)
89: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
90: and nvl(irc_irt_shd.g_old_rec.language, hr_api.g_varchar2)
91: <> nvl(p_language, hr_api.g_varchar2))) then
92: --
93: hr_utility.set_location(l_proc,30);
94: --

Line 172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is

168: fnd_message.set_name('PER','IRC_412104_RSE_NAME_NULL');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location('Entering:'||l_proc,20);
172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
173: null)
174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then
176: open csr_name;

Line 174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null

170: end if;
171: hr_utility.set_location('Entering:'||l_proc,20);
172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
173: null)
174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then
176: open csr_name;
177: fetch csr_name into l_name;
178: hr_utility.set_location('Entering:'||l_proc,30);

Line 175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then

171: hr_utility.set_location('Entering:'||l_proc,20);
172: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
173: null)
174: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
175: and irc_irt_shd.g_old_rec.site_name <> p_site_name)) then
176: open csr_name;
177: fetch csr_name into l_name;
178: hr_utility.set_location('Entering:'||l_proc,30);
179: if (csr_name%found)

Line 245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is

241: -- have been updated, or if inserting.
242: --
243: hr_utility.set_location(l_proc,20);
244: --
245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
246: null)
247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)
249: <> nvl(p_redirection_url,hr_api.g_varchar2)))

Line 247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null

243: hr_utility.set_location(l_proc,20);
244: --
245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
246: null)
247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)
249: <> nvl(p_redirection_url,hr_api.g_varchar2)))
250: then
251: hr_utility.set_location(l_proc,25);

Line 248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)

244: --
245: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
246: null)
247: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
248: and nvl(irc_irt_shd.g_old_rec.redirection_url,hr_api.g_varchar2)
249: <> nvl(p_redirection_url,hr_api.g_varchar2)))
250: then
251: hr_utility.set_location(l_proc,25);
252: open csr_third_party;

Line 323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is

319: -- have been updated, or if inserting.
320: --
321: hr_utility.set_location(l_proc,20);
322: --
323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
324: null)
325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)
327: <> nvl(p_posting_url,hr_api.g_varchar2)))

Line 325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null

321: hr_utility.set_location(l_proc,20);
322: --
323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
324: null)
325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)
327: <> nvl(p_posting_url,hr_api.g_varchar2)))
328: then
329: hr_utility.set_location(l_proc,25);

Line 326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)

322: --
323: if ((irc_irt_shd.g_old_rec.recruiting_site_id is
324: null)
325: or (irc_irt_shd.g_old_rec.recruiting_site_id is not null
326: and nvl(irc_irt_shd.g_old_rec.posting_url,hr_api.g_varchar2)
327: <> nvl(p_posting_url,hr_api.g_varchar2)))
328: then
329: hr_utility.set_location(l_proc,25);
330: open csr_third_party;

Line 363: (p_rec in irc_irt_shd.g_rec_type

359: -- ----------------------------------------------------------------------------
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';

Line 405: (p_rec in irc_irt_shd.g_rec_type

401: -- ----------------------------------------------------------------------------
402: -- |---------------------------< update_validate >----------------------------|
403: -- ----------------------------------------------------------------------------
404: Procedure update_validate
405: (p_rec in irc_irt_shd.g_rec_type
406: ) is
407: --
408: l_proc varchar2(72) := g_package||'update_validate';
409: --

Line 451: (p_rec in irc_irt_shd.g_rec_type

447: -- ----------------------------------------------------------------------------
448: -- |---------------------------< delete_validate >----------------------------|
449: -- ----------------------------------------------------------------------------
450: Procedure delete_validate
451: (p_rec in irc_irt_shd.g_rec_type
452: ) is
453: --
454: l_proc varchar2(72) := g_package||'delete_validate';
455: --