DBA Data[Home] [Help]

APPS.GMA_PURGE_COPY SQL Statements

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

Line: 69

      l_sqlstatement := 'SELECT UNIQUE rowidtochar(' ||
                         l_sourcetable ||
                         ') FROM ' ||
                         p_owner||'.'||p_arcrowtablename ||  --Bug#6681753
                         ' WHERE ' ||
                         l_sourcetable ||
                         ' != CHARTOROWID(' ||
                         '''' ||
                         '0' ||
                         '''' ||
                         ')';
Line: 119

          l_sqlstatement := 'INSERT INTO '|| p_owner || '.' || l_arctablename --Bug#6681753
                             || ' SELECT * FROM ' ||
                             l_sourcetable || ' WHERE ROWID = :b_detailrowid ';
Line: 133

          l_sqlstatement := 'DELETE FROM ' ||l_sourcetable ||
                            ' WHERE ROWID = :b_detailrowid ';
Line: 163

          l_sqlstatement := 'INSERT INTO ' || p_owner || '.' || l_arctablename || --Bug#6681753
                             ' SELECT * FROM ' ||
                             l_sourcetable || ' WHERE ROWID =:b_detailrowid ';