APPS.RG_XFER_COMPONENTS_PKG SQL Statements

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

Line: 52

  /* Strings to select from the source database and insert into the
   * target database. */

  AxisSetsString VARCHAR2(2000) :=
    'INSERT INTO RG_REPORT_AXIS_SETS (' ||
    '  APPLICATION_ID, AXIS_SET_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, NAME, AXIS_SET_TYPE' ||
    ', SECURITY_FLAG, DISPLAY_IN_LIST_FLAG, PERIOD_SET_NAME, DESCRIPTION' ||
    ', COLUMN_SET_HEADER, ROW_SET_TITLE, SEGMENT_NAME, ID_FLEX_CODE' ||
    ', STRUCTURE_ID, CONTEXT   , ATTRIBUTE1 , ATTRIBUTE2 ' ||
    ', ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 ' ||
    ', ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10' ||
    ', ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
    ', ATTRIBUTE15, TAXONOMY_ID' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id     , SYSDATE    , :user_id' ||
    ', :login_id  , SYSDATE    , :user_id   , NAME     , AXIS_SET_TYPE' ||
    ', ''N'', DISPLAY_IN_LIST_FLAG, PERIOD_SET_NAME, DESCRIPTION' ||
    ', null       , ROW_SET_TITLE, SEGMENT_NAME, ID_FLEX_CODE' ||
    ', :coa_id    , CONTEXT    , ATTRIBUTE1 , ATTRIBUTE2 ' ||
    ', ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 ' ||
    ', ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10' ||
    ', ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
    ', ATTRIBUTE15, :tax_id  ' ||
    'FROM RG_REPORT_AXIS_SETS@';

Line: 79

    'INSERT INTO RG_REPORT_CONTENT_SETS (' ||
    '  APPLICATION_ID   , CONTENT_SET_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE , CREATED_BY      , NAME        ' ||
    ', REPORT_RUN_TYPE  , ID_FLEX_CODE  , STRUCTURE_ID    , DESCRIPTION ' ||
    ', CONTEXT          , ATTRIBUTE1    , ATTRIBUTE2      , ATTRIBUTE3  ' ||
    ', ATTRIBUTE4       , ATTRIBUTE5    , ATTRIBUTE6      , ATTRIBUTE7  ' ||
    ', ATTRIBUTE8       , ATTRIBUTE9    , ATTRIBUTE10     , ATTRIBUTE11 ' ||
    ', ATTRIBUTE12      , ATTRIBUTE13   , ATTRIBUTE14     , ATTRIBUTE15 ' ||
    ', SECURITY_FLAG ) SELECT            ' ||
    '  APPLICATION_ID   , :id           , SYSDATE         , :user_id    ' ||
    ', :login_id        , SYSDATE       , :user_id        , NAME        ' ||
    ', REPORT_RUN_TYPE  , ID_FLEX_CODE  , :coa_id         , DESCRIPTION ' ||
    ', CONTEXT          , ATTRIBUTE1    , ATTRIBUTE2      , ATTRIBUTE3  ' ||
    ', ATTRIBUTE4       , ATTRIBUTE5    , ATTRIBUTE6      , ATTRIBUTE7  ' ||
    ', ATTRIBUTE8       , ATTRIBUTE9    , ATTRIBUTE10     , ATTRIBUTE11 ' ||
    ', ATTRIBUTE12      , ATTRIBUTE13   , ATTRIBUTE14     , ATTRIBUTE15 ' ||
    ', ''N''   FROM RG_REPORT_CONTENT_SETS@';

Line: 98

    'INSERT INTO RG_REPORT_DISPLAY_GROUPS (' ||
    '  REPORT_DISPLAY_GROUP_ID, NAME    , CREATION_DATE    , CREATED_BY   ' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, FROM_SEQUENCE' ||
    ', TO_SEQUENCE, DESCRIPTION, ROW_SET_ID , COLUMN_SET_ID' ||
    ', CONTEXT    , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 ' ||
    ', ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 ' ||
    ', ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11' ||
    ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15' ||
    ') SELECT' ||
    '  :id        , NAME       , SYSDATE    , :user_id     ' ||
    ', SYSDATE    , :user_id   , :login_id  , FROM_SEQUENCE' ||
    ', TO_SEQUENCE, DESCRIPTION, :row_set_id , :column_set_id' ||
    ', CONTEXT    , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3   ' ||
    ', ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7   ' ||
    ', ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11  ' ||
    ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15  ' ||
    'FROM RG_REPORT_DISPLAY_GROUPS@';

Line: 117

    'INSERT INTO RG_REPORT_DISPLAYS (' ||
    '  REPORT_DISPLAY_ID, REPORT_DISPLAY_SET_ID, SEQUENCE, CREATION_DATE ' ||
    ', CREATED_BY  , LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
    ', DISPLAY_FLAG, ROW_GROUP_ID, COLUMN_GROUP_ID, DESCRIPTION' ||
    ', CONTEXT     , ATTRIBUTE1  , ATTRIBUTE2     , ATTRIBUTE3 ' ||
    ', ATTRIBUTE4  , ATTRIBUTE5  , ATTRIBUTE6     , ATTRIBUTE7 ' ||
    ', ATTRIBUTE8  , ATTRIBUTE9  , ATTRIBUTE10    , ATTRIBUTE11' ||
    ', ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14    , ATTRIBUTE15' ||
    ') SELECT' ||
    '  rg_report_displays_s.nextval, :id, SEQUENCE, SYSDATE     ' ||
    ', :user_id    , SYSDATE     , :user_id       , :login_id   ' ||
    ', DISPLAY_FLAG,:row_group_id,:column_group_id, DESCRIPTION ' ||
    ', CONTEXT     , ATTRIBUTE1  , ATTRIBUTE2     , ATTRIBUTE3  ' ||
    ', ATTRIBUTE4  , ATTRIBUTE5  , ATTRIBUTE6     , ATTRIBUTE7  ' ||
    ', ATTRIBUTE8  , ATTRIBUTE9  , ATTRIBUTE10    , ATTRIBUTE11 ' ||
    ', ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14    , ATTRIBUTE15 ' ||
    'FROM RG_REPORT_DISPLAYS@';

Line: 136

    'INSERT INTO RG_REPORT_DISPLAY_SETS (' ||
    '  REPORT_DISPLAY_SET_ID, NAME  , CREATION_DATE, CREATED_BY' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ROW_SET_ID'||
    ', COLUMN_SET_ID, DESCRIPTION, CONTEXT    , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2   , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6   , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10  , ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14  , ATTRIBUTE15'                           ||
    ') SELECT ' ||
    '  :id         , NAME, SYSDATE, :user_id' ||
    ', SYSDATE     , :user_id   , :login_id  , :row_set_id' ||
    ', :column_set_id, DESCRIPTION , CONTEXT , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2  , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6  , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10 , ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14 , ATTRIBUTE15 '                          ||
    'FROM RG_REPORT_DISPLAY_SETS@';

Line: 155

    'INSERT INTO RG_REPORT_PARAMETERS (' ||
    '  PARAMETER_SET_ID, LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN' ||
    ', CREATION_DATE   , CREATED_BY      , PARAMETER_NUM , DATA_TYPE  ' ||
    ', PARAMETER_ID    , ENTERED_CURRENCY, CURRENCY_TYPE , LEDGER_CURRENCY' ||
    ', PERIOD_NUM      , FISCAL_YEAR_OFFSET ' ||
    ', CONTEXT         , ATTRIBUTE1      , ATTRIBUTE2    , ATTRIBUTE3 ' ||
    ', ATTRIBUTE4      , ATTRIBUTE5      , ATTRIBUTE6    , ATTRIBUTE7 ' ||
    ', ATTRIBUTE8      , ATTRIBUTE9      , ATTRIBUTE10   , ATTRIBUTE11' ||
    ', ATTRIBUTE12     , ATTRIBUTE13     , ATTRIBUTE14   , ATTRIBUTE15' ||
    ') SELECT' ||
    '  :id             , SYSDATE         , :user_id      , :login_id  ' ||
    ', SYSDATE         , :user_id        , PARAMETER_NUM , DATA_TYPE  ' ||
    ', :parameter_id   , ENTERED_CURRENCY, CURRENCY_TYPE , LEDGER_CURRENCY' ||
    ', PERIOD_NUM      , FISCAL_YEAR_OFFSET ' ||
    ', CONTEXT         , ATTRIBUTE1      , ATTRIBUTE2    , ATTRIBUTE3 ' ||
    ', ATTRIBUTE4      , ATTRIBUTE5      , ATTRIBUTE6    , ATTRIBUTE7 ' ||
    ', ATTRIBUTE8      , ATTRIBUTE9      , ATTRIBUTE10   , ATTRIBUTE11' ||
    ', ATTRIBUTE12     , ATTRIBUTE13     , ATTRIBUTE14   , ATTRIBUTE15 '||
    'FROM RG_REPORT_PARAMETERS@';

Line: 176

    'INSERT INTO RG_REPORT_REQUESTS (' ||
    '  APPLICATION_ID, REPORT_REQUEST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, REPORT_ID ' ||
    ', SEQUENCE, FORM_SUBMISSION_FLAG, CONCURRENT_REQUEST_ID, REPORT_SET_ID' ||
    ', CONTENT_SET_ID, ROW_ORDER_ID, EXCEPTIONS_FLAG, ROUNDING_OPTION      ' ||
    ', LEDGER_ID, ALC_LEDGER_CURRENCY, REPORT_DISPLAY_SET_ID, ID_FLEX_CODE ' ||
    ', STRUCTURE_ID, SEGMENT_OVERRIDE, OVERRIDE_ALC_LEDGER_CURRENCY ' ||
    ', PERIOD_NAME, UNIT_OF_MEASURE_ID, CONTEXT' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, RUNTIME_OPTION_CONTEXT' ||
    ', ACCOUNTING_DATE, OUTPUT_OPTION' ||
    ') SELECT' ||
    '  APPLICATION_ID, rg_report_requests_s.nextval, SYSDATE    , :user_id' ||
    ', :login_id  , SYSDATE    , :user_id   , :report_id' ||
    ', SEQUENCE   , FORM_SUBMISSION_FLAG, null, :id' ||
    ', null       , null       , ''N''      , ''C''' ||
    ', null       , null       , null       , ID_FLEX_CODE ' ||
    ', :coa_id    , null       , null ' ||
    ', null       , null       , CONTEXT    ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, RUNTIME_OPTION_CONTEXT' ||
    ', null, NVL(OUTPUT_OPTION, ''R'') ' ||
    'FROM RG_REPORT_REQUESTS@';

Line: 205

    'INSERT INTO RG_REPORTS (' ||
    '  APPLICATION_ID   , REPORT_ID    , LAST_UPDATE_DATE, LAST_UPDATED_BY ' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY , NAME, SECURITY_FLAG ' ||
    ', REPORT_TITLE, ROW_SET_ID, COLUMN_SET_ID, ROUNDING_OPTION ' ||
    ', OUTPUT_OPTION , CONTENT_SET_ID , ROW_ORDER_ID ' ||
    ', PARAMETER_SET_ID , UNIT_OF_MEASURE_ID, ID_FLEX_CODE , STRUCTURE_ID '||
    ', SEGMENT_OVERRIDE , OVERRIDE_ALC_LEDGER_CURRENCY , PERIOD_SET_NAME ' ||
    ', MINIMUM_DISPLAY_LEVEL, DESCRIPTION, CONTEXT       , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2       , ATTRIBUTE3   , ATTRIBUTE4      , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6       , ATTRIBUTE7   , ATTRIBUTE8      , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10      , ATTRIBUTE11  , ATTRIBUTE12     , ATTRIBUTE13' ||
    ', ATTRIBUTE14      , ATTRIBUTE15  , REPORT_DISPLAY_SET_ID        ' ||
    ') SELECT' ||
    '  APPLICATION_ID   , :id          , SYSDATE         , :user_id' ||
    ', :login_id        , SYSDATE      , :user_id , NAME , ''N'' ' ||
    ', REPORT_TITLE     , :row_set_id  , :column_set_id  , ROUNDING_OPTION'||
    ', NVL(OUTPUT_OPTION,''R''), :content_set_id, :row_order_id ' ||
    ', :parameter_set_id, :currency_code , ID_FLEX_CODE  , :coa_id ' ||
    ', :segment_override, :override_alc_ledger_currency  , PERIOD_SET_NAME ' ||
    ', MINIMUM_DISPLAY_LEVEL, DESCRIPTION, CONTEXT       , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2       , ATTRIBUTE3   , ATTRIBUTE4      , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6       , ATTRIBUTE7   , ATTRIBUTE8      , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10      , ATTRIBUTE11  , ATTRIBUTE12     , ATTRIBUTE13' ||
    ', ATTRIBUTE14      , ATTRIBUTE15  , :display_set_id ' ||
    'FROM RG_REPORTS@';

Line: 232

    'INSERT INTO RG_REPORT_SETS (' ||
    '  APPLICATION_ID, REPORT_SET_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, NAME, SECURITY_FLAG ' ||
    ', ID_FLEX_CODE,PERIOD_TYPE, PERIOD_NAME, STRUCTURE_ID' ||
    ', DESCRIPTION, CONTEXT    , ATTRIBUTE1 , ATTRIBUTE2  ' ||
    ', ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6  ' ||
    ', ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 ' ||
    ', ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14 ' ||
    ', ATTRIBUTE15, UNIT_OF_MEASURE_ID' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id     , SYSDATE    , :user_id    ' ||
    ', :login_id  , SYSDATE    , :user_id   , NAME        , ''N'' ' ||
    ', ID_FLEX_CODE,PERIOD_TYPE, PERIOD_NAME, :coa_id     ' ||
    ', DESCRIPTION, CONTEXT    , ATTRIBUTE1 , ATTRIBUTE2  ' ||
    ', ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6  ' ||
    ', ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 ' ||
    ', ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14 ' ||
    ', ATTRIBUTE15, UNIT_OF_MEASURE_ID ' ||
    'FROM RG_REPORT_SETS@';

Line: 253

    'INSERT INTO RG_ROW_ORDERS (' ||
    '  APPLICATION_ID   , ROW_ORDER_ID , LAST_UPDATE_DATE, LAST_UPDATED_BY' ||
    ', LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY      , NAME        ' ||
    ', SECURITY_FLAG    , ROW_RANK_TYPE, ID_FLEX_CODE    , STRUCTURE_ID' ||
    ', DESCRIPTION      , COLUMN_NUMBER, COLUMN_NAME     , CONTEXT ' ||
    ', ATTRIBUTE1       , ATTRIBUTE2   , ATTRIBUTE3      , ATTRIBUTE4  ' ||
    ', ATTRIBUTE5       , ATTRIBUTE6   , ATTRIBUTE7      , ATTRIBUTE8  ' ||
    ', ATTRIBUTE9       , ATTRIBUTE10  , ATTRIBUTE11     , ATTRIBUTE12 ' ||
    ', ATTRIBUTE13      , ATTRIBUTE14  , ATTRIBUTE15 ' ||
    ') SELECT ' ||
    '  APPLICATION_ID   , :id          , SYSDATE         , :user_id    ' ||
    ', :login_id        , SYSDATE      , :user_id        , NAME        ' ||
    ', ''N''            , ROW_RANK_TYPE, ID_FLEX_CODE    , :coa_id     ' ||
    ', DESCRIPTION      , COLUMN_NUMBER, :column_name    , CONTEXT     ' ||
    ', ATTRIBUTE1       , ATTRIBUTE2   , ATTRIBUTE3      , ATTRIBUTE4  ' ||
    ', ATTRIBUTE5       , ATTRIBUTE6   , ATTRIBUTE7      , ATTRIBUTE8  ' ||
    ', ATTRIBUTE9       , ATTRIBUTE10  , ATTRIBUTE11     , ATTRIBUTE12 ' ||
    ', ATTRIBUTE13      , ATTRIBUTE14  , ATTRIBUTE15 ' ||
    'FROM RG_ROW_ORDERS@';

Line: 274

    'INSERT INTO RG_ROW_SEGMENT_SEQUENCES (' ||
    '  APPLICATION_ID  , ROW_ORDER_ID    , ROW_SEGMENT_SEQUENCE_ID' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY , LAST_UPDATE_LOGIN' ||
    ', CREATION_DATE   , CREATED_BY      , SEGMENT_SEQUENCE ' ||
    ', SEG_ORDER_TYPE  , SEG_DISPLAY_TYPE, STRUCTURE_ID     ' ||
    ', SEGMENT_NAME    , SEGMENT_WIDTH   , CONTEXT    , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2      , ATTRIBUTE3      , ATTRIBUTE4 , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6      , ATTRIBUTE7      , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10     , ATTRIBUTE11     , ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14     , ATTRIBUTE15     , APPLICATION_COLUMN_NAME ' ||
    ') SELECT' ||
    '  APPLICATION_ID  , :id           , rg_row_segment_sequences_s.nextval' ||
    ', sysdate         , :user_id        , :login_id' ||
    ', sysdate         , :user_id        , SEGMENT_SEQUENCE' ||
    ', SEG_ORDER_TYPE  , SEG_DISPLAY_TYPE, :coa_id  ' ||
    ', SEGMENT_NAME    , SEGMENT_WIDTH   , CONTEXT    , ATTRIBUTE1 ' ||
    ', ATTRIBUTE2      , ATTRIBUTE3      , ATTRIBUTE4 , ATTRIBUTE5 ' ||
    ', ATTRIBUTE6      , ATTRIBUTE7      , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10     , ATTRIBUTE11     , ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14     , ATTRIBUTE15     , APPLICATION_COLUMN_NAME ' ||
    'FROM RG_ROW_SEGMENT_SEQUENCES@';

Line: 497

  SQLString    VARCHAR2(700) := 'SELECT name FROM ';

Line: 860

    SQLString := 'SELECT ref_table.taxonomy_alias '||
               'FROM RG_REPORT_AXIS_SETS'||'@'||G_LinkName||' main_table,' ||
               ' RG_XBRL_TAXONOMIES' || '@'|| G_LinkName || ' ref_table ' ||
               'WHERE main_table.name' || '='|| ValueString ||
               ' AND main_table.taxonomy_id = ref_table.taxonomy_id';

Line: 883

    SQLString := 'SELECT taxonomy_id ' ||
               'FROM   rg_xbrl_taxonomies ' ||
               'WHERE  taxonomy_alias = ' || ValueString;

Line: 898

    SQLString := 'SELECT taxonomy_id ' ||
               'FROM   rg_xbrl_taxonomies ' ||
               'WHERE  taxonomy_alias = ' || ValueString;

Line: 907

  SQLString := 'SELECT axis_set_id ' ||
               'FROM   rg_report_axis_sets ' ||
               'WHERE  name = ''' || AdjustedName || '''' ||
               'AND    axis_set_type = ''' || AxisSetType || ''''||
               'AND    ((application_id = 168)' ||
               '  OR    (application_id = ' || TO_CHAR(G_ApplId) || '))';

Line: 917

    /* Component doesn't exist in target db. Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORT_AXIS_SETS_S');

Line: 948

    RG_XFER_UTILS_PKG.insert_rows(SQLString, TargetId, UseCOAId => FALSE);

Line: 958

    /* New component - insert into the list of components copied */
    IF (ComponentType = 'RG_ROW_SET') THEN
      RG_XFER_UTILS_PKG.insert_into_list(
        RowSetList, RowSetCount, ComponentName);

Line: 972

      RG_XFER_UTILS_PKG.insert_into_list(
        ColumnSetList, ColumnSetCount, ComponentName);

Line: 1171

  SQLString := 'SELECT content_set_id ' ||
               'FROM   rg_report_content_sets ' ||
               'WHERE  name = ''' || AdjustedName || '''' ||
               'AND    application_id = ' || TO_CHAR(G_ApplId);

Line: 1178

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORT_CONTENT_SETS_S');

Line: 1185

    RG_XFER_UTILS_PKG.insert_rows(
      ContentSetsString || G_LinkName ||
        ' WHERE content_set_id = ' || TO_CHAR(SourceId),
      TargetId, UseCOAId => TRUE);

Line: 1193

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      ContentSetList, ContentSetCount, ComponentName);

Line: 1329

  SQLString := 'SELECT row_order_id  ' ||
               'FROM   rg_row_orders ' ||
               'WHERE  name = ''' || AdjustedName || '''' ||
               'AND    application_id = ' || TO_CHAR(G_ApplId);

Line: 1336

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_ROW_ORDERS_S');

Line: 1346

                      'SELECT column_name FROM rg_row_orders@'|| G_LinkName ||
                        ' WHERE row_order_id='||TO_CHAR(SourceId),
                      30);

Line: 1362

        /* select the column name */
        ColumnName := 'COLUMN_NAME';

Line: 1369

    /* Substitute column_name token and insert row */
    SQLString := RowOrdersString || G_LinkName ||
                   ' WHERE row_order_id = ' || TO_CHAR(SourceId);

Line: 1376

    RG_XFER_UTILS_PKG.insert_rows(SQLString, TargetId, UseCOAId=> TRUE);

Line: 1378

    /* Insert detail rows */
    RG_XFER_UTILS_PKG.insert_rows(
      RowSegmentSequencesString || G_LinkName ||
        ' WHERE row_order_id = ' || TO_CHAR(SourceId),
      TargetId, UseCOAId => TRUE);

Line: 1384

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      RowOrderList, RowOrderCount, ComponentName);

Line: 1504

  SQLString := 'SELECT report_display_set_id ' ||
               'FROM   rg_report_display_sets ' ||
               'WHERE  name = ''' || AdjustedName || '''';

Line: 1584

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORT_DISPLAY_SETS_S');

Line: 1598

    RG_XFER_UTILS_PKG.insert_rows(SQLString, TargetId, UseCOAId=> FALSE);

Line: 1603

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      DisplaySetList, DisplaySetCount, ComponentName);

Line: 1653

 *        database and insert them into the target database. We need to
 *        process one detail record at a time to check for the existence
 *        of display groups. If a display group does not exist then copy
 *        the display group from the source database. If there is an error
 *        copying the display group, then omit the display group from the
 *        detail record.
 *
 * History:
 *   10/17/95   S Rahman   Created.
 */
PROCEDURE copy_display_set_details(
            SourceDisplaySetId NUMBER,
            TargetDisplaySetId NUMBER) IS
  CursorId     INTEGER;

Line: 1687

                 'SELECT report_display_id FROM rg_report_displays@' ||
                   G_LinkName || ' WHERE report_display_set_id =' ||
                   TO_CHAR(SourceDisplaySetId),
                 DBMS_SQL.v7);

Line: 1780

      /* Insert the row */
      SQLString := DisplaysString || G_LinkName ||
                     ' WHERE report_display_id = ' || TO_CHAR(DisplayId);

Line: 1789

      RG_XFER_UTILS_PKG.insert_rows(
        SQLString, TargetDisplaySetId, UseCOAId=> FALSE);

Line: 1860

  SQLString := 'SELECT report_display_group_id ' ||
               'FROM   rg_report_display_groups ' ||
               'WHERE  name = ''' || AdjustedName || '''';

Line: 1940

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORT_DISPLAY_GROUPS_S');

Line: 1954

    RG_XFER_UTILS_PKG.insert_rows(SQLString, TargetId, UseCOAId=> FALSE);

Line: 1956

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      DisplayGroupList, DisplayGroupCount, ComponentName);

Line: 2103

  SQLString := 'SELECT report_id ' ||
               'FROM   rg_reports ' ||
               'WHERE  name = ''' || AdjustedName || ''' ' ||
               'AND    application_id = ' || TO_CHAR(G_ApplId);

Line: 2316

                     'SELECT segment_override FROM rg_reports@' ||
                      G_LinkName || ' WHERE report_id = ' ||
                      TO_CHAR(SourceId), 800);

Line: 2320

                     'SELECT override_alc_ledger_currency FROM rg_reports@' ||
                      G_LinkName || ' WHERE report_id = ' ||
                      TO_CHAR(SourceId), 15);

Line: 2325

                     'SELECT concatenated_segment_delimiter' ||
                     ' FROM fnd_id_flex_structures@' ||
                      G_LinkName || ' f, rg_reports@' || G_LinkName || ' r' ||
                     ' WHERE f.application_id = r.application_id' ||
                     ' AND   f.id_flex_code = r.id_flex_code' ||
                     ' AND   f.id_flex_num = r.structure_id' ||
                     ' AND   report_id = ' || TO_CHAR(SourceId), 1);

Line: 2364

                      'SELECT unit_of_measure_id FROM rg_reports@'||
                        G_LinkName || ' WHERE report_id='||TO_CHAR(SourceId),
                      15);

Line: 2409

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORTS_S');

Line: 2435

    RG_XFER_UTILS_PKG.insert_rows(SQLString, TargetId, UseCOAId=> TRUE);

Line: 2437

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      ReportList, ReportCount, ComponentName);

Line: 2568

                 'SELECT par.data_type, par.parameter_id, ' ||
                   'par.parameter_set_id, par.entered_currency, '||
                   'par.ledger_currency, ' ||
                   'par.parameter_num FROM rg_report_parameters@' ||
                   G_LinkName || ' par, rg_reports@' || G_LinkName ||
                   ' rp WHERE par.parameter_set_id = rp.parameter_set_id '||
                   'AND rp.report_id =' || TO_CHAR(ReportId),
                 DBMS_SQL.v7);

Line: 2691

        /* Insert the row */
        SQLString := ReportParametersString || G_LinkName ||
                     ' WHERE parameter_set_id = ' ||
                         TO_CHAR(SourceParameterSetId) ||
                     ' AND data_type = ''' || DataType || '''' ||
                     ' AND parameter_num = ' || TO_CHAR(ParameterNum);

Line: 2701

        RG_XFER_UTILS_PKG.insert_rows(
          SQLString, TargetParameterSetId, UseCOAId=> FALSE);

Line: 2792

  SQLString := 'SELECT report_set_id  ' ||
               'FROM   rg_report_sets ' ||
               'WHERE  name = ''' || AdjustedName || '''' ||
               'AND    application_id = ' || TO_CHAR(G_ApplId);

Line: 2799

    /* Insert data into table */
    TargetId := RG_XFER_UTILS_PKG.get_new_id('RG_REPORT_SETS_S');

Line: 2806

    RG_XFER_UTILS_PKG.insert_rows(
      ReportSetsString || G_LinkName ||
        ' WHERE report_set_id = ' || TO_CHAR(SourceId),
      TargetId, UseCOAId=> TRUE);

Line: 2813

    /* New component - insert into the list of components copied */
    RG_XFER_UTILS_PKG.insert_into_list(
      ReportSetList, ReportSetCount, ComponentName);

Line: 2891

                 'SELECT report_request_id FROM rg_report_requests@' ||
                   G_LinkName || ' WHERE report_set_id =' ||
                   TO_CHAR(SourceReportSetId),
                 DBMS_SQL.v7);

Line: 2943

        /* Insert the row */
        SQLString := ReportRequestsString || G_LinkName ||
                       ' WHERE report_request_id = '||TO_CHAR(ReportRequestId);

Line: 2950

        RG_XFER_UTILS_PKG.insert_rows(
          SQLString, TargetReportSetId, UseCOAId=>TRUE);

Line: 3032

  SQLString := 'SELECT taxonomy_id ' ||
               'FROM   rg_xbrl_taxonomies ' ||
               'WHERE  taxonomy_alias = ' || ValueString;

Line: 3044

  SQLString := 'SELECT DISTINCT tax.taxonomy_id,tax.taxonomy_alias '||
               'FROM RG_XBRL_TAXONOMIES'||'@'|| G_LinkName || ' tax,' ||
               ' RG_XBRL_ELEMENTS'||'@'|| G_LinkName || ' elm,' ||
               ' RG_XBRL_MAP_ELEMENTS'||'@'|| G_LinkName || ' map ' ||
               'WHERE map.element_id = elm.element_id AND ' ||
               ' elm.taxonomy_id = tax.taxonomy_id AND ' ||
               ' map.enabled_flag = ''Y'' AND ' ||
               ' map.taxonomy_id = '|| to_char(parent_tax_id) || ' AND ' ||
               ' tax.taxonomy_id <> ' || to_char(parent_tax_id);

Line: 3088

    'INSERT INTO RG_XBRL_TAXONOMIES (' ||
    ' TAXONOMY_ID, TAXONOMY_ALIAS, TAXONOMY_NAME,  ' ||
    ' TAXONOMY_DESCR, TAXONOMY_URL, TAXONOMY_IMPORT_FLAG, ' ||
    ' CREATION_DATE, CREATED_BY, ' ||
    ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
    ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
    ' taxonomy_alias, taxonomy_name, ' ||
    ' taxonomy_descr, taxonomy_url, taxonomy_import_flag, ' ||
    ' SYSDATE,' || to_char(l_user_id) || ', ' ||
    ' SYSDATE,' || to_char(l_user_id) || ', ' ||
    to_char(l_login_id) || ' ' ||
    'FROM RG_XBRL_TAXONOMIES@' || G_LinkName ||
    ' WHERE taxonomy_id = ' || to_char(parent_tax_id);

Line: 3111

    'SELECT ' ||
    ' element_identifier, ' ||
    ' element_name, element_type, element_group, ' ||
    ' element_descr, element_label, parent_identifier, ' ||
    ' has_child_flag, has_parent_flag, hierarchy_level ' ||
    'FROM RG_XBRL_ELEMENTS@' || G_LinkName ||
    ' WHERE taxonomy_id = ' || to_char(parent_tax_id);

Line: 3154

        INSERT INTO RG_XBRL_ELEMENTS (
        TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
        ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,
        ELEMENT_DESCR, ELEMENT_LABEL, PARENT_IDENTIFIER,
        PARENT_ID, HAS_CHILD_FLAG, HAS_PARENT_FLAG, HIERARCHY_LEVEL,
        CREATION_DATE, CREATED_BY,
        LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
        VALUES (
        dest_taxonomy_id,cur_elem_id,src_element_identifier,
        src_element_name,src_element_type,src_element_group,
        src_element_descr,src_element_label,src_parent_identifier,
        NULL,src_has_child_flag,src_has_parent_flag,src_hierarchy_level,
        SYSDATE,l_user_id,SYSDATE,l_user_id,l_login_id);

Line: 3177

    'INSERT INTO RG_XBRL_MAP_ELEMENTS ('||
    ' TAXONOMY_ID, ELEMENT_ID, ENABLED_FLAG,' ||
    ' CREATION_DATE, CREATED_BY,' ||
    ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
    ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
    ' element_id, ''Y'',' ||
    ' SYSDATE,' || to_char(l_user_id) || ',' ||
    ' SYSDATE,' || to_char(l_user_id) || ',' || to_char(l_login_id) ||
    ' FROM RG_XBRL_ELEMENTS ' ||
    ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);

Line: 3215

      SQLString := 'SELECT taxonomy_id ' ||
                   'FROM   rg_xbrl_taxonomies ' ||
                   'WHERE  taxonomy_alias = ' || ValueString;

Line: 3231

        'INSERT INTO RG_XBRL_TAXONOMIES (' ||
        ' TAXONOMY_ID, TAXONOMY_ALIAS, TAXONOMY_NAME,' ||
        ' TAXONOMY_DESCR, TAXONOMY_URL, TAXONOMY_IMPORT_FLAG,' ||
        ' CREATION_DATE, CREATED_BY,' ||
        ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
        ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
        ' taxonomy_alias, taxonomy_name,' ||
        ' taxonomy_descr, taxonomy_url, taxonomy_import_flag,' ||
        ' SYSDATE,' || TO_CHAR(l_user_id) || ',' ||
        ' SYSDATE,' || TO_CHAR(l_user_id) || ',' || TO_CHAR(l_login_id) ||
        ' FROM RG_XBRL_TAXONOMIES@' || G_LinkName ||
        ' WHERE taxonomy_id = ' || to_char(parent_tax_id);

Line: 3254

        'SELECT ' ||
        ' element_identifier, element_name, element_type, element_group,' ||
        ' element_descr, element_label, parent_identifier,' ||
        ' has_child_flag, has_parent_flag, hierarchy_level' ||
        ' FROM RG_XBRL_ELEMENTS@' || G_LinkName ||
        ' WHERE taxonomy_id = ' || to_char(parent_tax_id);

Line: 3296

            INSERT INTO RG_XBRL_ELEMENTS (
            TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
            ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,
            ELEMENT_DESCR, ELEMENT_LABEL, PARENT_IDENTIFIER,
            PARENT_ID, HAS_CHILD_FLAG, HAS_PARENT_FLAG, HIERARCHY_LEVEL,
            CREATION_DATE, CREATED_BY,
            LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
            VALUES (
            dest_taxonomy_id,cur_elem_id,src_element_identifier,
            src_element_name,src_element_type,src_element_group,
            src_element_descr,src_element_label,src_parent_identifier,
            NULL,src_has_child_flag,src_has_parent_flag,src_hierarchy_level,
            SYSDATE,l_user_id,SYSDATE,l_user_id,l_login_id);

Line: 3319

        'INSERT INTO RG_XBRL_MAP_ELEMENTS (' ||
        ' TAXONOMY_ID, ELEMENT_ID, ENABLED_FLAG,' ||
        ' CREATION_DATE, CREATED_BY,' ||
        ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
        ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
        ' element_id, ''Y'',' ||
        ' SYSDATE,' || TO_CHAR(l_user_id) || ',' ||
        ' SYSDATE,' || TO_CHAR(l_user_id) || ',' || TO_CHAR(l_login_id) ||
        ' FROM RG_XBRL_ELEMENTS ' ||
        ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);

Line: 3339

      /* update rg_xbrl_map_elements for the parent with a child */

      RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, cur_tax_alias);

Line: 3344

      SQLString := 'SELECT taxonomy_id ' ||
                   'FROM   rg_xbrl_taxonomies ' ||
                   'WHERE  taxonomy_alias = ' || ValueString;

Line: 3351

      'INSERT INTO RG_XBRL_MAP_ELEMENTS (' ||
      ' TAXONOMY_ID, ELEMENT_ID, ENABLED_FLAG,' ||
      ' CREATION_DATE, CREATED_BY,' ||
      ' LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
      ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
      ' mel.element_id, mel.enabled_flag,' ||
      ' SYSDATE,' || TO_CHAR(l_user_id) || ',' ||
      ' SYSDATE,' || TO_CHAR(l_user_id) || ',' || TO_CHAR(l_login_id) ||
      ' FROM RG_XBRL_MAP_ELEMENTS mel' ||
      ' WHERE mel.taxonomy_id = ' || to_char(l_child_tax_id) || ' AND ' ||
      ' mel.element_id NOT IN ' ||
      '(SELECT map.element_id FROM RG_XBRL_MAP_ELEMENTS map ' ||
      'WHERE map.taxonomy_id = ' || to_char(dest_taxonomy_id) || ')';