DBA Data[Home] [Help]

APPS.IRC_PENDING_DATA_API dependencies on IRC_UTILITIES_PKG

Line 1187: l_person_type := irc_utilities_pkg.get_emp_spt_for_person(p_person_id=>l_person_id, p_eff_date=>trunc(l_data.creation_date));

1183: -- fix for bug 4046889
1184: -- check if this Person is an Employee and if he is applying for an
1185: -- External vacancy
1186: Fnd_file.put_line(FND_FILE.LOG,'Checking if this applicant is an employee and is applying for an internal vacancy only:');
1187: l_person_type := irc_utilities_pkg.get_emp_spt_for_person(p_person_id=>l_person_id, p_eff_date=>trunc(l_data.creation_date));
1188: if (l_person_type = 'EMP') then
1189: open csr_is_internal_vacancy(l_data.vacancy_id, trunc(l_data.creation_date));
1190: fetch csr_is_internal_vacancy into l_num;
1191: if csr_is_internal_vacancy%notfound then