[Home] [Help]
PACKAGE: APPS.AMS_ACTPRODUCT_PVT
Source
1 PACKAGE AMS_ActProduct_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvprds.pls 120.0 2005/06/01 00:06:54 appldev noship $*/
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_ActProduct_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing Product information in
11 -- AMS.
12 --
13 -- Procedures:
14 -- Create_Act_Product (see below for specification)
15 -- Update_Act_Product (see below for specification)
16 -- Delete_Act_Product (see below for specification)
17 -- Lock_Act_Product (see below for specification)
18 -- Validate_Act_Product (see below for specification)
19 -- Validate_Act_Product_Items (see below for specification)
20 -- Validate_Act_Product_Record (see below for specification
21 --
22 -- NOTES
23 --
24 -- History created rvaka 28-DEC-1999
25 -- 01-MAY-2001 julou modified, added 3 columns to ams_act_products
26 -- security_group_id, line_lumpsum_amount, line_lumpsum_qty
27 -- 05-Nov-2001 musman Commented out the reference to security_group_id
28
29 -- End of Comments
30
31 -- global constants
32
33 TYPE act_Product_rec_type
34 IS RECORD
35 (
36 ACTIVITY_PRODUCT_ID NUMBER,
37 LAST_UPDATE_DATE DATE,
38 LAST_UPDATED_BY NUMBER,
39 CREATION_DATE DATE,
40 CREATED_BY NUMBER,
41 LAST_UPDATE_LOGIN NUMBER,
42 OBJECT_VERSION_NUMBER NUMBER,
43 ACT_PRODUCT_USED_BY_ID NUMBER,
44 ARC_ACT_PRODUCT_USED_BY VARCHAR2(30),
45 PRODUCT_SALE_TYPE VARCHAR2(30),
46 PRIMARY_PRODUCT_FLAG VARCHAR2(1),
47 ENABLED_FLAG VARCHAR2(1),
48 EXCLUDED_FLAG VARCHAR2(1),
49 CATEGORY_ID NUMBER,
50 CATEGORY_SET_ID NUMBER,
51 ORGANIZATION_ID NUMBER,
52 INVENTORY_ITEM_ID NUMBER,
53 LEVEL_TYPE_CODE VARCHAR2(30),
54 --SECURITY_GROUP_ID NUMBER,
55 LINE_LUMPSUM_AMOUNT NUMBER,
56 LINE_LUMPSUM_QTY NUMBER,
57 ATTRIBUTE_CATEGORY VARCHAR2(30),
58 ATTRIBUTE1 VARCHAR2(150),
59 ATTRIBUTE2 VARCHAR2(150),
60 ATTRIBUTE3 VARCHAR2(150),
61 ATTRIBUTE4 VARCHAR2(150),
62 ATTRIBUTE5 VARCHAR2(150),
63 ATTRIBUTE6 VARCHAR2(150),
64 ATTRIBUTE7 VARCHAR2(150),
65 ATTRIBUTE8 VARCHAR2(150),
66 ATTRIBUTE9 VARCHAR2(150),
67 ATTRIBUTE10 VARCHAR2(150),
68 ATTRIBUTE11 VARCHAR2(150),
69 ATTRIBUTE12 VARCHAR2(150),
70 ATTRIBUTE13 VARCHAR2(150),
71 ATTRIBUTE14 VARCHAR2(150),
72 ATTRIBUTE15 VARCHAR2(150),
73 CHANNEL_ID NUMBER,
74 UOM_CODE VARCHAR2(3),
75 QUANTITY NUMBER,
76 SCAN_VALUE NUMBER,
77 SCAN_UNIT_FORECAST NUMBER,
78 ADJUSTMENT_FLAG VARCHAR2(1));
79
80 FUNCTION get_actual_unit(p_activity_product_id IN NUMBER)
81 RETURN NUMBER;
82
83 --FUNCTION get_actual_amount(p_activity_product_id IN NUMBER)
84 --RETURN NUMBER;
85
86 PROCEDURE Create_Act_Product
87 ( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94
95 p_act_Product_rec IN Act_Product_rec_type,
96 x_act_Product_id OUT NOCOPY NUMBER
97 );
98
99 /****************************************************************************/
100 -- Start of Comments
101 --
102 -- API name : Update_Act_Product
103 -- Type : Private
104 -- Function : Update a row in AMS_ACT_PRODUCTS table
105 --
106 -- Pre-reqs : None
107 -- Paramaeters :
108 -- IN :
109 -- standard IN parameters
110 -- p_api_version IN NUMBER := NULL Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
113 -- p_validation_level IN NUMBER
114 -- := FND_API.G_VALID_LEVEL_FULL,
115 -- API's IN parameters
116 --
117 -- p_act_Product_rec IN Act_Product_rec_type
118 --
119 -- OUT :
120 -- standard OUT parameters
121 -- x_return_status OUT VARCHAR2(1)
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2(2000)
124 --
125 -- Version : Current version 1.0
126 -- Initial version 1.0
127 --
128 -- Note : 1. p_act_Product_rec.activity_delivery_method_id is a required parameter
129 -- 2. p_act_Product_rec.activity_delivery_method_id is not updatable
130 --
131 -- End Of Comments
132
133 PROCEDURE Update_Act_Product
134 ( p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141
142 p_act_Product_rec IN Act_Product_rec_type
143 );
144
145 /*****************************************************************************************/
146 -- Start of Comments
147 --
148 -- API name : Delete_Act_Product
149 -- Type : Private
150 -- Function : Delete a row in AMS_ACT_PRODUCTS table
151 --
152 -- Pre-reqs : None
153 -- Paramaeters :
154 -- IN :
155 -- standard IN parameters
156 -- p_api_version IN NUMBER := NULL Required
157 -- p_init_msg_list IN VARCHAR2 Optional
158 -- Default := FND_API.G_FALSE
159 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
160 -- p_validation_level IN NUMBER
161 -- := FND_API.G_VALID_LEVEL_FULL,
162 -- API's IN parameters
163 -- p_act_Product_rec IN Act_Product_rec_type Required
164 --
165 -- standard OUT parameters
166 -- x_return_status OUT VARCHAR2(1)
167 -- x_msg_count OUT NUMBER
168 -- x_msg_data OUT VARCHAR2(2000)
169 --
170 -- Version : Current version 1.0
171 -- Initial version 1.0
172 --
173 -- Note : 1. p_Product_rec.activity_Delivery_method_id is a required parameter
174 --
175 -- End Of Comments
176
177 PROCEDURE Delete_Act_Product
178 ( p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185
186 p_act_Product_id IN NUMBER,
187 p_object_version IN NUMBER
188 );
189
190
191 /*****************************************************************************************/
192 -- Start of Comments
193 --
194 -- API name : Lock_Act_Product
195 -- Type : Private
196 -- Function : Lock a row in AMS_ACT_PRODUCTS table
197 --
198 -- Pre-reqs : None
199 -- Paramaeters :
200 -- IN :
201 -- standard IN parameters
202 -- p_api_version IN NUMBER := NULL Required
203 -- p_init_msg_list IN VARCHAR2 Optional
204 -- Default := FND_API.G_FALSE
205 -- p_validation_level IN NUMBER
206 -- := FND_API.G_VALID_LEVEL_FULL,
207 -- API's IN parameters
208 -- p_Product_rec IN Act_Product_rec_type Required
209 -- OUT :
210 -- standard OUT parameters
211 -- x_return_status OUT VARCHAR2(1)
212 -- x_msg_count OUT NUMBER
213 -- x_msg_data OUT VARCHAR2(2000)
214 --
215 --
216 -- Version : Current version 1.0
217 -- Initial version 1.0
218 --
219 -- Note : p_Product_rec.activity_product_id is a required parameter
220 --
221 -- End Of Comments
222
223 PROCEDURE Lock_Act_Product
224 ( p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230
231 p_act_Product_id IN NUMBER,
232 p_object_version IN NUMBER
233 );
234
235 /*****************************************************************************************/
236 -- Start of Comments
237 --
238 -- API name : Validate_Act_Product
239 -- Type : Private
240 -- Function : Validate a row in AMS_ACT_PRODUCTS table
241 --
242 -- Pre-reqs : None
243 -- Paramaeters :
244 -- IN :
245 -- standard IN parameters
246 -- p_api_version IN NUMBER := NULL Required
247 -- p_init_msg_list IN VARCHAR2 Optional
248 -- Default := FND_API.G_FALSE
249 -- p_validation_level IN NUMBER
250 -- := FND_API.G_VALID_LEVEL_FULL,
251 -- API's IN parameters
252 --
253 -- p_Product_rec IN Act_Product_rec_type Required
254 --
255 -- standard OUT parameters
256 -- x_return_status OUT VARCHAR2(1)
257 -- x_msg_count OUT NUMBER
258 -- x_msg_data OUT VARCHAR2(2000)
259 --
260 -- Version : Current version 1.0
261 -- Initial version 1.0
262 --
263 -- Note : 1. p_Product_rec.activity_product_id is a required parameter
264 -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
265 -- FND_API.G_RET_STS_ERROR, or
266 -- FND_API.G_RET_STS_UNEXP_ERROR
267 --
268 -- End Of Comments
269
270 PROCEDURE Validate_Act_Product
271 ( p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277
278 p_act_Product_rec IN Act_Product_rec_type
279 );
280
281 PROCEDURE Validate_Act_Product_Items
282 ( p_act_Product_rec IN Act_Product_rec_type,
283 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
284 x_return_status OUT NOCOPY VARCHAR2
285 );
286
287 PROCEDURE Validate_Act_Product_Record
288 (
289 p_act_Product_rec IN Act_Product_rec_type,
290 x_return_status OUT NOCOPY VARCHAR2
291 );
292
293 PROCEDURE complete_act_Product_rec(
294 p_act_Product_rec IN Act_Product_rec_type,
295 x_act_Product_rec OUT NOCOPY Act_Product_rec_type
296 );
297
298 FUNCTION get_category_name(
299 p_category_id IN NUMBER,
300 p_category_set_id IN NUMBER,
301 p_object_type in varchar2
302 ) RETURN VARCHAR2;
303
304 FUNCTION get_category_desc(
305 p_category_id IN NUMBER,
306 p_category_set_id IN NUMBER,
307 p_object_type in varchar2
308 ) RETURN VARCHAR2;
309
310 -------------------------------------------------------------
311 -- Start of Comments
312 -- Name
313 -- UPDATE_SCHEDULE_ACTIVITIES
314 --
315 -- Purpose
316 -- This function is called from Business Event
317 -------------------------------------------------------------
318 FUNCTION UPDATE_SCHEDULE_ACTIVITIES(p_subscription_guid IN RAW,
319 p_event IN OUT NOCOPY WF_EVENT_T
320 ) RETURN VARCHAR2;
321
322 PROCEDURE IS_ALL_CONTENT_APPROVED (
323 p_schedule_id IN NUMBER,
324 x_return_status OUT NOCOPY VARCHAR2
325 );
326
327 -------------------------------------------------------------
328 -- Start of Comments
329 -- Name
330 -- GET_CATEGORY_SET_ID
331 --
332 -- Purpose
333 -- This function is used by web adi import apis
334 -------------------------------------------------------------
335 FUNCTION GET_CATEGORY_SET_ID
336 RETURN NUMBER;
337
338 -------------------------------------------------------------
339 -- Start of Comments
340 -- Name
341 -- GET_LEVEL_TYPE_CODE
342 --
343 -- Purpose
344 -- This function is used by web adi import apis
345 -------------------------------------------------------------
346 FUNCTION GET_LEVEL_TYPE_CODE( p_inv_id IN NUMBER
347 ,p_Cat_id IN NUMBER)
348 RETURN VARCHAR2;
349
350
351 END AMS_ActProduct_PVT;