APPS.FTE_DIST_UTIL_PKG SQL Statements

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

Line: 58

PROCEDURE DELETE_FILES_LINES(p_template_id                  IN  NUMBER,
                             x_return_message               OUT NOCOPY VARCHAR2,
                             x_return_status                OUT NOCOPY VARCHAR2) IS


l_error_text VARCHAR2(2000);

Line: 68

select download_file_id
from   fte_mile_download_files
where  template_id = cp_template_id;

Line: 79

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_FILES_LINES';

Line: 87

   l_file_ids.DELETE;

Line: 140

            DELETE fte_mile_download_lines
            WHERE  download_file_id = l_file_ids(j);

Line: 147

            DELETE fte_mile_download_files
            WHERE  download_file_id = l_file_ids(j);

Line: 189

         WSH_DEBUG_SV.logmsg(l_module_name,  'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT  );

Line: 194

      WSH_UTIL_CORE.default_handler('FTE_DIST_UTIL_PKG.DELETE_FILES_LINES');

Line: 208

END DELETE_FILES_LINES;