APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_LIST_MAP_TMP4

Line 6380: * in pa_res_list_map_tmp4.

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: **************************************************************/
6382: Function Derive_Resource_List_Member
6383: (p_project_id IN NUMBER,
6384: p_res_format_id IN NUMBER,

Line 6753: DELETE FROM pa_res_list_map_tmp4;

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
6757: * would read the values from the below table and will get

Line 6810: * table pa_res_list_map_tmp4.

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: **************************************************/
6812: -- dbms_output.put_line('Pa_Resource_Mapping.map_resource_list');
6813: -- dbms_output.put_line('l_resource_list_id IS : ' || l_resource_list_id);
6814: -- dbms_output.put_line('p_project_id IS : ' || p_project_id);

Line 6829: * the pa_res_list_map_tmp4 table.

6825: END IF;
6826:
6827: /***********************************************
6828: * Get the resource_list_member_id value from
6829: * the pa_res_list_map_tmp4 table.
6830: ************************************************/
6831: BEGIN
6832: SELECT RESOURCE_LIST_MEMBER_ID
6833: INTO l_res_list_member_id

Line 6834: FROM pa_res_list_map_tmp4

6830: ************************************************/
6831: BEGIN
6832: SELECT RESOURCE_LIST_MEMBER_ID
6833: INTO l_res_list_member_id
6834: FROM pa_res_list_map_tmp4
6835: WHERE rownum = 1;
6836: -- dbms_output.put_line('MAPPING l_res_list_member_id IS : ' || l_res_list_member_id);
6837: EXCEPTION
6838: WHEN OTHERS THEN