APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_LIST_MAP_TMP1

Line 6377: * (6a) Insert into Pa_res_list_map_tmp1 and then call

6373: * created resource_list_member_id
6374: * (6) If it is a Centrally controlled resource list
6375: * Then it calls Vijays API which will return the best
6376: * Matching resource list member.
6377: * (6a) Insert into Pa_res_list_map_tmp1 and then call
6378: * Api pa_resource_mapping.map_resource_list.
6379: * which will put the correct resource_list_member_id
6380: * in pa_res_list_map_tmp4.
6381: **************************************************************/

Line 6752: DELETE FROM pa_res_list_map_tmp1;

6748: * following.
6749: * *********************************************************/
6750: IF l_exists = 'N' and l_central_control = 'Y' THEN
6751: --Delete the temp table.
6752: DELETE FROM pa_res_list_map_tmp1;
6753: DELETE FROM pa_res_list_map_tmp4;
6754: /***************************************************
6755: * Populate the temp table with the parameters passed in.
6756: * Then we need to call the mapping API, which

Line 6778: INSERT INTO pa_res_list_map_tmp1

6774: END IF;
6775:
6776: --dbms_output.put_line('l_fc_res_type_code IS : ' || l_fc_res_type_code);
6777:
6778: INSERT INTO pa_res_list_map_tmp1
6779: (person_id,
6780: job_id,
6781: organization_id,
6782: expenditure_type,

Line 6807: * table pa_res_list_map_tmp1 and will take in

6803: p_named_role);
6804: /**********************************************
6805: * Call to the API passing the resource_list_ID
6806: * This API would read the values from the temp
6807: * table pa_res_list_map_tmp1 and will take in
6808: * the resource_list_id and get the best matching
6809: * resource_list_member_id and insert it into the
6810: * table pa_res_list_map_tmp4.
6811: **************************************************/