46: l_seq_id number;
47: l_grp_cnt number;
48:
49: BEGIN
50: -- Standard Start of API savepoint
51: SAVEPOINT create_item_PVT;
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
54: p_api_version_number,
48:
49: BEGIN
50: -- Standard Start of API savepoint
51: SAVEPOINT create_item_PVT;
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
146: p_ATTRIBUTE14,
147: p_ATTRIBUTE15
148: );
149:
150: -- Standard Check Of p_commit.
151: IF FND_API.To_Boolean(p_commit) THEN
152: COMMIT WORK;
153: END IF;
154: -- Standard callto get message count and if count is 1, get message info.
150: -- Standard Check Of p_commit.
151: IF FND_API.To_Boolean(p_commit) THEN
152: COMMIT WORK;
153: END IF;
154: -- Standard callto get message count and if count is 1, get message info.
155: FND_MSG_PUB.Count_And_Get
156: ( p_count => x_msg_count,
157: p_data => x_msg_data
158: );
199: l_api_name VARCHAR2(255):='delete_item';
200: l_api_version_number NUMBER:=1.0;
201:
202: BEGIN
203: -- Standard Start of API savepoint
204: SAVEPOINT delete_item_PVT;
205: -- Standard call to check for call compatibility.
206: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
207: p_api_version_number,
201:
202: BEGIN
203: -- Standard Start of API savepoint
204: SAVEPOINT delete_item_PVT;
205: -- Standard call to check for call compatibility.
206: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
207: p_api_version_number,
208: l_api_name,
209: G_PKG_NAME)
220:
221: DELETE FROM IEM_KB_RESULTS
222: where kb_delete='Y';
223:
224: -- Standard Check Of p_commit.
225: IF FND_API.To_Boolean(p_commit) THEN
226: COMMIT WORK;
227: END IF;
228: -- Standard callto get message count and if count is 1, get message info.
224: -- Standard Check Of p_commit.
225: IF FND_API.To_Boolean(p_commit) THEN
226: COMMIT WORK;
227: END IF;
228: -- Standard callto get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
298: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
299: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
300:
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT update_item_PVT;
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
306: p_api_version_number,
300:
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT update_item_PVT;
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
319: UPDATE IEM_KB_RESULTS
320: set kb_delete='Y'
321: where kb_result_id=p_kb_result_id ;
322:
323: -- Standard Check Of p_commit.
324: IF FND_API.To_Boolean(p_commit) THEN
325: COMMIT WORK;
326: END IF;
327: -- Standard callto get message count and if count is 1, get message info.
323: -- Standard Check Of p_commit.
324: IF FND_API.To_Boolean(p_commit) THEN
325: COMMIT WORK;
326: END IF;
327: -- Standard callto get message count and if count is 1, get message info.
328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data
331: );