DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_VACANCY_CONSIDERATIONS

Line 313: from irc_vacancy_considerations

309: where party_id = p_party_id;
310: --
311: cursor csr_ivc_cons is
312: select vacancy_consideration_id, object_version_number
313: from irc_vacancy_considerations
314: where party_id = p_party_id;
315: --
316: begin
317: hr_utility.set_location('Entering Purge Person Info:'||l_proc, 10);

Line 433: -- Delete from IRC_VACANCY_CONSIDERATIONS

429: ,p_object_version_number => rec_phn.object_version_number
430: );
431: end loop;
432: --
433: -- Delete from IRC_VACANCY_CONSIDERATIONS
434: --
435: hr_utility.set_location(l_proc, 112);
436: for rec_ivc in csr_ivc_cons loop
437: irc_vacancy_considerations_api.delete_vacancy_consideration

Line 437: irc_vacancy_considerations_api.delete_vacancy_consideration

433: -- Delete from IRC_VACANCY_CONSIDERATIONS
434: --
435: hr_utility.set_location(l_proc, 112);
436: for rec_ivc in csr_ivc_cons loop
437: irc_vacancy_considerations_api.delete_vacancy_consideration
438: (p_vacancy_consideration_id => rec_ivc.vacancy_consideration_id
439: ,p_object_version_number => rec_ivc.object_version_number
440: );
441: end loop;