[Home] [Help]
150: l_api_name CONSTANT VARCHAR2(30) := 'Create_check_ratings';
151: l_api_version_number CONSTANT NUMBER := 1.0;
152: l_PVT_CHK_RATING_Rec CSC_CHECK_RATINGS_PVT.CHK_RATING_Rec_Type;
153: BEGIN
154: -- Standard Start of API savepoint
155: SAVEPOINT CREATE_CHECK_RATINGS_PUB;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
153: BEGIN
154: -- Standard Start of API savepoint
155: SAVEPOINT CREATE_CHECK_RATINGS_PUB;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
159: p_api_version_number,
160: l_api_name,
161: G_PKG_NAME)
205: --
206: -- End of API body.
207: --
208:
209: -- Standard check for p_commit
210: IF FND_API.to_Boolean( p_commit )
211: THEN
212: COMMIT WORK;
213: END IF;
212: COMMIT WORK;
213: END IF;
214:
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
320: l_api_name CONSTANT VARCHAR2(30) := 'Update_check_ratings';
321: l_api_version_number CONSTANT NUMBER := 1.0;
322: l_pvt_CHK_RATING_rec CSC_CHECK_RATINGS_PVT.CHK_RATING_Rec_Type;
323: BEGIN
324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_CHECK_RATINGS_PUB;
326:
327: -- Standard call to check for call compatibility.
328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
323: BEGIN
324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_CHECK_RATINGS_PUB;
326:
327: -- Standard call to check for call compatibility.
328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
329: p_api_version_number,
330: l_api_name,
331: G_PKG_NAME)
374: --
375: -- End of API body
376: --
377:
378: -- Standard check for p_commit
379: IF FND_API.to_Boolean( p_commit )
380: THEN
381: COMMIT WORK;
382: END IF;
381: COMMIT WORK;
382: END IF;
383:
384:
385: -- Standard call to get message count and if count is 1, get message info.
386: FND_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count,
388: p_data => x_msg_data
389: );
430: l_api_name CONSTANT VARCHAR2(30) := 'Delete_check_ratings';
431: l_api_version_number CONSTANT NUMBER := 2.0;
432: l_pvt_CHK_RATING_rec CSC_CHECK_RATINGS_PVT.CHK_RATING_Rec_Type;
433: BEGIN
434: -- Standard Start of API savepoint
435: SAVEPOINT DELETE_CHECK_RATINGS_PUB;
436:
437: -- Standard call to check for call compatibility.
438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
433: BEGIN
434: -- Standard Start of API savepoint
435: SAVEPOINT DELETE_CHECK_RATINGS_PUB;
436:
437: -- Standard call to check for call compatibility.
438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
439: p_api_version_number,
440: l_api_name,
441: G_PKG_NAME)
481: --
482: -- End of API body
483: --
484:
485: -- Standard check for p_commit
486: IF FND_API.to_Boolean( p_commit )
487: THEN
488: COMMIT WORK;
489: END IF;
488: COMMIT WORK;
489: END IF;
490:
491:
492: -- Standard call to get message count and if count is 1, get message info.
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count,
495: p_data => x_msg_data
496: );