DBA Data[Home] [Help]

APPS.IEM_DB_CONNECTIONS_PVT dependencies on STANDARD

Line 48: -- Standard Start of API savepoint

44: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
45: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
46:
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_item_PVT;
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
52: p_api_version_number,

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

46:
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_item_PVT;
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)

Line 146: -- Standard Check Of p_commit.

142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:
146: -- Standard Check Of p_commit.
147: IF FND_API.To_Boolean(p_commit) THEN
148: COMMIT WORK;
149: END IF;
150: -- Standard callto get message count and if count is 1, get message info.

Line 150: -- Standard callto get message count and if count is 1, get message info.

146: -- Standard Check Of p_commit.
147: IF FND_API.To_Boolean(p_commit) THEN
148: COMMIT WORK;
149: END IF;
150: -- Standard callto get message count and if count is 1, get message info.
151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );

Line 202: -- Standard Start of API savepoint

198: l_api_name VARCHAR2(255):='delete_item';
199: l_api_version_number NUMBER:=1.0;
200:
201: BEGIN
202: -- Standard Start of API savepoint
203: SAVEPOINT delete_item_PVT;
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
206: p_api_version_number,

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

200:
201: BEGIN
202: -- Standard Start of API savepoint
203: SAVEPOINT delete_item_PVT;
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
206: p_api_version_number,
207: l_api_name,
208: G_PKG_NAME)

Line 227: -- Standard Check Of p_commit.

223: delete from IEM_DB_CONNECTIONS
224: where db_connection_id=p_db_conn_id;
225: end if;
226:
227: -- Standard Check Of p_commit.
228: IF FND_API.To_Boolean(p_commit) THEN
229: COMMIT WORK;
230: END IF;
231: -- Standard callto get message count and if count is 1, get message info.

Line 231: -- Standard callto get message count and if count is 1, get message info.

227: -- Standard Check Of p_commit.
228: IF FND_API.To_Boolean(p_commit) THEN
229: COMMIT WORK;
230: END IF;
231: -- Standard callto get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 310: -- Standard Start of API savepoint

306: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
307: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
308:
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT update_item_PVT;
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
314: p_api_version_number,

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

308:
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT update_item_PVT;
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)

Line 398: -- Standard Check Of p_commit.

394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
395: where db_connection_id=p_db_conn_id;
396: end if;
397:
398: -- Standard Check Of p_commit.
399: IF FND_API.To_Boolean(p_commit) THEN
400: COMMIT WORK;
401: END IF;
402: -- Standard callto get message count and if count is 1, get message info.

Line 402: -- Standard callto get message count and if count is 1, get message info.

398: -- Standard Check Of p_commit.
399: IF FND_API.To_Boolean(p_commit) THEN
400: COMMIT WORK;
401: END IF;
402: -- Standard callto get message count and if count is 1, get message info.
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data
406: );

Line 454: -- Standard Start of API savepoint

450: l_api_name VARCHAR2(255):='select_item';
451: l_api_version_number NUMBER:=1.0;
452:
453: BEGIN
454: -- Standard Start of API savepoint
455: SAVEPOINT select_item_PVT;
456: -- Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
458: p_api_version_number,

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

452:
453: BEGIN
454: -- Standard Start of API savepoint
455: SAVEPOINT select_item_PVT;
456: -- Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
458: p_api_version_number,
459: l_api_name,
460: G_PKG_NAME)

Line 489: -- Standard Check Of p_commit.

485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);
488: END;
489: -- Standard Check Of p_commit.
490: IF FND_API.To_Boolean(p_commit) THEN
491: COMMIT WORK;
492: END IF;
493: -- Standard callto get message count and if count is 1, get message info.

Line 493: -- Standard callto get message count and if count is 1, get message info.

489: -- Standard Check Of p_commit.
490: IF FND_API.To_Boolean(p_commit) THEN
491: COMMIT WORK;
492: END IF;
493: -- Standard callto get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get
495: ( p_count => x_msg_count,
496: p_data => x_msg_data
497: );