32: -- regionCustDocID Document ID of the region customization document
33: -- regionCompSeq Component sequence of the region component (source)
34: -- extendingRegion Component ID of the extending region
35: -- needElementAtt Is an element attribute needed?
36: PROCEDURE addAttributes(pageCustDocID jdr_paths.path_docid%TYPE,
37: pageCompSeq jdr_attributes.att_comp_seq%TYPE,
38: regionCustDocID jdr_paths.path_docid%TYPE,
39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,
40: extendingRegion jdr_components.comp_id%TYPE,
34: -- extendingRegion Component ID of the extending region
35: -- needElementAtt Is an element attribute needed?
36: PROCEDURE addAttributes(pageCustDocID jdr_paths.path_docid%TYPE,
37: pageCompSeq jdr_attributes.att_comp_seq%TYPE,
38: regionCustDocID jdr_paths.path_docid%TYPE,
39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,
40: extendingRegion jdr_components.comp_id%TYPE,
41: needElementAtt BOOLEAN)
42: IS
39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,
40: extendingRegion jdr_components.comp_id%TYPE,
41: needElementAtt BOOLEAN)
42: IS
43: CURSOR c_attributes(docID jdr_paths.path_docid%TYPE,
44: compSeq jdr_components.comp_seq%TYPE) IS
45: SELECT att_seq, att_name, att_value
46: FROM jdr_attributes
47: WHERE att_comp_docid = docID AND
109: -- regionCustDocID Document ID of the region customization document
110: -- regionStartSeq Start sequence of the region components (source)
111: -- regionEndSeq End sequence of the region components
112: -- extendingRegion Component ID of the extending region
113: PROCEDURE addComponents(pageCustDocID jdr_paths.path_docid%TYPE,
114: pageStartSeq jdr_components.comp_seq%TYPE,
115: regionCustDocID jdr_paths.path_docid%TYPE,
116: regionStartSeq jdr_components.comp_seq%TYPE,
117: regionEndSeq jdr_components.comp_seq%TYPE,
111: -- regionEndSeq End sequence of the region components
112: -- extendingRegion Component ID of the extending region
113: PROCEDURE addComponents(pageCustDocID jdr_paths.path_docid%TYPE,
114: pageStartSeq jdr_components.comp_seq%TYPE,
115: regionCustDocID jdr_paths.path_docid%TYPE,
116: regionStartSeq jdr_components.comp_seq%TYPE,
117: regionEndSeq jdr_components.comp_seq%TYPE,
118: extendingRegion jdr_components.comp_id%TYPE)
119: IS
116: regionStartSeq jdr_components.comp_seq%TYPE,
117: regionEndSeq jdr_components.comp_seq%TYPE,
118: extendingRegion jdr_components.comp_id%TYPE)
119: IS
120: CURSOR c_components(docID jdr_paths.path_docid%TYPE,
121: startSeq jdr_components.comp_seq%TYPE,
122: endSeq jdr_components.comp_seq%TYPE) IS
123: SELECT comp_seq, comp_level, comp_grouping, comp_element, comp_id
124: FROM jdr_components
196: -- Parameters:
197: -- pageCustDocID Document ID of the page customization document
198: -- regionCustDocID Document ID of the region customization document
199: -- extendingRegion Component ID of the extending region
200: PROCEDURE appendModifications(pageCustDocID jdr_paths.path_docid%TYPE,
201: regionCustDocID jdr_paths.path_docid%TYPE,
202: extendingRegion jdr_components.comp_id%TYPE)
203:
204: IS
197: -- pageCustDocID Document ID of the page customization document
198: -- regionCustDocID Document ID of the region customization document
199: -- extendingRegion Component ID of the extending region
200: PROCEDURE appendModifications(pageCustDocID jdr_paths.path_docid%TYPE,
201: regionCustDocID jdr_paths.path_docid%TYPE,
202: extendingRegion jdr_components.comp_id%TYPE)
203:
204: IS
205: pageStartSeq jdr_components.comp_seq%TYPE;
231: -- pageCustDocID Document ID of the page customization document
232: -- regionCustDocID Document ID of the region customization document
233: -- extendingRegion Component ID of the extending region
234: -- viewID ID of the view
235: PROCEDURE appendView(pageCustDocID jdr_paths.path_docid%TYPE,
236: regionCustDocID jdr_paths.path_docid%TYPE,
237: extendingRegion jdr_components.comp_id%TYPE,
238: viewID jdr_components.comp_id%TYPE)
239: IS
232: -- regionCustDocID Document ID of the region customization document
233: -- extendingRegion Component ID of the extending region
234: -- viewID ID of the view
235: PROCEDURE appendView(pageCustDocID jdr_paths.path_docid%TYPE,
236: regionCustDocID jdr_paths.path_docid%TYPE,
237: extendingRegion jdr_components.comp_id%TYPE,
238: viewID jdr_components.comp_id%TYPE)
239: IS
240: pageStartSeq jdr_components.comp_seq%TYPE;
684:
685: PROCEDURE migrateCustomizationsToPage(regionCustDocName IN VARCHAR2,
686: extendingRegionName IN VARCHAR2)
687: IS
688: CURSOR c_translations(docID jdr_paths.path_docid%TYPE) IS
689: SELECT atl_lang, atl_comp_ref, atl_name, atl_value
690: FROM jdr_attributes_trans
691: WHERE atl_comp_docid = docID;
692:
689: SELECT atl_lang, atl_comp_ref, atl_name, atl_value
690: FROM jdr_attributes_trans
691: WHERE atl_comp_docid = docID;
692:
693: CURSOR c_views(docID jdr_paths.path_docid%TYPE) IS
694: SELECT comp_id
695: FROM jdr_components
696: WHERE comp_docid = docID and
697: comp_element = 'view'
699:
700: tranRec c_translations%ROWTYPE;
701: pageBaseDocName VARCHAR2(512);
702: pageCustDocName VARCHAR2(512);
703: pageCustDocID jdr_paths.path_docid%TYPE;
704: regionBaseDocName VARCHAR2(512);
705: regionCustDocID jdr_paths.path_docid%TYPE;
706: regionBaseDocID jdr_paths.path_docid%TYPE;
707: custType jdr_components.comp_grouping%TYPE;
701: pageBaseDocName VARCHAR2(512);
702: pageCustDocName VARCHAR2(512);
703: pageCustDocID jdr_paths.path_docid%TYPE;
704: regionBaseDocName VARCHAR2(512);
705: regionCustDocID jdr_paths.path_docid%TYPE;
706: regionBaseDocID jdr_paths.path_docid%TYPE;
707: custType jdr_components.comp_grouping%TYPE;
708: extendingRegion jdr_components.comp_id%TYPE;
709: viewID jdr_components.comp_id%TYPE;
702: pageCustDocName VARCHAR2(512);
703: pageCustDocID jdr_paths.path_docid%TYPE;
704: regionBaseDocName VARCHAR2(512);
705: regionCustDocID jdr_paths.path_docid%TYPE;
706: regionBaseDocID jdr_paths.path_docid%TYPE;
707: custType jdr_components.comp_grouping%TYPE;
708: extendingRegion jdr_components.comp_id%TYPE;
709: viewID jdr_components.comp_id%TYPE;
710: pos1 INTEGER;
926: oldRef VARCHAR2(512);
927: newRef VARCHAR2(512);
928: currDoc VARCHAR2(512);
929: currLayer VARCHAR2(100);
930: pathName JDR_PATHS.PATH_NAME%TYPE;
931: custIndex NUMBER;
932: layerIndex NUMBER;
933: cntDocs NUMBER := 1;
934: cntLayers NUMBER := 1;
937: docs jdr_stringArray := jdr_stringArray(null);
938: layers jdr_stringArray := jdr_stringArray(null);
939: CURSOR c(custDocLike VARCHAR2, pathName VARCHAR2) IS
940: SELECT jdr_mds_internal.getDocumentName(path_docid)
941: FROM jdr_paths
942: WHERE path_type = 'DOCUMENT' AND
943: path_name = pathName AND
944: path_seq = -1 AND
945: jdr_mds_internal.getDocumentName(path_docid) like custDocLike;