The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT att_seq, att_name, att_value
FROM jdr_attributes
WHERE att_comp_docid = docID AND
att_comp_seq = compSeq;
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);
INSERT INTO jdr_attributes
(att_comp_docid, att_comp_seq, att_seq, att_name, att_value)
VALUES
(pageCustDocID, pageCompSeq,
nextAttSequence, 'element', extendingRegion);
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;
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);
SELECT MAX(comp_seq) + 1 INTO pageStartSeq
FROM jdr_components
WHERE comp_docid = pageCustDocID;
SELECT MAX(comp_seq) INTO regionEndSeq
FROM jdr_components
WHERE comp_docid = regionCustDocID;
SELECT comp_seq, comp_level INTO regionStartSeq, regionCompLevel
FROM jdr_components
WHERE comp_docid = regionCustDocID AND
comp_element = 'view' AND
comp_id = viewID;
SELECT MIN(comp_seq) - 1 INTO regionEndSeq
FROM jdr_components
WHERE comp_docid = regionCustDocID AND
comp_seq > regionStartSeq AND
comp_level <= regionCompLevel;
SELECT MAX(comp_seq) INTO regionEndSeq
FROM jdr_components
WHERE comp_docid = regionCustDocID;
SELECT comp_seq, comp_level INTO pageStartSeq, pageCompLevel
FROM jdr_components
WHERE comp_docid = pageCustDocID AND
comp_element = 'view' AND
comp_id = viewID;
SELECT MIN(comp_seq) - 1 INTO pageEndSeq
FROM jdr_components
WHERE comp_docid = pageCustDocID AND
comp_seq > pageStartSeq AND
comp_level <= pageCompLevel;
SELECT MAX(comp_seq) INTO pageEndSeq
FROM jdr_components
WHERE comp_docid = pageCustDocID;
SELECT MAX(comp_seq) + 1 INTO pageStartSeq
FROM jdr_components
WHERE comp_docid = pageCustDocID;
UPDATE jdr_components
SET comp_seq = comp_seq + componentsAdded
WHERE comp_docid = pageCustDocID AND
comp_seq > pageEndSeq;
UPDATE jdr_attributes
SET att_comp_seq = att_comp_seq + componentsAdded
WHERE att_comp_docid = pageCustDocID AND
att_comp_seq > pageEndSeq;
SELECT att_value INTO isActive
FROM jdr_attributes
WHERE att_comp_docid = custDocID AND
att_comp_seq = 0 AND
att_name = 'MDSActiveDoc';
SELECT atl_lang, atl_comp_ref, atl_name, atl_value
FROM jdr_attributes_trans
WHERE atl_comp_docid = docID;
SELECT comp_id
FROM jdr_components
WHERE comp_docid = docID and
comp_element = 'view'
ORDER BY comp_seq;
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)
)
);
SELECT comp_grouping INTO custType
FROM jdr_components
WHERE comp_docid = regionCustDocID AND
comp_seq = 1;
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);
jdr_mds_internal.deleteDocument(regionCustDocID, TRUE);
DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;
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;