APPS.IEM_KB_CATEGORIES_PVT dependencies on STANDARD

Line 49: -- Standard Start of API savepoint

45: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
46: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
47:
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT create_item_PVT;
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
53: p_api_version_number,

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

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

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

127: p_ATTRIBUTE14,
128: p_ATTRIBUTE15
129: );
130:
131: -- Standard callto get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );

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 210: -- Standard Check Of p_commit.

206: DELETE FROM IEM_KB_CATEGORIES
207: where kb_category_id=p_kb_category_id;
208: end if;
209:
210: -- Standard Check Of p_commit.
211: IF FND_API.To_Boolean(p_commit) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard callto get message count and if count is 1, get message info.

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

210: -- Standard Check Of p_commit.
211: IF FND_API.To_Boolean(p_commit) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard callto get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get
216: ( p_count => x_msg_count,
217: p_data => x_msg_data
218: );

Line 292: -- Standard Start of API savepoint

288: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
289: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
290:
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT update_item_PVT;
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
296: p_api_version_number,

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

290:
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT update_item_PVT;
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)

Line 337: -- Standard Check Of p_commit.

333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;
336:
337: -- Standard Check Of p_commit.
338: IF FND_API.To_Boolean(p_commit) THEN
339: COMMIT WORK;
340: END IF;
341: -- Standard callto get message count and if count is 1, get message info.

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

337: -- Standard Check Of p_commit.
338: IF FND_API.To_Boolean(p_commit) THEN
339: COMMIT WORK;
340: END IF;
341: -- Standard callto get message count and if count is 1, get message info.
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );