1 PACKAGE OZF_Vol_Offr_PVT AS
2 /* $Header: ozfvvos.pls 120.0 2005/06/01 02:49:18 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Vol_Offr_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- vol_offr_tier_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- volume_offer_tiers_id
29 -- qp_list_header_id
30 -- discount_type_code
31 -- discount
32 -- break_type_code
33 -- tier_value_from
34 -- tier_value_to
35 -- volume_type
36 -- active
37 -- uom_code
38 -- object_version_number
39 --
40 -- Required
41 --
42 -- Defaults
43 --
44 -- Note: This is automatic generated record definition, it includes all columns
45 -- defined in the table, developer must manually add or delete some of the attributes.
46 --
47 -- End of Comments
48
49 --===================================================================
50 TYPE vol_offr_tier_rec_type IS RECORD
51 (
52 volume_offer_tiers_id NUMBER,
53 qp_list_header_id NUMBER,
54 discount_type_code VARCHAR2(30),
55 discount NUMBER,
56 break_type_code VARCHAR2(30),
57 tier_value_from NUMBER,
58 tier_value_to NUMBER,
59 volume_type VARCHAR2(30),
60 active VARCHAR2(1),
61 uom_code VARCHAR2(30),
62 object_version_number NUMBER
63 );
64
65 g_miss_vol_offr_tier_rec vol_offr_tier_rec_type := NULL;
66 TYPE vol_offr_tier_tbl_type IS TABLE OF vol_offr_tier_rec_type INDEX BY BINARY_INTEGER;
67 g_miss_vol_offr_tier_tbl vol_offr_tier_tbl_type;
68
69 -- ==============================================================================
70 -- Start of Comments
71 -- ==============================================================================
72 -- API Name
73 -- Create_Vol_Offr
74 -- Type
75 -- Private
76 -- Pre-Req
77 --
78 -- Parameters
79 --
80 -- IN
81 -- p_api_version_number IN NUMBER Required
82 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85 -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86 --
87 -- OUT
88 -- x_return_status OUT VARCHAR2
89 -- x_msg_count OUT NUMBER
90 -- x_msg_data OUT VARCHAR2
91 -- Version : Current version 1.0
92 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
93 -- and basic operation, developer must manually add parameters and business logic as necessary.
94 --
95 -- History
96 --
97 -- NOTE
98 --
99 -- End of Comments
100 -- ==============================================================================
101
102 PROCEDURE Create_Vol_Offr(
103 p_api_version_number IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111
112 p_vol_offr_tier_rec IN vol_offr_tier_rec_type := g_miss_vol_offr_tier_rec,
113 x_volume_offer_tiers_id OUT NOCOPY NUMBER
114 );
115
116 -- ==============================================================================
117 -- Start of Comments
118 -- ==============================================================================
119 -- API Name
120 -- Update_Vol_Offr
121 -- Type
122 -- Private
123 -- Pre-Req
124 --
125 -- Parameters
126 --
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133 --
134 -- OUT
135 -- x_return_status OUT VARCHAR2
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2
138 -- Version : Current version 1.0
139 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
140 -- and basic operation, developer must manually add parameters and business logic as necessary.
141 --
142 -- History
143 --
144 -- NOTE
145 --
146 -- End of Comments
147 -- ==============================================================================
148
149 PROCEDURE Update_Vol_Offr(
150 p_api_version_number IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_commit IN VARCHAR2 := FND_API.G_FALSE,
153 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158
159 p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
160 x_object_version_number OUT NOCOPY NUMBER
161 );
162
163 -- ==============================================================================
164 -- Start of Comments
165 -- ==============================================================================
166 -- API Name
167 -- Delete_Vol_Offr
168 -- Type
169 -- Private
170 -- Pre-Req
171 --
172 -- Parameters
173 --
174 -- IN
175 -- p_api_version_number IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179 -- p_volume_offer_tiers_id IN NUMBER
180 -- p_object_version_number IN NUMBER Optional Default = NULL
181 --
182 -- OUT
183 -- x_return_status OUT VARCHAR2
184 -- x_msg_count OUT NUMBER
185 -- x_msg_data OUT VARCHAR2
186 -- Version : Current version 1.0
187 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
188 -- and basic operation, developer must manually add parameters and business logic as necessary.
189 --
190 -- History
191 --
192 -- NOTE
193 --
194 -- End of Comments
195 -- ==============================================================================
196
197 PROCEDURE Delete_Vol_Offr(
198 p_api_version_number IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_volume_offer_tiers_id IN NUMBER,
206 p_object_version_number IN NUMBER
207 );
208
209 -- ==============================================================================
210 -- Start of Comments
211 -- ==============================================================================
212 -- API Name
213 -- Lock_Vol_Offr
214 -- Type
215 -- Private
216 -- Pre-Req
217 --
218 -- Parameters
219 --
220 -- IN
221 -- p_api_version_number IN NUMBER Required
222 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225 -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226 --
227 -- OUT
228 -- x_return_status OUT VARCHAR2
229 -- x_msg_count OUT NUMBER
230 -- x_msg_data OUT VARCHAR2
231 -- Version : Current version 1.0
232 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
233 -- and basic operation, developer must manually add parameters and business logic as necessary.
234 --
235 -- History
236 --
237 -- NOTE
238 --
239 -- End of Comments
240 -- ==============================================================================
241
242 PROCEDURE Lock_Vol_Offr(
243 p_api_version_number IN NUMBER,
244 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249
250 p_volume_offer_tiers_id IN NUMBER,
251 p_object_version IN NUMBER
252 );
253
254
255 -- ==============================================================================
256 -- Start of Comments
257 -- ==============================================================================
258 -- API Name
259 -- Validate_Vol_Offr
260 --
261 -- Version : Current version 1.0
262 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
263 -- For create: G_CREATE, for update: G_UPDATE
264 -- Note: 1. This is automated generated item level validation procedure.
265 -- The actual validation detail is needed to be added.
266 -- 2. We can also validate table instead of record. There will be an option for user to choose.
267 --
268 -- History
269 --
270 -- NOTE
271 --
272 -- End of Comments
273 -- ==============================================================================
274
275
276 PROCEDURE Validate_Vol_Offr(
277 p_api_version_number IN NUMBER,
278 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280 p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
281 p_validation_mode IN VARCHAR2,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2
285 );
286
287 -- ==============================================================================
288 -- Start of Comments
289 -- ==============================================================================
290 -- API Name
291 -- Vol_Offr_Tier_Items
292 --
293 -- Version : Current version 1.0
294 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
295 -- For create: G_CREATE, for update: G_UPDATE
296 -- Note: 1. This is automated generated item level validation procedure.
297 -- The actual validation detail is needed to be added.
298 -- 2. Validate the unique keys, lookups here
299 --
300 -- History
301 --
302 -- NOTE
303 --
304 -- End of Comments
305 -- ==============================================================================
306
307
308 PROCEDURE Check_Vol_Offr_Tier_Items (
309 P_vol_offr_tier_rec IN vol_offr_tier_rec_type,
310 p_validation_mode IN VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2
312 );
313
314 -- ==============================================================================
315 -- Start of Comments
316 -- ==============================================================================
317 -- API Name
318 -- Validate_Vol_Offr_Tier_Rec
319 --
320 -- Version : Current version 1.0
321 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
322 -- For create: G_CREATE, for update: G_UPDATE
323 -- Note: 1. This is automated generated item level validation procedure.
324 -- The actual validation detail is needed to be added.
325 -- 2. Developer can manually added inter-field level validation.
326 --
327 -- History
328 --
329 -- NOTE
330 --
331 -- End of Comments
332 -- ==============================================================================
333
334
335 PROCEDURE Validate_Vol_Offr_Tier_Rec (
336 p_api_version_number IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_vol_offr_tier_rec IN vol_offr_tier_rec_type
342 );
343 END OZF_Vol_Offr_PVT;