1: PACKAGE BODY CSC_PROF_CHECK_RATINGS_PKG as
2: /* $Header: csctprab.pls 120.5 2006/07/21 06:13:23 adhanara ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_CHECK_RATINGS_PKG
5: -- Purpose :
1: PACKAGE BODY CSC_PROF_CHECK_RATINGS_PKG as
2: /* $Header: csctprab.pls 120.5 2006/07/21 06:13:23 adhanara ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_CHECK_RATINGS_PKG
5: -- Purpose :
6: -- History :
7: -- 03 Nov 00 axsubram Added load_row (# 1487338)
8: -- 03 Nov 00 axsubram File name constant corrected to csctprab.pls
13: -- NOTE :
14: -- End of Comments
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_CHECK_RATINGS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctprab.pls';
19:
20: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR;
21: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM;
218: BEGIN
219:
220: l_check_rating_id := p_check_rating_id;
221:
222: Csc_Prof_Check_Ratings_Pkg.Update_Row(
223: p_CHECK_RATING_ID => p_check_rating_id,
224: p_CHECK_ID => p_check_id,
225: p_CHECK_RATING_GRADE => p_check_rating_grade,
226: p_RATING_CODE => p_rating_code,
234:
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237:
238: Csc_Prof_Check_Ratings_Pkg.Insert_Row(
239: px_CHECK_RATING_ID => l_check_rating_id,
240: p_CHECK_ID => p_check_id,
241: p_CHECK_RATING_GRADE => p_check_rating_grade,
242: p_RATING_CODE => p_rating_code,
253:
254: End Load_Row;
255:
256:
257: End CSC_PROF_CHECK_RATINGS_PKG;