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,
327: CREATION_DATE,
328: CREATED_BY,
329: LAST_UPDATE_LOGIN,
330: SEEDED_FLAG
331: From CSC_PROF_CHECK_RATINGS
332: Where check_id = c_CHECK_RATING_ID
333: For Update NOWAIT;
334: l_api_name CONSTANT VARCHAR2(30) := 'Update_check_ratings';
335: l_api_version_number CONSTANT NUMBER := 1.0;
335: l_api_version_number CONSTANT NUMBER := 1.0;
336: -- Local Variables
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:
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: --