DBA Data[Home] [Help]

APPS.IEM_KB_RESULTS_PVT dependencies on STANDARD

Line 50: -- Standard Start of API savepoint

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,

Line 52: -- Standard call to check for call compatibility.

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)

Line 150: -- Standard Check Of p_commit.

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.

Line 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: );

Line 203: -- Standard Start of API savepoint

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,

Line 205: -- Standard call to check for call compatibility.

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)

Line 224: -- Standard Check Of p_commit.

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.

Line 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: );

Line 302: -- Standard Start of API savepoint

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,

Line 304: -- Standard call to check for call compatibility.

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)

Line 323: -- Standard Check Of p_commit.

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.

Line 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: );