DBA Data[Home] [Help]

APPS.CSC_CHECK_RATINGS_PVT dependencies on CSC_PROF_CHECK_RATINGS

Line 177: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Insert_Row)

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,

Line 178: CSC_PROF_CHECK_RATINGS_PKG.Insert_Row(

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,

Line 331: From CSC_PROF_CHECK_RATINGS

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;

Line 339: l_old_chk_rating_rec CSC_PROF_CHECK_RATINGS%ROWTYPE;

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:

Line 410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)

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),

Line 411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(

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),

Line 512: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Delete_Row)

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

Line 513: CSC_PROF_CHECK_RATINGS_PKG.Delete_Row(

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: --