[Home] [Help]
54: p_item_id IN NUMBER
55: ) IS
56: l_api_name CONSTANT VARCHAR2(30) := 'Request_ItemMatch';
57: l_api_version CONSTANT NUMBER := 1.0;
58: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
59: --
60: BEGIN
61: SAVEPOINT Request_ItemMatch_Pvt;
62: -- Standard call to check for call compatibility.
82: END IF;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: --
86: l_message_obj := SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
87: (
88: G_AMV_APP_ID,
89: p_item_id,
90: 'ITEM',
152: p_channel_id IN NUMBER
153: ) IS
154: l_api_name CONSTANT VARCHAR2(30) := 'Request_ChannelMatch';
155: l_api_version CONSTANT NUMBER := 1.0;
156: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
157: --
158: BEGIN
159: SAVEPOINT Request_ChannelMatch_Pvt;
160: -- Standard call to check for call compatibility.
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183: --
184: l_message_obj := SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
185: (
186: G_AMV_APP_ID,
187: p_channel_id,
188: 'CHANNEL',
250: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE
251: ) IS
252: l_api_name CONSTANT VARCHAR2(30) := 'Stop_MatchingEngine';
253: l_api_version CONSTANT NUMBER := 1.0;
254: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
255: --
256: BEGIN
257: SAVEPOINT Stop_MatchingEngine_Pvt;
258: -- Standard call to check for call compatibility.
266: --Initialize message list if p_init_msg_list is TRUE.
267: IF FND_API.To_Boolean (p_init_msg_list) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270: l_message_obj := SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
271: (
272: G_AMV_APP_ID,
273: 911,
274: 'STOP',
335: l_current_login_id NUMBER := -1;
336: l_current_user_status VARCHAR2(80);
337: --
338: l_admin_flag VARCHAR2(1);
339: l_message_obj SYSTEM.AMV_AQ_MSG_OBJECT_TYPE;
340: l_return_status VARCHAR2(1);
341: l_msg_count NUMBER;
342: l_msg_data VARCHAR2(2000);
343: