APPS.ZPB_AW_LOADER_PVT SQL Statements

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

Line: 49

   select ORACLE_USERNAME
    into l_schema
    from FND_ORACLE_USERID a,
      FND_APPLICATION b,
      FND_PRODUCT_INSTALLATIONS c
    where a.ORACLE_ID = c.ORACLE_ID
      and c.APPLICATION_ID = b.APPLICATION_ID
      and b.APPLICATION_SHORT_NAME = upper(p_app_name);

Line: 96

         dbms_aw.execute ('property delete all');

Line: 116

procedure DELETE_OBJECT(p_object_name   in varchar2)
        is
begin
   if (CALL_BOOL('shw exists ('''||p_object_name||''')')) then
      dbms_aw.execute('delete ' || p_object_name);

Line: 122

end DELETE_OBJECT;

Line: 139

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

Line: 183

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

Line: 279

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

Line: 283

end UPDATE_AW;