15: IS
16: p_chunk VARCHAR2(32000) DEFAULT '';
17: full_document CLOB DEFAULT '';
18: BEGIN
19: p_chunk := jdr_mds_internal.exportDocumentAsXML(p_document);
20: full_document := p_chunk;
21: IF p_chunk IS NULL THEN
22: return full_document;
23: ELSE
21: IF p_chunk IS NULL THEN
22: return full_document;
23: ELSE
24: LOOP
25: p_chunk := jdr_mds_internal.exportDocumentAsXML(NULL);
26: EXIT WHEN p_chunk IS NULL;
27: full_document := full_document || p_chunk;
28: END LOOP;
29: END IF;
134: x.APP_SHORT_NAME
135: BULK COLLECT INTO docId, docName, regionName, regionType, appName
136: FROM (
137: SELECT COMP.comp_docid AS document_id,
138: jdr_mds_internal.getdocumentname(COMP.comp_docid) AS document_name,
139: PATH.path_name AS region_name,
140: COMP.comp_element AS region_type,
141: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
142: FROM jdr_components COMP, jdr_attributes ATTR, jdr_paths PATH
160: AND att_value = 'true'
161: AND att_comp_seq = 0 )
162: UNION ALL
163: SELECT COMP.comp_docid AS document_id,
164: jdr_mds_internal.getdocumentname(COMP.comp_docid)||'.'||COMP.comp_id AS document_name,
165: COMP.comp_id AS region_name,
166: COMP.comp_element AS region_type ,
167: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
168: FROM jdr_components COMP, jdr_attributes ATTR
185: AND att_value = 'true'
186: AND att_comp_seq = COMP.comp_seq )
187: UNION ALL
188: SELECT COMP.comp_docid AS document_id,
189: jdr_mds_internal.getdocumentname(COMP.comp_docid) AS document_name,
190: PATH.path_name AS region_name,
191: COMP.comp_element AS region_type,
192: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
193: FROM jdr_components COMP, jdr_paths PATH
195: AND PATH.path_docid = COMP.comp_docid
196: AND COMP.COMP_SEQ = 0
197: UNION ALL
198: SELECT COMP.comp_docid AS document_id,
199: jdr_mds_internal.getdocumentname(COMP.comp_docid)||'.'||COMP.comp_id AS document_name,
200: COMP.comp_id AS region_name,
201: COMP.comp_element AS region_type,
202: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
203: FROM jdr_components COMP