APPS.JDR_UTILS SQL Statements

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

Line: 44

      SELECT path_type, path_seq INTO pathType, pathSeq
      FROM jdr_paths WHERE path_docid = docID;

Line: 265

  PROCEDURE deleteDocument(p_document VARCHAR2)
  IS
    docID    JDR_PATHS.PATH_DOCID%TYPE;

Line: 278

    dbms_output.put_line('Successfully deleted document ' || p_document || '.');

Line: 282

  PROCEDURE deleteEmptyCustomizations
  IS
    CURSOR c_docs IS
      SELECT path_docid
      FROM jdr_paths
      WHERE jdr_mds_internal.getDocumentName(path_docid)
            LIKE '%/customizations/%' AND
            path_type = 'DOCUMENT';

Line: 291

      SELECT comp_element
      FROM jdr_components
      WHERE comp_docid = docID;

Line: 296

      SELECT att_name
      FROM jdr_attributes
      WHERE att_comp_docid = docID AND
            att_comp_seq = compID;

Line: 376

  PROCEDURE deletePackage(p_package VARCHAR2)
  IS
    docID    JDR_PATHS.PATH_DOCID%TYPE;

Line: 389

    SELECT COUNT(*) INTO contents
    FROM jdr_paths
    WHERE path_owner_docid = docID;

Line: 394

      dbms_output.put_line('Error: Unable to delete ' || p_package ||
                           ' since it contains documents and/or packages.');

Line: 400

    dbms_output.put_line('Successfully deleted package ' || p_package || '.');

Line: 479

      SELECT
        atl_lang, atl_comp_ref, atl_name, atl_value
      FROM
        jdr_attributes_trans
      WHERE
        atl_comp_docid = p_docID
      ORDER BY
        atl_lang;

Line: 532

      SELECT
        jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
      FROM
        jdr_paths
      WHERE
        path_owner_docid = docid AND
        ((path_type = 'DOCUMENT' AND path_seq = -1) OR
         (path_type = 'PACKAGE' AND (path_seq = 0 OR path_seq = -1)));

Line: 543

      SELECT
        jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
      FROM
        (SELECT path_docid, path_type, path_seq
         FROM jdr_paths
         START WITH path_owner_docid = docid
         CONNECT BY PRIOR path_docid = path_owner_docid) paths
      WHERE
        (path_type = 'DOCUMENT' AND path_seq = -1) OR
        (path_type = 'PACKAGE' AND path_seq = 0) OR
        (path_type = 'PACKAGE' AND path_seq = -1 AND
         NOT EXISTS (SELECT * FROM jdr_paths
                     WHERE path_owner_docid = paths.path_docid));

Line: 628

      SELECT jdr_mds_internal.getDocumentName(path_docid)
      FROM jdr_paths, jdr_attributes
      WHERE path_docid   = att_comp_docid AND
            path_name    = pathName       AND
            att_comp_seq = 0              AND
            att_name     = 'customizes'   AND
            att_value    = docName;

Line: 684

      SELECT DISTINCT(atl_lang) FROM jdr_attributes_trans
      WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths
                               START WITH path_docid = docID
                               CONNECT BY PRIOR path_docid=path_owner_docid);

Line: 801

    DELETE FROM jdr_attributes_trans WHERE atl_comp_docid = docID;

Line: 814

      INSERT
        INTO jdr_attributes_trans
          (atl_comp_docid,
           atl_lang,
           atl_comp_ref,
           atl_name,
           atl_value)
        VALUES
          (docID,
           lang,
           NVL(p_translations(pos).compref, '.'),
           p_translations(pos).name,
           p_translations(pos).value);