SYS.WPG_DOCLOAD SQL Statements

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

Line: 193

    last_updated DATE;

Line: 203

    last_updated_str VARCHAR2(128);

Line: 226

    new_cols := 'LAST_UPDATED,MIME_TYPE,CONTENT_TYPE,DAD_CHARSET,DOC_SIZE';

Line: 236

    sql_stmt := 'select '||new_cols||' from '||dbms_assert.qualified_sql_name(p_doctable)||
      ' where NAME=:docname';

Line: 241

    sys.dbms_sys_sql.define_column(cursor_handle, 1, last_updated);

Line: 250

    sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);

Line: 289

       IF (mod_date = last_updated) THEN
         IF (mod_len IS NULL OR mod_len = doc_size) THEN
            last_updated_str := 'NOT_MODIFIED';

Line: 293

            last_updated_str := to_char(last_updated,
               'Dy, DD Mon YYYY HH24:MI:SS "GMT"',
               'NLS_DATE_LANGUAGE = American');

Line: 298

         last_updated_str := to_char(last_updated,
            'Dy, DD Mon YYYY HH24:MI:SS "GMT"',
            'NLS_DATE_LANGUAGE = American');

Line: 304

         last_updated_str := to_char(last_updated,
             'Dy, DD Mon YYYY HH24:MI:SS "GMT"',
         'NLS_DATE_LANGUAGE = American');

Line: 308

         last_updated_str := NULL;

Line: 315

    p_doc_info := p_doc_info||encode_parameter(last_updated_str);

Line: 327

       last_updated := NULL;

Line: 331

       sql_stmt := 'select '||old_cols||' from '||
            dbms_assert.qualified_sql_name(p_doctable) ||
            ' where NAME=:docname';

Line: 348

       p_doc_info := p_doc_info||encode_parameter(last_updated);