83: -- IN :
84: -- standard IN parameters
85: -- p_api_version IN NUMBER := NULL Required
86: -- p_init_msg_list IN VARCHAR2 Optional
87: -- Default := FND_API.g_false,
88: -- p_commit IN VARCHAR2 := FND_API.g_false, Optional
89: -- p_validation_level IN NUMBER
90: -- := FND_API.g_valid_level_full,
91: --
84: -- standard IN parameters
85: -- p_api_version IN NUMBER := NULL Required
86: -- p_init_msg_list IN VARCHAR2 Optional
87: -- Default := FND_API.g_false,
88: -- p_commit IN VARCHAR2 := FND_API.g_false, Optional
89: -- p_validation_level IN NUMBER
90: -- := FND_API.g_valid_level_full,
91: --
92: -- API's IN parameters
86: -- p_init_msg_list IN VARCHAR2 Optional
87: -- Default := FND_API.g_false,
88: -- p_commit IN VARCHAR2 := FND_API.g_false, Optional
89: -- p_validation_level IN NUMBER
90: -- := FND_API.g_valid_level_full,
91: --
92: -- API's IN parameters
93: -- p_Category_rec IN category_rec_type Required
94: -- OUT :
110: -- End Of Comments
111:
112: PROCEDURE Create_Category
113: ( p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
111:
112: PROCEDURE Create_Category
113: ( p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
112: PROCEDURE Create_Category
113: ( p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_category_rec IN category_rec_type,
133: -- IN :
134: -- standard IN parameters
135: -- p_api_version IN NUMBER := NULL Required
136: -- p_init_msg_list IN VARCHAR2 Optional
137: -- Default := FND_API.g_false
138: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
139: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140: -- API's IN parameters
141: -- p_Category_rec IN category_rec_type Required
134: -- standard IN parameters
135: -- p_api_version IN NUMBER := NULL Required
136: -- p_init_msg_list IN VARCHAR2 Optional
137: -- Default := FND_API.g_false
138: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
139: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140: -- API's IN parameters
141: -- p_Category_rec IN category_rec_type Required
142: --
135: -- p_api_version IN NUMBER := NULL Required
136: -- p_init_msg_list IN VARCHAR2 Optional
137: -- Default := FND_API.g_false
138: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
139: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140: -- API's IN parameters
141: -- p_Category_rec IN category_rec_type Required
142: --
143: -- OUT :
156: -- End Of Comments
157:
158: PROCEDURE Update_Category
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
157:
158: PROCEDURE Update_Category
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
158: PROCEDURE Update_Category
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161: p_commit IN VARCHAR2 := FND_API.g_false,
162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166:
179: -- IN :
180: -- standard IN parameters
181: -- p_api_version IN NUMBER := NULL Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default := FND_API.g_false
184: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
185: -- p_validation_level IN NUMBER
186: -- := FND_API.g_valid_level_full,
187: -- API's IN parameters
180: -- standard IN parameters
181: -- p_api_version IN NUMBER := NULL Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default := FND_API.g_false
184: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
185: -- p_validation_level IN NUMBER
186: -- := FND_API.g_valid_level_full,
187: -- API's IN parameters
188: -- p_Category_rec IN category_rec_type Required
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default := FND_API.g_false
184: -- p_commit IN VARCHAR2 := FND_API.g_false Optional
185: -- p_validation_level IN NUMBER
186: -- := FND_API.g_valid_level_full,
187: -- API's IN parameters
188: -- p_Category_rec IN category_rec_type Required
189: --
190: --
202: -- End Of Comments
203:
204: PROCEDURE Delete_Category
205: ( p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
203:
204: PROCEDURE Delete_Category
205: ( p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
204: PROCEDURE Delete_Category
205: ( p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212:
227: -- IN :
228: -- standard IN parameters
229: -- p_api_version IN NUMBER := NULL Required
230: -- p_init_msg_list IN VARCHAR2 Optional
231: -- Default := FND_API.g_false
232: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233: -- API's IN parameters
234: -- p_category_id IN NUMBER required
235: -- p_object_version IN NUMBER required
228: -- standard IN parameters
229: -- p_api_version IN NUMBER := NULL Required
230: -- p_init_msg_list IN VARCHAR2 Optional
231: -- Default := FND_API.g_false
232: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233: -- API's IN parameters
234: -- p_category_id IN NUMBER required
235: -- p_object_version IN NUMBER required
236: -- standard OUT parameters
247: -- End Of Comments
248:
249: PROCEDURE Lock_Category
250: ( p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
252: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
248:
249: PROCEDURE Lock_Category
250: ( p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
252: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256:
263: -- complete_category_rec
264: --
265: -- PURPOSE
266: -- For update_category, some attributes may be passed in as
267: -- FND_API.g_miss_char/num/date if the user doesn't want to
268: -- update those attributes. This procedure will replace the
269: -- "g_miss" attributes with current database values.
270: --
271: -- PARAMETERS
269: -- "g_miss" attributes with current database values.
270: --
271: -- PARAMETERS
272: -- p_category_rec: the record which may contain attributes as
273: -- FND_API.g_miss_char/num/date
274: -- x_complete_rec: the complete record after all "g_miss" items
275: -- have been replaced by current database values
276: ---------------------------------------------------------------------
277: PROCEDURE complete_category_rec(
291: -- IN :
292: -- standard IN parameters
293: -- p_api_version IN NUMBER := NULL Required
294: -- p_init_msg_list IN VARCHAR2 Optional
295: -- Default := FND_API.g_false
296: -- p_validation_level IN NUMBER
297: -- := FND_API.g_valid_level_full,
298: -- API's IN parameters
299: -- p_Category_rec IN category_rec_type Required
293: -- p_api_version IN NUMBER := NULL Required
294: -- p_init_msg_list IN VARCHAR2 Optional
295: -- Default := FND_API.g_false
296: -- p_validation_level IN NUMBER
297: -- := FND_API.g_valid_level_full,
298: -- API's IN parameters
299: -- p_Category_rec IN category_rec_type Required
300: --
301: -- OUT :
311: -- Version : Current version 1.0
312: -- Initial version 1.0
313: --
314: -- Note : 1. p_Category_rec.category_id is a required parameter
315: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
316: -- FND_API.G_RET_STS_UNEXP_ERROR
317: --
318: -- End Of Comments
319:
312: -- Initial version 1.0
313: --
314: -- Note : 1. p_Category_rec.category_id is a required parameter
315: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
316: -- FND_API.G_RET_STS_UNEXP_ERROR
317: --
318: -- End Of Comments
319:
320: PROCEDURE Validate_Category
318: -- End Of Comments
319:
320: PROCEDURE Validate_Category
321: ( p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
323: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
319:
320: PROCEDURE Validate_Category
321: ( p_api_version IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
323: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327:
362: -- IN :
363: -- standard IN parameters
364: -- p_api_version IN NUMBER := NULL Required
365: -- p_init_msg_list IN VARCHAR2 Optional
366: -- Default := FND_API.g_false
367: -- API's IN parameters
368: --
369: -- p_Category_rec IN category_rec_type Required
370: --
377: --
378: -- Version : Current version 1.0
379: -- Initial version 1.0
380: --
381: -- Note : x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
382: -- FND_API.G_RET_STS_UNEXP_ERROR
383: --
384: -- End Of Comments
385:
378: -- Version : Current version 1.0
379: -- Initial version 1.0
380: --
381: -- Note : x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
382: -- FND_API.G_RET_STS_UNEXP_ERROR
383: --
384: -- End Of Comments
385:
386: PROCEDURE Validate_Cty_Record
384: -- End Of Comments
385:
386: PROCEDURE Validate_Cty_Record
387: ( p_api_version IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
392: