DBA Data[Home] [Help]

APPS.AD_AW_LOADER SQL Statements

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

Line: 56

         dbms_aw.execute ('property delete all');
Line: 70

procedure DELETE_OBJECT(p_object_name   in varchar2)
        is
begin
        if(upper (CALL_AW('shw exists ('''||p_object_name||''')')) = 'YES') then
                dbms_aw.execute('delete ' || p_object_name);
Line: 76

end DELETE_OBJECT;
Line: 88

      dbms_aw.execute('mnt '||m_curr_obj||' delete last '||
                      (l_size - p_dimension_size));
Line: 126

      dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');
Line: 187

procedure UPDATE_AW
   is
begin
   dbms_aw.execute ('upd');
Line: 191

end UPDATE_AW;