280: x_resource_id := NULL;
281: END IF;
282: END IF;
283:
284: /* Commented for bug#2683266 as person type should not be checked in pa_resource_types table
285: as pa_resource_types does not contain all person_types defined in HR table per_person_types
286:
287: IF l_sys_per_type is not null THEN
288: select resource_type_id
281: END IF;
282: END IF;
283:
284: /* Commented for bug#2683266 as person type should not be checked in pa_resource_types table
285: as pa_resource_types does not contain all person_types defined in HR table per_person_types
286:
287: IF l_sys_per_type is not null THEN
288: select resource_type_id
289: into x_resource_type_id
286:
287: IF l_sys_per_type is not null THEN
288: select resource_type_id
289: into x_resource_type_id
290: from pa_resource_types
291: where resource_type_code = decode(l_sys_per_type,
292: 'EMP','EMPLOYEE');
293: END IF;
294: */
3704: BEGIN
3705:
3706: SELECT resource_type_code
3707: INTO l_resource_type
3708: FROM pa_resources pr, pa_resource_types pt
3709: WHERE pr.resource_id = p_resource_id
3710: AND pr.resource_type_id = pt.resource_type_id;
3711:
3712: RETURN l_resource_type;
3927: FUNCTION get_res_name_from_type(p_resource_type_id IN NUMBER,
3928: p_resource_source_id IN NUMBER)
3929: RETURN VARCHAR2 IS
3930:
3931: l_resource_type_code pa_resource_types.resource_type_code%TYPE;
3932: l_name pa_resources.name%TYPE;
3933:
3934: BEGIN
3935:
3936: BEGIN
3937:
3938: SELECT resource_type_code
3939: INTO l_resource_type_code
3940: FROM pa_resource_types
3941: WHERE resource_type_id = p_resource_type_id;
3942:
3943: EXCEPTION
3944: WHEN OTHERS THEN