19: l_api_name CONSTANT VARCHAR2(30) := 'GET_MIDDLEWARE_ID';
20: l_api_version CONSTANT NUMBER := 1.0;
21:
22: BEGIN
23: -- Standard Start of API savepoint
24: SAVEPOINT GET_MIDDLEWARE_ID_PUB;
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
27: p_api_version ,
21:
22: BEGIN
23: -- Standard Start of API savepoint
24: SAVEPOINT GET_MIDDLEWARE_ID_PUB;
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )
43: select middleware_id into x_middleware_id from cct_telesets where teleset_id =
44: (select client_id from cct_agent_rt_stats where attribute1='T' and agent_id = p_agent_id);
45:
46: -- End of API body.
47: -- Standard check of p_commit.
48: IF FND_API.To_Boolean( p_commit ) THEN
49: COMMIT WORK;
50: END IF;
51: -- Standard call to get message count and if count is 1, get message info.
47: -- Standard check of p_commit.
48: IF FND_API.To_Boolean( p_commit ) THEN
49: COMMIT WORK;
50: END IF;
51: -- Standard call to get message count and if count is 1, get message info.
52: FND_MSG_PUB.Count_And_Get
53: ( p_count => x_msg_count ,
54: p_data => x_msg_data
55: );
106: l_start_date_time DATE ;
107: l_milcs_duration NUMBER;
108:
109: BEGIN
110: -- Standard Start of API savepoint
111: SAVEPOINT CLOSE_MILCS_PUB;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
114: p_api_version ,
108:
109: BEGIN
110: -- Standard Start of API savepoint
111: SAVEPOINT CLOSE_MILCS_PUB;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
114: p_api_version ,
115: l_api_name ,
116: G_PKG_NAME )
150: ,x_msg_data=>x_msg_data );
151:
152:
153: -- End of API body.
154: -- Standard check of p_commit.
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT WORK;
157: END IF;
158: EXCEPTION
203: media_item_at_route_point_ex EXCEPTION;
204: no_data_found_ex EXCEPTION;
205:
206: BEGIN
207: -- Standard Start of API savepoint
208: SAVEPOINT CAN_CLOSE_MEDIA_ITEM_PUB;
209: -- Standard call to check for call compatibility.
210: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
211: p_api_version ,
205:
206: BEGIN
207: -- Standard Start of API savepoint
208: SAVEPOINT CAN_CLOSE_MEDIA_ITEM_PUB;
209: -- Standard call to check for call compatibility.
210: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
211: p_api_version ,
212: l_api_name ,
213: G_PKG_NAME )
251: -- dbms_output.put_line('media item is a candidate for closure');
252: x_can_close_media_item := 0;
253:
254: -- End of API body.
255: -- Standard check of p_commit.
256: IF FND_API.To_Boolean( p_commit ) THEN
257: COMMIT WORK;
258: END IF;
259: