14: END IF;
15: x_return_status := fnd_api.g_ret_sts_success;
16:
17: IF (p_resource_list_assignment_id is null) THEN
18: DELETE pa_resource_maps;
19: ELSE
20: DELETE pa_resource_maps prm
21: WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;
22: END IF;
16:
17: IF (p_resource_list_assignment_id is null) THEN
18: DELETE pa_resource_maps;
19: ELSE
20: DELETE pa_resource_maps prm
21: WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;
22: END IF;
23: IF P_DEBUG_MODE = 'Y' THEN
24: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Exiting - Delete Resource Maps');