APPS.IEM_EMAIL_CATEGORY_MAPS_PVT dependencies on STANDARD

Line 41: -- Standard Start of API savepoint

37: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
38: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
45: p_api_version_number,

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

39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)

Line 128: -- Standard Check Of p_commit.

124: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
125: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
126: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
127: );
128: -- Standard Check Of p_commit.
129: IF FND_API.To_Boolean(p_commit) THEN
130: COMMIT WORK;
131: END IF;
132: -- Standard callto get message count and if count is 1, get message info.

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

128: -- Standard Check Of p_commit.
129: IF FND_API.To_Boolean(p_commit) THEN
130: COMMIT WORK;
131: END IF;
132: -- Standard callto get message count and if count is 1, get message info.
133: FND_MSG_PUB.Count_And_Get
134: ( p_count => x_msg_count,
135: p_data => x_msg_data
136: );

Line 183: -- Standard Start of API savepoint

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

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

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

Line 205: -- Standard Check Of p_commit.

201: DELETE FROM IEM_EMAIL_CATEGORY_MAPS
202: where email_account_id=p_email_account_id
203: and kb_category_id=p_kb_category_id;
204:
205: -- Standard Check Of p_commit.
206: IF FND_API.To_Boolean(p_commit) THEN
207: COMMIT WORK;
208: END IF;
209: -- Standard callto get message count and if count is 1, get message info.

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

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