The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT path_type, path_seq INTO pathType, pathSeq
FROM jdr_paths WHERE path_docid = docID;
PROCEDURE deleteDocument(p_document VARCHAR2)
IS
docID JDR_PATHS.PATH_DOCID%TYPE;
dbms_output.put_line('Successfully deleted document ' || p_document || '.');
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';
SELECT comp_element
FROM jdr_components
WHERE comp_docid = docID;
SELECT att_name
FROM jdr_attributes
WHERE att_comp_docid = docID AND
att_comp_seq = compID;
PROCEDURE deletePackage(p_package VARCHAR2)
IS
docID JDR_PATHS.PATH_DOCID%TYPE;
SELECT COUNT(*) INTO contents
FROM jdr_paths
WHERE path_owner_docid = docID;
dbms_output.put_line('Error: Unable to delete ' || p_package ||
' since it contains documents and/or packages.');
dbms_output.put_line('Successfully deleted package ' || p_package || '.');
SELECT
atl_lang, atl_comp_ref, atl_name, atl_value
FROM
jdr_attributes_trans
WHERE
atl_comp_docid = p_docID
ORDER BY
atl_lang;
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)));
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));
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;
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);
DELETE FROM jdr_attributes_trans WHERE atl_comp_docid = docID;
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);