[Home] [Help]
PACKAGE: APPS.BSC_DATASETS_PUB
Source
1 package BSC_DATASETS_PUB as
2 /* $Header: BSCPDTSS.pls 120.2 2007/02/08 13:25:53 akoduri ship $ */
3
4 /* RECORD Type for Data Sets.*/
5
6 TYPE Bsc_Dataset_Rec_Type is RECORD(
7 Bsc_Dataset_Autoscale_Flag number
8 ,Bsc_Dataset_Color_Method number
9 ,Bsc_Dataset_Format_Id number
10 ,Bsc_Dataset_Help bsc_sys_datasets_tl.help%TYPE
11 ,Bsc_Dataset_Id number
12 -- mdamle 03/12/2003 - PMD - Measure Definer - Changed from 60 to 80 to match bis_indicators name
13 ,Bsc_Dataset_Name bsc_sys_datasets_tl.name%TYPE
14 ,Bsc_Dataset_Projection_Flag number
15 -- mdamle 03/12/2003 - PMD - Measure Definer
16 ,Bsc_Dataset_Operation varchar2(3)
17 ,Bsc_Disabled_Calc_Id number
18 ,Bsc_Language varchar2(5)
19 ,Bsc_Measure_Col varchar2(320)
20 ,Bsc_Measure_Group_Id number
21 ,Bsc_Measure_Help varchar2(45)
22 ,Bsc_Measure_Id number
23 ,Bsc_Measure_Id2 number
24 -- mdamle 03/12/2003 - PMD - Measure Definer - Changed from 60 to 80 to match bis_indicators name
25 ,Bsc_Measure_Long_Name bsc_sys_datasets_tl.name%TYPE
26 ,Bsc_Measure_Max_Act_Value number
27 ,Bsc_Measure_Max_Bud_Value number
28 ,Bsc_Measure_Min_Act_Value number
29 ,Bsc_Measure_Min_Bud_Value number
30 ,Bsc_Measure_Operation varchar2(15)
31 ,Bsc_Measure_Projection_Id number
32 ,Bsc_Measure_Random_Style number
33 ,Bsc_Measure_Short_Name varchar2(30)
34 ,Bsc_Measure_Type number
35 -- mdamle 03/12/2003 - PMD - Measure Definer
36 ,Bsc_Measure_color_formula varchar2(4000)
37 ,Bsc_Source varchar2(10)
38 ,Bsc_Source_Language varchar2(5)
39 ,Bsc_Y_Axis_Title varchar2(90)
40 -- 16-JUN-2003 ADRAO Added WHO Columns
41 ,Bsc_Meas_Type NUMBER
42 ,Bsc_Measure_Created_By BSC_SYS_MEASURES.CREATED_BY%TYPE
43 ,Bsc_Measure_Creation_Date BSC_SYS_MEASURES.CREATION_DATE%TYPE
44 ,Bsc_Measure_Last_Update_By BSC_SYS_MEASURES.LAST_UPDATED_BY%TYPE
45 ,Bsc_Measure_Last_Update_Date BSC_SYS_MEASURES.LAST_UPDATE_DATE%TYPE
46 ,Bsc_Measure_Last_Update_Login BSC_SYS_MEASURES.LAST_UPDATE_LOGIN%TYPE
47
48 ,Bsc_Dataset_Created_By BSC_SYS_DATASETS_B.CREATED_BY%TYPE
49 ,Bsc_Dataset_Creation_Date BSC_SYS_DATASETS_B.CREATION_DATE%TYPE
50 ,Bsc_Dataset_Last_Update_By BSC_SYS_DATASETS_B.LAST_UPDATED_BY%TYPE
51 ,Bsc_Dataset_Last_Update_Date BSC_SYS_DATASETS_B.LAST_UPDATE_DATE%TYPE
52 ,Bsc_Dataset_Last_Update_Login BSC_SYS_DATASETS_B.LAST_UPDATE_LOGIN%TYPE
53
54 -- 18-OCT-2004 ADRAO added for POSCO Bug#3817894
55 -- Added Bsc_Measure_Group_Help for furture enhancements.
56 ,Bsc_Measure_Col_Help BSC_DB_MEASURE_COLS_TL.HELP%TYPE
57 ,Bsc_Measure_Group_Help BSC_DB_MEASURE_GROUPS_TL.HELP%TYPE
58 );
59
60 TYPE Bsc_Dataset_Tbl_Type IS TABLE OF Bsc_Dataset_Rec_Type
61 INDEX BY BINARY_INTEGER;
62
63
64 procedure Create_Measures(
65 p_commit IN varchar2 := FND_API.G_FALSE
66 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
67 ,x_Dataset_Id OUT NOCOPY number
68 ,x_return_status OUT NOCOPY varchar2
69 ,x_msg_count OUT NOCOPY number
70 ,x_msg_data OUT NOCOPY varchar2
71 );
72
73 -- ADRAO : Overloaded for iBuilder
74 procedure Create_Measures(
75 p_commit IN varchar2 := FND_API.G_FALSE
76 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
77 ,x_return_status OUT NOCOPY varchar2
78 ,x_msg_count OUT NOCOPY number
79 ,x_msg_data OUT NOCOPY varchar2
80 );
81 -- ADRAO : Overloaded for iBuilder
82
83 procedure Retrieve_Measures(
84 p_commit IN varchar2 := FND_API.G_FALSE
85 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
86 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
87 ,x_return_status OUT NOCOPY varchar2
88 ,x_msg_count OUT NOCOPY number
89 ,x_msg_data OUT NOCOPY varchar2
90 );
91
92 procedure Update_Measures(
93 p_commit IN varchar2 := FND_API.G_FALSE
94 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
95 ,x_return_status OUT NOCOPY varchar2
96 ,x_msg_count OUT NOCOPY number
97 ,x_msg_data OUT NOCOPY varchar2
98 );
99
100 -- mdamle 03/12/2003 - PMD - Measure Definer - Added p_update_dset_calc
101 procedure Update_Measures(
102 p_commit IN varchar2 := FND_API.G_FALSE
103 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
104 ,p_update_dset_calc IN BOOLEAN
105 ,x_return_status OUT NOCOPY varchar2
106 ,x_msg_count OUT NOCOPY number
107 ,x_msg_data OUT NOCOPY varchar2
108 );
109
110 procedure Delete_Measures(
111 p_commit IN varchar2 := FND_API.G_FALSE
112 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
113 ,x_return_status OUT NOCOPY varchar2
114 ,x_msg_count OUT NOCOPY number
115 ,x_msg_data OUT NOCOPY varchar2
116 );
117
118 procedure Create_Dataset(
119 p_commit IN varchar2 := FND_API.G_FALSE
120 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
121 ,x_Dataset_Id OUT NOCOPY number
122 ,x_return_status OUT NOCOPY varchar2
123 ,x_msg_count OUT NOCOPY number
124 ,x_msg_data OUT NOCOPY varchar2
125 );
126
127 -- ADRAO : Overloaded for iBuilder
128 procedure Create_Dataset(
129 p_commit IN varchar2 := FND_API.G_FALSE
130 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
131 ,x_return_status OUT NOCOPY varchar2
132 ,x_msg_count OUT NOCOPY number
133 ,x_msg_data OUT NOCOPY varchar2
134 );
135 -- ADRAO : Overloaded for iBuilder
136
137 procedure Retrieve_Dataset(
138 p_commit IN varchar2 := FND_API.G_FALSE
139 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
140 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
141 ,x_return_status OUT NOCOPY varchar2
142 ,x_msg_count OUT NOCOPY number
143 ,x_msg_data OUT NOCOPY varchar2
144 );
145
146 procedure Update_Dataset(
147 p_commit IN varchar2 := FND_API.G_FALSE
148 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
149 ,x_return_status OUT NOCOPY varchar2
150 ,x_msg_count OUT NOCOPY number
151 ,x_msg_data OUT NOCOPY varchar2
152 );
153
154 procedure Delete_Dataset(
155 p_commit IN varchar2 := FND_API.G_FALSE
156 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
157 ,x_return_status OUT NOCOPY varchar2
158 ,x_msg_count OUT NOCOPY number
159 ,x_msg_data OUT NOCOPY varchar2
160 );
161
162 procedure Create_Dataset_Calc(
163 p_commit IN varchar2 := FND_API.G_FALSE
164 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
165 ,x_return_status OUT NOCOPY varchar2
166 ,x_msg_count OUT NOCOPY number
167 ,x_msg_data OUT NOCOPY varchar2
168 );
169
170 procedure Retrieve_Dataset_Calc(
171 p_commit IN varchar2 := FND_API.G_FALSE
172 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
173 ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
174 ,x_return_status OUT NOCOPY varchar2
175 ,x_msg_count OUT NOCOPY number
176 ,x_msg_data OUT NOCOPY varchar2
177 );
178
179 procedure Update_Dataset_Calc(
180 p_commit IN varchar2 := FND_API.G_FALSE
181 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
182 ,x_return_status OUT NOCOPY varchar2
183 ,x_msg_count OUT NOCOPY number
184 ,x_msg_data OUT NOCOPY varchar2
185 );
186
187 procedure Delete_Dataset_Calc(
188 p_commit IN varchar2 := FND_API.G_FALSE
189 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
190 ,x_return_status OUT NOCOPY varchar2
191 ,x_msg_count OUT NOCOPY number
192 ,x_msg_data OUT NOCOPY varchar2
193 );
194
195 procedure Update_Dataset(
196 p_commit IN varchar2 := FND_API.G_FALSE
197 ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
198 ,p_update_dset_calc IN BOOLEAN
199 ,x_return_status OUT NOCOPY varchar2
200 ,x_msg_count OUT NOCOPY number
201 ,x_msg_data OUT NOCOPY varchar2
202 );
203
204 --=============================================================================
205 PROCEDURE Translate_Measure
206 ( p_commit IN VARCHAR2
207 , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
208 , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
209 , x_return_status OUT NOCOPY VARCHAR2
210 , x_msg_count OUT NOCOPY NUMBER
211 , x_msg_data OUT NOCOPY VARCHAR2
212 ) ;
213 --=============================================================================
214
215 PROCEDURE Translate_Measure_By_Lang
216 ( p_commit IN VARCHAR2
217 , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
218 , p_lang IN VARCHAR2
219 , p_source_lang IN VARCHAR2
220 , x_return_status OUT NOCOPY VARCHAR2
221 , x_msg_count OUT NOCOPY NUMBER
222 , x_msg_data OUT NOCOPY VARCHAR2
223 );
224
225 FUNCTION Get_DataSet_Name(
226 p_DataSet_Id IN NUMBER
227 ) RETURN VARCHAR2;
228
229 FUNCTION Get_DataSet_Source(
230 p_DataSet_Id IN NUMBER
231 ) RETURN VARCHAR2;
232
233 FUNCTION Get_DataSet_Full_Name(
234 p_DataSet_Id IN NUMBER
235 ) RETURN VARCHAR2;
236
237 end BSC_DATASETS_PUB;