The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_MY_GROUP (p_user_id NUMBER
, x_return_status OUT NOCOPY VARCHAR2
, x_error_message OUT NOCOPY VARCHAR2)
IS
--CURSOR declarations
CURSOR c_group_ins(b_user_id NUMBER)
IS
SELECT GROUP_ID, OWNER_ID
FROM ASG_USER usr
WHERE usr.USER_ID = b_user_id
AND usr.ENABLED = 'Y'
AND NOT EXISTS
(
SELECT 1
FROM CSM_GROUPS acc
WHERE acc.USER_ID = usr.OWNER_ID
AND acc.GROUP_TYPE ='C'
);
CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
CSM_ACC_PKG.Insert_Acc
(P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
,P_ACC_TABLE_NAME => g_grp_acc_table_name
,P_SEQ_NAME => g_grp_seq_name
,P_PK1_NAME => g_grp_pk1_name
,P_PK1_NUM_VALUE => l_group_id
,P_USER_ID => l_owner_id
);
UPDATE CSM_GROUPS
SET GROUP_TYPE ='C',
GROUP_OWNER_ID=l_owner_id
WHERE GROUP_ID = l_group_id
AND USER_ID = l_owner_id;
x_error_message := 'Group Data for Current Group successfully Inserted';
CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
END INSERT_MY_GROUP;
PROCEDURE DELETE_MY_GROUP ( p_user_id NUMBER
, x_return_status OUT NOCOPY VARCHAR2
, x_error_message OUT NOCOPY VARCHAR2)
IS
--CURSOR declarations
CURSOR c_group_del(b_user_id NUMBER)
IS
SELECT acc.group_id
FROM CSM_GROUPS acc
WHERE acc.USER_ID = b_user_id
AND acc.GROUP_TYPE = 'C';
CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
CSM_ACC_PKG.Delete_Acc
(P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
,P_ACC_TABLE_NAME => g_grp_acc_table_name
,P_PK1_NAME => g_grp_pk1_name
,P_PK1_NUM_VALUE => l_group_id
,P_USER_ID => p_user_id
);
x_error_message := 'Group Data successfully Deleted';
CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Procedure : for accessid '
|| l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
END DELETE_MY_GROUP;
PROCEDURE INSERT_GROUP_ACC (p_user_id NUMBER
, p_group_id NUMBER
, p_owner_id NUMBER
, p_group_type VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_error_message OUT NOCOPY VARCHAR2)
IS
--CURSOR declarations
CURSOR c_rel_group_ins(b_group_id IN NUMBER)
IS
SELECT 1
FROM JTF_RS_GROUPS_B jrgb
WHERE jrgb.GROUP_ID = b_group_id
AND NVL(jrgb.END_DATE_ACTIVE,SYSDATE) >= TRUNC(SYSDATE);
CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
'CSM_GROUP_DOWNLOAD.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
CSM_ACC_PKG.Insert_Acc
(P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
,P_ACC_TABLE_NAME => g_grp_acc_table_name
,P_SEQ_NAME => g_grp_seq_name
,P_PK1_NAME => g_grp_pk1_name
,P_PK1_NUM_VALUE => p_group_id
,P_USER_ID => p_user_id
);
UPDATE CSM_GROUPS
SET GROUP_TYPE = p_group_type,
GROUP_OWNER_ID = p_owner_id
WHERE GROUP_ID = p_group_id
AND USER_ID = p_user_id;
x_error_message := 'Group Data successfully Inserted';
CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
END INSERT_GROUP_ACC;
PROCEDURE DELETE_GROUP_ACC ( p_user_id NUMBER
, p_group_id NUMBER
, x_return_status OUT NOCOPY VARCHAR2
, x_error_message OUT NOCOPY VARCHAR2)
IS
--variable declarations
l_group_id CSM_GROUPS.GROUP_ID%TYPE;
CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
CSM_ACC_PKG.Delete_Acc
(P_PUBLICATION_ITEM_NAMES => g_grp_pubi_name
,P_ACC_TABLE_NAME => g_grp_acc_table_name
,P_PK1_NAME => g_grp_pk1_name
,P_PK1_NUM_VALUE => p_group_id
,P_USER_ID => p_user_id
);
x_error_message := 'Group Data successfully Deleted';
CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
l_message := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Procedure : for accessid '
|| l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',
FND_LOG.LEVEL_EXCEPTION);
END DELETE_GROUP_ACC;