[Home] [Help]
PACKAGE: APPS.BISVIEWER
Source
1 package bisviewer AUTHID CURRENT_USER as
2 /* $Header: BISVIEWS.pls 120.4 2006/02/06 00:49:15 ksadagop noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.116=120.4):~PROD:~PATH:~FILE
5 ----------------------------------------------------------------------------
6 -- PACKAGE: bisviewer --
7 -- --
8 -- DESCRIPTION: Report Generate main engine. --
9 -- --
10 -- MODIFICATIONS --
11 -- Date User Modification --
12 -- XX-XXX-XX XXXXXXXX Initial creation --
13 -- 11-NOV-01 aleung initial creation --
14 -- 10-MAY-02 nkishore Added pParameters for showReport --
15 -- 10-OCT-02 mdamle Added parameter for pEnableForecastGraph --
16 -- 16-APR-03 nkishore Added pRespId to get_notify_rpt_url bug 2833251 --
17 -- 27-JUN-03 rcmuthuk Added p_UserId to get_notify_rpt_url bug 2810397--
18 -- 07-JUN-03 gsanap Added p_NextExtraViewBy to drilldown bug 3007145--
19 -- 28-JAN-04 nkishore BugFix 3075441 --
20 -- 20-APR-04 nbarik Enh 3378782 - Parameter Validation --
21 -- 13-Oct-04 ugodavar added pMaxResultSetSize & pOutputFormat --
22 -- 18-Jan-05 smargand Enh #4031345 Report XML definition --
23 -- 05-Jan-06 ugodavar bug.fix.4922183, added pPrevBCInfo --
24 ----------------------------------------------------------------------------
25
26 type t_num is table of number index by binary_integer;
27 type t_bool is table of boolean index by binary_integer;
28 type t_char is table of varchar2(32000) index by binary_integer;
29 type t_date is table of date index by binary_integer;
30
31 procedure showReport(pRegionCode in varchar2 ,
32 pFunctionName in varchar2 ,
33 pApplicationId in varchar2 default NULL,
34 pSessionId in varchar2 default NULL,
35 pUserId in varchar2 default NULL,
36 pResponsibilityId in varchar2 default NULL,
37 pFirstTime in number default 1,
38 pHideParm in varchar2 default 'false',
39 pHideGraph in varchar2 default 'false',
40 pHideTable in varchar2 default 'false',
41 pHideRinfo in varchar2 default 'false',
42 pSortInfo in varchar2 default NULL,
43 pMode in varchar2 default 'SHOW',
44 pPreFunctionName in varchar2 default NULL,
45 pScheduleId in varchar2 default NULL,
46 pRequestType in varchar2 default 'R',
47 pFileId in number default null,
48 pParameterDisplayOnly in varchar2 default 'N',
49 pForceRun in varchar2 default 'N',
50 pDisplayParameters in varchar2 default 'Y',
51 pReportSchedule in varchar2 default 'Y',
52 pCSVFileName in varchar2 default NULL,
53 pPageId in varchar2 default NULL,
54 pParameters in varchar2 default NULL,
55 -- mdamle 10/10/2002 - Enh# 2460903 - Forecast Graph
56 pEnableForecastGraph in varchar2 default NULL,
57 -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
58 pCustomView in varchar2 default NULL,
59 -- Bug Fix 2997706
60 pObjectType IN VARCHAR2 DEFAULT NULL,
61 pautoRefresh IN VARCHAR2 DEFAULT NULL,
62 -- Enh Display Run Button
63 pDispRun IN VARCHAR2 DEFAULT NULL,
64 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
65 pDrillDefaultParameters IN VARCHAR2 DEFAULT NULL,
66 --ugodavar -Enahncement 3946492
67 pMaxResultSetSize IN number DEFAULT NULL,
68 pOutputFormat IN VARCHAR2 DEFAULT NULL,
69 -- nbarik - 02/08/05 - Enhancement 4120795
70 hideNav IN VARCHAR2 DEFAULT NULL,
71 tab IN VARCHAR2 DEFAULT NULL,
72 displayOnlyParameters IN VARCHAR2 DEFAULT NULL,
73 displayOnlyNoViewByParams IN VARCHAR2 DEFAULT NULL,
74 pBCFromFunctionName IN VARCHAR2 DEFAULT NULL,
75 pPrevBCInfo IN VARCHAR2 DEFAULT NULL,
76 pResetView IN VARCHAR2 DEFAULT NULL
77 );
78
79 procedure drilldown ( pRegionCode in varchar2,
80 pFunctionName in varchar2,
81 pSessionId in Varchar2,
82 pUserId in Varchar2,
83 pResponsibilityId in Varchar2,
84 pCurrValue in varchar2,
85 pCurrLevel in varchar2,
86 pCurrAttCode in varchar2,
87 pNextLevel in varchar2,
88 pNextAttCode in varchar2,
89 pDimension in varchar2,
90 pYaxisView in varchar2,
91 pOrgParam in varchar2,
92 pOrgValue in varchar2,
93 pScheduleId in varchar2 default null,
94 pPageId in varchar2 default NULL,
95 pNextExtraViewBy in varchar2 default NULL );
96
97 procedure displayErrorMessage (p_reportTitle in varchar2,
98 p_dimn_level_short_name in varchar2,
99 p_dimn_level_value in varchar2,
100 p_error_no in number,
101 pRegionCode in varchar2 default null);
102
103 procedure displayError (pErrorNumber in Number,
104 pOracleErrorNo in varchar2,
105 pOracleErrorMessage in varchar2);
106 --BugFix 3075441, add p_NlsLangCode
107 function get_notify_rpt_url(
108 p_measure_id IN VARCHAR2,
109 p_region_code in varchar2 default null,
110 p_function_name in varchar2 default null,
111 p_bplan_name IN VARCHAR2 default null,
112 p_viewby_level_short_name IN VARCHAR2 default null,
113 p_Parm1Level_short_name IN VARCHAR2 default null, p_Parm1Value_name IN VARCHAR2 default null,
114 p_Parm2Level_short_name IN VARCHAR2 default null, p_Parm2Value_name IN VARCHAR2 default null,
115 p_Parm3Level_short_name IN VARCHAR2 default null, p_Parm3Value_name IN VARCHAR2 default null,
116 p_Parm4Level_short_name IN VARCHAR2 default null, p_Parm4Value_name IN VARCHAR2 default null,
117 p_Parm5Level_short_name IN VARCHAR2 default null, p_Parm5Value_name IN VARCHAR2 default null,
118 p_Parm6Level_short_name IN VARCHAR2 default null, p_Parm6Value_name IN VARCHAR2 default null,
119 p_Parm7Level_short_name IN VARCHAR2 default null, p_Parm7Value_name IN VARCHAR2 default null,
120 p_Parm8Level_short_name IN VARCHAR2 default null, p_Parm8Value_name IN VARCHAR2 default null,
121 p_Parm9Level_short_name IN VARCHAR2 default null, p_Parm9Value_name IN VARCHAR2 default null,
122 p_Parm10Level_short_name IN VARCHAR2 default null, p_Parm10Value_name IN VARCHAR2 default null,
123 p_Parm11Level_short_name IN VARCHAR2 default null, p_Parm11Value_name IN VARCHAR2 default null,
124 p_Parm12Level_short_name IN VARCHAR2 default null, p_Parm12Value_name IN VARCHAR2 default null,
125 p_Parm13Level_short_name IN VARCHAR2 default null, p_Parm13Value_name IN VARCHAR2 default null,
126 p_TimeParmLevel_short_name in varchar2 default null, p_TimeFromParmValue_name in varchar2 default null,
127 p_TimeToParmValue_name in varchar2 default null, p_resp_id in varchar2 default null, p_UserId IN VARCHAR2 default null,
128 p_NlsLangCode in varchar2 default null) return varchar2;
129
130
131 -- Report XML enhancement
132 procedure showXmlReport(reportName in varchar2 ,
133 sourceType in varchar2 default 'MDS',
134 pFunctionName in varchar2 ,
135 pApplicationId in varchar2 default NULL,
136 pSessionId in varchar2 default NULL,
137 pUserId in varchar2 default NULL,
138 pResponsibilityId in varchar2 default NULL,
139 pFirstTime in number default 1,
140 pHideParm in varchar2 default 'false',
141 pHideGraph in varchar2 default 'false',
142 pHideTable in varchar2 default 'false',
143 pHideRinfo in varchar2 default 'false',
144 pSortInfo in varchar2 default null,
145 pMode in varchar2 default 'SHOW',
146 pPreFunctionName in varchar2 default NULL,
147 pScheduleId in varchar2 default NULL,
148 pRequestType in varchar2 default 'R',
149 pFileId in number default null,
150 pParameterDisplayOnly in varchar2 default 'N',
151 pForceRun in varchar2 default 'N',
152 pDisplayParameters in varchar2 default 'Y',
153 pReportSchedule in varchar2 default 'Y',
154 pCSVFileName in varchar2 default NULL,
155 pPageId in varchar2 default NULL,
156 pParameters in varchar2 default NULL,
157 -- mdamle 10/10/2002 - Enh# 2460903 - Forecast Graph
158 pEnableForecastGraph in varchar2 default NULL,
159 -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
160 pCustomView in varchar2 default NULL,
161 pObjectType IN VARCHAR2 DEFAULT NULL,
162 pautoRefresh IN VARCHAR2 DEFAULT NULL,
163 -- Enh Display Run Button
164 pDispRun IN VARCHAR2 DEFAULT NULL,
165 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
166 pDrillDefaultParameters IN VARCHAR2 DEFAULT NULL,
167 --ugodavar - 10/12/04 - Enh.3946492
168 pMaxResultSetSize IN number DEFAULT NULL,
169 pOutputFormat IN VARCHAR2 DEFAULT NULL
170 );
171 end bisviewer;