[Home] [Help]
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);
272: l_resource_name VARCHAR2(1000);
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
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
796:
797: IF l_resource_id IS NULL THEN
798:
799: /***********************************************
800: * Insert into PA_RESOURCES and PA_RESOURCE_TXN_ATTRIBUTES
801: * Table. This is done by a call to
802: * pa_create_resource.Create_Resource procedure.
803: ************************************************/
804: pa_create_resource.Create_Resource