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