eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_AQ_UTILITY_PVT dependencies on FND_API

Line 43: -- Default = FND_API.G_FALSE

39: -- Function : Create the AQ table, the AQ itself, and start it.
40: -- Parameters :
41: -- IN p_api_version NUMBER Required
42: -- p_init_msg_list VARCHAR2 Optional
43: -- Default = FND_API.G_FALSE
44: -- p_commit VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_validation_level NUMBER Optional
47: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 45: -- Default = FND_API.G_FALSE

41: -- IN p_api_version NUMBER Required
42: -- p_init_msg_list VARCHAR2 Optional
43: -- Default = FND_API.G_FALSE
44: -- p_commit VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_validation_level NUMBER Optional
47: -- Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_check_login_user VARCHAR2 Optional
49: -- Default = FND_API.G_TRUE

Line 47: -- Default = FND_API.G_VALID_LEVEL_FULL

43: -- Default = FND_API.G_FALSE
44: -- p_commit VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_validation_level NUMBER Optional
47: -- Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_check_login_user VARCHAR2 Optional
49: -- Default = FND_API.G_TRUE
50: -- Flag for checking user privilege and if user is login.
51: -- p_queue_table_name VARCHAR2 Optional

Line 49: -- Default = FND_API.G_TRUE

45: -- Default = FND_API.G_FALSE
46: -- p_validation_level NUMBER Optional
47: -- Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_check_login_user VARCHAR2 Optional
49: -- Default = FND_API.G_TRUE
50: -- Flag for checking user privilege and if user is login.
51: -- p_queue_table_name VARCHAR2 Optional
52: -- The underline table used by the AQ queue.
53: -- Default 'AMV_MATCHING_QUEUE_TBL'

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

69: --
70: PROCEDURE Add_Queue
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,

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

70: PROCEDURE Add_Queue
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,

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

71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 79: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
80: p_queue_table_name IN VARCHAR2 := AMV_QUEUE.queue_table_name,
81: p_queue_name IN VARCHAR2 := AMV_QUEUE.queue_name,
82: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'
83: );

Line 116: -- Default = FND_API.G_FALSE

112: -- Function : Stop the AQ queue, drop it, and then drop the AQ table.
113: -- Parameters :
114: -- IN : p_api_version NUMBER Required
115: -- p_init_msg_list VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 118: -- Default = FND_API.G_FALSE

114: -- IN : p_api_version NUMBER Required
115: -- p_init_msg_list VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_check_login_user VARCHAR2 Optional
122: -- Default = FND_API.G_TRUE

Line 120: -- Default = FND_API.G_VALID_LEVEL_FULL

116: -- Default = FND_API.G_FALSE
117: -- p_commit VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_check_login_user VARCHAR2 Optional
122: -- Default = FND_API.G_TRUE
123: -- Flag for checking user privilege and if user is login.
124: -- p_queue_table_name VARCHAR2 Optional

Line 122: -- Default = FND_API.G_TRUE

118: -- Default = FND_API.G_FALSE
119: -- p_validation_level NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_check_login_user VARCHAR2 Optional
122: -- Default = FND_API.G_TRUE
123: -- Flag for checking user privilege and if user is login.
124: -- p_queue_table_name VARCHAR2 Optional
125: -- The underline table used by the AQ queue.
126: -- Default 'AMV_MATCHING_QUEUE_TBL'

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

139: --
140: PROCEDURE Delete_Queue
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,

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

140: PROCEDURE Delete_Queue
141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,

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

141: (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 149: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
150: p_queue_table_name IN VARCHAR2 := AMV_QUEUE.queue_table_name,
151: p_queue_name IN VARCHAR2 := AMV_QUEUE.queue_name
152: );
153: --

Line 184: -- Default = FND_API.G_FALSE

180: -- Function : Put (enqueue) the message into the AQ queue.
181: -- Parameters :
182: -- IN : p_api_version NUMBER Required
183: -- p_init_msg_list VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_commit VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 186: -- Default = FND_API.G_FALSE

182: -- IN : p_api_version NUMBER Required
183: -- p_init_msg_list VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_commit VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_check_login_user VARCHAR2 Optional
190: -- Default = FND_API.G_TRUE

Line 188: -- Default = FND_API.G_VALID_LEVEL_FULL

184: -- Default = FND_API.G_FALSE
185: -- p_commit VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_check_login_user VARCHAR2 Optional
190: -- Default = FND_API.G_TRUE
191: -- Flag for checking user privilege and if user is login.
192: -- p_queue_table_name VARCHAR2 Optional

Line 190: -- Default = FND_API.G_TRUE

186: -- Default = FND_API.G_FALSE
187: -- p_validation_level NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_check_login_user VARCHAR2 Optional
190: -- Default = FND_API.G_TRUE
191: -- Flag for checking user privilege and if user is login.
192: -- p_queue_table_name VARCHAR2 Optional
193: -- p_message_obj AMV_AQ_MSG_OBJECT_TYPE
194: -- Required

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

202: --
203: PROCEDURE Enqueue_Message
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,

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

203: PROCEDURE Enqueue_Message
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,

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

204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 212: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
213: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
214: );
215: --
216: -- Algorithm:

Line 244: -- Default = FND_API.G_FALSE

240: -- Function : Get (dequeue) a message from the AQ queue.
241: -- Parameters :
242: -- IN : p_api_version NUMBER Required
243: -- p_init_msg_list VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 246: -- Default = FND_API.G_FALSE

242: -- IN : p_api_version NUMBER Required
243: -- p_init_msg_list VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_check_login_user VARCHAR2 Optional
250: -- Default = FND_API.G_TRUE

Line 248: -- Default = FND_API.G_VALID_LEVEL_FULL

244: -- Default = FND_API.G_FALSE
245: -- p_commit VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_check_login_user VARCHAR2 Optional
250: -- Default = FND_API.G_TRUE
251: -- Flag for checking user privilege and if user is login.
252: -- p_delete_flag VARCHAR2 Optional

Line 250: -- Default = FND_API.G_TRUE

246: -- Default = FND_API.G_FALSE
247: -- p_validation_level NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_check_login_user VARCHAR2 Optional
250: -- Default = FND_API.G_TRUE
251: -- Flag for checking user privilege and if user is login.
252: -- p_delete_flag VARCHAR2 Optional
253: -- Default = FND_API.G_TRUE
254: -- Flag for delete the message from the queue.

Line 253: -- Default = FND_API.G_TRUE

249: -- p_check_login_user VARCHAR2 Optional
250: -- Default = FND_API.G_TRUE
251: -- Flag for checking user privilege and if user is login.
252: -- p_delete_flag VARCHAR2 Optional
253: -- Default = FND_API.G_TRUE
254: -- Flag for delete the message from the queue.
255: -- OUT : x_message_obj AMV_AQ_MSG_OBJECT_TYPE
256: -- The message object to be dequeued from the AQ queue.
257: -- Version : Current version 1.0

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

262: --
263: PROCEDURE Dequeue_Message
264: (
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,

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

263: PROCEDURE Dequeue_Message
264: (
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,

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

264: (
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 272: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

268: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
273: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
274: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
275: );
276: --

Line 273: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,

269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
273: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
274: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
275: );
276: --
277: -- Algorithm: