APPS.AMV_AQ_UTILITY_PVT dependencies on AMV_AQ_MSG_OBJECT_TYPE

Line 62: -- Default 'AMV_AQ_MSG_OBJECT_TYPE'

58: -- The underline table used by the AQ queue.
59: -- Default 'AMV_MATCHING_QUEUE'
60: -- p_payload_obj_type VARCHAR2 Optional
61: -- The name of the payload (DB object) handled by the AQ queue.
62: -- Default 'AMV_AQ_MSG_OBJECT_TYPE'
63: -- OUT : None
64: -- Version : Current version 1.0
65: -- Previous version 1.0
66: -- Initial version 1.0

Line 74: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'

70: PROCEDURE Add_Queue
71: (
72: p_queue_table_name IN VARCHAR2 := AMV_QUEUE.queue_table_name,
73: p_queue_name IN VARCHAR2 := AMV_QUEUE.queue_name,
74: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'
75: );
76: --
77: --------------------------------------------------------------------------------
78: -- Start of comments

Line 112: -- IN : p_message_obj AMV_AQ_MSG_OBJECT_TYPE

108: -- Type : Private
109: -- Pre-reqs : None
110: -- Function : Put the message into the AQ.
111: -- Parameters :
112: -- IN : p_message_obj AMV_AQ_MSG_OBJECT_TYPE
113: -- Required
114: -- The message object to be enqueued to the AQ queue.
115: -- OUT : None
116: -- Version : Current version 1.0

Line 124: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

120: -- End of comments
121: --
122: PROCEDURE Enqueue_Message
123: (
124: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
125: );
126: --
127: --------------------------------------------------------------------------------
128: -- Start of comments

Line 138: -- OUT : x_message_obj AMV_AQ_MSG_OBJECT_TYPE

134: -- IN : p_delete_flag VARCHAR2 Optional
135: -- Default = FND_API.G_TRUE
136: -- Flag for delelting the message from the queue.
137: -- IN : None
138: -- OUT : x_message_obj AMV_AQ_MSG_OBJECT_TYPE
139: -- The message object to be dequeued from the AQ queue.
140: -- Version : Current version 1.0
141: -- Previous version 1.0
142: -- Initial version 1.0

Line 149: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

145: --
146: PROCEDURE Dequeue_Message
147: (
148: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
149: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
150: );
151: --
152: --------------------------------------------------------------------------------
153: --------------------------------------------------------------------------------

Line 162: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'

158: PROCEDURE Add_Queue
159: (
160: p_queue_table_name IN VARCHAR2 := AMV_QUEUE.queue_table_name,
161: p_queue_name IN VARCHAR2 := AMV_QUEUE.queue_name,
162: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'
163: ) IS
164: --
165: l_comment varchar2(2000) := '';
166: l_temp_str varchar2(200);

Line 253: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

249: --
250: --------------------------------------------------------------------------------
251: PROCEDURE Enqueue_Message
252: (
253: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
254: ) IS
255: --
256: l_enqueue_options dbms_aq.enqueue_options_t;
257: l_message_properties dbms_aq.message_properties_t;

Line 278: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

274: --------------------------------------------------------------------------------
275: PROCEDURE Dequeue_Message
276: (
277: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
278: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
279: ) IS
280: l_dequeue_options dbms_aq.dequeue_options_t;
281: l_message_properties dbms_aq.message_properties_t;
282: l_message_handle RAW(16);

Line 312: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'

308: x_msg_data OUT NOCOPY VARCHAR2,
309: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
310: p_queue_table_name IN VARCHAR2 := AMV_QUEUE.queue_table_name,
311: p_queue_name IN VARCHAR2 := AMV_QUEUE.queue_name,
312: p_payload_obj_type IN VARCHAR2 := 'SYSTEM.AMV_AQ_MSG_OBJECT_TYPE'
313: ) IS
314: l_api_name CONSTANT VARCHAR2(30) := 'Add_Queue';
315: l_api_version CONSTANT NUMBER := 1.0;
316: l_resource_id NUMBER := -1;

Line 549: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

545: x_return_status OUT NOCOPY VARCHAR2,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
549: p_message_obj IN SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
550: ) IS
551: l_api_name CONSTANT VARCHAR2(30) := 'Enqueue_Message';
552: l_api_version CONSTANT NUMBER := 1.0;
553: l_resource_id NUMBER := -1;

Line 666: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE

662: x_msg_count OUT NOCOPY NUMBER,
663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
665: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
666: x_message_obj OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
667: ) IS
668: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Queue';
669: l_api_version CONSTANT NUMBER := 1.0;
670: l_resource_id NUMBER := -1;