APPS.FWK_PORTLET_GEN_UTIL dependencies on FWK_PORTLET_GEN_UTIL

Line 1: PACKAGE BODY FWK_PORTLET_GEN_UTIL as

1: PACKAGE BODY FWK_PORTLET_GEN_UTIL as
2: /* $Header: fwkportgenutlb.pls 120.4 2011/12/29 20:20:25 mmuhanna ship $ */
3: -----------------------------------------------------------------------------
4: ---------------------------- PUBLIC METHODS ---------------------------------
5: -----------------------------------------------------------------------------

Line 141: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name

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

Line 167: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name

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

Line 192: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name

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

Line 202: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name

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
204: WHERE COMP.comp_element = 'oa:contentContainer'
205: AND COMP.COMP_SEQ <> 0 )x;
206:

Line 235: END FWK_PORTLET_GEN_UTIL;

231:
232:
233:
234:
235: END FWK_PORTLET_GEN_UTIL;