APPS.JDR_CUSTOM_INTERNAL SQL Statements

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

Line: 45

      SELECT att_seq, att_name, att_value
      FROM jdr_attributes
      WHERE att_comp_docid = docID AND
            att_comp_seq = compSeq;

Line: 79

      INSERT INTO jdr_attributes
        (att_comp_docid, att_comp_seq, att_seq, att_name, att_value)
      VALUES
        (pageCustDocID, pageCompSeq,
         attRec.att_seq, attRec.att_name, attRec.att_value);

Line: 94

      INSERT INTO jdr_attributes
        (att_comp_docid, att_comp_seq, att_seq, att_name, att_value)
      VALUES
        (pageCustDocID, pageCompSeq,
         nextAttSequence, 'element', extendingRegion);

Line: 123

      SELECT comp_seq, comp_level, comp_grouping, comp_element, comp_id
      FROM jdr_components
      WHERE comp_docid = docID AND
            comp_seq >= startSeq AND
            comp_seq <= endSeq;

Line: 160

      INSERT INTO jdr_components
        (comp_docid, comp_seq, comp_level, comp_grouping, comp_element, comp_id)
      VALUES
        (pageCustDocID, pageSeq, compRec.comp_level,
         compRec.comp_grouping, compRec.comp_element, compRec.comp_id);

Line: 209

    SELECT MAX(comp_seq) + 1 INTO pageStartSeq
    FROM jdr_components
    WHERE comp_docid = pageCustDocID;

Line: 214

    SELECT MAX(comp_seq) INTO regionEndSeq
    FROM jdr_components
    WHERE comp_docid = regionCustDocID;

Line: 250

    SELECT comp_seq, comp_level INTO regionStartSeq, regionCompLevel
    FROM jdr_components
    WHERE comp_docid = regionCustDocID AND
          comp_element = 'view' AND
          comp_id = viewID;

Line: 257

    SELECT MIN(comp_seq) - 1  INTO regionEndSeq
    FROM jdr_components
    WHERE comp_docid =  regionCustDocID AND
          comp_seq > regionStartSeq AND
          comp_level <= regionCompLevel;

Line: 266

      SELECT MAX(comp_seq) INTO regionEndSeq
      FROM jdr_components
      WHERE comp_docid = regionCustDocID;

Line: 275

      SELECT comp_seq, comp_level INTO pageStartSeq, pageCompLevel
      FROM jdr_components
      WHERE comp_docid = pageCustDocID AND
            comp_element = 'view' AND
            comp_id = viewID;

Line: 282

      SELECT MIN(comp_seq) - 1  INTO pageEndSeq
      FROM jdr_components
      WHERE comp_docid =  pageCustDocID AND
            comp_seq > pageStartSeq AND
            comp_level <= pageCompLevel;

Line: 291

        SELECT MAX(comp_seq) INTO pageEndSeq
        FROM jdr_components
        WHERE comp_docid = pageCustDocID;

Line: 300

        SELECT MAX(comp_seq) + 1 INTO pageStartSeq
        FROM jdr_components
        WHERE comp_docid = pageCustDocID;

Line: 323

      UPDATE jdr_components
      SET comp_seq = comp_seq + componentsAdded
      WHERE comp_docid = pageCustDocID AND
            comp_seq > pageEndSeq;

Line: 329

      UPDATE jdr_attributes
      SET att_comp_seq = att_comp_seq + componentsAdded
      WHERE att_comp_docid = pageCustDocID AND
            att_comp_seq > pageEndSeq;

Line: 649

              SELECT  att_value INTO isActive
                FROM  jdr_attributes
                WHERE att_comp_docid = custDocID AND
                      att_comp_seq   = 0         AND
                      att_name = 'MDSActiveDoc';

Line: 689

     SELECT  atl_lang, atl_comp_ref, atl_name, atl_value
     FROM jdr_attributes_trans
     WHERE atl_comp_docid = docID;

Line: 694

      SELECT comp_id
      FROM jdr_components
      WHERE comp_docid = docID and
            comp_element = 'view'
      ORDER BY comp_seq;

Line: 775

        SELECT 'x' INTO tempStr FROM DUAL WHERE EXISTS (
          SELECT *
          FROM jdr_components, jdr_attributes
          WHERE comp_docid = pageCustDocID AND
                att_comp_docid = pageCustDocID AND
                att_comp_seq = comp_seq AND
                comp_element IN ('view', 'modify', 'move', 'insert', 'criterion') AND
                att_name IN ('element', 'before', 'after', 'parent') AND
                (
                  att_value = extendingRegion OR
                  att_value LIKE extendingRegion||'.%' OR
                  att_value IN (SELECT comp_id
                                FROM jdr_components
                                WHERE comp_docid = regionBaseDocID AND
                                      comp_id IS NOT NULL)
                )
          );

Line: 834

      SELECT comp_grouping INTO custType
      FROM jdr_components
      WHERE comp_docid = regionCustDocID AND
            comp_seq = 1;

Line: 893

        INSERT INTO jdr_attributes_trans
          (atl_comp_docid, atl_lang, atl_comp_ref, atl_name, atl_value)
        VALUES
          (pageCustDocID,
           tranRec.atl_lang, tranRec.atl_comp_ref,
           tranRec.atl_name, tranRec.atl_value);

Line: 903

    jdr_mds_internal.deleteDocument(regionCustDocID, TRUE);

Line: 905

    DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;

Line: 940

      SELECT jdr_mds_internal.getDocumentName(path_docid)
      FROM jdr_paths
      WHERE path_type = 'DOCUMENT' AND
            path_name = pathName   AND
            path_seq  = -1         AND
            jdr_mds_internal.getDocumentName(path_docid) like custDocLike;