[Home] [Help]
PACKAGE: APPS.BIS_TARGET_LEVEL_PUB
Source
1 PACKAGE BIS_Target_Level_PUB AS
2 /* $Header: BISPTALS.pls 120.0 2005/06/01 18:08:13 appldev noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVINLS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API for creating and managing Indicator Levels
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 28-NOV-98 irchen Creation
19 REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
20 REM | initialization or declaration (bug#2774644) |
21 REM |
22 REM | 26-JUN-03 RCHANDRA do away with hard coded length for name and |
23 REM | description for bug 2910316 |
24 REM | for dimension and dimension levels |
25 REM | 30-JUN-03 rchandra Added DATASET_ID as an attribute to |
26 REM | Target_Level_Rec_Typefor bug 3004651 |
27 REM | 28-JUN-04 ankgoel Removed Retrieve_Measure_Notify_Resps for |
28 REM | bug#3634587 |
29 REM | 21-FEB-2005 ankagarw modified measure name and description |
30 REM | column length for enh. 3862703 |
31 REM +=======================================================================+
32 */
33 --
34 -- Data Types: Records
35 --
36 TYPE Target_Level_Rec_Type IS RECORD
37 ( Measure_ID NUMBER
38 , Measure_Short_Name VARCHAR2(30)
39 , Measure_Name bis_indicators_tl.name%TYPE
40 , Dataset_ID bis_indicators.dataset_id%TYPE
41 , Target_Level_ID NUMBER
42 , Target_Level_Short_Name VARCHAR2(80)
43 , Target_Level_Name VARCHAR2(80)
44 , Description VARCHAR2(240)
45 , Org_Level_ID NUMBER
46 , Org_Level_Short_Name VARCHAR2(30)
47 , Org_Level_Name bis_levels_tl.name%TYPE
48 , Time_Level_ID NUMBER
49 , Time_Level_Short_Name VARCHAR2(30)
50 , Time_Level_Name bis_levels_tl.name%TYPE
51 , Dimension1_Level_ID NUMBER
52 , Dimension1_Level_Short_Name VARCHAR2(30)
53 , Dimension1_Level_Name bis_levels_tl.name%TYPE
54 , Dimension2_Level_ID NUMBER
55 , Dimension2_Level_Short_Name VARCHAR2(30)
56 , Dimension2_Level_Name bis_levels_tl.name%TYPE
57 , Dimension3_Level_ID NUMBER
58 , Dimension3_Level_Short_Name VARCHAR2(30)
59 , Dimension3_Level_Name bis_levels_tl.name%TYPE
60 , Dimension4_Level_ID NUMBER
61 , Dimension4_Level_Short_Name VARCHAR2(30)
62 , Dimension4_Level_Name bis_levels_tl.name%TYPE
63 , Dimension5_Level_ID NUMBER
64 , Dimension5_Level_Short_Name VARCHAR2(30)
65 , Dimension5_Level_Name bis_levels_tl.name%TYPE
66 , Dimension6_Level_ID NUMBER
67 , Dimension6_Level_Short_Name VARCHAR2(30)
68 , Dimension6_Level_Name bis_levels_tl.name%TYPE
69 , Dimension7_Level_ID NUMBER
70 , Dimension7_Level_Short_Name VARCHAR2(30)
71 , Dimension7_Level_Name bis_levels_tl.name%TYPE
72 , Workflow_Process_Short_Name VARCHAR2(30)
73 , Workflow_Process_Name VARCHAR2(4000)
74 , Workflow_Item_Type VARCHAR2(8)
75 , Default_Notify_Resp_ID NUMBER
76 , Default_Notify_Resp_short_name VARCHAR2(100)
77 , Default_Notify_Resp_Name VARCHAR2(4000)
78 , Computing_Function_ID NUMBER
79 , Computing_Function_Name VARCHAR2(4000)
80 , Computing_User_Function_Name VARCHAR2(4000)
81 , Report_Function_ID NUMBER
82 , Report_Function_Name VARCHAR2(4000)
83 , Report_User_Function_Name VARCHAR2(4000)
84 , Unit_Of_Measure VARCHAR(30)
85 , System_Flag VARCHAR2(1) := 'N'
86 , Source VARCHAR2(30)
87 , IS_WF_INFO_NEEDED BOOLEAN := TRUE -- 2528450
88 );
89 --
90 -- Data Types: Tables
91 --
92 TYPE Target_Level_Tbl_Type IS TABLE of Target_Level_Rec_Type
93 INDEX BY BINARY_INTEGER;
94 --
95 -- Global Missing Composite Types
96 --
97 G_MISS_IND_LEVEL_REC Target_Level_Rec_Type;
98 --
99 G_MISS_IND_LEVEL_TBL Target_Level_Tbl_Type;
100 --
101 --
102 -- PROCEDUREs
103 --
104 -- creates one Indicator Level
105 PROCEDURE Create_Target_Level
106 ( p_api_version IN NUMBER
107 , p_commit IN VARCHAR2 := FND_API.G_FALSE
108 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
111 );
112 --
113 -- Gets All Indicator Levels
114 -- If information about the dimensions are not required, set all_info to
115 -- FALSE
116 PROCEDURE Retrieve_Target_Levels
117 ( p_api_version IN NUMBER
118 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
119 , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
120 , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
121 , x_return_status OUT NOCOPY VARCHAR2
122 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
123 );
124 --
125 --
126 -- Gets Information for one Indicator Level
127 -- If information about the dimension are not required, set all_info to FALSE.
128 PROCEDURE Retrieve_Target_Level
129 ( p_api_version IN NUMBER
130 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
131 , p_all_info IN VARCHAR2 := FND_API.G_TRUE
132 , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
133 , x_return_status OUT NOCOPY VARCHAR2
134 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
135 );
136 --
137 --
138 -- Update_Target_Levels
139 PROCEDURE Update_Target_Level
140 ( p_api_version IN NUMBER
141 , p_commit IN VARCHAR2 := FND_API.G_FALSE
142 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
143 , x_return_status OUT NOCOPY VARCHAR2
144 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
145 );
146 --
147 -- deletes one Target_Level
148 PROCEDURE Delete_Target_Level
149 ( p_api_version IN NUMBER
150 , p_commit IN VARCHAR2 := FND_API.G_FALSE
151 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
152 , x_return_status OUT NOCOPY VARCHAR2
153 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
154 );
155 --
156 -- Validates measure
157 PROCEDURE Validate_Target_Level
158 ( p_api_version IN NUMBER
159 , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
160 , x_return_status OUT NOCOPY VARCHAR2
161 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
162 );
163 --
164 Procedure Retrieve_User_Target_Levels
165 ( p_api_version IN NUMBER
166 , p_user_id IN NUMBER
167 , p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR
168 , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
169 , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
170 , x_return_status OUT NOCOPY VARCHAR2
171 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
172 );
173
174 --
175 Procedure Translate_Target_Level
176 ( p_api_version IN NUMBER
177 , p_commit IN VARCHAR2 := FND_API.G_FALSE
178 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179 , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
180 , p_OWNER IN VARCHAR2
181 , x_return_status OUT NOCOPY VARCHAR2
182 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
183 );
184 --
185 Procedure Load_Target_Level
186 ( p_api_version IN NUMBER
187 , p_commit IN VARCHAR2 := FND_API.G_FALSE
188 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
189 , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
190 , p_OWNER IN VARCHAR2
191 , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
192 , x_return_status OUT NOCOPY VARCHAR2
193 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
194 );
195 --
196 FUNCTION Get_Id_From_DimLevelShortNames
197 ( p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
198 ) RETURN NUMBER;
199
200 -- New Procedure to return TargetLevel given the DimensionLevel ShortNames in any sequence
201 -- and the Measure Short Name
202
203 PROCEDURE Retrieve_TL_From_DimLvlShNms
204 (p_api_version IN NUMBER
205 ,p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
206 , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
207 , x_return_status OUT NOCOPY VARCHAR2
208 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
209 );
210
211 -- Given a target level short name update the
212 -- bis_target_levels, bis_target_levels_tl
213 -- for last_updated_by , created_by as 1
214 PROCEDURE updt_tl_attributes(p_tl_short_name IN VARCHAR2
215 ,p_tl_new_short_name IN VARCHAR2
216 ,x_return_status OUT NOCOPY VARCHAR2);
217
218
219 END BIS_Target_Level_PUB;