APPS.CSC_PROF_CHECK_RATINGS_PKG dependencies on CSC_PROF_CHECK_RATINGS

Line 1: PACKAGE BODY CSC_PROF_CHECK_RATINGS_PKG as

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 :

Line 4: -- Package name : CSC_PROF_CHECK_RATINGS_PKG

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

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_CHECK_RATINGS_PKG';

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;

Line 40: CURSOR C2 IS SELECT CSC_PROF_CHECK_RATINGS_S.nextval FROM sys.dual;

36: p_LAST_UPDATE_LOGIN NUMBER,
37: p_SEEDED_FLAG VARCHAR2)
38:
39: IS
40: CURSOR C2 IS SELECT CSC_PROF_CHECK_RATINGS_S.nextval FROM sys.dual;
41: ps_SEEDED_FLAG Varchar2(3);
42: BEGIN
43:
44: /* added the below 2 lines for bug 4596220 */

Line 61: INSERT INTO CSC_PROF_CHECK_RATINGS(

57: OPEN C2;
58: FETCH C2 INTO px_CHECK_RATING_ID;
59: CLOSE C2;
60: End If;
61: INSERT INTO CSC_PROF_CHECK_RATINGS(
62: CHECK_RATING_ID,
63: CHECK_ID,
64: CHECK_RATING_GRADE,
65: RATING_CODE,

Line 106: Update CSC_PROF_CHECK_RATINGS

102: p_SEEDED_FLAG VARCHAR2)
103:
104: IS
105: BEGIN
106: Update CSC_PROF_CHECK_RATINGS
107: SET
108: CHECK_ID = p_CHECK_ID,
109: CHECK_RATING_GRADE = p_CHECK_RATING_GRADE,
110: RATING_CODE = p_RATING_CODE,

Line 145: FROM CSC_PROF_CHECK_RATINGS

141:
142: IS
143: CURSOR C IS
144: SELECT *
145: FROM CSC_PROF_CHECK_RATINGS
146: WHERE CHECK_RATING_ID = p_CHECK_RATING_ID
147: FOR UPDATE of CHECK_RATING_ID NOWAIT;
148: Recinfo C%ROWTYPE;
149: BEGIN

Line 189: DELETE FROM CSC_PROF_CHECK_RATINGS

185: PROCEDURE Delete_Row(
186: p_CHECK_RATING_ID NUMBER)
187: IS
188: BEGIN
189: DELETE FROM CSC_PROF_CHECK_RATINGS
190: WHERE CHECK_RATING_ID = p_CHECK_RATING_ID;
191: If (SQL%NOTFOUND) then
192: RAISE NO_DATA_FOUND;
193: End If;

Line 222: Csc_Prof_Check_Ratings_Pkg.Update_Row(

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,

Line 238: Csc_Prof_Check_Ratings_Pkg.Insert_Row(

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,

Line 257: End CSC_PROF_CHECK_RATINGS_PKG;

253:
254: End Load_Row;
255:
256:
257: End CSC_PROF_CHECK_RATINGS_PKG;