DBA Data[Home] [Help]

APPS.IEM_EMAIL_ICNTR_MAPS_PVT dependencies on STANDARD

Line 40: -- Standard Start of API savepoint

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,

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

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)

Line 121: -- Standard Check Of p_commit.

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.

Line 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.

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

Line 180: -- Standard Start of API savepoint

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,

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

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)

Line 206: -- Standard Check Of p_commit.

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.

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

Line 284: -- Standard Start of API savepoint

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,

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

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)

Line 358: -- Standard Check Of p_commit.

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.

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