APPS.PER_RAA_BUS dependencies on IRC_ALL_RECRUITING_SITES

Line 979: -- Checks that posting_content_id exists in IRC_ALL_RECRUITING_SITES

975: -- |-------------------< chk_recruiting_site_id >------------------------------|
976: -- -----------------------------------------------------------------------------
977: --
978: -- Description:
979: -- Checks that posting_content_id exists in IRC_ALL_RECRUITING_SITES
980: --
981: -- Prerequisites:
982: -- g_old_rec has been populated with details of the values currently in
983: -- the database.

Line 1016: select null from IRC_ALL_RECRUITING_SITES irs

1012: l_recruiting_site_id varchar2(1);
1013: l_api_updating boolean;
1014:
1015: cursor csr_recruiting_site_id is
1016: select null from IRC_ALL_RECRUITING_SITES irs
1017: where irs.recruiting_site_id = p_recruiting_site_id;
1018: --
1019: begin
1020: hr_utility.set_location('Entering:'||l_proc,10);

Line 1031: -- check that recruiting_site_id exists in IRC_ALL_RECRUITING_SITES.

1027: p_recruiting_site_id <>
1028: NVL(per_raa_shd.g_old_rec.recruiting_site_id,hr_api.g_number)
1029: ) or (NOT l_api_updating) then
1030:
1031: -- check that recruiting_site_id exists in IRC_ALL_RECRUITING_SITES.
1032: hr_utility.set_location(l_proc,30);
1033: open csr_recruiting_site_id;
1034: fetch csr_recruiting_site_id into l_recruiting_site_id;
1035: if csr_recruiting_site_id%NOTFOUND then