173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Insert_Row)
178: CSC_PROF_CHECK_RATINGS_PKG.Insert_Row(
179: px_CHECK_RATING_ID => px_CHECK_RATING_ID,
180: p_CHECK_ID => P_CHK_RATING_rec.CHECK_ID,
181: p_CHECK_RATING_GRADE => P_CHK_RATING_rec.CHECK_RATING_GRADE,
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Insert_Row)
178: CSC_PROF_CHECK_RATINGS_PKG.Insert_Row(
179: px_CHECK_RATING_ID => px_CHECK_RATING_ID,
180: p_CHECK_ID => P_CHK_RATING_rec.CHECK_ID,
181: p_CHECK_RATING_GRADE => P_CHK_RATING_rec.CHECK_RATING_GRADE,
182: --p_RATING_COLOR_ID => P_CHK_RATING_rec.RATING_COLOR_ID,
406: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
508: --
509: -- Api body
510: --
511:
512: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Delete_Row)
513: CSC_PROF_CHECK_RATINGS_PKG.Delete_Row(
514: p_CHECK_RATING_ID => p_CHECK_RATING_ID);
515: --
516: -- End of API body
509: -- Api body
510: --
511:
512: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Delete_Row)
513: CSC_PROF_CHECK_RATINGS_PKG.Delete_Row(
514: p_CHECK_RATING_ID => p_CHECK_RATING_ID);
515: --
516: -- End of API body
517: --