APPS.PA_FC_RES_MAP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

PROCEDURE delete_res_maps_on_asgn_id
           (p_resource_list_assignment_id  IN NUMBER,
            x_return_status                OUT NOCOPY VARCHAR2,
            x_error_message_code           OUT NOCOPY VARCHAR2) IS
   BEGIN
     IF P_DEBUG_MODE = 'Y' THEN
        pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Entering - Delete Resource Maps');

Line: 18

       DELETE pa_resource_maps;

Line: 20

       DELETE pa_resource_maps prm
       WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;

Line: 24

        pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Exiting - Delete Resource Maps');

Line: 35

   END delete_res_maps_on_asgn_id;

Line: 245

	    -- delete all the old maps for this resource list assignments
	    -- for all the transactions
            pa_funds_control_utils.print_message('RList changed');

Line: 251

	    delete_res_maps_on_asgn_id(
			p_resource_list_assignment_id => current_rl_assignment_id,
			x_return_status => x_return_status,
			x_error_message_code =>	x_error_message_code);