APPS.PA_RESOURCE_UTILS dependencies on HR_ORGANIZATION_UNITS

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

791: -- Raise the Error
792: RAISE;
793: END populate_role_flags;
794:
795: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
796: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
797: IS
798: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
799: BEGIN

Line 796: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE

792: RAISE;
793: END populate_role_flags;
794:
795: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
796: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
797: IS
798: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
799: BEGIN
800: -- 4882876 : Adding caching logic

Line 798: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;

794:
795: FUNCTION get_organization_name(p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
796: RETURN HR_ORGANIZATION_UNITS.NAME%TYPE
797: IS
798: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
799: BEGIN
800: -- 4882876 : Adding caching logic
801: IF G_ORGANIZATION_ID IS NULL OR G_ORGANIZATION_ID <> p_org_id THEN
802: G_ORGANIZATION_ID := p_org_id;

Line 805: FROM hr_organization_units

801: IF G_ORGANIZATION_ID IS NULL OR G_ORGANIZATION_ID <> p_org_id THEN
802: G_ORGANIZATION_ID := p_org_id;
803: SELECT name
804: INTO l_org_name
805: FROM hr_organization_units
806: WHERE organization_id = p_org_id;
807: G_ORGANIZATION_NAME := l_org_name;
808: ELSE
809: l_org_name := G_ORGANIZATION_NAME;