[Home] [Help]
PACKAGE: APPS.BIS_PMV_UTIL
Source
1 package BIS_PMV_UTIL AUTHID CURRENT_USER as
2 /* $Header: BISPMVUS.pls 120.3.12010000.2 2008/08/12 07:41:27 bijain ship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(120.3.12000000.2=120.4):~PROD:~PATH:~FILE
5 -- Purpose: LOV for PM Viewer
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- aleung 7/13/01 initial creation
10 -- amkulkar 7/18/01 Added function to sort attributecodes based on their lengths
11 -- mdamle 12/12/01 Added getParameterValue
12 -- mdamle 12/19/01 Added getDefaultResponsibility
13 -- nbarik 03/09/02 Bug Fix 2503143 Added getICXCurrentDateTime
14 -- nbarik 01/10/03 Enhancement : 2638594 - Portlet Builder
15 -- Added function getRegionApplicationId
16 -- nkishore 04/25/03 BugFix 2823330 Added Get_Last_Refresh_Date
17 -- ansingh 06/09/03 BugFix 2995675 Staling of RL Portlets based on PlugId
18 -- nbarik 08/21/03 Bug Fix 3099831 - Added hasfunctionAccess
19 -- mdamle 08/04/04 Added getRegionDataSourceType
20 -- --------- ------- ------------------------------------------
21 type lob_varchar_pieces is table of varchar2(32000) index by binary_integer;
22 g_db_nls_lang varchar2(200) := userenv('LANGUAGE');
23 g_db_charset varchar2(200) := substr(g_db_nls_lang, instr(g_db_nls_lang, '.')+1);
24
25 function readFndLobs (pFileId in number) return lob_varchar_pieces;
26
27 procedure sortAttributeCode
28 (p_attributeCode_tbl in OUT NOCOPY BISVIEWER.t_char
29 ,p_attributeValue_tbl in OUT NOCOPY BISVIEWER.t_char
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 procedure getCurrentDateTime (x_current_date_time out NOCOPY varchar2,
36 x_current_date out NOCOPY varchar2,
37 x_current_hour out NOCOPY varchar2,
38 x_current_minute out NOCOPY varchar2);
39
40 --Bug Fix 2503143 nbarik 03/sep/2002
41 procedure getICXCurrentDateTime( p_icx_date_format IN VARCHAR2,
42 x_current_date_time OUT NOCOPY VARCHAR2,
43 x_current_date OUT NOCOPY VARCHAR2,
44 x_current_hour OUT NOCOPY VARCHAR2,
45 x_current_minute OUT NOCOPY VARCHAR2);
46
47 PROCEDURE RETRIEVE_DATA
48 ( document_id IN NUMBER
49 ,document IN OUT NOCOPY VARCHAR2
50 );
51
52 function getAppendTitle(pRegionCode in varchar2) return varchar2;
53 procedure getReportTitle
54 (pFunctionName IN VARCHAR2
55 ,pRegionCode IN VARCHAR2 DEFAULT NULL
56 ,pRegionName IN VARCHAR2 DEFAULT NULL
57 ,xTitleString OUT NOCOPY VARCHAR2
58 ,xBrowserTitle OUT NOCOPY VARCHAR2
59 );
60
61 function getHierarchyElementId(pElementShortName in varchar2,
62 pDimensionShortNAme in varchar2) return varchar2;
63
64 function getDimensionForAttribute(pAttributeCode in varchar2,
65 pRegionCode in varchar2) return varchar2;
66
67 function getAttributeForDimension(pDimension in varchar2,
68 pRegionCode in varchar2) return varchar2;
69
70 function encode (p_url in varchar2,
71 p_charset in varchar2 default null) return varchar2;
72
73 function decode1 (p_url in varchar2,
74 p_charset in varchar2 default null) return varchar2;
75
76 -- mdamle 11/08/2001
77 function getReportRegion(pFunctionName IN VARCHAR2) return varchar2;
78
79 -- mdamle 12/05/01
80 function getFormattedDate(pInputDate in date, pFormatMask in varchar2) return varchar2;
81
82 -- mdamle 12/12/01
83 function getParameterValue(pParameters IN VARCHAR2, pParameterKey IN VARCHAR2) return varchar2;
84
85 -- mdamle 12/19/2001
86 function getDefaultResponsibility(pUserId in varchar2
87 , pFunctionName in varchar2
88 , pCheckPMVSpecific in varchar2 default 'N') return varchar2;
89
90 procedure stale_portlet(pUserId in varchar2,
91 pFunctionName in varchar2,
92 pPlugId in varchar2 default null);
93 procedure update_portlets_bypage(p_Page_Id in varchar2);
94 function get_render_type
95 (p_region_code in varchar2
96 ,p_user_id in varchar2
97 ,p_responsibility_id in varchar2)
98 return varchar2;
99
100 -- mdamle 10/31/2002 - Bug#2560743 - Use previous page parameters for linked page
101 function getPortalPageId(pPageName in varchar2) return number;
102
103 -- nbarik 01/10/03 - Portlet Builder
104 FUNCTION getRegionApplicationId(pRegionCode IN VARCHAR2) RETURN NUMBER;
105
106 PROCEDURE stale_portlet_by_RefPath (pReferencePath IN VARCHAR2);
107
108 --BugFix 2995675: ansingh
109 PROCEDURE STALE_PORTLET_BY_PLUGID(pPlugId IN VARCHAR2);
110
111 PROCEDURE SETUP_BIND_VARIABLES
112 (p_bind_variables in varchar2,
113 x_bind_var_tbl out NOCOPY BISVIEWER.t_char);
114
115
116 --This api has been deprecated, But to be on the safer side has not been deleted.
117 --BugFix 2823330 Get lastrefreshDate
118 FUNCTION GET_LAST_REFRESH_DATE(pObjectType varchar2, pFunctionName in varchar2) return varchar2;
119 FUNCTION GET_LAST_REFRESH_DATE(pObjectType varchar2, pFunctionName in varchar2,pRFUrl in varchar2) return varchar2;
120
121 --This api has been deprecated, But to be on the safer side has not been deleted.
122 FUNCTION GET_LAST_REFRESH_DATE_URL(pObjectType in varchar2, pFunctionName in varchar2) return varchar2;
123 FUNCTION GET_LAST_REFRESH_DATE_URL(pObjectType in varchar2, pFunctionName in varchar2,pRFUrl in varchar2) return varchar2;
124 -- nbarik 08/21/03 - Bug Fix 3099831
125 FUNCTION hasFunctionAccess(pUserId IN VARCHAR2, pFunctionName IN VARCHAR2, pPMVSpecific IN VARCHAR2) RETURN VARCHAR2;
126
127 --serao-09/05-bug3122867
128 PROCEDURE bis_run_function(
129 pApplication_id IN VARCHAR2,
130 pResponsibility_id IN VARCHAR2,
131 pSecurity_group_id IN VARCHAR2,
132 pFunction_id IN VARCHAR2,
133 pParameters IN VARCHAR2 DEFAULT NULL
134 );
135
136 -- nbarik 03/01/2004
137 -- udua 07/25/2005 - Changed API name and behavior.
138 FUNCTION getParamPortletFuncName(pPageFunctionName IN VARCHAR2) RETURN VARCHAR2;
139 -- nbarik 03/01/2004
140 FUNCTION getDocumentID(pFullPathName VARCHAR2) RETURN NUMBER;
141 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
142 FUNCTION getRoleIds(pPrivileges IN VARCHAR2) RETURN BISVIEWER.t_char;
143 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
144 PROCEDURE getDelegations(
145 pRoleIdsTbl IN BISVIEWER.t_char
146 , pParamName IN VARCHAR2
147 , pParameterView IN VARCHAR2
148 , pAsOfDate IN DATE
149 , xDelegatorIdTbl OUT NOCOPY BISVIEWER.t_char
150 , xDelegatorValueTbl OUT NOCOPY BISVIEWER.t_char
151 );
152
153 --=============================================================================
154 -- gbhaloti 05/25/04 Generic Report Designer
155 FUNCTION getPortletType(pType IN VARCHAR2, pParameters IN VARCHAR2) RETURN VARCHAR2;
156
157 --=============================================================================
158 -- gbhaloti 05/25/04 Generic Report Designer
159 FUNCTION getPortletTypeCode(pType IN VARCHAR2, pParameters IN VARCHAR2) RETURN CHAR;
160
161 --=============================================================================
162 -- gbhaloti 05/25/04 Generic Report Designer
163 FUNCTION getRegionCode(pType IN VARCHAR2, pParameters IN VARCHAR2, webHtmlCall IN VARCHAR2, functionName IN VARCHAR2) RETURN CHAR;
164 --=============================================================================
165 -- gbhaloti 05/25/04 Generic Report Designer
166 FUNCTION getRegionApplicationName(pRegionCode IN VARCHAR2) RETURN VARCHAR2;
167 --==============================================================================
168
169 -- mdamle 08/04/2004
170 FUNCTION getRegionDataSourceType(pRegionCode IN VARCHAR2) RETURN VARCHAR2;
171
172 -- msaran 08/31/2005 eliminate mod_plsql
173 PROCEDURE readBinaryFile (p_file_id IN VARCHAR2, content_type OUT NOCOPY VARCHAR2, data OUT NOCOPY BLOB);
174
175 end BIS_PMV_UTIL;