139: -- Paramaeters :
140: -- IN :
141: -- standard IN parameters
142: -- p_api_version IN NUMBER := NULL Required
143: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
145: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: --
147: -- API's IN parameters
140: -- IN :
141: -- standard IN parameters
142: -- p_api_version IN NUMBER := NULL Required
143: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
145: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: --
147: -- API's IN parameters
148: -- p_Thldchk_Rec IN thldchk_rec_type,
141: -- standard IN parameters
142: -- p_api_version IN NUMBER := NULL Required
143: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
145: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: --
147: -- API's IN parameters
148: -- p_Thldchk_Rec IN thldchk_rec_type,
149: -- OUT :
167: -- End Of Comments
168:
169: PROCEDURE Create_thldchk
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
172: p_commit IN VARCHAR2 := FND_API.G_False,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
168:
169: PROCEDURE Create_thldchk
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
172: p_commit IN VARCHAR2 := FND_API.G_False,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
169: PROCEDURE Create_thldchk
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
172: p_commit IN VARCHAR2 := FND_API.G_False,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177:
190: -- Paramaeters :
191: -- IN :
192: -- standard IN parameters
193: -- p_api_version IN NUMBER := NULL Required
194: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
195: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
196: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: -- API's IN parameters
198: -- p_thldchk_rec IN thldchk_rec_type
191: -- IN :
192: -- standard IN parameters
193: -- p_api_version IN NUMBER := NULL Required
194: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
195: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
196: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: -- API's IN parameters
198: -- p_thldchk_rec IN thldchk_rec_type
199:
192: -- standard IN parameters
193: -- p_api_version IN NUMBER := NULL Required
194: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
195: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
196: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: -- API's IN parameters
198: -- p_thldchk_rec IN thldchk_rec_type
199:
200: -- OUT :
212: -- End Of Comments
213:
214: PROCEDURE Update_Thldchk
215: ( p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
217: p_commit IN VARCHAR2 := FND_API.G_False,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
213:
214: PROCEDURE Update_Thldchk
215: ( p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
217: p_commit IN VARCHAR2 := FND_API.G_False,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
214: PROCEDURE Update_Thldchk
215: ( p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
217: p_commit IN VARCHAR2 := FND_API.G_False,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
235: -- Paramaeters :
236: -- IN :
237: -- standard IN parameters
238: -- p_api_version IN NUMBER := NULL Required
239: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
240: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
241: -- API's IN parameters
242: -- p_trigger_check_id IN NUMBER,
243: -- p_object_version_number IN NUMBER
236: -- IN :
237: -- standard IN parameters
238: -- p_api_version IN NUMBER := NULL Required
239: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
240: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
241: -- API's IN parameters
242: -- p_trigger_check_id IN NUMBER,
243: -- p_object_version_number IN NUMBER
244: --
257: -- End Of Comments
258:
259: PROCEDURE Delete_Thldchk
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
262: p_commit IN VARCHAR2 := FND_API.G_False,
263:
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
258:
259: PROCEDURE Delete_Thldchk
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
262: p_commit IN VARCHAR2 := FND_API.G_False,
263:
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
281: -- Paramaeters :
282: -- IN :
283: -- standard IN parameters
284: -- p_api_version IN NUMBER := NULL Required
285: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
286: --
287: -- API's IN parameters
288: -- p_trigger_check_id IN NUMBER
289: -- p_object_version_number IN NUMBER
303:
304:
305: PROCEDURE Lock_Thldchk
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
308:
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
326: -- Paramaeters :
327: -- IN :
328: -- standard IN parameters
329: -- p_api_version IN NUMBER := NULL Required
330: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
331: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332: --
333: -- API's IN parameters
334: -- p_thldchk_Rec IN thldchk_rec_type
327: -- IN :
328: -- standard IN parameters
329: -- p_api_version IN NUMBER := NULL Required
330: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
331: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332: --
333: -- API's IN parameters
334: -- p_thldchk_Rec IN thldchk_rec_type
335: --
349: -- End Of Comments
350:
351: PROCEDURE Validate_Thldchk
352: ( p_api_version IN NUMBER,
353: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: x_return_status OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,
357: x_msg_data OUT NOCOPY VARCHAR2,
350:
351: PROCEDURE Validate_Thldchk
352: ( p_api_version IN NUMBER,
353: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355: x_return_status OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,
357: x_msg_data OUT NOCOPY VARCHAR2,
358: