The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
SELECT
path_xml_version, path_xml_encoding
INTO
xml_version, xml_encoding
FROM
jdr_paths
WHERE
path_docid = docID;
SELECT path_docid, path_type, path_seq
INTO docID, pType, pSeq
FROM jdr_paths
WHERE path_name = pName AND path_owner_docid = ownerID;
SELECT path_docid
FROM jdr_paths
WHERE path_name = packageName AND
path_owner_docid = ownerID AND
path_seq = -1 AND
path_type = 'PACKAGE';
SELECT jdr_document_id_s.NEXTVAL INTO docID FROM DUAL;
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);
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;
SELECT count(*) INTO cnt
FROM jdr_paths
WHERE
path_name = pathname AND
path_owner_docid = ownerID;
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);
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);
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);
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);
jdr_mds_internal.deleteDocument(docID, TRUE);
SELECT path_type INTO mPathType FROM jdr_paths WHERE path_docid = docid;
SELECT att_value INTO baseLanguage FROM jdr_attributes
WHERE att_comp_docid = docID AND
att_name = 'xml:lang' AND
att_comp_seq = 0;
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')
)
);
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;
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;
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
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')
)
);
SELECT path_docid, path_type
INTO docID, pType
FROM jdr_paths
WHERE path_name = pathNames(pathLevel) AND path_owner_docid = ownerID;
SELECT path_docid, path_seq INTO docid, seq
FROM jdr_paths
WHERE
path_name = name AND
path_owner_docid = ownerID AND
path_type = docType;
UPDATE jdr_paths SET path_seq = pathSeq
WHERE
path_docid = docid;
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;
SELECT path_owner_docid, path_seq
INTO ownerID, pathSeq
FROM jdr_paths
WHERE path_docid = newDocID;
SELECT path_docid INTO tmpdocID
FROM jdr_paths
WHERE path_docid = docID
FOR UPDATE NOWAIT;
FUNCTION prepareDocumentForInsert(
username VARCHAR2,
fullPathName VARCHAR2,
pathType VARCHAR2,
xmlversion VARCHAR2,
xmlencoding VARCHAR2) RETURN NUMBER
IS
docID jdr_paths.path_docid%TYPE;
SELECT path_seq INTO pathSeq FROM jdr_paths WHERE path_docid = docID;
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;
deleteDocument(docID, FALSE);
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;
UPDATE jdr_paths
SET last_updated_by = username,
last_update_date = SYSDATE,
last_update_login = username
WHERE path_docid = docID;
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');
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);
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;
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;
UPDATE jdr_attributes_trans SET atl_comp_ref = newCompRef
WHERE atl_comp_docid = docID AND
atl_comp_ref = oldCompRef;
UPDATE jdr_paths
SET path_name = newBaseName,
path_owner_docid = ownerID
WHERE path_docid = docID;
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;
UPDATE jdr_attributes
SET att_value = REPLACE(newCustDocName, '/'||newBaseName)
WHERE att_comp_docid = docID AND
att_comp_seq = 0 AND
att_name = 'package';
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);