[Home] [Help]
129: l_api_version_number CONSTANT NUMBER := 1.0;
130: l_return_status_full VARCHAR2(1);
131: l_chk_rating_rec CHK_RATING_Rec_Type;
132: BEGIN
133: -- Standard Start of API savepoint
134: SAVEPOINT CREATE_CHECK_RATINGS_PVT;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
132: BEGIN
133: -- Standard Start of API savepoint
134: SAVEPOINT CREATE_CHECK_RATINGS_PVT;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
138: p_api_version_number,
139: l_api_name,
140: G_PKG_NAME)
199: --
200: -- End of API body
201: --
202:
203: -- Standard check for p_commit
204: IF FND_API.to_Boolean( p_commit )
205: THEN
206: COMMIT WORK;
207: END IF;
206: COMMIT WORK;
207: END IF;
208:
209:
210: -- Standard call to 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: );
337: l_rowid ROWID;
338: l_chk_rating_rec CHK_RATING_Rec_Type;
339: l_old_chk_rating_rec CSC_PROF_CHECK_RATINGS%ROWTYPE;
340: BEGIN
341: -- Standard Start of API savepoint
342: SAVEPOINT UPDATE_CHECK_RATINGS_PVT;
343:
344: -- Standard call to check for call compatibility.
345: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
340: BEGIN
341: -- Standard Start of API savepoint
342: SAVEPOINT UPDATE_CHECK_RATINGS_PVT;
343:
344: -- Standard call to check for call compatibility.
345: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
346: p_api_version_number,
347: l_api_name,
348: G_PKG_NAME)
425: --
426: -- End of API body.
427: --
428:
429: -- Standard check for p_commit
430: IF FND_API.to_Boolean( p_commit )
431: THEN
432: COMMIT WORK;
433: END IF;
432: COMMIT WORK;
433: END IF;
434:
435:
436: -- Standard call to get message count and if count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );
482: IS
483: l_api_name CONSTANT VARCHAR2(30) := 'Delete_check_ratings';
484: l_api_version_number CONSTANT NUMBER := 1.0;
485: BEGIN
486: -- Standard Start of API savepoint
487: SAVEPOINT DELETE_CHECK_RATINGS_PVT;
488:
489: -- Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
485: BEGIN
486: -- Standard Start of API savepoint
487: SAVEPOINT DELETE_CHECK_RATINGS_PVT;
488:
489: -- Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
491: p_api_version_number,
492: l_api_name,
493: G_PKG_NAME)
515: --
516: -- End of API body
517: --
518:
519: -- Standard check for p_commit
520: IF FND_API.to_Boolean( p_commit )
521: THEN
522: COMMIT WORK;
523: END IF;
523: END IF;
524:
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: ( p_count => x_msg_count,
530: p_data => x_msg_data
531: );
638: p_argument_Value => p_check_id );
639: END IF;
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.
643: FND_MSG_PUB.Count_And_Get
644: ( p_count => x_msg_count,
645: p_data => x_msg_data
646: );
685: -- verify if data is valid
686: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
687: NULL;
688: END IF;
689: -- Standard call to get message count and if count is 1, get message info.
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => x_msg_count,
692: p_data => x_msg_data
693: );
769: END IF;
770: END IF;
771: END IF;
772:
773: -- Standard call to get message count and if count is 1, get message info.
774: FND_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count,
776: p_data => x_msg_data
777: );