602: l_posting_content varchar2(1);
603: --
604: cursor csr_posting_content is
605: select null
606: from per_all_vacancies vac
607: where vac.primary_posting_id = p_posting_content_id;
608: --
609: begin
610: --
609: begin
610: --
611: hr_utility.set_location('Entering:'||l_proc,10);
612: --
613: -- check if referenced records exist in the PER_ALL_VACANCIES table.
614: --
615: open csr_posting_content;
616: fetch csr_posting_content into l_posting_content;
617: hr_utility.set_location(l_proc,20);