DBA Data[Home] [Help]

APPS.IEM_PREPENQDEQ_PUB dependencies on FND_API

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

6: -- Pre-reqs : None
7: -- Parameters :
8: -- IN
9: -- p_api_version_number IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
12: -- p_msg_id IN NUMBER Required
13: -- p_msg_size IN NUMBER Required
14: -- p_sender_name IN VARCHAR2 Required

Line 11: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

7: -- Parameters :
8: -- IN
9: -- p_api_version_number IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
12: -- p_msg_id IN NUMBER Required
13: -- p_msg_size IN NUMBER Required
14: -- p_sender_name IN VARCHAR2 Required
15: -- p_user_name IN VARCHAR2 Required

Line 35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

31:
32:
33: PROCEDURE PREP_ENQUEUE(
34: P_Api_Version_Number IN NUMBER,
35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_msg_id IN NUMBER,
38: p_msg_size IN NUMBER,
39: p_sender_name IN VARCHAR2,

Line 36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

32:
33: PROCEDURE PREP_ENQUEUE(
34: P_Api_Version_Number IN NUMBER,
35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_msg_id IN NUMBER,
38: p_msg_size IN NUMBER,
39: p_sender_name IN VARCHAR2,
40: p_user_name IN VARCHAR2,

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

54: -- Pre-reqs : None
55: -- Parameters :
56: -- IN
57: -- p_api_version_number IN NUMBER Required
58: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
59: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
60: -- p_msg_id OUT NUMBER
61: -- p_msg_size OUT NUMBER
62: -- p_sender_name OUT VARCHAR2

Line 59: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

55: -- Parameters :
56: -- IN
57: -- p_api_version_number IN NUMBER Required
58: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
59: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
60: -- p_msg_id OUT NUMBER
61: -- p_msg_size OUT NUMBER
62: -- p_sender_name OUT VARCHAR2
63: -- p_user_name OUT VARCHAR2

Line 83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

79:
80:
81: PROCEDURE PREP_DEQUEUE(
82: P_Api_Version_Number IN NUMBER,
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_msg_id OUT NOCOPY NUMBER,
86: p_msg_size OUT NOCOPY NUMBER,
87: p_sender_name OUT NOCOPY VARCHAR2,

Line 84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

80:
81: PROCEDURE PREP_DEQUEUE(
82: P_Api_Version_Number IN NUMBER,
83: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_msg_id OUT NOCOPY NUMBER,
86: p_msg_size OUT NOCOPY NUMBER,
87: p_sender_name OUT NOCOPY VARCHAR2,
88: p_user_name OUT NOCOPY VARCHAR2,

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

102: -- Pre-reqs : None
103: -- Parameters :
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
108: -- p_qopt IN VARCHAR2
109: -- p_msg_id OUT NUMBER
110: -- p_msg_size OUT NUMBER

Line 107: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

103: -- Parameters :
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
108: -- p_qopt IN VARCHAR2
109: -- p_msg_id OUT NUMBER
110: -- p_msg_size OUT NUMBER
111: -- p_sender_name OUT VARCHAR2

Line 132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

128:
129:
130: PROCEDURE PREP_DEQUEUE(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_qopt IN VARCHAR2,
135: p_msg_id OUT NOCOPY NUMBER,
136: p_msg_size OUT NOCOPY NUMBER,

Line 133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

129:
130: PROCEDURE PREP_DEQUEUE(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_qopt IN VARCHAR2,
135: p_msg_id OUT NOCOPY NUMBER,
136: p_msg_size OUT NOCOPY NUMBER,
137: p_sender_name OUT NOCOPY VARCHAR2,

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

152: -- Pre-reqs : None
153: -- Parameters :
154: -- IN
155: -- p_api_version_number IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
158: -- p_qopt IN VARCHAR2
159: -- p_qdeq IN VARCHAR2
160: -- p_msg_id OUT NUMBER

Line 157: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

153: -- Parameters :
154: -- IN
155: -- p_api_version_number IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
158: -- p_qopt IN VARCHAR2
159: -- p_qdeq IN VARCHAR2
160: -- p_msg_id OUT NUMBER
161: -- p_msg_size OUT NUMBER

Line 183: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

179:
180:
181: PROCEDURE PREP_DEQUEUE(
182: P_Api_Version_Number IN NUMBER,
183: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
184: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_qopt IN VARCHAR2,
186: p_qdeq IN VARCHAR2,
187: p_msg_id OUT NOCOPY NUMBER,

Line 184: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

180:
181: PROCEDURE PREP_DEQUEUE(
182: P_Api_Version_Number IN NUMBER,
183: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
184: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_qopt IN VARCHAR2,
186: p_qdeq IN VARCHAR2,
187: p_msg_id OUT NOCOPY NUMBER,
188: p_msg_size OUT NOCOPY NUMBER,

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

204: -- Pre-reqs : None
205: -- Parameters :
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_msg_id IN NUMBER
211: -- p_msg_size IN NUMBER
212: -- p_sender_name IN VARCHAR2

Line 209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

205: -- Parameters :
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_msg_id IN NUMBER
211: -- p_msg_size IN NUMBER
212: -- p_sender_name IN VARCHAR2
213: -- p_user_name IN VARCHAR2

Line 256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

252: -- End of Comments
253:
254: PROCEDURE PROC_ENQUEUE(
255: P_Api_Version_Number IN NUMBER,
256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_msg_id IN NUMBER,
259: p_msg_size IN NUMBER,
260: p_sender_name IN VARCHAR2,

Line 257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

253:
254: PROCEDURE PROC_ENQUEUE(
255: P_Api_Version_Number IN NUMBER,
256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_msg_id IN NUMBER,
259: p_msg_size IN NUMBER,
260: p_sender_name IN VARCHAR2,
261: p_user_name IN VARCHAR2,

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

299: -- Pre-reqs : None
300: -- Parameters :
301: -- IN
302: -- p_api_version_number IN NUMBER Required
303: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
304: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
305: -- p_msg_id OUT NUMBER
306: -- p_msg_size OUT NUMBER
307: -- p_sender_name OUT VARCHAR2

Line 304: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

300: -- Parameters :
301: -- IN
302: -- p_api_version_number IN NUMBER Required
303: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
304: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
305: -- p_msg_id OUT NUMBER
306: -- p_msg_size OUT NUMBER
307: -- p_sender_name OUT VARCHAR2
308: -- p_user_name OUT VARCHAR2

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

347: -- End of Comments
348:
349: PROCEDURE PROC_DEQUEUE(
350: P_Api_Version_Number IN NUMBER,
351: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
352: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
353: p_msg_id OUT NOCOPY NUMBER,
354: p_msg_size OUT NOCOPY NUMBER,
355: p_sender_name OUT NOCOPY VARCHAR2,

Line 352: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

348:
349: PROCEDURE PROC_DEQUEUE(
350: P_Api_Version_Number IN NUMBER,
351: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
352: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
353: p_msg_id OUT NOCOPY NUMBER,
354: p_msg_size OUT NOCOPY NUMBER,
355: p_sender_name OUT NOCOPY VARCHAR2,
356: p_user_name OUT NOCOPY VARCHAR2,

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

394: -- Pre-reqs : None
395: -- Parameters :
396: -- IN
397: -- p_api_version_number IN NUMBER Required
398: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
399: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
400: -- p_qopt IN VARCHAR2
401: -- p_msg_id OUT NUMBER
402: -- p_msg_size OUT NUMBER

Line 399: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

395: -- Parameters :
396: -- IN
397: -- p_api_version_number IN NUMBER Required
398: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
399: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
400: -- p_qopt IN VARCHAR2
401: -- p_msg_id OUT NUMBER
402: -- p_msg_size OUT NUMBER
403: -- p_sender_name OUT VARCHAR2

Line 447: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

443: -- End of Comments
444:
445: PROCEDURE PROC_DEQUEUE(
446: P_Api_Version_Number IN NUMBER,
447: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
448: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
449: p_qopt IN VARCHAR2,
450: p_msg_id OUT NOCOPY NUMBER,
451: p_msg_size OUT NOCOPY NUMBER,

Line 448: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

444:
445: PROCEDURE PROC_DEQUEUE(
446: P_Api_Version_Number IN NUMBER,
447: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
448: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
449: p_qopt IN VARCHAR2,
450: p_msg_id OUT NOCOPY NUMBER,
451: p_msg_size OUT NOCOPY NUMBER,
452: p_sender_name OUT NOCOPY VARCHAR2,

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

491: -- Pre-reqs : None
492: -- Parameters :
493: -- IN
494: -- p_api_version_number IN NUMBER Required
495: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
496: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
497: -- p_qopt IN VARCHAR2
498: -- p_qdeq IN VARCHAR2
499: -- p_msg_id OUT NUMBER

Line 496: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

492: -- Parameters :
493: -- IN
494: -- p_api_version_number IN NUMBER Required
495: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
496: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
497: -- p_qopt IN VARCHAR2
498: -- p_qdeq IN VARCHAR2
499: -- p_msg_id OUT NUMBER
500: -- p_msg_size OUT NUMBER

Line 545: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

541: -- End of Comments
542:
543: PROCEDURE PROC_DEQUEUE(
544: P_Api_Version_Number IN NUMBER,
545: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
546: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
547: p_qopt IN VARCHAR2,
548: p_qdeq IN VARCHAR2,
549: p_msg_id OUT NOCOPY NUMBER,

Line 546: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

542:
543: PROCEDURE PROC_DEQUEUE(
544: P_Api_Version_Number IN NUMBER,
545: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
546: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
547: p_qopt IN VARCHAR2,
548: p_qdeq IN VARCHAR2,
549: p_msg_id OUT NOCOPY NUMBER,
550: p_msg_size OUT NOCOPY NUMBER,

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

590: -- Pre-reqs : None
591: -- Parameters :
592: -- IN
593: -- p_api_version_number IN NUMBER Required
594: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
595: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
596: -- p_queue_name IN VARCHAR2
597: -- p_enqueue IN VARCHAR2
598: -- p_dequeue IN VARCHAR2

Line 595: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

591: -- Parameters :
592: -- IN
593: -- p_api_version_number IN NUMBER Required
594: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
595: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
596: -- p_queue_name IN VARCHAR2
597: -- p_enqueue IN VARCHAR2
598: -- p_dequeue IN VARCHAR2
599: --

Line 613: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

609:
610:
611: PROCEDURE ENABLE_QUEUE(
612: P_Api_Version_Number IN NUMBER,
613: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
614: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
615: p_queue_name IN VARCHAR2,
616: p_enqueue IN VARCHAR2,
617: p_dequeue IN VARCHAR2,

Line 614: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

610:
611: PROCEDURE ENABLE_QUEUE(
612: P_Api_Version_Number IN NUMBER,
613: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
614: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
615: p_queue_name IN VARCHAR2,
616: p_enqueue IN VARCHAR2,
617: p_dequeue IN VARCHAR2,
618: x_msg_count OUT NOCOPY NUMBER,

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

625: -- Pre-reqs : None
626: -- Parameters :
627: -- IN
628: -- p_api_version_number IN NUMBER Required
629: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
630: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
631: -- p_queue_name IN VARCHAR2
632: -- p_enqueue IN VARCHAR2
633: -- p_dequeue IN VARCHAR2

Line 630: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE

626: -- Parameters :
627: -- IN
628: -- p_api_version_number IN NUMBER Required
629: -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
630: -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
631: -- p_queue_name IN VARCHAR2
632: -- p_enqueue IN VARCHAR2
633: -- p_dequeue IN VARCHAR2
634: --

Line 648: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

644:
645:
646: PROCEDURE DISABLE_QUEUE(
647: P_Api_Version_Number IN NUMBER,
648: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
649: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
650: p_queue_name IN VARCHAR2,
651: p_enqueue IN VARCHAR2,
652: p_dequeue IN VARCHAR2,

Line 649: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

645:
646: PROCEDURE DISABLE_QUEUE(
647: P_Api_Version_Number IN NUMBER,
648: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
649: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
650: p_queue_name IN VARCHAR2,
651: p_enqueue IN VARCHAR2,
652: p_dequeue IN VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,