DBA Data[Home] [Help]

APPS.AMS_TRIG_PVT dependencies on FND_API

Line 139: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

135: -- Paramaeters :
136: -- IN :
137: -- standard IN parameters
138: -- p_api_version IN NUMBER := NULL Required
139: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: --
143: -- API's IN parameters

Line 140: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

136: -- IN :
137: -- standard IN parameters
138: -- p_api_version IN NUMBER := NULL Required
139: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: --
143: -- API's IN parameters
144: -- p_Trig_Rec IN trig_rec_type%ROWTYPE,

Line 141: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

137: -- standard IN parameters
138: -- p_api_version IN NUMBER := NULL Required
139: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: --
143: -- API's IN parameters
144: -- p_Trig_Rec IN trig_rec_type%ROWTYPE,
145: -- OUT :

Line 175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

171: -- End Of Comments
172:
173: PROCEDURE Create_Trigger
174: ( p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status OUT NOCOPY VARCHAR2,

Line 176: p_commit IN VARCHAR2 := FND_API.G_FALSE,

172:
173: PROCEDURE Create_Trigger
174: ( p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,

Line 177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

173: PROCEDURE Create_Trigger
174: ( p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178:
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,

Line 199: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

195: -- Paramaeters :
196: -- IN :
197: -- standard IN parameters
198: -- p_api_version IN NUMBER := NULL Required
199: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: -- p_validation_level IN := FND_API.G_VALID_LEVEL_FULL,
202: -- API's IN parameters
203: -- p_trig_rec IN trig_rec_type

Line 200: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

196: -- IN :
197: -- standard IN parameters
198: -- p_api_version IN NUMBER := NULL Required
199: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: -- p_validation_level IN := FND_API.G_VALID_LEVEL_FULL,
202: -- API's IN parameters
203: -- p_trig_rec IN trig_rec_type
204: --

Line 201: -- p_validation_level IN := FND_API.G_VALID_LEVEL_FULL,

197: -- standard IN parameters
198: -- p_api_version IN NUMBER := NULL Required
199: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: -- p_validation_level IN := FND_API.G_VALID_LEVEL_FULL,
202: -- API's IN parameters
203: -- p_trig_rec IN trig_rec_type
204: --
205: -- OUT :

Line 222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

218: -- End Of Comments
219:
220: PROCEDURE Update_Trigger
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_commit IN VARCHAR2 := FND_API.G_FALSE,

219:
220: PROCEDURE Update_Trigger
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

220: PROCEDURE Update_Trigger
221: ( p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

Line 245: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

241: -- Paramaeters :
242: -- IN :
243: -- standard IN parameters
244: -- p_api_version IN NUMBER := NULL Required
245: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
247: -- API's IN parameters
248: -- p_Trigger_id IN NUMBER
249: -- p_object_version_number IN NUMBER

Line 246: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

242: -- IN :
243: -- standard IN parameters
244: -- p_api_version IN NUMBER := NULL Required
245: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
246: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
247: -- API's IN parameters
248: -- p_Trigger_id IN NUMBER
249: -- p_object_version_number IN NUMBER
250: --

Line 269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

265: -- End Of Comments
266:
267: PROCEDURE Delete_Trigger
268: ( p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,

Line 270: p_commit IN VARCHAR2 := FND_API.G_FALSE,

266:
267: PROCEDURE Delete_Trigger
268: ( p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,

Line 293: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional

289: -- Paramaeters :
290: -- IN :
291: -- standard IN parameters
292: -- p_api_version IN NUMBER := NULL Required
293: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
294: --
295: -- API's IN parameters
296: -- p_Trigger_id IN NUMBER
297: -- p_object_version_number IN NUMBER

Line 316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

312:
313:
314: PROCEDURE Lock_Trigger
315: ( p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317:
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,

Line 339: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional

335: -- Paramaeters :
336: -- IN :
337: -- standard IN parameters
338: -- p_api_version IN NUMBER := NULL Required
339: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
340: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: --
342: -- API's IN parameters
343: -- p_Trig_Rec IN trig_rec_type

Line 340: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

336: -- IN :
337: -- standard IN parameters
338: -- p_api_version IN NUMBER := NULL Required
339: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
340: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: --
342: -- API's IN parameters
343: -- p_Trig_Rec IN trig_rec_type
344: --

Line 358: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,

354: -- Version : Current version 1.0
355: -- Initial version 1.0
356: --
357: -- Note : 1. p_Trig_rec.trigger_id is a required parameter
358: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
359: -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
360: -- Business rules:
361: -- 1. ...
362: --

Line 359: -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

355: -- Initial version 1.0
356: --
357: -- Note : 1. p_Trig_rec.trigger_id is a required parameter
358: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
359: -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
360: -- Business rules:
361: -- 1. ...
362: --
363: --

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

364: -- End Of Comments
365:
366: PROCEDURE Validate_Trigger(
367: p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
369: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
370:
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,

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

365:
366: PROCEDURE Validate_Trigger(
367: p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
369: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
370:
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,

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

426: --
427: -- Version : Current version 1.0
428: -- Initial version 1.0
429: --
430: -- Note : x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
431: -- FND_API.G_RET_STS_UNEXP_ERROR
432: --
433: --
434: -- Business rules:

Line 431: -- FND_API.G_RET_STS_UNEXP_ERROR

427: -- Version : Current version 1.0
428: -- Initial version 1.0
429: --
430: -- Note : x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
431: -- FND_API.G_RET_STS_UNEXP_ERROR
432: --
433: --
434: -- Business rules:
435: -- 1. ...