The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_CHECK_RATING_ID IN OUT NOCOPY NUMBER,
p_CHECK_ID NUMBER,
p_CHECK_RATING_GRADE VARCHAR2,
p_RATING_CODE VARCHAR2,
p_COLOR_CODE VARCHAR2,
p_RANGE_LOW_VALUE VARCHAR2,
p_RANGE_HIGH_VALUE VARCHAR2,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
CURSOR C2 IS SELECT CSC_PROF_CHECK_RATINGS_S.nextval FROM sys.dual;
INSERT INTO CSC_PROF_CHECK_RATINGS(
CHECK_RATING_ID,
CHECK_ID,
CHECK_RATING_GRADE,
RATING_CODE,
COLOR_CODE,
RANGE_LOW_VALUE,
RANGE_HIGH_VALUE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
SEEDED_FLAG
) VALUES (
px_CHECK_RATING_ID,
decode( p_CHECK_ID, G_MISS_NUM, NULL, p_CHECK_ID),
decode( p_CHECK_RATING_GRADE, G_MISS_CHAR, NULL, p_CHECK_RATING_GRADE),
decode( p_RATING_CODE, G_MISS_CHAR, NULL, p_RATING_CODE),
decode( p_COLOR_CODE, G_MISS_CHAR, NULL, p_COLOR_CODE),
decode( p_RANGE_LOW_VALUE, G_MISS_CHAR, NULL, p_RANGE_LOW_VALUE),
decode( p_RANGE_HIGH_VALUE,G_MISS_CHAR, NULL, p_RANGE_HIGH_VALUE),
decode( p_LAST_UPDATE_DATE, G_MISS_DATE, to_date(NULL), p_LAST_UPDATE_DATE),
decode( p_LAST_UPDATED_BY, G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode( p_CREATION_DATE, G_MISS_DATE, to_date(NULL), p_CREATION_DATE),
decode( p_CREATED_BY, G_MISS_NUM, NULL, p_CREATED_BY),
decode( p_LAST_UPDATE_LOGIN, G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
decode( p_SEEDED_FLAG, G_MISS_CHAR, NULL, ps_SEEDED_FLAG));
End Insert_Row;
PROCEDURE Update_Row(
p_CHECK_RATING_ID NUMBER,
p_CHECK_ID NUMBER,
p_CHECK_RATING_GRADE VARCHAR2,
p_RATING_CODE VARCHAR2,
p_COLOR_CODE VARCHAR2,
p_RANGE_LOW_VALUE VARCHAR2,
p_RANGE_HIGH_VALUE VARCHAR2,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
BEGIN
Update CSC_PROF_CHECK_RATINGS
SET
CHECK_ID = p_CHECK_ID,
CHECK_RATING_GRADE = p_CHECK_RATING_GRADE,
RATING_CODE = p_RATING_CODE,
COLOR_CODE = p_COLOR_CODE,
RANGE_LOW_VALUE = p_RANGE_LOW_VALUE,
RANGE_HIGH_VALUE = p_RANGE_HIGH_VALUE,
LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
LAST_UPDATED_BY = p_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
SEEDED_FLAG = p_SEEDED_FLAG
where CHECK_RATING_ID = p_CHECK_RATING_ID;
END Update_Row;
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
CURSOR C IS
SELECT *
FROM CSC_PROF_CHECK_RATINGS
WHERE CHECK_RATING_ID = p_CHECK_RATING_ID
FOR UPDATE of CHECK_RATING_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( to_char(Recinfo.LAST_UPDATE_DATE,'dd-mon-rrrr') = to_char(p_LAST_UPDATE_DATE,'dd-mon-rrrr'))
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
) then
return;
PROCEDURE Delete_Row(
p_CHECK_RATING_ID NUMBER)
IS
BEGIN
DELETE FROM CSC_PROF_CHECK_RATINGS
WHERE CHECK_RATING_ID = p_CHECK_RATING_ID;
END Delete_Row;
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2,
P_Owner VARCHAR2)
IS
l_user_id number := 0;
check_rating_id returned from insert_row is not used.
**/
BEGIN
l_check_rating_id := p_check_rating_id;
Csc_Prof_Check_Ratings_Pkg.Update_Row(
p_CHECK_RATING_ID => p_check_rating_id,
p_CHECK_ID => p_check_id,
p_CHECK_RATING_GRADE => p_check_rating_grade,
p_RATING_CODE => p_rating_code,
p_COLOR_CODE => p_color_code,
p_RANGE_LOW_VALUE => p_range_low_value,
p_RANGE_HIGH_VALUE => p_range_high_value,
p_LAST_UPDATE_DATE => p_last_update_date,
p_LAST_UPDATED_BY => p_last_updated_by,
p_LAST_UPDATE_LOGIN => 0,
p_SEEDED_FLAG => p_seeded_flag);
Csc_Prof_Check_Ratings_Pkg.Insert_Row(
px_CHECK_RATING_ID => l_check_rating_id,
p_CHECK_ID => p_check_id,
p_CHECK_RATING_GRADE => p_check_rating_grade,
p_RATING_CODE => p_rating_code,
p_COLOR_CODE => p_color_code,
p_RANGE_LOW_VALUE => p_range_low_value,
p_RANGE_HIGH_VALUE => p_range_high_value,
p_LAST_UPDATE_DATE => p_last_update_date,
p_LAST_UPDATED_BY => p_last_updated_by,
p_CREATION_DATE => p_last_update_date,
p_CREATED_BY => p_last_updated_by,
p_LAST_UPDATE_LOGIN => 0,
p_SEEDED_FLAG => p_seeded_flag);