APPS.FWK_PORTLET_GEN_UTIL dependencies on JDR_COMPONENTS

Line 142: FROM jdr_components COMP, jdr_attributes ATTR, jdr_paths PATH

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
143: WHERE COMP.comp_docid = ATTR.att_comp_docid
144: AND PATH.path_docid = COMP.comp_docid
145: AND ATTR.att_name = 'amDefName'
146: AND ATTR.att_value IS NOT NULL

Line 168: FROM jdr_components COMP, jdr_attributes ATTR

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
169: WHERE COMP.comp_docid = ATTR.att_comp_docid
170: AND ATTR.att_name = 'amDefName'
171: AND attr.att_value IS NOT NULL
172: AND ATTR.att_comp_seq = COMP.comp_seq

Line 193: FROM jdr_components COMP, jdr_paths PATH

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
194: WHERE COMP.comp_element = 'oa:contentContainer'
195: AND PATH.path_docid = COMP.comp_docid
196: AND COMP.COMP_SEQ = 0
197: UNION ALL

Line 203: FROM jdr_components COMP

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
204: WHERE COMP.comp_element = 'oa:contentContainer'
205: AND COMP.COMP_SEQ <> 0 )x;
206:
207: FORALL i IN docId.FIRST..docId.LAST