[Home] [Help]
PACKAGE: APPS.BISVIEWER_PMF
Source
1 package bisviewer_pmf AUTHID CURRENT_USER as
2 /* $Header: BISRGPMS.pls 115.11 2002/11/19 18:30:18 kiprabha noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile:~PROD:~PATH:~FILE
5
6 Function Get_Target (pMeasureShortName Varchar2,
7 pDimension1Level Varchar2 default NULL,
8 pDimension2Level Varchar2 default NULL,
9 pDimension3Level Varchar2 default NULL,
10 pDimension4Level Varchar2 default NULL,
11 pDimension5Level Varchar2 default NULL,
12 pDimension6Level Varchar2 default NULL,
13 pDimension7Level Varchar2 default NULL,
14 pDimension1 Varchar2 default NULL,
15 pDimension2 Varchar2 default NULL,
16 pDimension3 Varchar2 default NULL,
17 pDimension4 Varchar2 default NULL,
18 pDimension5 Varchar2 default NULL,
19 pDimension6 Varchar2 default NULL,
20 pDimension7 Varchar2 default NULL,
21 pDimension1LevelValue Varchar2 default NULL,
22 pDimension2LevelValue Varchar2 default NULL,
23 pDimension3LevelValue Varchar2 default NULL,
24 pDimension4LevelValue Varchar2 default NULL,
25 pDimension5LevelValue Varchar2 default NULL,
26 pDimension6LevelValue Varchar2 default NULL,
27 pDimension7LevelValue Varchar2 default NULL,
28 pPlanId Varchar2) return VARCHAR2;
29
30
31 FUNCTION Get_Target_For_Level
32 ( p_MEASURE_SHORT_NAME VARCHAR2
33 , p_DIMENSION1_LEVEL VARCHAR2
34 , p_DIMENSION2_LEVEL VARCHAR2
35 , p_DIMENSION3_LEVEL VARCHAR2
36 , p_DIMENSION4_LEVEL VARCHAR2
37 , p_DIMENSION5_LEVEL VARCHAR2
38 , p_DIMENSION6_LEVEL VARCHAR2
39 , p_DIMENSION7_LEVEL VARCHAR2
40 , p_DIMENSION1_LEVEL_VALUE VARCHAR2
41 , p_DIMENSION2_LEVEL_VALUE VARCHAR2
42 , p_DIMENSION3_LEVEL_VALUE VARCHAR2
43 , p_DIMENSION4_LEVEL_VALUE VARCHAR2
44 , p_DIMENSION5_LEVEL_VALUE VARCHAR2
45 , p_DIMENSION6_LEVEL_VALUE VARCHAR2
46 , p_DIMENSION7_LEVEL_VALUE VARCHAR2
47 , p_PLAN VARCHAR2
48 ) RETURN VARCHAR2;
49
50
51 FUNCTION Get_Target_Value
52 ( p_TARGET_LEVEL_ID VARCHAR2
53 , p_DIMENSION1_LEVEL_VALUE VARCHAR2
54 , p_DIMENSION2_LEVEL_VALUE VARCHAR2
55 , p_DIMENSION3_LEVEL_VALUE VARCHAR2
56 , p_DIMENSION4_LEVEL_VALUE VARCHAR2
57 , p_DIMENSION5_LEVEL_VALUE VARCHAR2
58 , p_DIMENSION6_LEVEL_VALUE VARCHAR2
59 , p_DIMENSION7_LEVEL_VALUE VARCHAR2
60 , p_PLAN VARCHAR2
61 ) RETURN VARCHAR2;
62
63
64 FUNCTION Get_LEVEL_ID ( p_Level_Short_Name IN VARCHAR2 ) RETURN NUMBER ;
65
66
67
68 procedure toleranceTest(pTargetLowHigh in varchar2,
69 pValue in varchar2,
70 pTarget out NOCOPY number,
71 pToleranceFlag out NOCOPY varchar2);
72
73
74 Function Schedule_Alert_Link
75 (pMeasureShortName Varchar2,
76 pOrgLevel Varchar2,
77 pTimeLevel Varchar2,
78 pDimension1Level Varchar2 default NULL,
79 pDimension2Level Varchar2 default NULL,
80 pDimension3Level Varchar2 default NULL,
81 pDimension4Level Varchar2 default NULL,
82 pDimension5Level Varchar2 default NULL,
83 pDimension1 Varchar2 default NULL,
84 pDimension2 Varchar2 default NULL,
85 pDimension3 Varchar2 default NULL,
86 pDimension4 Varchar2 default NULL,
87 pDimension5 Varchar2 default NULL,
88 pOrgLevelValue Varchar2 ,
89 pTimeLevelValue Varchar2 ,
90 pDimension1LevelValue Varchar2 default NULL,
91 pDimension2LevelValue Varchar2 default NULL,
92 pDimension3LevelValue Varchar2 default NULL,
93 pDimension4LevelValue Varchar2 default NULL,
94 pDimension5LevelValue Varchar2 default NULL,
95 pPlanId Varchar2) Return VARCHAR2;
96
97
98 FUNCTION Schedule_Alert_URL
99 ( p_MEASURE_SHORT_NAME VARCHAR2
100 , p_ORG_LEVEL VARCHAR2
101 , p_TIME_LEVEL VARCHAR2
102 , p_DIMENSION1_LEVEL VARCHAR2
103 , p_DIMENSION2_LEVEL VARCHAR2
104 , p_DIMENSION3_LEVEL VARCHAR2
105 , p_DIMENSION4_LEVEL VARCHAR2
106 , p_DIMENSION5_LEVEL VARCHAR2
107 , p_ORG_LEVEL_VALUE VARCHAR2
108 , p_TIME_LEVEL_VALUE VARCHAR2
109 , p_DIMENSION1_LEVEL_VALUE VARCHAR2
110 , p_DIMENSION2_LEVEL_VALUE VARCHAR2
111 , p_DIMENSION3_LEVEL_VALUE VARCHAR2
112 , p_DIMENSION4_LEVEL_VALUE VARCHAR2
113 , p_DIMENSION5_LEVEL_VALUE VARCHAR2
114 , p_PLAN VARCHAR2
115 ) RETURN VARCHAR2;
116
117
118 procedure scheduleReports(
119 pRegionCode in varchar2,
120 pFunctionName in varchar2,
121 pUserId in varchar2,
122 pSessionId in varchar2,
123 pResponsibilityId in varchar2,
124 pReportTitle in varchar2 default NULL,
125 pApplicationId in varchar2 default NULL,
126 pParmPrint in varchar2 default NULL,
127 pRequestType in varchar2 default 'R',
128 pPlugId in varchar2 default NULL,
129 pGraphType in varchar2 default NULL
130 );
131
132 Function Schedule_Reports_Link
133 (pRegionCode Varchar2,
134 pFunctionName Varchar2,
135 pApplicationId Varchar2 default NULL,
136 pOrgLevel Varchar2,
137 pTimeLevel Varchar2,
138 pDimension1Level Varchar2 default NULL,
139 pDimension2Level Varchar2 default NULL,
140 pDimension3Level Varchar2 default NULL,
141 pDimension4Level Varchar2 default NULL,
142 pDimension5Level Varchar2 default NULL,
143 pDimension1 Varchar2 default NULL,
144 pDimension2 Varchar2 default NULL,
145 pDimension3 Varchar2 default NULL,
146 pDimension4 Varchar2 default NULL,
147 pDimension5 Varchar2 default NULL,
148 pOrgLevelValue Varchar2 ,
149 pTimeLevelValue Varchar2 ,
150 pDimension1LevelValue Varchar2 default NULL,
151 pDimension2LevelValue Varchar2 default NULL,
152 pDimension3LevelValue Varchar2 default NULL,
153 pDimension4LevelValue Varchar2 default NULL,
154 pDimension5LevelValue Varchar2 default NULL,
155 pPlanId Varchar2,
156 pViewByLevel Varchar2) Return VARCHAR2;
157
158 function getTargetParm(Display in varchar2,
159 Measure in varchar2,
160 PlanId in varchar2,
161 Dim1Level in varchar2 default null,
162 Dim2Level in varchar2 default null,
163 Dim3Level in varchar2 default null,
164 Dim4Level in varchar2 default null,
165 Dim5Level in varchar2 default null,
166 Dim6Level in varchar2 default null,
167 Dim7Level in varchar2 default null,
168 Dim1LevelValue in varchar2 default null,
169 Dim2LevelValue in varchar2 default null,
170 Dim3LevelValue in varchar2 default null,
171 Dim4LevelValue in varchar2 default null,
172 Dim5LevelValue in varchar2 default null,
173 Dim6LevelValue in varchar2 default null,
174 Dim7LevelValue in varchar2 default null) return varchar2;
175
176 procedure getTotalDimValue(pDimSource in varchar2,
177 pDimension in varchar2 default null,
178 pDimensionLevel in out NOCOPY varchar2,
179 pDimensionLevelValue out NOCOPY varchar2);
180
181 function getTotalDimLevelName(pDimShortName IN VARCHAR2
182 ,pSource IN VARCHAR2)
183 RETURN VARCHAR2;
184
185 end bisviewer_pmf;