148: -- Parameters
149: --
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
156: --
149: --
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
156: --
157: -- OUT
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
156: --
157: -- OUT
158: -- x_return_status OUT VARCHAR2
167: --
168:
169: PROCEDURE Create_Threshold_Rule(
170: p_api_version_number 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:
175: x_return_status OUT NOCOPY VARCHAR2,
168:
169: PROCEDURE Create_Threshold_Rule(
170: p_api_version_number 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:
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
169: PROCEDURE Create_Threshold_Rule(
170: p_api_version_number 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:
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
192: -- Parameters
193: --
194: -- IN
195: -- p_api_version_number IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
197: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
199: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
200: --
193: --
194: -- IN
195: -- p_api_version_number IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
197: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
199: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
200: --
201: -- OUT
194: -- IN
195: -- p_api_version_number IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
197: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
199: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
200: --
201: -- OUT
202: -- x_return_status OUT VARCHAR2
211: --
212:
213: PROCEDURE Update_Threshold_Rule(
214: p_api_version_number IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218:
219: x_return_status OUT NOCOPY VARCHAR2,
212:
213: PROCEDURE Update_Threshold_Rule(
214: p_api_version_number IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218:
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
213: PROCEDURE Update_Threshold_Rule(
214: p_api_version_number IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218:
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
236: -- Parameters
237: --
238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
243: -- p_THRESHOLD_RULE_ID IN NUMBER
244: -- p_object_version_number IN NUMBER Optional Default = NULL
237: --
238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
243: -- p_THRESHOLD_RULE_ID IN NUMBER
244: -- p_object_version_number IN NUMBER Optional Default = NULL
245: --
238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
243: -- p_THRESHOLD_RULE_ID IN NUMBER
244: -- p_object_version_number IN NUMBER Optional Default = NULL
245: --
246: -- OUT
256: --
257:
258: PROCEDURE Delete_Threshold_Rule(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
257:
258: PROCEDURE Delete_Threshold_Rule(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
258: PROCEDURE Delete_Threshold_Rule(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_threshold_rule_id IN NUMBER,
279: -- Parameters
280: --
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
287: --
280: --
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
287: --
288: -- OUT
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_threshold_rule_rec IN threshold_rule_rec_type Required
287: --
288: -- OUT
289: -- x_return_status OUT VARCHAR2
298: --
299:
300: PROCEDURE Lock_Threshold_Rule(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303:
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
322: -- End of Comments
323:
324: PROCEDURE Validate_threshold_rule(
325: p_api_version_number IN NUMBER,
326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: p_threshold_rule_rec IN threshold_rule_rec_type,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
323:
324: PROCEDURE Validate_threshold_rule(
325: p_api_version_number IN NUMBER,
326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: p_threshold_rule_rec IN threshold_rule_rec_type,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2
360: -- End of Comments
361:
362: PROCEDURE Validate_threshold_rule_rec(
363: p_api_version_number IN NUMBER,
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_threshold_rule_rec IN threshold_rule_rec_type