37: l_api_version_number NUMBER:=1.0;
38: l_seq_id number;
39:
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
45: p_api_version_number,
39:
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
109: p_ATTRIBUTE12,
110: p_ATTRIBUTE13,
111: p_ATTRIBUTE14,
112: p_ATTRIBUTE15);
113: -- Standard Check Of p_commit.
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117: -- Standard callto get message count and if count is 1, get message info.
113: -- Standard Check Of p_commit.
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117: -- Standard callto get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
165: l_api_version_number NUMBER:=1.0;
166: l_seq_id number;
167:
168: BEGIN
169: -- Standard Start of API savepoint
170: SAVEPOINT delete_item_PVT;
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
173: p_api_version_number,
167:
168: BEGIN
169: -- Standard Start of API savepoint
170: SAVEPOINT delete_item_PVT;
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
173: p_api_version_number,
174: l_api_name,
175: G_PKG_NAME)
197: DELETE FROM IEM_EMAIL_SERVER_TYPES
198: WHERE EMAIL_SERVER_TYPE_ID=p_server_type_id;
199: end if;
200:
201: -- Standard Check Of p_commit.
202: IF FND_API.To_Boolean(p_commit) THEN
203: COMMIT WORK;
204: END IF;
205: -- Standard callto get message count and if count is 1, get message info.
201: -- Standard Check Of p_commit.
202: IF FND_API.To_Boolean(p_commit) THEN
203: COMMIT WORK;
204: END IF;
205: -- Standard callto get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,
208: p_data => x_msg_data
209: );
273: l_api_version_number NUMBER:=1.0;
274: l_seq_id NUMBER;
275:
276: BEGIN
277: -- Standard Start of API savepoint
278: SAVEPOINT update_item_PVT;
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
281: p_api_version_number,
275:
276: BEGIN
277: -- Standard Start of API savepoint
278: SAVEPOINT update_item_PVT;
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
281: p_api_version_number,
282: l_api_name,
283: G_PKG_NAME)
341: WHERE EMAIL_SERVER_TYPE_ID=p_server_type_id;
342:
343: end if;
344:
345: -- Standard Check Of p_commit.
346: IF FND_API.To_Boolean(p_commit) THEN
347: COMMIT WORK;
348: END IF;
349: -- Standard callto get message count and if count is 1, get message info.
345: -- Standard Check Of p_commit.
346: IF FND_API.To_Boolean(p_commit) THEN
347: COMMIT WORK;
348: END IF;
349: -- Standard callto get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );