APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_LIST_MAP_TMP1

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

6531: * created resource_list_member_id
6532: * (6) If it is a Centrally controlled resource list
6533: * Then it calls Vijays API which will return the best
6534: * Matching resource list member.
6535: * (6a) Insert into Pa_res_list_map_tmp1 and then call
6536: * Api pa_resource_mapping.map_resource_list.
6537: * which will put the correct resource_list_member_id
6538: * in pa_res_list_map_tmp4.
6539: **************************************************************/

Line 6910: DELETE FROM pa_res_list_map_tmp1;

6906: * following.
6907: * *********************************************************/
6908: IF l_exists = 'N' and l_central_control = 'Y' THEN
6909: --Delete the temp table.
6910: DELETE FROM pa_res_list_map_tmp1;
6911: DELETE FROM pa_res_list_map_tmp4;
6912: /***************************************************
6913: * Populate the temp table with the parameters passed in.
6914: * Then we need to call the mapping API, which

Line 6936: INSERT INTO pa_res_list_map_tmp1

6932: END IF;
6933:
6934: --dbms_output.put_line('l_fc_res_type_code IS : ' || l_fc_res_type_code);
6935:
6936: INSERT INTO pa_res_list_map_tmp1
6937: (person_id,
6938: job_id,
6939: organization_id,
6940: expenditure_type,

Line 6965: * table pa_res_list_map_tmp1 and will take in

6961: p_named_role);
6962: /**********************************************
6963: * Call to the API passing the resource_list_ID
6964: * This API would read the values from the temp
6965: * table pa_res_list_map_tmp1 and will take in
6966: * the resource_list_id and get the best matching
6967: * resource_list_member_id and insert it into the
6968: * table pa_res_list_map_tmp4.
6969: **************************************************/