DBA Data[Home] [Help]

APPS.IEM_EML_CLASSIFICATIONS_PVT dependencies on STANDARD

Line 53: -- Standard Start of API savepoint

49: l_api_version_number NUMBER:=1.0;
50: l_count NUMBER;
51:
52: BEGIN
53: -- Standard Start of API savepoint
54: -- SAVEPOINT create_item_PVT;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,

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

51:
52: BEGIN
53: -- Standard Start of API savepoint
54: -- SAVEPOINT create_item_PVT;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)

Line 99: -- Standard Check Of p_commit.

95: sysdate,
96: DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
97: );
98: END IF;
99: -- Standard Check Of p_commit.
100: IF FND_API.To_Boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103: -- Standard callto get message count and if count is 1, get message info.

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

99: -- Standard Check Of p_commit.
100: IF FND_API.To_Boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103: -- Standard callto get message count and if count is 1, get message info.
104: FND_MSG_PUB.Count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data
107: );

Line 181: -- Standard Start of API savepoint

177: l_api_version_number NUMBER:=1.0;
178: l_grp_cnt NUMBER;
179:
180: BEGIN
181: -- Standard Start of API savepoint
182: --SAVEPOINT delete_item_PVT;
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
185: p_api_version_number,

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

179:
180: BEGIN
181: -- Standard Start of API savepoint
182: --SAVEPOINT delete_item_PVT;
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
185: p_api_version_number,
186: l_api_name,
187: G_PKG_NAME)

Line 202: -- Standard Check Of p_commit.

198: DELETE FROM IEM_EMAIL_CLASSIFICATIONS
199: where message_id=p_message_id
200: and classification_id=p_classification_id
201: and email_account_id=p_email_account_id;
202: -- Standard Check Of p_commit.
203: IF FND_API.To_Boolean(p_commit) THEN
204: COMMIT WORK;
205: END IF;
206: -- Standard callto get message count and if count is 1, get message info.

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

202: -- Standard Check Of p_commit.
203: IF FND_API.To_Boolean(p_commit) THEN
204: COMMIT WORK;
205: END IF;
206: -- Standard callto get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count,
209: p_data => x_msg_data
210: );

Line 266: -- Standard Start of API savepoint

262: AND a.message_id = p_message_id
263: AND a.email_account_id = p_email_account_id;
264:
265: BEGIN
266: -- Standard Start of API savepoint
267: --SAVEPOINT getClassification_pvt;
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
270: p_api_version_number,

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

264:
265: BEGIN
266: -- Standard Start of API savepoint
267: --SAVEPOINT getClassification_pvt;
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
270: p_api_version_number,
271: l_api_name,
272: G_PKG_NAME)

Line 295: -- Standard Check Of p_commit.

291: l_cnt:=l_cnt+1;
292:
293: END LOOP;
294:
295: -- Standard Check Of p_commit.
296: IF FND_API.To_Boolean(p_commit) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard callto get message count and if count is 1, get message info.

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

295: -- Standard Check Of p_commit.
296: IF FND_API.To_Boolean(p_commit) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard callto get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count,
302: p_data => x_msg_data
303: );

Line 364: -- Standard Start of API savepoint

360: AND a.message_id = p_message_id
361: AND a.email_account_id = p_email_account_id;
362:
363: BEGIN
364: -- Standard Start of API savepoint
365: --SAVEPOINT getClassification_pvt;
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
368: p_api_version_number,

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

362:
363: BEGIN
364: -- Standard Start of API savepoint
365: --SAVEPOINT getClassification_pvt;
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)

Line 402: -- Standard Check Of p_commit.

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

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

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

Line 495: -- Standard Start of API savepoint

491: l_api_version_number NUMBER:=1.0;
492: l_count NUMBER;
493:
494: BEGIN
495: -- Standard Start of API savepoint
496: -- SAVEPOINT create_item_PVT;
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
499: p_api_version_number,

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

493:
494: BEGIN
495: -- Standard Start of API savepoint
496: -- SAVEPOINT create_item_PVT;
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)

Line 543: -- Standard Check Of p_commit.

539: sysdate,
540: DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
541: );
542: END IF;
543: -- Standard Check Of p_commit.
544: IF FND_API.To_Boolean(p_commit) THEN
545: COMMIT WORK;
546: END IF;
547: -- Standard callto get message count and if count is 1, get message info.

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

543: -- Standard Check Of p_commit.
544: IF FND_API.To_Boolean(p_commit) THEN
545: COMMIT WORK;
546: END IF;
547: -- Standard callto get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count,
550: p_data => x_msg_data
551: );