APPS.IRC_VACANCY_COMMIT dependencies on IRC_AGENCY_VACANCIES

Line 1698: irc_agency_vacancies_swi.create_agency_vacancy (

1694: hr_utility.trace('Entering commit_i_agency_vacancy');
1695: --
1696: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1697: --
1698: irc_agency_vacancies_swi.create_agency_vacancy (
1699: P_VALIDATE => g_validate
1700: ,P_AGENCY_ID => valueOf(commitNode,'AgencyId')
1701: ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1702: ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))

Line 1764: irc_agency_vacancies_swi.delete_agency_vacancy (

1760: hr_utility.trace('Entering commit_d_agency_vacancy');
1761: --
1762: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1763: --
1764: irc_agency_vacancies_swi.delete_agency_vacancy (
1765: P_AGENCY_VACANCY_ID => valueOf(commitNode,'AgencyVacancyId')
1766: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1767: ,P_RETURN_STATUS => l_return_status
1768: ,P_VALIDATE => g_validate);

Line 1795: irc_agency_vacancies_swi.update_agency_vacancy (

1791: hr_utility.trace('Entering commit_u_agency_vacancy');
1792: --
1793: l_object_version_number := valueOf(commitNode,'ObjectVersionNumber');
1794: --
1795: irc_agency_vacancies_swi.update_agency_vacancy (
1796: P_AGENCY_ID => valueOf(commitNode,'AgencyId')
1797: ,P_VACANCY_ID => valueOf(commitNode,'VacancyId')
1798: ,P_START_DATE => date_value(valueOf(commitNode,'StartDate'))
1799: ,P_END_DATE => date_value(valueOf(commitNode,'EndDate'))

Line 2488: from IRC_AGENCY_VACANCIES

2484: l_agency_vacancy_id := valueOf(commitNode,'AgencyVacancyId');
2485: --
2486: select count(*)
2487: into l_row_count
2488: from IRC_AGENCY_VACANCIES
2489: where agency_vacancy_id = l_agency_vacancy_id;
2490: --
2491: if (l_row_count = 0) then
2492: hr_utility.trace('Exiting found_agency_vacancy returning FALSE');