APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RESOURCES

Line 265: l_resource_id pa_resources.resource_id%TYPE;

261: l_res_class_id Number;
262: l_fmt_details get_fmt_details%ROWTYPE;
263: l_res_type VARCHAR2(30);
264: l_person_name per_people_x.full_name%TYPE;
265: l_resource_id pa_resources.resource_id%TYPE;
266: l_unique_res_list VARCHAR2(30) := null;
267: --Local vars for Validate_planning_resource
268: l_resource_code VARCHAR2(30);
269: l_resource_name VARCHAR2(1000);

Line 669: * Then Insert into pa_resources

665: * If the l_res_type returned = 'NAMED_PERSON' then
666: * first we need to get the value of person_name into
667: * l_person_name based on l_person_id.
668: * This is obtained from the per_people_x view
669: * Then Insert into pa_resources
670: * followed by insert into pa_resources_txn_attributes
671: ***************************************************/
672:
673: IF l_res_type = 'NAMED_PERSON' THEN

Line 670: * followed by insert into pa_resources_txn_attributes

666: * first we need to get the value of person_name into
667: * l_person_name based on l_person_id.
668: * This is obtained from the per_people_x view
669: * Then Insert into pa_resources
670: * followed by insert into pa_resources_txn_attributes
671: ***************************************************/
672:
673: IF l_res_type = 'NAMED_PERSON' THEN
674: BEGIN

Line 716: * Insert into PA_RESOURCES and PA_RESOURCE_TXN_ATTRIBUTES

712:
713: IF l_resource_id IS NULL THEN
714:
715: /***********************************************
716: * Insert into PA_RESOURCES and PA_RESOURCE_TXN_ATTRIBUTES
717: * Table. This is done by a call to
718: * pa_create_resource.Create_Resource procedure.
719: ************************************************/
720: pa_create_resource.Create_Resource