APPS.FWK_PORTLET_GEN_UTIL dependencies on FWK_PORTLET_GEN

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 83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');

79:
80: fnd_file.put_line(fnd_file.log, 'Refreshing materialized view');
81: fnd_file.put_line(fnd_file.log, 'Start time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
82:
83: dbms_mview.refresh('FWK_PORTLET_GEN_MV');
84:
85: fnd_file.put_line(fnd_file.log, 'Refresh successful.');
86: fnd_file.put_line(fnd_file.log, 'End time : ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS'));
87:

Line 104: -- This is the concurrent program that will refresh the FWK_PORTLET_GEN table.

100: -----------------------------------------------------------------------------
101: ---------------------------- PUBLIC METHODS ---------------------------------
102: -----------------------------------------------------------------------------
103:
104: -- This is the concurrent program that will refresh the FWK_PORTLET_GEN table.
105: --
106: -- Parameters:
107: -- none
108:

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 208: INSERT INTO FWK_PORTLET_GEN(DOCUMENT_ID ,

204: WHERE COMP.comp_element = 'oa:contentContainer'
205: AND COMP.COMP_SEQ <> 0 )x;
206:
207: FORALL i IN docId.FIRST..docId.LAST
208: INSERT INTO FWK_PORTLET_GEN(DOCUMENT_ID ,
209: DOCUMENT_NAME ,
210: REGION_NAME ,
211: REGION_TYPE ,
212: APP_SHORT_NAME)

Line 235: END FWK_PORTLET_GEN_UTIL;

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