263: l_res_class_code VARCHAR2(30);
264: l_res_class_id Number;
265: l_fmt_details get_fmt_details%ROWTYPE;
266: l_res_type VARCHAR2(30);
267: l_person_name per_people_x.full_name%TYPE;
268: l_resource_id pa_resources.resource_id%TYPE;
269: l_unique_res_list VARCHAR2(30) := null;
270: --Local vars for Validate_planning_resource
271: l_resource_code VARCHAR2(30);
724: /******************************************************
725: * If the l_res_type returned = 'NAMED_PERSON' then
726: * first we need to get the value of person_name into
727: * l_person_name based on l_person_id.
728: * This is obtained from the per_people_x view
729: * Then Insert into pa_resources
730: * followed by insert into pa_resources_txn_attributes
731: ***************************************************/
732:
733: IF l_res_type = 'NAMED_PERSON' THEN
734: BEGIN
735: SELECT full_name
736: INTO l_person_name
737: FROM per_people_x
738: WHERE person_id = l_person_id;
739: EXCEPTION
740: WHEN OTHERS THEN
741: l_person_name := null;