APPS.RG_XBRL_PKG SQL Statements

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

Line: 31

  RG_XBRL_PKG.delete_taxonomy(p_full_tax_name	=> p_full_tax_name);

Line: 42

PROCEDURE delete_taxonomy(p_full_tax_name IN VARCHAR2)
IS
p_taxonomy_id NUMBER(15) := 0;

Line: 50

    SELECT taxonomy_id
    INTO p_taxonomy_id
    FROM RG_XBRL_TAXONOMIES
    WHERE taxonomy_name = p_full_tax_name AND
      ROWNUM = 1;

Line: 69

                      'RG_XBRL_PKG.delete_taxonomy',
                      t2        =>'ACTION',
                      v2        =>'Taxonomy name '
                                || p_full_tax_name
                                ||' does not exist');

Line: 82

    SELECT axis_set_id
    INTO l_axis_set_id
    FROM RG_REPORT_AXIS_SETS
    WHERE taxonomy_id = p_taxonomy_id AND
      axis_set_type = 'R' AND
      ROWNUM = 1;

Line: 102

                      'RG_XBRL_PKG.delete_taxonomy',
                      t2        =>'ACTION',
                      v2        =>'Taxonomy '
                                || p_full_tax_name
                                ||' is still used in a row set');

Line: 113

    SELECT 0
    INTO l_parent_flag
    FROM DUAL
    WHERE EXISTS
      (SELECT v1.taxonomy_id
       FROM rg_xbrl_taxonomies v1
       WHERE v1.taxonomy_id <> p_taxonomy_id AND
         p_taxonomy_id IN
         (SELECT DISTINCT v2.source_taxonomy_id
          FROM rg_xbrl_map_v v2
           WHERE v2.map_taxonomy_id = v1.taxonomy_id)
      );

Line: 145

                      'RG_XBRL_PKG.delete_taxonomy',
                      t2        =>'ACTION',
                      v2        =>'Taxonomy '
                                || p_full_tax_name
                                ||' is not a parent');

Line: 154

  DELETE FROM RG_XBRL_MAP_ELEMENTS
  WHERE taxonomy_id = p_taxonomy_id;

Line: 158

  DELETE FROM RG_XBRL_ELEMENTS
  WHERE taxonomy_id = p_taxonomy_id;

Line: 162

  DELETE FROM RG_XBRL_TAXONOMIES
  WHERE taxonomy_id = p_taxonomy_id;

Line: 166

END delete_taxonomy;

Line: 209

  SELECT directory_path
  INTO p_tax_dir
  FROM all_directories
  WHERE directory_name = 'XMLDIR'
  AND owner = 'SYS';

Line: 235

    SELECT taxonomy_id
    INTO l_taxonomy_id
    FROM RG_XBRL_TAXONOMIES
    WHERE taxonomy_url = l_url;

Line: 271

    SELECT RG_XBRL_TAXONOMY_S.NEXTVAL
    INTO p_taxonomy_id
    FROM dual;

Line: 277

    INSERT INTO RG_XBRL_TAXONOMIES
      (TAXONOMY_ID,TAXONOMY_ALIAS,TAXONOMY_NAME,TAXONOMY_URL,TAXONOMY_DESCR,
       TAXONOMY_IMPORT_FLAG,
       CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,LAST_UPDATE_DATE)
    VALUES (p_taxonomy_id, l_tax_file_name, p_full_tax_name,l_url,p_tax_descr,'N',
       l_user_id,l_user_id,l_login_id,l_date,l_date);

Line: 287

      insert_tax_clob(p_taxonomy_id, l_file_name, l_valid_import_str);

Line: 292

       update_lbl_clob(l_tax_file_name, p_taxonomy_id,l_file_name_l);

Line: 296

       update_dfn_clob(l_tax_file_name, p_taxonomy_id, l_file_name_d);

Line: 300

       update_flags(p_taxonomy_id);

Line: 307

PROCEDURE update_flags(p_taxonomy_id IN NUMBER)
IS
l_taxonomy_id NUMBER := 0;

Line: 312

  UPDATE RG_XBRL_ELEMENTS t2
  SET t2.parent_id =
    (SELECT t1.element_id
     FROM RG_XBRL_ELEMENTS t1
     WHERE t1.element_identifier = t2.parent_identifier AND
       t1.taxonomy_id = p_taxonomy_id)
  WHERE t2.taxonomy_id = p_taxonomy_id;

Line: 321

  UPDATE RG_XBRL_ELEMENTS
  SET has_parent_flag = 'Y'
  WHERE taxonomy_id = p_taxonomy_id AND
    parent_identifier IS NOT NULL;

Line: 327

  UPDATE RG_XBRL_ELEMENTS t2
  SET t2.has_child_flag = 'Y'
  WHERE t2.taxonomy_id = p_taxonomy_id AND
    t2.element_identifier IN
    (SELECT t1.parent_identifier
     FROM RG_XBRL_ELEMENTS t1
     WHERE t1.taxonomy_id = p_taxonomy_id);

Line: 336

  UPDATE RG_XBRL_ELEMENTS
  SET hierarchy_level = 3
  WHERE taxonomy_id = p_taxonomy_id AND
    (has_child_flag = 'Y' AND has_parent_flag = 'N');

Line: 342

  UPDATE RG_XBRL_ELEMENTS
  SET hierarchy_level = 1
  WHERE taxonomy_id = p_taxonomy_id AND
    (has_child_flag = 'N' AND has_parent_flag = 'Y');

Line: 348

  UPDATE RG_XBRL_ELEMENTS
  SET hierarchy_level = 2
  WHERE taxonomy_id = p_taxonomy_id AND
    (has_child_flag = 'Y' AND has_parent_flag = 'Y');

Line: 354

END update_flags;

Line: 435

          SELECT taxonomy_id
          INTO l_tax_id
          FROM RG_XBRL_TAXONOMIES
          WHERE taxonomy_url = l_namesp_str;

Line: 561

PROCEDURE insert_tax_clob(p_taxonomy_id IN NUMBER,
                          filename      IN VARCHAR2,
                          p_valid_str   IN VARCHAR2)
IS
xbfile bfile;

Line: 600

Insert_tax_err EXCEPTION;

Line: 792

          SELECT RG_XBRL_ELEMENTS_S.NEXTVAL
          INTO l_elem_id
          FROM dual;

Line: 796

          INSERT INTO RG_XBRL_ELEMENTS
            (taxonomy_id,element_id,
             element_identifier,element_descr,
             element_name,element_type,
             element_group,
             has_child_flag,has_parent_flag,hierarchy_level,
             CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
             CREATION_DATE,LAST_UPDATE_DATE)
          VALUES
            (p_taxonomy_id, l_elem_id,
             l_elem_xbrl_id, l_elem_descr,
             l_elem_name, l_elem_type,
             l_elem_group,
             'N', 'N', 0,
             l_user_id,l_user_id,l_login_id,
             l_date,l_date);

Line: 813

          INSERT INTO RG_XBRL_MAP_ELEMENTS
            (taxonomy_id,element_id,
             enabled_flag,
             CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
             CREATION_DATE,LAST_UPDATE_DATE)
          VALUES
            (p_taxonomy_id, l_elem_id,
             'Y',
             l_user_id,l_user_id,l_login_id,
             l_date,l_date);

Line: 849

      SELECT taxonomy_id
      INTO l_source_tax_id
      FROM RG_XBRL_TAXONOMIES
      WHERE taxonomy_url = l_cur_url;

Line: 861

                        'RG_XBRL_PKG.insert_tax_clob',
                        t2        =>'ACTION',
                        v2        =>'Import Taxonomy '
                                  || l_cur_url ||
                                  ' was not loaded');

Line: 866

        RAISE Insert_tax_err;

Line: 869

        INSERT INTO RG_XBRL_MAP_ELEMENTS
          (taxonomy_id,element_id,
           enabled_flag,
           CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
           CREATION_DATE,LAST_UPDATE_DATE)
          ( SELECT p_taxonomy_id,
            mel.element_id,mel.enabled_flag,
            mel.CREATED_BY,mel.LAST_UPDATED_BY,mel.LAST_UPDATE_LOGIN,
            mel.CREATION_DATE,mel.LAST_UPDATE_DATE
            FROM RG_XBRL_MAP_ELEMENTS mel
            WHERE mel.taxonomy_id = l_source_tax_id AND
              mel.element_id NOT IN
              (SELECT map.element_id
               FROM RG_XBRL_MAP_ELEMENTS map
               WHERE map.taxonomy_id = p_taxonomy_id)
          );

Line: 886

        UPDATE RG_XBRL_TAXONOMIES
        SET TAXONOMY_IMPORT_FLAG = 'Y'
        WHERE taxonomy_id = p_taxonomy_id;

Line: 905

END insert_tax_clob;

Line: 909

PROCEDURE update_lbl_clob(p_tax_name    IN VARCHAR2,
                          p_taxonomy_id IN NUMBER,
                          filename      IN VARCHAR2)
IS
xbfile bfile;

Line: 939

  SELECT element_id,
         element_identifier,
         element_label
  FROM RG_XBRL_ELEMENTS t1
  WHERE t1.taxonomy_id = tax_id
  FOR UPDATE;

Line: 1013

      UPDATE RG_XBRL_ELEMENTS
        SET element_label = l_label
        WHERE CURRENT OF tax_el_storage;

Line: 1020

END update_lbl_clob;

Line: 1024

PROCEDURE update_dfn_clob(p_tax_name    IN VARCHAR2,
                          p_taxonomy_id IN NUMBER,
                          filename      IN VARCHAR2)
IS
xbfile bfile;

Line: 1050

  SELECT element_id,
         element_identifier,
         parent_identifier
  FROM RG_XBRL_ELEMENTS t1
  WHERE t1.taxonomy_id = tax_id
  FOR UPDATE;

Line: 1099

      UPDATE RG_XBRL_ELEMENTS
        SET parent_identifier = l_element_defn_parent
        WHERE CURRENT OF tax_el_storage;

Line: 1106

END update_dfn_clob;