1 PACKAGE OZF_Offer_Back_Create_PVT AS
2 /* $Header: ozfvobcs.pls 120.0 2005/06/01 00:44:31 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offer_Back_Create_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- offer_back_create_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- offer_adjustment_line_id
26 -- offer_adjustment_id
27 -- list_line_id
28 -- arithmetic_operator
29 -- original_discount
30 -- modified_discount
31 -- last_update_date
32 -- last_updated_by
33 -- creation_date
34 -- created_by
35 -- last_update_login
36 -- object_version_number
37 -- security_group_id
38 --
39 -- Required
40 --
41 -- Defaults
42 --
43 -- Note: This is automatic generated record definition, it includes all columns
44 -- defined in the table, developer must manually add or delete some of the attributes.
45 --
46 -- End of Comments
47
48 --===================================================================
49 TYPE offer_back_create_rec_type IS RECORD
50 (
51 offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52 offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53 list_line_id NUMBER := FND_API.G_MISS_NUM,
54 arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 original_discount NUMBER := FND_API.G_MISS_NUM,
56 modified_discount NUMBER := FND_API.G_MISS_NUM,
57 last_update_date DATE := FND_API.G_MISS_DATE,
58 last_updated_by NUMBER := FND_API.G_MISS_NUM,
59 creation_date DATE := FND_API.G_MISS_DATE,
60 created_by NUMBER := FND_API.G_MISS_NUM,
61 last_update_login NUMBER := FND_API.G_MISS_NUM,
62 object_version_number NUMBER := FND_API.G_MISS_NUM,
63 security_group_id NUMBER := FND_API.G_MISS_NUM
64 );
65
66 g_miss_offer_back_create_rec offer_back_create_rec_type;
67 TYPE offer_back_create_tbl_type IS TABLE OF offer_back_create_rec_type INDEX BY BINARY_INTEGER;
68 g_miss_offer_back_create_tbl offer_back_create_tbl_type;
69
70 -- ==============================================================================
71 -- Start of Comments
72 -- ==============================================================================
73 -- API Name
74 -- Create_Offer_Back_Create
75 -- Type
76 -- Private
77 -- Pre-Req
78 --
79 -- Parameters
80 --
81 -- IN
82 -- p_api_version_number IN NUMBER Required
83 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_offer_back_create_rec IN offer_back_create_rec_type Required
87 --
88 -- OUT
89 -- x_return_status OUT VARCHAR2
90 -- x_msg_count OUT NUMBER
91 -- x_msg_data OUT VARCHAR2
92 -- Version : Current version 1.0
93 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
94 -- and basic operation, developer must manually add parameters and business logic as necessary.
95 --
96 -- End of Comments
97 -- ==============================================================================
98 --
99
100 PROCEDURE Create_Offer_Back(
101 p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109
110 p_offer_back_create_rec IN offer_back_create_rec_type := g_miss_offer_back_create_rec,
111 x_offer_adjustment_line_id OUT NOCOPY NUMBER
112 );
113
114 -- ==============================================================================
115 -- Start of Comments
116 -- ==============================================================================
117 -- API Name
118 -- Update_Offer_Back_Create
119 -- Type
120 -- Private
121 -- Pre-Req
122 --
123 -- Parameters
124 --
125 -- IN
126 -- p_api_version_number IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130 -- p_offer_back_create_rec IN offer_back_create_rec_type Required
131 --
132 -- OUT
133 -- x_return_status OUT VARCHAR2
134 -- x_msg_count OUT NUMBER
135 -- x_msg_data OUT VARCHAR2
136 -- Version : Current version 1.0
137 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
138 -- and basic operation, developer must manually add parameters and business logic as necessary.
139 --
140 -- End of Comments
141 -- ==============================================================================
142 --
143
144 PROCEDURE Update_Offer_Back(
145 p_api_version_number IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE,
148 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153
154 p_offer_back_create_rec IN offer_back_create_rec_type,
155 x_object_version_number OUT NOCOPY NUMBER
156 );
157
158 -- ==============================================================================
159 -- Start of Comments
160 -- ==============================================================================
161 -- API Name
162 -- Delete_Offer_Back_Create
163 -- Type
164 -- Private
165 -- Pre-Req
166 --
167 -- Parameters
168 --
169 -- IN
170 -- p_api_version_number IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- p_OFFER_ADJUSTMENT_LINE_ID IN NUMBER
175 -- p_object_version_number IN NUMBER Optional Default = NULL
176 --
177 -- OUT
178 -- x_return_status OUT VARCHAR2
179 -- x_msg_count OUT NUMBER
180 -- x_msg_data OUT VARCHAR2
181 -- Version : Current version 1.0
182 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
183 -- and basic operation, developer must manually add parameters and business logic as necessary.
184 --
185 -- End of Comments
186 -- ==============================================================================
187 --
188
189 PROCEDURE Delete_Offer_Back(
190 p_api_version_number IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_offer_adjustment_line_id IN NUMBER,
198 p_object_version_number IN NUMBER
199 );
200
201 -- ==============================================================================
202 -- Start of Comments
203 -- ==============================================================================
204 -- API Name
205 -- Lock_Offer_Back_Create
206 -- Type
207 -- Private
208 -- Pre-Req
209 --
210 -- Parameters
211 --
212 -- IN
213 -- p_api_version_number IN NUMBER Required
214 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217 -- p_offer_back_create_rec IN offer_back_create_rec_type Required
218 --
219 -- OUT
220 -- x_return_status OUT VARCHAR2
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2
223 -- Version : Current version 1.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 -- ==============================================================================
229 --
230
231 PROCEDURE Lock_Offer_Back(
232 p_api_version_number IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238
239 p_offer_adjustment_line_id IN NUMBER,
240 p_object_version IN NUMBER
241 );
242
243
244 -- Start of Comments
245 --
246 -- validation procedures
247 --
248 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
249 -- For create: G_CREATE, for update: G_UPDATE
250 -- Note: 1. This is automated generated item level validation procedure.
251 -- The actual validation detail is needed to be added.
252 -- 2. We can also validate table instead of record. There will be an option for user to choose.
253 -- End of Comments
254
255 PROCEDURE Validate_offer_back(
256 p_api_version_number IN NUMBER,
257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259 p_offer_back_create_rec IN offer_back_create_rec_type,
260 p_validation_mode IN VARCHAR2,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2
264 );
265
266 -- Start of Comments
267 --
268 -- validation procedures
269 --
270 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
271 -- For create: G_CREATE, for update: G_UPDATE
272 -- Note: 1. This is automated generated item level validation procedure.
273 -- The actual validation detail is needed to be added.
274 -- 2. Validate the unique keys, lookups here
275 -- End of Comments
276
277 PROCEDURE Check_offer_back_Items (
278 P_offer_back_create_rec IN offer_back_create_rec_type,
279 p_validation_mode IN VARCHAR2,
280 x_return_status OUT NOCOPY VARCHAR2
281 );
282
283 -- Start of Comments
284 --
285 -- Record level validation procedures
286 --
287 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation procedure.
290 -- The actual validation detail is needed to be added.
291 -- 2. Developer can manually added inter-field level validation.
292 -- End of Comments
293
294 PROCEDURE Validate_offer_back_rec(
295 p_api_version_number IN NUMBER,
296 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_offer_back_create_rec IN offer_back_create_rec_type
301 );
302 END OZF_Offer_Back_Create_PVT;
[Home] [Help]