APPS.JDR_DOCBUILDER SQL Statements

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

Line: 255

	              mAttributes.DELETE(j);

Line: 398

	          mGroupings.DELETE(i);

Line: 508

  PROCEDURE insertAttributes(p_docid NUMBER)
  IS
    i PLS_INTEGER;

Line: 513

	INSERT INTO jdr_attributes
	   (ATT_COMP_DOCID, ATT_COMP_SEQ, ATT_SEQ, ATT_NAME, ATT_VALUE)
	VALUES
	   (p_docid, attList1(i), attList2(i), attList3(i),attList4(i));

Line: 525

  PROCEDURE insertComponents(p_docid NUMBER)
  IS
    i PLS_INTEGER;

Line: 530

       INSERT INTO jdr_components
	  (COMP_DOCID, COMP_SEQ , COMP_LEVEL, COMP_GROUPING, COMP_ELEMENT,
	   COMP_ID, COMP_REF, COMP_EXTENDS, COMP_USE, COMP_COMMENT)
       VALUES
	  (p_docid, compList2(i), compList3(i), compList4(i), compList5(i),
	   compList6(i), compList7(i), compList8(i), compList9(i), compList10(i));

Line: 649

      SELECT path_docid INTO pkgDocId
        FROM jdr_paths
        WHERE jdr_mds_internal.getDocumentName(path_docid) = pkgName AND
              path_type = 'PACKAGE' AND
              path_seq  = 0;

Line: 697

  PROCEDURE deleteDocument(
      p_fullPathName VARCHAR2)
  IS
    docid    NUMBER;

Line: 708

      SELECT path_type INTO pathType
        FROM jdr_paths
        WHERE path_docid = docid;

Line: 768

	      compList1.DELETE;

Line: 769

	      compList2.DELETE;

Line: 770

	      compList3.DELETE;

Line: 771

	      compList4.DELETE;

Line: 772

	      compList5.DELETE;

Line: 773

	      compList6.DELETE;

Line: 774

	      compList7.DELETE;

Line: 775

	      compList8.DELETE;

Line: 776

	      compList9.DELETE;

Line: 777

	      compList10.DELETE;

Line: 781

        attList1.DELETE;

Line: 782

	      attList2.DELETE;

Line: 783

	      attList3.DELETE;

Line: 784

	      attList4.DELETE;

Line: 790

      	  db_docid := jdr_mds_internal.prepareDocumentForInsert('INTERNAL',
	  			 		                                                currDoc.fullPath,
		  					                                              'DOCUMENT',
			  				                                              '1.0',
				  			                                              'UTF-8');

Line: 802

            SELECT path_seq INTO docSeq
              FROM jdr_paths
              WHERE path_name = docName AND
                    path_owner_docid = currDoc.parentId;

Line: 810

              SELECT max(path_seq) INTO docSeq
                FROM jdr_paths
                WHERE path_owner_docid = currDoc.parentId;

Line: 816

          db_docid := jdr_mds_internal.prepareDocumentForInsert('INTERNAL',
                                                               docName,
                                                               currDoc.parentId,
                                                               docSeq,
                                                               'DOCUMENT');

Line: 824

            DELETE jdr_attributes WHERE att_comp_docid = db_docid;

Line: 825

            DELETE jdr_components WHERE comp_docid = db_docid;

Line: 828

	      -- Bulk Insert the components/attributes
	      insertComponents(db_docid);

Line: 830

	      insertAttributes(db_docid);