APPS.JDR_MDS_INTERNAL SQL Statements

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

Line: 40

    SELECT
      comp_seq,
      comp_element,
      comp_level,
      comp_grouping,
      comp_id,
      comp_ref,
      comp_extends,
      comp_use,
      att_name,
      att_value
    FROM
      jdr_components, jdr_attributes
    WHERE
      comp_docid = docid AND
      comp_docid = att_comp_docid(+) AND
      comp_seq = att_comp_seq(+)
    ORDER BY
      comp_seq,
      att_comp_seq,
      att_seq;

Line: 65

    SELECT
      path_docid,
      path_name,
      path_type,
      path_seq,
      path_owner_docid,
      comp_seq,
      comp_element,
      comp_level,
      comp_grouping,
      comp_id,
      comp_ref,
      comp_extends,
      comp_use,
      att_name,
      att_value
    FROM
      jdr_paths, jdr_components, jdr_attributes
    WHERE
      path_docid IN
        (SELECT
           path_docid
         FROM
           jdr_paths
         START WITH
           path_docid = docID
         CONNECT BY PRIOR
           path_docid=path_owner_docid
        ) AND
      path_docid = comp_docid(+) AND
      comp_docid = att_comp_docid(+) AND
      comp_seq = att_comp_seq(+)
    ORDER BY
      path_seq,
      comp_seq,
      att_comp_seq,
      att_seq;

Line: 108

    SELECT
      atl_comp_docid,
      atl_comp_ref,
      atl_name,
      atl_value
    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) AND
      atl_lang = lang
    ORDER BY
      atl_comp_docid,
      atl_comp_ref;

Line: 332

    SELECT
      path_xml_version, path_xml_encoding
    INTO
      xml_version, xml_encoding
    FROM
      jdr_paths
    WHERE
      path_docid = docID;

Line: 410

    SELECT path_docid, path_type, path_seq
    INTO docID, pType, pSeq
    FROM jdr_paths
    WHERE path_name = pName AND path_owner_docid = ownerID;

Line: 472

      SELECT path_docid
      FROM jdr_paths
      WHERE path_name = packageName AND
            path_owner_docid = ownerID AND
            path_seq = -1 AND
            path_type = 'PACKAGE';

Line: 589

    SELECT jdr_document_id_s.NEXTVAL INTO docID FROM DUAL;

Line: 591

    INSERT INTO jdr_paths
      (PATH_NAME, PATH_DOCID, PATH_OWNER_DOCID, PATH_TYPE, PATH_SEQ,
       PATH_XML_VERSION, PATH_XML_ENCODING,
       CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN)
    VALUES
      (pathname, docID, ownerID, docType, pathSeq,
       xmlversion, xmlencoding,
       username, SYSDATE, username, SYSDATE, username);

Line: 623

        SELECT path_docid INTO docID
        FROM jdr_paths
        WHERE
          path_name = pathname AND
          path_owner_docid = ownerID AND
          path_type = docType AND
          path_seq = pathseq;

Line: 637

          SELECT count(*) INTO cnt
          FROM jdr_paths
          WHERE
            path_name = pathname AND
            path_owner_docid = ownerID;

Line: 666

  PROCEDURE deleteDocument(
    docID      JDR_PATHS.PATH_DOCID%TYPE,
    isDrop     BOOLEAN DEFAULT FALSE)
  IS
  BEGIN
    -- Delete the attributes of the document
    DELETE jdr_attributes WHERE att_comp_docid IN
      (SELECT path_docid FROM jdr_paths
       START WITH path_docid = docid
       CONNECT BY PRIOR path_docid=path_owner_docid);

Line: 678

    DELETE jdr_components WHERE comp_docid IN
      (SELECT path_docid FROM jdr_paths
       START WITH path_docid = docid
       CONNECT BY PRIOR path_docid=path_owner_docid);

Line: 700

      DELETE jdr_paths where path_docid IN
        (SELECT path_docid FROM jdr_paths
         START WITH path_docid = docid
         CONNECT BY PRIOR path_docid=path_owner_docid);

Line: 705

        UPDATE jdr_paths SET path_seq = -2
        WHERE path_seq > 0 AND path_docid IN
         (SELECT path_docid FROM jdr_paths
          START WITH path_docid = docid
          CONNECT BY PRIOR path_docid=path_owner_docid);

Line: 730

    jdr_mds_internal.deleteDocument(docID, TRUE);

Line: 1308

      SELECT path_type INTO mPathType FROM jdr_paths WHERE path_docid = docid;

Line: 1354

        SELECT att_value INTO baseLanguage FROM jdr_attributes
        WHERE att_comp_docid = docID AND
              att_name = 'xml:lang' AND
              att_comp_seq = 0;

Line: 1424

          SELECT
           source.att_value INTO source
          FROM
            jdr_components, jdr_attributes source, jdr_attributes custs
          WHERE
            source.att_comp_docid = r_trans.atl_comp_docid AND
            comp_docid = r_trans.atl_comp_docid AND
            custs.att_comp_docid = r_trans.atl_comp_docid AND
            source.att_name = r_trans.atl_name AND
            comp_seq = source.att_comp_seq AND
            comp_seq = custs.att_comp_seq AND
            (
              (
                custs.att_name = r_trans.atl_name AND
                (
                  comp_id = r_trans.atl_comp_ref OR
                  (comp_seq=0 AND r_trans.atl_comp_ref='.')
                )
              )
              OR
              (
                custs.att_name IN ('element') AND
                custs.att_value = r_trans.atl_comp_ref AND
                comp_element IN ('view', 'modify', 'move', 'insert')
              )
            );

Line: 1463

          SELECT comp_seq, comp_level INTO startSeq, startLevel
          FROM jdr_components
          WHERE comp_docid =  r_trans.atl_comp_docid AND
                comp_element = 'view' AND
                comp_id = viewID;

Line: 1470

          SELECT MAX(comp_seq) - 1 INTO endSeq
          FROM jdr_components
          WHERE comp_docid = r_trans.atl_comp_docid AND
                comp_seq > startSeq AND
                comp_level <= startLevel;

Line: 1476

          SELECT
            DISTINCT source.att_value INTO source
          FROM
            jdr_components, jdr_attributes source, jdr_attributes custs
          WHERE
            source.att_comp_docid = r_trans.atl_comp_docid AND
            comp_docid = r_trans.atl_comp_docid AND
            custs.att_comp_docid = r_trans.atl_comp_docid AND
            source.att_name = r_trans.atl_name AND
            comp_seq = source.att_comp_seq AND
            comp_seq = custs.att_comp_seq AND
            comp_seq >= startSeq AND
            (comp_seq <= endSeq OR endSeq IS NULL) AND
            comp_element IN ('view', 'modify', 'move', 'insert') AND
            --
            -- Either the viewCompRef is not null, indicating that the reference
            -- is not a top level component, in which case there must be
            -- an element attribute matching the component reference; or the

Line: 1506

                NOT EXISTS (SELECT att_name FROM jdr_attributes
                            WHERE  att_comp_docid = r_trans.atl_comp_docid AND
                                   att_comp_seq = comp_seq AND
                                   att_name = 'element')
              )
            );

Line: 1663

      SELECT path_docid, path_type
      INTO docID, pType
      FROM jdr_paths
      WHERE path_name = pathNames(pathLevel) AND path_owner_docid = ownerID;

Line: 1749

    SELECT  path_docid, path_seq INTO docid, seq
    FROM jdr_paths
    WHERE
      path_name = name AND
      path_owner_docid = ownerID AND
      path_type = docType;

Line: 1758

      UPDATE jdr_paths SET path_seq = pathSeq
      WHERE
        path_docid = docid;

Line: 1809

    SELECT path_name BULK COLLECT INTO pathNames
    FROM jdr_paths
    START WITH path_docid = docid
    CONNECT BY PRIOR path_owner_docid = path_docid
    ORDER BY LEVEL DESC;

Line: 1842

      SELECT path_owner_docid, path_seq
      INTO ownerID, pathSeq
      FROM jdr_paths
      WHERE path_docid = newDocID;

Line: 1918

        SELECT path_docid INTO tmpdocID
        FROM jdr_paths
        WHERE path_docid = docID
        FOR UPDATE NOWAIT;

Line: 1956

  FUNCTION prepareDocumentForInsert(
    username     VARCHAR2,
    fullPathName VARCHAR2,
    pathType     VARCHAR2,
    xmlversion   VARCHAR2,
    xmlencoding  VARCHAR2) RETURN NUMBER
  IS
    docID   jdr_paths.path_docid%TYPE;

Line: 1997

      SELECT path_seq INTO pathSeq FROM jdr_paths WHERE path_docid = docID;

Line: 2021

      UPDATE jdr_paths
      SET path_xml_version = xmlversion,
          path_xml_encoding = xmlencoding,
          last_updated_by = username,
          last_update_date = SYSDATE,
          last_update_login = username
      WHERE path_docid = docID;

Line: 2030

      deleteDocument(docID, FALSE);

Line: 2055

  FUNCTION prepareDocumentForInsert(
    username   VARCHAR2,
    pathname   VARCHAR2,
    ownerID    JDR_PATHS.PATH_OWNER_DOCID%TYPE,
    pathSeq    JDR_PATHS.PATH_SEQ%TYPE,
    pathType   JDR_PATHS.PATH_TYPE%TYPE) RETURN NUMBER
  IS
    docID  jdr_paths.path_docid%TYPE;

Line: 2073

      UPDATE jdr_paths
      SET last_updated_by = username,
          last_update_date = SYSDATE,
          last_update_login = username
      WHERE path_docid = docID;

Line: 2098

      SELECT att_comp_docid,
             att_comp_seq,
             att_seq,
             att_name
      FROM (SELECT path_docid
            FROM jdr_attributes, jdr_paths
            WHERE path_docid = att_comp_docid AND
                  path_name = baseName AND
                  att_comp_seq = 0 AND
                  att_name = 'customizes' AND
                  att_value = fullName) docids,
           jdr_attributes, jdr_components
      WHERE att_comp_docid = docids.path_docid AND
            att_comp_docid = comp_docid AND
            att_comp_seq = comp_seq AND
            att_name IN ('element', 'before', 'after', 'parent') AND
            att_value = compID AND
            comp_element IN ('view', 'modify', 'move', 'insert', 'criterion');

Line: 2120

      SELECT atl_comp_docid,
             atl_comp_ref
      FROM (SELECT path_docid
            FROM jdr_attributes, jdr_paths
            WHERE path_docid = att_comp_docid AND
                  path_name = baseName AND
                  att_comp_seq = 0 AND
                  att_name = 'customizes' AND
                  att_value = fullName) docids,
           jdr_attributes_trans
      WHERE atl_comp_docid = docids.path_docid AND
            (atl_comp_ref = compID OR atl_comp_ref like ':%.'||compID);

Line: 2136

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

Line: 2216

        UPDATE jdr_attributes SET att_value = newCompName
        WHERE att_comp_docid = docID AND
              att_comp_seq = attCompSeq AND
              att_seq = attSeq AND
              att_name = attName;

Line: 2244

          UPDATE jdr_attributes_trans SET atl_comp_ref = newCompRef
          WHERE atl_comp_docid = docID AND
                atl_comp_ref = oldCompRef;

Line: 2377

          UPDATE jdr_paths
          SET path_name = newBaseName,
              path_owner_docid = ownerID
          WHERE path_docid = docID;

Line: 2391

        UPDATE jdr_attributes
        SET att_value = newDocName
        WHERE att_comp_docid = docID AND
              att_comp_seq = 0 AND
              att_name = 'customizes' AND
              att_value = oldDocName;

Line: 2401

          UPDATE jdr_attributes
          SET att_value = REPLACE(newCustDocName, '/'||newBaseName)
          WHERE att_comp_docid = docID AND
                att_comp_seq = 0 AND
                att_name = 'package';

Line: 2430

    DELETE jdr_paths
    WHERE path_seq=-2 AND path_docid IN
      (SELECT path_docid FROM jdr_paths
       START WITH path_docid = docid
       CONNECT BY PRIOR path_docid=path_owner_docid);