The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
p_GROUP_ID NUMBER,
p_CATEGORY_CODE VARCHAR2,
p_CATEGORY_SEQUENCE NUMBER,
p_CREATED_BY NUMBER,
p_CREATION_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
CURSOR C2 IS SELECT CSC_PROF_GROUP_CATEGORIES_S.nextval FROM sys.dual;
INSERT INTO CSC_PROF_GROUP_CATEGORIES(
GROUP_CATEGORY_ID,
GROUP_ID,
CATEGORY_CODE,
CATEGORY_SEQUENCE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SEEDED_FLAG
) VALUES (
px_GROUP_CATEGORY_ID,
decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));
End Insert_Row;
PROCEDURE Update_Row(
p_GROUP_CATEGORY_ID NUMBER,
p_GROUP_ID NUMBER,
p_CATEGORY_CODE VARCHAR2,
p_CATEGORY_SEQUENCE NUMBER,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
BEGIN
Update CSC_PROF_GROUP_CATEGORIES
SET
GROUP_ID = p_GROUP_ID,
CATEGORY_CODE = p_CATEGORY_CODE,
CATEGORY_SEQUENCE =p_CATEGORY_SEQUENCE,
LAST_UPDATED_BY = p_LAST_UPDATED_BY,
LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN =p_LAST_UPDATE_LOGIN,
SEEDED_FLAG= p_SEEDED_FLAG
where GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_GROUP_CATEGORY_ID NUMBER)
IS
BEGIN
DELETE FROM CSC_PROF_GROUP_CATEGORIES
WHERE GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID;
END Delete_Row;
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_SEEDED_FLAG VARCHAR2)
IS
CURSOR C IS
SELECT *
FROM CSC_PROF_GROUP_CATEGORIES
WHERE GROUP_CATEGORY_ID = p_GROUP_CATEGORY_ID
FOR UPDATE of GROUP_CATEGORY_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
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_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE 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 )))
AND ( ( Recinfo.SEEDED_FLAG = p_SEEDED_FLAG)
OR ( ( Recinfo.SEEDED_FLAG IS NULL )
AND ( p_SEEDED_FLAG IS NULL )))
) then
return;
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE
) is
l_user_id number := 0;
Csc_Prof_Group_Categories_Pkg.Update_Row(
p_GROUP_CATEGORY_ID => p_GROUP_CATEGORY_ID,
p_GROUP_ID => p_GROUP_ID,
p_CATEGORY_CODE => p_CATEGORY_CODE,
p_CATEGORY_SEQUENCE => p_CATEGORY_SEQUENCE,
p_LAST_UPDATED_BY => p_last_updated_by,
p_LAST_UPDATE_DATE => p_last_update_date,
p_LAST_UPDATE_LOGIN => 0,
p_SEEDED_FLAG => p_SEEDED_FLAG);
Csc_Prof_Group_Categories_Pkg.Insert_Row(
px_GROUP_CATEGORY_ID => l_group_category_id,
p_GROUP_ID => p_GROUP_ID,
p_CATEGORY_CODE => p_CATEGORY_CODE,
p_CATEGORY_SEQUENCE => p_CATEGORY_SEQUENCE,
p_CREATED_BY => p_last_updated_by,
p_CREATION_DATE => p_last_update_date,
p_LAST_UPDATED_BY => p_last_updated_by,
p_LAST_UPDATE_DATE => p_last_update_date,
p_LAST_UPDATE_LOGIN => 0,
p_SEEDED_FLAG => p_SEEDED_FLAG );