APPS.FWK_PORTLET_GEN_UTIL dependencies on JDR_PATHS

Line 45: path_name JDR_PATHS.PATH_NAME%TYPE;

41: -- p_docid - the fully qualified document id
42:
43: FUNCTION getPathName(p_docid in NUMBER) RETURN VARCHAR
44: IS
45: path_name JDR_PATHS.PATH_NAME%TYPE;
46:
47: CURSOR c_pathName(docID JDR_PATHS.PATH_OWNER_DOCID%TYPE) IS
48: SELECT path_name
49: FROM JDR_PATHS

Line 47: CURSOR c_pathName(docID JDR_PATHS.PATH_OWNER_DOCID%TYPE) IS

43: FUNCTION getPathName(p_docid in NUMBER) RETURN VARCHAR
44: IS
45: path_name JDR_PATHS.PATH_NAME%TYPE;
46:
47: CURSOR c_pathName(docID JDR_PATHS.PATH_OWNER_DOCID%TYPE) IS
48: SELECT path_name
49: FROM JDR_PATHS
50: WHERE path_owner_docid = 2
51: CONNECT BY PRIOR PATH_OWNER_DOCID = PATH_DOCID

Line 49: FROM JDR_PATHS

45: path_name JDR_PATHS.PATH_NAME%TYPE;
46:
47: CURSOR c_pathName(docID JDR_PATHS.PATH_OWNER_DOCID%TYPE) IS
48: SELECT path_name
49: FROM JDR_PATHS
50: WHERE path_owner_docid = 2
51: CONNECT BY PRIOR PATH_OWNER_DOCID = PATH_DOCID
52: START WITH PATH_DOCID = docID;
53:

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 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