DBA Data[Home] [Help]

APPS.AMS_CATEGORY_PVT dependencies on FND_API

Line 87: -- Default := FND_API.g_false,

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: --

Line 88: -- p_commit IN VARCHAR2 := FND_API.g_false, Optional

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

Line 90: -- := FND_API.g_valid_level_full,

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 :

Line 114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 115: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 116: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 137: -- Default := FND_API.g_false

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

Line 138: -- p_commit IN VARCHAR2 := FND_API.g_false Optional

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: --

Line 139: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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 :

Line 160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 161: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 162: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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:

Line 183: -- Default := FND_API.g_false

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

Line 184: -- p_commit IN VARCHAR2 := FND_API.g_false Optional

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

Line 186: -- := FND_API.g_valid_level_full,

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: --

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 207: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 208: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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:

Line 231: -- Default := FND_API.g_false

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

Line 232: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 252: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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:

Line 267: -- FND_API.g_miss_char/num/date if the user doesn't want to

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

Line 273: -- FND_API.g_miss_char/num/date

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(

Line 295: -- Default := FND_API.g_false

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

Line 297: -- := FND_API.g_valid_level_full,

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 :

Line 315: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or

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:

Line 316: -- FND_API.G_RET_STS_UNEXP_ERROR

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

Line 322: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 323: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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:

Line 366: -- Default := FND_API.g_false

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: --

Line 381: -- Note : x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or

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:

Line 382: -- FND_API.G_RET_STS_UNEXP_ERROR

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

Line 388: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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: