[Home] [Help]
PACKAGE: APPS.BIS_PMV_PMF_PVT
Source
1 PACKAGE BIS_PMV_PMF_PVT AUTHID CURRENT_USER as
2 /* $Header: BISVPMPS.pls 120.1 2005/09/23 03:57:29 msaran noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.11=120.1):~PROD:~PATH:~FILE
5 ----------------------------------------------------------------------------
6 -- PACKAGE: BIS_PMV_PMF_PVT
7 -- --
8 -- DESCRIPTION: Target related APIs for PMV
9 -- --
10 -- MODIFICATIONS --
11 -- Date User Modification
12 -- XX-XXX-XX XXXXXXXX Modifications made, which procedures changed & --
13 -- list bug number, if fixing a bug. --
14 -- --
15 -- 10/17/00 amkulkar Initial creation --
16 -- 4/16/2003 nkishore Added pRespId to get_notify_rpt_url bug 2833251--
17 -- 6/27/03 rcmuthuk Added p_UserId to get_notify_rpt_url bug 2810397--
18 -- 1/28/2004 nkishore BugFix 3075441 --
19 ----------------------------------------------------------------------------
20
21 --jprabhud enhancement#2184054
22 G_DIMENSION_LEVEL varchar2(20) := 'DIMENSION LEVEL';
23 G_DIM_LEVEL_SINGLE_VALUE varchar2(30) := 'DIM LEVEL SINGLE VALUE';
24 G_VIEWBY_PARAMETER varchar2(20) := 'VIEWBY PARAMETER';
25
26
27 FUNCTION GET_TARGET
28 (pSource IN VARCHAR2
29 ,pSessionId IN VARCHAR2
30 ,pRegionCode IN VARCHAR2
31 ,pFunctionName IN VARCHAR2
32 ,pMeasureShortName IN VARCHAR2 DEFAULT NULL
33 ,pPlanId IN VARCHAR2 DEFAULT NULL
34 ,pDimension1 IN VARCHAR2 DEFAULT NULL
35 ,pDim1Level IN VARCHAR2 DEFAULT NULL
36 ,pDim1LevelValue IN VARCHAR2 DEFAULT NULL
37 ,pDimension2 IN VARCHAR2 DEFAULT NULL
38 ,pDim2Level IN VARCHAR2 DEFAULT NULL
39 ,pDim2LevelValue IN VARCHAR2 DEFAULT NULL
40 ,pDimension3 IN VARCHAR2 DEFAULT NULL
41 ,pDim3Level IN VARCHAR2 DEFAULT NULL
42 ,pDim3LevelValue IN VARCHAR2 DEFAULT NULL
43 ,pDimension4 IN VARCHAR2 DEFAULT NULL
44 ,pDim4Level IN VARCHAR2 DEFAULT NULL
45 ,pDim4LevelValue IN VARCHAR2 DEFAULT NULL
46 ,pDimension5 IN VARCHAR2 DEFAULT NULL
47 ,pDim5Level IN VARCHAR2 DEFAULT NULL
48 ,pDim5LevelValue IN VARCHAR2 DEFAULT NULL
49 ,pDimension6 IN VARCHAR2 DEFAULT NULL
50 ,pDim6Level IN VARCHAR2 DEFAULT NULL
51 ,pDim6LevelValue IN VARCHAR2 DEFAULT NULL
52 ,pDimension7 IN VARCHAR2 DEFAULT NULL
53 ,pDim7Level IN VARCHAR2 DEFAULT NULL
54 ,pDim7LevelValue IN VARCHAR2 DEFAULT NULL
55 )
56 RETURN VARCHAR2;
57 FUNCTION GETTOTALDIMVALUE
58 (pDimSource IN VARCHAR2,
59 pDimension IN VARCHAR2 DEFAULT NULL,
60 pDimensionLevel IN VARCHAR2
61 )
62 RETURN VARCHAR2;
63 Function GETTOTALDIMlEVELNAME
64 (pDimShortName IN VARCHAR2
65 ,pSource IN VARCHAR2
66 )
67 RETURN VARCHAR2;
68 PROCEDURE TOLERANCE_TEST
69 (p_target_value IN VARCHAR2
70 ,p_actual_value IN VARCHAR2
71 ,p_range1_high IN VARCHAR2
72 ,p_range1_low IN VARCHAR2
73 ,x_tolerance OUT NOCOPY VARCHAR2
74 );
75
76 --BugFix 3075441, add p_NlsLangCode
77 FUNCTION GET_NOTIFY_RPT_URL(
78 p_measure_id IN VARCHAR2
79 ,p_region_code in varchar2 default null
80 ,p_function_name in varchar2 default null
81 ,p_bplan_name IN VARCHAR2 default null
82 ,p_viewby_level_short_name IN VARCHAR2 default null
83 ,p_Parm1Level_short_name IN VARCHAR2 default null
84 ,p_Parm1Value_name IN VARCHAR2 default null
85 ,p_Parm2Level_short_name IN VARCHAR2 default null
86 ,p_Parm2Value_name IN VARCHAR2 default null
87 ,p_Parm3Level_short_name IN VARCHAR2 default null
88 ,p_Parm3Value_name IN VARCHAR2 default null
89 ,p_Parm4Level_short_name IN VARCHAR2 default null
90 ,p_Parm4Value_name IN VARCHAR2 default null
91 ,p_Parm5Level_short_name IN VARCHAR2 default null
92 ,p_Parm5Value_name IN VARCHAR2 default null
93 ,p_Parm6Level_short_name IN VARCHAR2 default null
94 ,p_Parm6Value_name IN VARCHAR2 default null
95 ,p_Parm7Level_short_name IN VARCHAR2 default null
96 ,p_Parm7Value_name IN VARCHAR2 default null
97 ,p_Parm8Level_short_name IN VARCHAR2 default null
98 ,p_Parm8Value_name IN VARCHAR2 default null
99 ,p_Parm9Level_short_name IN VARCHAR2 default null
100 ,p_Parm9Value_name IN VARCHAR2 default null
101 ,p_Parm10Level_short_name IN VARCHAR2 default null
102 ,p_Parm10Value_name IN VARCHAR2 default null
103 ,p_Parm11Level_short_name IN VARCHAR2 default null
104 ,p_Parm11Value_name IN VARCHAR2 default null
105 ,p_Parm12Level_short_name IN VARCHAR2 default null
106 ,p_Parm12Value_name IN VARCHAR2 default null
107 ,p_Parm13Level_short_name IN VARCHAR2 default null
108 ,p_Parm13Value_name IN VARCHAR2 default null
109 ,p_TimeParmLevel_short_name in varchar2 default null
110 ,p_TimeFromParmValue_name in varchar2 default null
111 ,p_TimeToParmValue_name in varchar2 default null
112 ,p_resp_id in varchar2 default null
113 ,p_UserId IN VARCHAR2 default null
114 ,p_NlsLangCode IN VARCHAR2 default null)
115 RETURN VARCHAR2;
116
117 --msaran:4415814 - return report run url, to handle ssl
118 PROCEDURE GET_NOTIFY_RPT_RUN_URL(
119 p_measure_id IN VARCHAR2
120 ,p_region_code in varchar2 default null
121 ,p_function_name in varchar2 default null
122 ,p_bplan_name IN VARCHAR2 default null
123 ,p_viewby_level_short_name IN VARCHAR2 default null
124 ,p_Parm1Level_short_name IN VARCHAR2 default null
125 ,p_Parm1Value_name IN VARCHAR2 default null
126 ,p_Parm2Level_short_name IN VARCHAR2 default null
127 ,p_Parm2Value_name IN VARCHAR2 default null
128 ,p_Parm3Level_short_name IN VARCHAR2 default null
129 ,p_Parm3Value_name IN VARCHAR2 default null
130 ,p_Parm4Level_short_name IN VARCHAR2 default null
131 ,p_Parm4Value_name IN VARCHAR2 default null
132 ,p_Parm5Level_short_name IN VARCHAR2 default null
133 ,p_Parm5Value_name IN VARCHAR2 default null
134 ,p_Parm6Level_short_name IN VARCHAR2 default null
135 ,p_Parm6Value_name IN VARCHAR2 default null
136 ,p_Parm7Level_short_name IN VARCHAR2 default null
137 ,p_Parm7Value_name IN VARCHAR2 default null
138 ,p_Parm8Level_short_name IN VARCHAR2 default null
139 ,p_Parm8Value_name IN VARCHAR2 default null
140 ,p_Parm9Level_short_name IN VARCHAR2 default null
141 ,p_Parm9Value_name IN VARCHAR2 default null
142 ,p_Parm10Level_short_name IN VARCHAR2 default null
143 ,p_Parm10Value_name IN VARCHAR2 default null
144 ,p_Parm11Level_short_name IN VARCHAR2 default null
145 ,p_Parm11Value_name IN VARCHAR2 default null
146 ,p_Parm12Level_short_name IN VARCHAR2 default null
147 ,p_Parm12Value_name IN VARCHAR2 default null
148 ,p_Parm13Level_short_name IN VARCHAR2 default null
149 ,p_Parm13Value_name IN VARCHAR2 default null
150 ,p_TimeParmLevel_short_name in varchar2 default null
151 ,p_TimeFromParmValue_name in varchar2 default null
152 ,p_TimeToParmValue_name in varchar2 default null
153 ,p_resp_id in varchar2 default null
154 ,p_UserId IN VARCHAR2 default null
155 ,p_NlsLangCode IN VARCHAR2 default null
156 --msaran:4415814 - added out params from fileId and reportURL
157 ,vFileId OUT NOCOPY NUMBER
158 ,vReportURL OUT NOCOPY VARCHAR2
159 );
160
161 --serao 02/10/02 - added as replacement for get_target
162 FUNCTION GET_TARGET_NEW
163 (pSource IN VARCHAR2
164 ,pSessionId IN VARCHAR2
165 ,pRegionCode IN VARCHAR2
166 ,pFunctionName IN VARCHAR2
167 ,pMeasureShortName IN VARCHAR2 DEFAULT NULL
168 ,pPlanId IN VARCHAR2 DEFAULT NULL
169 ,pTarget_level_id IN NUMBER DEFAULT NULL
170 ,pDimension1 IN VARCHAR2 DEFAULT NULL
171 ,pDim1Level IN VARCHAR2 DEFAULT NULL
172 ,pDim1LevelValue IN VARCHAR2 DEFAULT NULL
173 ,pDimension2 IN VARCHAR2 DEFAULT NULL
174 ,pDim2Level IN VARCHAR2 DEFAULT NULL
175 ,pDim2LevelValue IN VARCHAR2 DEFAULT NULL
176 ,pDimension3 IN VARCHAR2 DEFAULT NULL
177 ,pDim3Level IN VARCHAR2 DEFAULT NULL
178 ,pDim3LevelValue IN VARCHAR2 DEFAULT NULL
179 ,pDimension4 IN VARCHAR2 DEFAULT NULL
180 ,pDim4Level IN VARCHAR2 DEFAULT NULL
181 ,pDim4LevelValue IN VARCHAR2 DEFAULT NULL
182 ,pDimension5 IN VARCHAR2 DEFAULT NULL
183 ,pDim5Level IN VARCHAR2 DEFAULT NULL
184 ,pDim5LevelValue IN VARCHAR2 DEFAULT NULL
185 ,pDimension6 IN VARCHAR2 DEFAULT NULL
186 ,pDim6Level IN VARCHAR2 DEFAULT NULL
187 ,pDim6LevelValue IN VARCHAR2 DEFAULT NULL
188 ,pDimension7 IN VARCHAR2 DEFAULT NULL
189 ,pDim7Level IN VARCHAR2 DEFAULT NULL
190 ,pDim7LevelValue IN VARCHAR2 DEFAULT NULL
191 ) RETURN VARCHAR2;
192
193 END BIS_PMV_PMF_PVT;