[Home] [Help]
36: pathType jdr_paths.path_type%TYPE;
37: pathSeq jdr_paths.path_seq%TYPE;
38: BEGIN
39: -- Get the ID of the document
40: docID := jdr_mds_internal.getDocumentID(p_document);
41:
42: -- Verify that we have found a document of the correct type
43: IF ((docID <> -1) AND (p_type <> 'ANY')) THEN
44: SELECT path_type, path_seq INTO pathType, pathSeq
273: RETURN;
274: END IF;
275:
276: -- Drop the document
277: jdr_mds_internal.dropDocument(docID);
278: dbms_output.put_line('Successfully deleted document ' || p_document || '.');
279: END;
280:
281: -- Deletes all empty customization documents from the repository
283: IS
284: CURSOR c_docs IS
285: SELECT path_docid
286: FROM jdr_paths
287: WHERE jdr_mds_internal.getDocumentName(path_docid)
288: LIKE '%/customizations/%' AND
289: path_type = 'DOCUMENT';
290: CURSOR c_comps(docID JDR_COMPONENTS.COMP_DOCID%TYPE) IS
291: SELECT comp_element
359: END IF;
360: IF attsIsEmpty THEN
361: -- This is an empty customization document
362: dbms_output.put_line('Deleting ' ||
363: jdr_mds_internal.getDocumentName(docID));
364: jdr_mds_internal.dropDocument(docID);
365: END IF;
366: END LOOP;
367: END;
360: IF attsIsEmpty THEN
361: -- This is an empty customization document
362: dbms_output.put_line('Deleting ' ||
363: jdr_mds_internal.getDocumentName(docID));
364: jdr_mds_internal.dropDocument(docID);
365: END IF;
366: END LOOP;
367: END;
368:
395: ' since it contains documents and/or packages.');
396: RETURN;
397: END IF;
398:
399: jdr_mds_internal.dropDocument(docID);
400: dbms_output.put_line('Successfully deleted package ' || p_package || '.');
401: END;
402:
403:
423: -- this will retrieve the first chunk of the document. If p_document is
424: -- null, then we are retrieving a subsequent chunk of the document.
425: --
426: -- It's a little ugly that we have to switch between INTEGERs and BOOLEANs,
427: -- but jdr_mds_internal.exportDocumentAsXML is called from JDBC and,
428: -- unfortunately, JDBC does not have support for BOOLEAN parameters, so
429: -- that's why we have to do the conversion.
430: chunk := jdr_mds_internal.exportDocumentAsXML(exportFinished,
431: p_document,
426: -- It's a little ugly that we have to switch between INTEGERs and BOOLEANs,
427: -- but jdr_mds_internal.exportDocumentAsXML is called from JDBC and,
428: -- unfortunately, JDBC does not have support for BOOLEAN parameters, so
429: -- that's why we have to do the conversion.
430: chunk := jdr_mds_internal.exportDocumentAsXML(exportFinished,
431: p_document,
432: formatted);
433:
434: p_exportFinished := (exportFinished = 1);
466: FUNCTION getDocumentName(
467: p_docid jdr_paths.path_docid%TYPE) RETURN VARCHAR2
468: IS
469: BEGIN
470: RETURN (jdr_mds_internal.getDocumentName(p_docid));
471: END;
472:
473:
474: -- Gets all of the translations of the specified document.
529: IS
530: -- Selects documents in the current directory
531: CURSOR c_docs(docid JDR_PATHS.PATH_DOCID%TYPE) IS
532: SELECT
533: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
534: FROM
535: jdr_paths
536: WHERE
537: path_owner_docid = docid AND
540:
541: -- Selects documents in the current directory, plus its children
542: CURSOR c_alldocs(docid JDR_PATHS.PATH_DOCID%TYPE) IS
543: SELECT
544: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
545: FROM
546: (SELECT path_docid, path_type, path_seq
547: FROM jdr_paths
548: START WITH path_owner_docid = docid
624: -- List the customizations for the specified document.
625: PROCEDURE listCustomizations(p_document VARCHAR2)
626: IS
627: CURSOR c(pathName VARCHAR2, docName VARCHAR2) IS
628: SELECT jdr_mds_internal.getDocumentName(path_docid)
629: FROM jdr_paths, jdr_attributes
630: WHERE path_docid = att_comp_docid AND
631: path_name = pathName AND
632: att_comp_seq = 0 AND
725: IF (p_maxLineSize > MAX_LINE_SIZE) THEN
726: maxLineSize := MAX_LINE_SIZE;
727: END IF;
728:
729: chunk := jdr_mds_internal.exportDocumentAsXML(p_document);
730:
731: IF chunk IS NULL THEN
732: dbms_output.put_line('Error: Could not find document ' || p_document);
733: ELSE
732: dbms_output.put_line('Error: Could not find document ' || p_document);
733: ELSE
734: printChunk(chunk, maxLineSize);
735: LOOP
736: chunk := jdr_mds_internal.exportDocumentAsXML(NULL);
737: EXIT WHEN chunk IS NULL;
738: printChunk(chunk, maxLineSize);
739: END LOOP;
740: END IF;
755: IF (p_maxLineSize > MAX_LINE_SIZE) THEN
756: maxLineSize := MAX_LINE_SIZE;
757: END IF;
758:
759: chunk := jdr_mds_internal.exportXLIFFDocument(exportFinished,
760: p_document,
761: p_language);
762:
763: IF chunk IS NULL THEN
764: dbms_output.put_line('Error: Could not find document ' || p_document);
765: ELSE
766: printChunk(chunk, maxLineSize);
767: WHILE (exportFinished = 0) LOOP
768: chunk := jdr_mds_internal.exportXLIFFDocument(exportFinished,
769: NULL,
770: NULL);
771: IF (chunk IS NOT NULL) THEN
772: printChunk(chunk, maxLineSize);
794: -- Create a savepoint in case of an exception
795: SAVEPOINT saveTranslations_1;
796:
797: -- Lock the document
798: jdr_mds_internal.lockDocument(docID, 100);
799:
800: -- Delete all of the translations
801: DELETE FROM jdr_attributes_trans WHERE atl_comp_docid = docID;
802: