1 PACKAGE OZF_Adj_New_Prod_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvanps.pls 120.0 2006/03/30 13:50:43 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Adj_New_Prod_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 -- adj_new_prod_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- offer_adj_new_product_id
26 -- offer_adj_new_line_id
27 -- product_context
28 -- product_attribute
29 -- product_attr_value
30 -- excluder_flag
31 -- uom_code
32 -- creation_date
33 -- created_by
34 -- last_update_date
35 -- last_updated_by
36 -- last_update_login
37 -- object_version_number
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 adj_new_prod_rec_type IS RECORD
50 (
51 offer_adj_new_product_id NUMBER ,
52 offer_adj_new_line_id NUMBER ,
53 offer_adjustment_id NUMBER ,
54 product_context VARCHAR2(30) ,
55 product_attribute VARCHAR2(30) ,
56 product_attr_value VARCHAR2(240) ,
57 excluder_flag VARCHAR2(1) ,
58 uom_code VARCHAR2(30) ,
59 creation_date DATE ,
60 created_by NUMBER ,
61 last_update_date DATE ,
62 last_updated_by NUMBER ,
63 last_update_login NUMBER ,
64 object_version_number NUMBER ,
65 offer_type VARCHAR2(30)
66 );
67
68 g_miss_adj_new_prod_rec adj_new_prod_rec_type;
69 TYPE adj_new_prod_tbl_type IS TABLE OF adj_new_prod_rec_type INDEX BY BINARY_INTEGER;
70 g_miss_adj_new_prod_tbl adj_new_prod_tbl_type;
71
72 -- ==============================================================================
73 -- Start of Comments
74 -- ==============================================================================
75 -- API Name
76 -- Create_Adj_New_Prod
77 -- Type
78 -- Private
79 -- Pre-Req
80 --
81 -- Parameters
82 --
83 -- IN
84 -- p_api_version_number IN NUMBER Required
85 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88 -- p_adj_new_prod_rec IN adj_new_prod_rec_type Required
89 --
90 -- OUT
91 -- x_return_status OUT VARCHAR2
92 -- x_msg_count OUT NUMBER
93 -- x_msg_data OUT VARCHAR2
94 -- Version : Current version 1.0
95 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
96 -- and basic operation, developer must manually add parameters and business logic as necessary.
97 --
98 -- End of Comments
99 -- ==============================================================================
100 --
101
102 PROCEDURE Create_Adj_New_Prod(
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_adj_new_prod_rec IN adj_new_prod_rec_type := g_miss_adj_new_prod_rec,
113 x_offer_adj_new_product_id OUT NOCOPY NUMBER
114 );
115
116 -- ==============================================================================
117 -- Start of Comments
118 -- ==============================================================================
119 -- API Name
120 -- Update_Adj_New_Prod
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_adj_new_prod_rec IN adj_new_prod_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 -- End of Comments
143 -- ==============================================================================
144 --
145
146 PROCEDURE Update_Adj_New_Prod(
147 p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155
156 p_adj_new_prod_rec IN adj_new_prod_rec_type,
157 x_object_version_number OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Delete_Adj_New_Prod
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_OFFER_ADJ_NEW_PRODUCT_ID IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 -- ==============================================================================
189 --
190
191 PROCEDURE Delete_Adj_New_Prod(
192 p_api_version_number IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_offer_adj_new_product_id IN NUMBER,
200 p_object_version_number IN NUMBER
201 );
202
203 -- ==============================================================================
204 -- Start of Comments
205 -- ==============================================================================
206 -- API Name
207 -- Lock_Adj_New_Prod
208 -- Type
209 -- Private
210 -- Pre-Req
211 --
212 -- Parameters
213 --
214 -- IN
215 -- p_api_version_number IN NUMBER Required
216 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219 -- p_adj_new_prod_rec IN adj_new_prod_rec_type Required
220 --
221 -- OUT
222 -- x_return_status OUT VARCHAR2
223 -- x_msg_count OUT NUMBER
224 -- x_msg_data OUT VARCHAR2
225 -- Version : Current version 1.0
226 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
227 -- and basic operation, developer must manually add parameters and business logic as necessary.
228 --
229 -- End of Comments
230 -- ==============================================================================
231 --
232
233 PROCEDURE Lock_Adj_New_Prod(
234 p_api_version_number IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240
241 p_offer_adj_new_product_id IN NUMBER,
242 p_object_version IN NUMBER
243 );
244
245
246 -- Start of Comments
247 --
248 -- validation procedures
249 --
250 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
251 -- For create: G_CREATE, for update: G_UPDATE
252 -- Note: 1. This is automated generated item level validation procedure.
253 -- The actual validation detail is needed to be added.
254 -- 2. We can also validate table instead of record. There will be an option for user to choose.
255 -- End of Comments
256
257 PROCEDURE Validate_adj_new_prod(
258 p_api_version_number IN NUMBER,
259 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
262 p_adj_new_prod_rec IN adj_new_prod_rec_type,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2
266 );
267
268 -- Start of Comments
269 --
270 -- validation procedures
271 --
272 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
273 -- For create: G_CREATE, for update: G_UPDATE
274 -- Note: 1. This is automated generated item level validation procedure.
275 -- The actual validation detail is needed to be added.
276 -- 2. Validate the unique keys, lookups here
277 -- End of Comments
278
279 PROCEDURE Check_adj_new_prod_Items (
280 P_adj_new_prod_rec IN adj_new_prod_rec_type,
281 p_validation_mode IN VARCHAR2,
282 x_return_status OUT NOCOPY VARCHAR2
283 );
284
285 -- Start of Comments
286 --
287 -- Record level validation procedures
288 --
289 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
290 -- For create: G_CREATE, for update: G_UPDATE
291 -- Note: 1. This is automated generated item level validation procedure.
292 -- The actual validation detail is needed to be added.
293 -- 2. Developer can manually added inter-field level validation.
294 -- End of Comments
295
296 PROCEDURE Validate_adj_new_prod_rec(
297 p_api_version_number IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_adj_new_prod_rec IN adj_new_prod_rec_type
303 );
304 END OZF_Adj_New_Prod_PVT;