1 PACKAGE WSMPVCPD AUTHID CURRENT_USER AS
2 /* $Header: WSMVCPDS.pls 115.4 2002/11/14 23:22:47 zchen ship $ */
3
4
5 /*===========================================================================
6 PROCEDURE NAME: val_co_prduct_related
7
8 DESCRIPTION: This routine is used to verify if a bill has
9 one or more currently active components with an active
10 co-product relationship.
11
12 PARAMETERS: x_bill_sequence_id IN NUMBER,
13 x_result IN OUT NOCOPY VARCHAR2,
14 x_error_code IN OUT NOCOPY NUMBER,
15 x_error_msg IN OUT NOCOPY VARCHAR2
16
17 x_result : Y, N
18 x_error_code : 0 - Successful.
19 Other values - SQL Error.
20
21 DESIGN REFERENCES:
22
23 ALGORITHM:
24
25 NOTES:
26
27 OPEN ISSUES:
28
29 CLOSED ISSUES:
30
31 CHANGE HISTORY: Ramana Mulpury 03/06/98 Created
32 ===========================================================================*/
33 PROCEDURE val_co_product_related (x_bill_sequence_id IN NUMBER,
34 x_result IN OUT NOCOPY VARCHAR2,
35 x_error_code IN OUT NOCOPY NUMBER,
36 x_error_msg IN OUT NOCOPY VARCHAR2);
37
38 /*===========================================================================
39 PROCEDURE NAME: val_co_product
40
41 DESCRIPTION: This routine is used to perform the following
42 validation.
43
44 - The co-product is unique for a
45 component/effectivity/organization combination.
46 - The substitutes that exist for the
47 component are not the same as the co-product.
48
49 PARAMETERS: x_rowid IN VARCHAR2
50 x_co_product_group_id IN NUMBER
51 x_co_product_id IN NUMBER
52 x_error_code IN OUT NOCOPY NUMBER
53 x_error_msg IN OUT NOCOPY VARCHAR2
54
55 x_error_code : 0 - Successful.
56 1 - In sufficient arguments.
57 2 - Business validation failure.
58 Other values - SQL Error.
59
60 DESIGN REFERENCES:
61
62 ALGORITHM:
63
64 NOTES:
65
66 OPEN ISSUES:
67
68 CLOSED ISSUES:
69
70 CHANGE HISTORY: Ramana Mulpury 06/16/97 Created
71 ===========================================================================*/
72 PROCEDURE val_co_product (x_rowid IN VARCHAR2,
73 x_co_product_group_id IN NUMBER,
74 x_co_product_id IN NUMBER,
75 x_error_code IN OUT NOCOPY NUMBER,
76 x_error_msg IN OUT NOCOPY VARCHAR2);
77
78
79 /*===========================================================================
80 PROCEDURE NAME: val_substitute_coproduct
81
82 DESCRIPTION: This routine is used to perform the following
83 validation of the substitute co-product.
84
85 PARAMETERS:
86
87 x_error_code : 0 - Successful.
88 > 0 - Business validation failure.
89 Other values - SQL Error.
90
91 DESIGN REFERENCES:
92
93 ALGORITHM:
94
95 NOTES:
96
97 OPEN ISSUES:
98
99 CLOSED ISSUES:
100
101 CHANGE HISTORY: Ramana Mulpury 01/27/98 Created
102 ===========================================================================*/
103 PROCEDURE val_substitute_coproduct(x_substitute_co_product_id IN NUMBER,
104 x_co_product_group_id IN NUMBER,
105 x_co_product_id IN NUMBER,
106 x_error_code IN OUT NOCOPY NUMBER,
107 x_error_msg IN OUT NOCOPY VARCHAR2);
108
109
110 /*===========================================================================
111 PROCEDURE NAME: val_pre_commit
112
113 DESCRIPTION: This routine is a cover for the routines that
114 are called in order to perform pre-commit validation
115 on the server.
116
117 PARAMETERS: x_co_product_group_id IN NUMBER
118 x_error_code IN OUT NOCOPY NUMBER
119 x_error_msg IN OUT NOCOPY VARCHAR2
120
121 x_error_code : 0 - Successful.
122 2 - Business validation failure.
123 Other values - SQL Error.
124
125 DESIGN REFERENCES:
126
127 ALGORITHM:
128
129 NOTES:
130
131 OPEN ISSUES:
132
133 CLOSED ISSUES:
134
135 CHANGE HISTORY: Ramana Mulpury 06/21/97 Created
136 ===========================================================================*/
137 PROCEDURE val_pre_commit (x_co_product_group_id IN NUMBER,
138 x_error_code IN OUT NOCOPY NUMBER,
139 x_error_msg IN OUT NOCOPY VARCHAR2);
140
141
142
143 /*===========================================================================
144 PROCEDURE NAME: val_primary_flag
145
146 DESCRIPTION: This routine validates that there is one and
147 only one primary co-product for a component.
148
149 PARAMETERS: x_rowid IN VARCHAR2
150 x_co_product_group_id IN NUMBER
151 x_error_code IN OUT NOCOPY NUMBER
152 x_error_msg IN OUT NOCOPY VARCHAR2
153
154 x_error_code : 0 - Successful.
155 1 - In sufficient arguments.
156 2 - Business validation failure.
157 Other values - SQL Error.
158
159 DESIGN REFERENCES:
160
161 ALGORITHM:
162
163 NOTES:
164
165 OPEN ISSUES:
166
167 CLOSED ISSUES:
168
169 CHANGE HISTORY: Ramana Mulpury 06/16/97 Created
170 ===========================================================================*/
171 PROCEDURE val_primary_flag (x_co_product_group_id IN NUMBER,
172 x_error_code IN OUT NOCOPY NUMBER,
173 x_error_msg IN OUT NOCOPY VARCHAR2);
174
175
176 /*===========================================================================
177 PROCEDURE NAME: val_split_total
178
179 DESCRIPTION: This routine validates that the split percentage
180 of all co-products for a component adds up to
181 100.
182
183 PARAMETERS: x_co_product_group_id IN NUMBER
184 x_error_code IN OUT NOCOPY NUMBER
185 x_error_msg IN OUT NOCOPY VARCHAR2
186
187 x_error_code : 0 - Successful.
188 1 - In sufficient arguments.
189 2 - Business validation failure.
190 Other values - SQL Error.
191
192 DESIGN REFERENCES:
193
194 ALGORITHM:
195
196 NOTES:
197
198 OPEN ISSUES:
199
200 CLOSED ISSUES:
201
202 CHANGE HISTORY: Ramana Mulpury 06/16/97 Created
203 ===========================================================================*/
204 PROCEDURE val_split_total (x_co_product_group_id IN NUMBER,
205 x_error_code IN OUT NOCOPY NUMBER,
206 x_error_msg IN OUT NOCOPY VARCHAR2);
207
208 /*===========================================================================
209 PROCEDURE NAME: val_add_to_bill
210
211 DESCRIPTION: This routine performs the processing
212 required to verify if components can be
213 added to an existing bill.
214
215 PARAMETERS: x_co_product_group_id IN NUMBER,
216 x_org_id IN NUMBER,
217 x_co_product_id IN NUMBER,
218 x_comm_bill_sequence_id IN NUMBER,
219 x_curr_bill_sequence_id IN NUMBER,
220 x_effectivity_date IN DATE,
221 x_disable_date IN DATE,
222 x_alternate_designator IN VARCHAR2,
223 x_error_code IN OUT NOCOPY NUMBER,
224 x_error_msg IN OUT NOCOPY VARCHAR
225
226 x_error_code : 0 - Successful.
227 x_error_code : 3 - Validation error.
228 Other values: - SQL Error.
229
230 DESIGN REFERENCES:
231
232 ALGORITHM:
233
234 NOTES:
235
236 OPEN ISSUES:
237
238 CLOSED ISSUES:
239
240 CHANGE HISTORY: Ramana Mulpury 07/11/97 Created
241 ===========================================================================*/
242 PROCEDURE val_add_to_bill ( x_co_product_group_id IN NUMBER,
243 x_org_id IN NUMBER,
244 x_co_product_id IN NUMBER,
245 x_comm_bill_sequence_id IN NUMBER,
246 x_curr_bill_sequence_id IN NUMBER,
247 x_effectivity_date IN DATE,
248 x_disable_date IN DATE,
249 x_alternate_designator IN VARCHAR2,
250 x_error_code IN OUT NOCOPY NUMBER,
251 x_error_msg IN OUT NOCOPY VARCHAR2);
252
253
254 /*===========================================================================
255 PROCEDURE NAME: val_component_overlap
256
257 DESCRIPTION: This routine is used to perform the following
258 validation.
259
260 - The component is unique for a
261 component/effectivity/organization combination.
262
263 PARAMETERS: x_org_id IN NUMBER,
264 x_component_id IN NUMBER,
265 x_effectivity_date IN DATE,
266 x_disable_date IN DATE,
267 x_rowid IN VARCHAR2,
268 x_error_code IN OUT NOCOPY NUMBER,
269 x_error_msg IN OUT NOCOPY VARCHAR2
270
271 x_error_code : 0 - Successful.
272 Other values - SQL Error.
273
274 DESIGN REFERENCES:
275
276 ALGORITHM:
277
278 NOTES:
279
280 OPEN ISSUES:
281
282 CLOSED ISSUES:
283
284 CHANGE HISTORY: Ramana Mulpury 06/20/97 Created
285 ===========================================================================*/
286 PROCEDURE val_component_overlap (x_org_id IN NUMBER,
287 x_component_id IN NUMBER,
288 x_effectivity_date IN DATE,
289 x_disable_date IN DATE,
290 x_rowid IN VARCHAR2,
291 x_error_code IN OUT NOCOPY NUMBER,
292 x_error_msg IN OUT NOCOPY VARCHAR2);
293
294
295 END;