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,
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)
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.
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: );
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,
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)
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.
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: );
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,
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)
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.
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: );
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,
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)
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.
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: );
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,
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)
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.
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: );