DBA Data[Home] [Help]

APPS.AMW_CONTROL_PVT dependencies on FND_API

Line 19: G_FALSE VARCHAr2(1) := FND_API.G_FALSE;

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

Line 20: G_TRUE VARCHAr2(1) := FND_API.G_TRUE;

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

Line 213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

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

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,

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

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,

Line 286: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 288: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

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

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,

Line 331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 333: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

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

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,

Line 375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 377: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

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

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,

Line 418: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 420: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

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,

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

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,

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

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

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

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