15:
16: -- Default number of records fetch per call
17: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18:
19: G_FALSE VARCHAr2(1) := FND_API.G_FALSE;
20: G_TRUE VARCHAr2(1) := FND_API.G_TRUE;
21:
22: --===================================================================
23: -- Start of Comments
16: -- Default number of records fetch per call
17: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18:
19: G_FALSE VARCHAr2(1) := FND_API.G_FALSE;
20: G_TRUE VARCHAr2(1) := FND_API.G_TRUE;
21:
22: --===================================================================
23: -- Start of Comments
24: -- -------------------------------------------------------
209: -- Parameters
210: --
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_control_rec IN control_rec_type Required
217: -- p_load_control_mode IN VARCHAR2 Required
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_control_rec IN control_rec_type Required
217: -- p_load_control_mode IN VARCHAR2 Required
218: --
219: -- OUT
229: --
230: /*
231: PROCEDURE Load1_Control(
232: p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236:
237: x_return_status OUT nocopy VARCHAR2,
230: /*
231: PROCEDURE Load1_Control(
232: p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236:
237: x_return_status OUT nocopy VARCHAR2,
238: x_msg_count OUT nocopy NUMBER,
231: PROCEDURE Load1_Control(
232: p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236:
237: x_return_status OUT nocopy VARCHAR2,
238: x_msg_count OUT nocopy NUMBER,
239: x_msg_data OUT nocopy VARCHAR2,
251: procedure load_Control(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := G_FALSE,
254: p_commit IN VARCHAR2 := G_FALSE,
255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256:
257: x_return_status OUT nocopy VARCHAR2,
258: x_msg_count OUT nocopy NUMBER,
259: x_msg_data OUT nocopy VARCHAR2,
282: -- Parameters
283: --
284: -- IN
285: -- p_api_version_number IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
287: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
288: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
289: -- p_control_rec IN control_rec_type Required
290: --
284: -- IN
285: -- p_api_version_number IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
287: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
288: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
289: -- p_control_rec IN control_rec_type Required
290: --
291: -- OUT
292: -- x_return_status OUT VARCHAR2
301: --
302:
303: PROCEDURE Create_Control(
304: p_api_version_number IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308:
309: x_return_status OUT nocopy VARCHAR2,
302:
303: PROCEDURE Create_Control(
304: p_api_version_number IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308:
309: x_return_status OUT nocopy VARCHAR2,
310: x_msg_count OUT nocopy NUMBER,
303: PROCEDURE Create_Control(
304: p_api_version_number IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308:
309: x_return_status OUT nocopy VARCHAR2,
310: x_msg_count OUT nocopy NUMBER,
311: x_msg_data OUT nocopy VARCHAR2,
327: -- Parameters
328: --
329: -- IN
330: -- p_api_version_number IN NUMBER Required
331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
333: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
334: -- p_control_rec IN control_rec_type Required
335: --
329: -- IN
330: -- p_api_version_number IN NUMBER Required
331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
333: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
334: -- p_control_rec IN control_rec_type Required
335: --
336: -- OUT
337: -- x_return_status OUT VARCHAR2
346: --
347:
348: PROCEDURE Update_Control(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353:
354: x_return_status OUT nocopy VARCHAR2,
347:
348: PROCEDURE Update_Control(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353:
354: x_return_status OUT nocopy VARCHAR2,
355: x_msg_count OUT nocopy NUMBER,
348: PROCEDURE Update_Control(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353:
354: x_return_status OUT nocopy VARCHAR2,
355: x_msg_count OUT nocopy NUMBER,
356: x_msg_data OUT nocopy VARCHAR2,
371: -- Parameters
372: --
373: -- IN
374: -- p_api_version_number IN NUMBER Required
375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
376: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
377: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_CONTROL_REV_ID IN NUMBER
379: -- p_object_version_number IN NUMBER Optional Default = NULL
373: -- IN
374: -- p_api_version_number IN NUMBER Required
375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
376: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
377: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_CONTROL_REV_ID IN NUMBER
379: -- p_object_version_number IN NUMBER Optional Default = NULL
380: --
381: -- OUT
391: --
392:
393: PROCEDURE Delete_Control(
394: p_api_version_number IN NUMBER,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT nocopy VARCHAR2,
399: x_msg_count OUT nocopy NUMBER,
392:
393: PROCEDURE Delete_Control(
394: p_api_version_number IN NUMBER,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT nocopy VARCHAR2,
399: x_msg_count OUT nocopy NUMBER,
400: x_msg_data OUT nocopy VARCHAR2,
393: PROCEDURE Delete_Control(
394: p_api_version_number IN NUMBER,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT nocopy VARCHAR2,
399: x_msg_count OUT nocopy NUMBER,
400: x_msg_data OUT nocopy VARCHAR2,
401: p_control_rev_id IN NUMBER,
414: -- Parameters
415: --
416: -- IN
417: -- p_api_version_number IN NUMBER Required
418: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
419: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
420: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
421: -- p_control_rec IN control_rec_type Required
422: --
416: -- IN
417: -- p_api_version_number IN NUMBER Required
418: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
419: -- p_commit IN VARCHAR2 Optional Default = G_FALSE
420: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
421: -- p_control_rec IN control_rec_type Required
422: --
423: -- OUT
424: -- x_return_status OUT VARCHAR2
433: --
434:
435: PROCEDURE Lock_Control(
436: p_api_version_number IN NUMBER,
437: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
438:
439: x_return_status OUT nocopy VARCHAR2,
440: x_msg_count OUT nocopy NUMBER,
441: x_msg_data OUT nocopy VARCHAR2,
458:
459: PROCEDURE Validate_control(
460: p_mode in varchar2,
461: p_api_version_number IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_control_rec IN out nocopy control_rec_type,
465: x_return_status OUT nocopy VARCHAR2,
466: x_msg_count OUT nocopy NUMBER,
459: PROCEDURE Validate_control(
460: p_mode in varchar2,
461: p_api_version_number IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_control_rec IN out nocopy control_rec_type,
465: x_return_status OUT nocopy VARCHAR2,
466: x_msg_count OUT nocopy NUMBER,
467: x_msg_data OUT nocopy VARCHAR2
497:
498: PROCEDURE Validate_control_rec(
499: p_mode in varchar2 := 'CREATE',
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: x_return_status OUT nocopy VARCHAR2,
503: x_msg_count OUT nocopy NUMBER,
504: x_msg_data OUT nocopy VARCHAR2,
505: p_control_rec IN control_rec_type