APPS.RG_XFER_UTILS_PKG SQL Statements

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

Line: 297

                 'SELECT 1 FROM DUAL@'|| LinkName,
                 DBMS_SQL.v7);

Line: 316

    SELECT *
    FROM user_db_links
    WHERE UPPER(db_link) = UPPER(LinkName);

Line: 388

/* Name:  insert_into_list
 * Desc:  Insert the passed name into the PL/SQL table and update the count.
 *
 * History:
 *   10/17/95   S Rahman   Created.
 */
PROCEDURE insert_into_list(
            ListName IN OUT NOCOPY ListType,
            ListCount IN OUT NOCOPY BINARY_INTEGER,
            Name VARCHAR2) IS
BEGIN
  ListName(ListCount) := Name;

Line: 401

END insert_into_list;

Line: 458

  SQLString := 'SELECT ' || IdName || ' FROM ' || TableName||'@'||G_LinkName ||
               ' WHERE name = ''' || ComponentName || ''' ' || WhereClause;

Line: 483

  SQLString := 'SELECT ' || SequenceName || '.nextval FROM sys.dual';

Line: 526

  SQLString := 'SELECT ref_table.name '||
               'FROM '||MainTableName||'@'||G_LinkName||' main_table,' ||
               RefTableName || '@'|| G_LinkName || ' ref_table ' ||
               'WHERE main_table.'||ColumnName || '='|| ValueString ||
               ' AND main_table.'||MainIdName || '= ref_table.'||RefIdName;

Line: 571

  SQLString := 'SELECT t.'|| IdColumnName || ', l.' || NameColumn ||
               ' FROM '|| TableName || ' t,' ||
                          TableName || '@' || G_LinkName ||' l' ||
               ' WHERE l.'|| IdColumnName || '=' || TO_CHAR(IdValue) ||
               ' AND l.' || NameColumn || '= t.' || NameColumn;

Line: 593

    SQLString := 'SELECT ' || NameColumn ||
                 ' FROM ' || TableName||'@'||G_LinkName ||
                 ' WHERE '|| IdColumnName || '=' || TO_CHAR(IdValue);

Line: 642

  SQLString := 'SELECT t.TARGET_LEDGER_ID, l.TARGET_LEDGER_NAME ' ||
               'FROM   GL_LEDGER_RELATIONSHIPS t, GL_LEDGER_RELATIONSHIPS@' ||
                                                  G_LinkName || ' l ' ||
               'WHERE  l.TARGET_LEDGER_ID = ' || TO_CHAR(LedgerId) ||
               ' AND   l.TARGET_CURRENCY_CODE = ''' || LedgerCurrency ||
               ''' AND   l.TARGET_LEDGER_NAME = t.TARGET_LEDGER_NAME';

Line: 666

    SQLString := 'SELECT TARGET_LEDGER_NAME ' ||
                 'FROM   GL_LEDGER_RELATIONSHIPS@' || G_LinkName ||
                 ' WHERE TARGET_LEDGER_ID = ' || TO_CHAR(LedgerId) ||
                 ' AND   TARGET_CURRENCY_CODE = ''' || LedgerCurrency || '''';

Line: 692

/* Name:  insert_rows
 * Desc:  Insert rows using the provided SQL statement. Binds variable as
 *        necessary.
 *
 * History:
 *   10/17/95   S Rahman   Created.
 */
PROCEDURE insert_rows(
            SQLStmt VARCHAR2,
            Id NUMBER,
            UseCOAId BOOLEAN DEFAULT FALSE,
            UseRowId BOOLEAN DEFAULT FALSE,
            RecRowId ROWID   DEFAULT NULL) IS
  CursorId INTEGER;

Line: 722

END insert_rows;

Line: 762

  SQLString := 'SELECT structure_id FROM ' || TableName || '@' || G_LinkName||
               ' WHERE name = ''' || ComponentName ||'''' ||
               NVL(WhereString,' AND application_id = ' || TO_CHAR(G_ApplId));

Line: 808

  SQLString := 'SELECT structure_id FROM ' || TableName ||
               ' WHERE name = ''' || ComponentName ||'''' ||
               NVL(WhereString,' AND application_id = ' || TO_CHAR(G_ApplId));

Line: 1015

  SQLString     VARCHAR2(200) := 'SELECT 1 FROM ';

Line: 1077

FUNCTION component_exists(SelectString VARCHAR2) RETURN NUMBER IS
  CursorId INTEGER;

Line: 1082

  display_string(SelectString);

Line: 1084

  DBMS_SQL.parse(CursorId, SelectString, DBMS_SQL.v7);

Line: 1110

  SQLString := 'SELECT 1 FROM fnd_currencies' ||
               ' WHERE currency_code = ''' || CurrencyCode || '''';

Line: 1143

  SQLString := 'SELECT 1 FROM sys.dual WHERE EXISTS ' ||
               '(SELECT 1 FROM rg_report_axes ax, rg_report_axis_sets axs'||
               ' WHERE axs.application_id+0 in ('||TO_CHAR(G_ApplId)||',168)'||
               ' AND   axs.axis_set_type = ''C'''||
               ' AND   ax.axis_set_id = DECODE(axs.axis_set_type, ''C'',' ||
                                       ' axs.axis_set_id, axs.axis_set_id)' ||
               ' AND   ax.axis_name  = '''||AdjustedName||''')';