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