2022: IS
2023: CURSOR c_organization_name
2024: IS
2025: SELECT name
2026: FROM hr_organization_units
2027: WHERE organization_id = p_organization_id;
2028:
2029: l_org_name hr_organization_units.name%TYPE;
2030: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';
2025: SELECT name
2026: FROM hr_organization_units
2027: WHERE organization_id = p_organization_id;
2028:
2029: l_org_name hr_organization_units.name%TYPE;
2030: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';
2031:
2032: BEGIN
2033: set_location(g_debug,'Entering : '||l_procedure,10);