APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_LIST_MAP_TMP4

Line 6538: * in pa_res_list_map_tmp4.

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: **************************************************************/
6540: Function Derive_Resource_List_Member
6541: (p_project_id IN NUMBER,
6542: p_res_format_id IN NUMBER,

Line 6911: DELETE FROM pa_res_list_map_tmp4;

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

Line 6968: * table pa_res_list_map_tmp4.

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: **************************************************/
6970: -- dbms_output.put_line('Pa_Resource_Mapping.map_resource_list');
6971: -- dbms_output.put_line('l_resource_list_id IS : ' || l_resource_list_id);
6972: -- dbms_output.put_line('p_project_id IS : ' || p_project_id);

Line 6987: * the pa_res_list_map_tmp4 table.

6983: END IF;
6984:
6985: /***********************************************
6986: * Get the resource_list_member_id value from
6987: * the pa_res_list_map_tmp4 table.
6988: ************************************************/
6989: BEGIN
6990: SELECT RESOURCE_LIST_MEMBER_ID
6991: INTO l_res_list_member_id

Line 6992: FROM pa_res_list_map_tmp4

6988: ************************************************/
6989: BEGIN
6990: SELECT RESOURCE_LIST_MEMBER_ID
6991: INTO l_res_list_member_id
6992: FROM pa_res_list_map_tmp4
6993: WHERE rownum = 1;
6994: -- dbms_output.put_line('MAPPING l_res_list_member_id IS : ' || l_res_list_member_id);
6995: EXCEPTION
6996: WHEN OTHERS THEN