[Home] [Help]
PACKAGE: APPS.BIS_WEIGHTED_MEASURE_PVT
Source
1 PACKAGE BIS_WEIGHTED_MEASURE_PVT AS
2 /* $Header: BISVWMES.pls 120.1 2005/09/16 17:01:28 jxyu noship $ */
3 /*======================================================================================+
4 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
5 | All rights reserved. |
6 +======================================================================================+
7 | FILENAME |
8 | BISPWMEB.pls |
9 | |
10 | Creation Date: |
11 | April 11, 2005 |
12 | Creator: |
13 | William Cano |
14 | |
15 | Description: |
16 | Private spec version. |
17 | This package handle bis Weighted Measure Metadata |
18 | History: |
19 | 04/11/05 wcano Created. |
20 | 09/15/05 jxyu Added Update_WM_Last_Update_Info API for bug#4427932. |
21 | |
22 +======================================================================================*/
23 ------- APIs for tables BIS_WEIGHTED_MEASURE_DEPENDS
24
25 PROCEDURE Create_WM_Dependency(
26 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
27 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
28 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE Retrieve_WM_Dependency(
35 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
36 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
37 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE Update_WM_Dependency(
44 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
45 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
46 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE Delete_WM_Dependency(
53 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
54 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
55 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 ------- APIs for table BIS_WEIGHTED_MEASURE_DEFNS
62
63 PROCEDURE Create_WM_Definition(
64 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
65 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
66 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE Retrieve_WM_Definition(
73 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
74 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
75 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81 PROCEDURE Update_WM_Definition(
82 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
83 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
84 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE Delete_WM_Definition(
91 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
92 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
93 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 ------- APIs for table BIS_WEIGHTED_MEASURE_PARAMS
100
101 PROCEDURE Create_WM_Parameter(
102 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
103 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
104 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
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 Retrieve_WM_Parameter(
111 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
112 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
113 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
114 ,x_return_status OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 PROCEDURE Update_WM_Parameter(
120 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
121 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
122 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY NUMBER
125 ,x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128 PROCEDURE Delete_WM_Parameter(
129 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
130 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
131 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 ------- APIs for table BIS_WEIGHTED_MEASURE_WEIGHTS
138
139 PROCEDURE Create_WM_Weight(
140 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
141 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
142 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
143 ,x_return_status OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 ,x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE Retrieve_WM_Weight(
149 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
150 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
151 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE Update_WM_Weight(
158 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
159 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
160 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
161 ,x_return_status OUT NOCOPY VARCHAR2
162 ,x_msg_count OUT NOCOPY NUMBER
163 ,x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE Delete_WM_Weight(
167 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
168 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
169 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
170 ,x_return_status OUT NOCOPY VARCHAR2
171 ,x_msg_count OUT NOCOPY NUMBER
172 ,x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 ------- APIs for table BIS_WEIGHTED_MEASURE_SCORES
176
177 PROCEDURE Create_WM_Score(
178 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
179 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
180 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
181 ,x_return_status OUT NOCOPY VARCHAR2
182 ,x_msg_count OUT NOCOPY NUMBER
183 ,x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE Retrieve_WM_Score(
187 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
188 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
189 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
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_WM_Score(
196 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
197 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
198 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
199 ,x_return_status OUT NOCOPY VARCHAR2
200 ,x_msg_count OUT NOCOPY NUMBER
201 ,x_msg_data OUT NOCOPY VARCHAR2
202 );
203
204 PROCEDURE Delete_WM_Score(
205 p_commit IN VARCHAR2 --:= FND_API.G_FALSE
206 ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
207 ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
208 ,x_return_status OUT NOCOPY VARCHAR2
209 ,x_msg_count OUT NOCOPY NUMBER
210 ,x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213
214 -------------------------------------------------------
215 PROCEDURE Update_WM_Last_Update_Info(
216 p_commit IN VARCHAR2 := FND_API.G_FALSE
217 ,p_Weighted_Measure_Id IN NUMBER
218 ,x_return_status OUT NOCOPY VARCHAR2
219 ,x_msg_count OUT NOCOPY NUMBER
220 ,x_msg_data OUT NOCOPY VARCHAR2
221 );
222
223 function validate_measure_id(
224 measure_id IN NUMBER
225 ) RETURN VARCHAR2;
226
227 -------------------------------------------------------
228
229 END BIS_WEIGHTED_MEASURE_PVT;