36: l_seq_id number;
37: l_grp_cnt number;
38:
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT create_item_PVT;
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
44: p_api_version_number,
38:
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT create_item_PVT;
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
117: p_ATTRIBUTE14,
118: p_ATTRIBUTE15
119: );
120:
121: -- Standard Check Of p_commit.
122: IF FND_API.To_Boolean(p_commit) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard Check Of p_commit.
121: -- Standard Check Of p_commit.
122: IF FND_API.To_Boolean(p_commit) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard Check Of p_commit.
126: IF FND_API.To_Boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129: -- Standard callto get message count and if count is 1, get message info.
125: -- Standard Check Of p_commit.
126: IF FND_API.To_Boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129: -- Standard callto get message count and if count is 1, get message info.
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
176: l_api_name VARCHAR2(255):='delete_item';
177: l_api_version_number NUMBER:=1.0;
178:
179: BEGIN
180: -- Standard Start of API savepoint
181: SAVEPOINT delete_item_PVT;
182: -- Standard call to check for call compatibility.
183: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
184: p_api_version_number,
178:
179: BEGIN
180: -- Standard Start of API savepoint
181: SAVEPOINT delete_item_PVT;
182: -- Standard call to check for call compatibility.
183: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
184: p_api_version_number,
185: l_api_name,
186: G_PKG_NAME)
202: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE
203: EMAIL_ACCOUNT_ID = p_email_account_id ;
204: end if;
205:
206: -- Standard Check Of p_commit.
207: IF FND_API.To_Boolean(p_commit) THEN
208: COMMIT WORK;
209: END IF;
210: -- Standard callto get message count and if count is 1, get message info.
206: -- Standard Check Of p_commit.
207: IF FND_API.To_Boolean(p_commit) THEN
208: COMMIT WORK;
209: END IF;
210: -- Standard callto get message count and if count is 1, get message info.
211: FND_MSG_PUB.Count_And_Get
212: ( p_count => x_msg_count,
213: p_data => x_msg_data
214: );
280: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
281: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
282:
283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT update_item_PVT;
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
288: p_api_version_number,
282:
283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT update_item_PVT;
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
288: p_api_version_number,
289: l_api_name,
290: G_PKG_NAME)
354: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
355: where email_icntr_map_id=p_email_icntr_map_id;
356: end if;
357:
358: -- Standard Check Of p_commit.
359: IF FND_API.To_Boolean(p_commit) THEN
360: COMMIT WORK;
361: END IF;
362: -- Standard callto get message count and if count is 1, get message info.
358: -- Standard Check Of p_commit.
359: IF FND_API.To_Boolean(p_commit) THEN
360: COMMIT WORK;
361: END IF;
362: -- Standard callto get message count and if count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get
364: ( p_count => x_msg_count,
365: p_data => x_msg_data
366: );