APPS.PA_RESOURCE_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 871: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)

867: -- Raise the Error
868: RAISE;
869: END populate_role_flags;
870:
871: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
872: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
873: IS
874: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
875: BEGIN

Line 872: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE

868: RAISE;
869: END populate_role_flags;
870:
871: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
872: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
873: IS
874: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
875: BEGIN
876: -- 4882876 : Adding caching logic

Line 874: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;

870:
871: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
872: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
873: IS
874: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
875: BEGIN
876: -- 4882876 : Adding caching logic
877: IF G_ORGANIZATION_ID IS NULL OR G_ORGANIZATION_ID <> p_org_id THEN
878: G_ORGANIZATION_ID := p_org_id;

Line 881: FROM hr_organization_units

877: IF G_ORGANIZATION_ID IS NULL OR G_ORGANIZATION_ID <> p_org_id THEN
878: G_ORGANIZATION_ID := p_org_id;
879: SELECT name
880: INTO l_org_name
881: FROM hr_organization_units
882: WHERE organization_id = p_org_id;
883: G_ORGANIZATION_NAME := l_org_name;
884: ELSIF p_org_id IS NULL THEN -- Bug 9156671
885: G_ORGANIZATION_ID := NULL;