DBA Data[Home] [Help]

APPS.IRC_IRT_BUS dependencies on HR_API

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 91: <> nvl(p_language, hr_api.g_varchar2))) then

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: --
95: -- Check value has been passed

Line 97: hr_api.mandatory_arg_error

93: hr_utility.set_location(l_proc,30);
94: --
95: -- Check value has been passed
96: --
97: hr_api.mandatory_arg_error
98: (p_api_name => l_proc
99: ,p_argument => 'source_lang'
100: ,p_argument_value => p_source_lang
101: );

Line 118: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then

114: fnd_message.raise_error;
115: end if;
116: close csr_language;
117: --
118: if nvl(l_installed_flag,hr_api.g_varchar2) not in ('I','B') then
119: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
120: fnd_message.set_token('PROCEDURE', l_proc);
121: fnd_message.set_token('STEP','20');
122: fnd_message.raise_error;

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 249: <> nvl(p_redirection_url,hr_api.g_varchar2)))

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;
253: fetch csr_third_party into l_third_party;

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 327: <> nvl(p_posting_url,hr_api.g_varchar2)))

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;
331: fetch csr_third_party into l_third_party;