DBA Data[Home] [Help]

APPS.CSM_GROUP_DOWNLOAD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

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'
	);
Line: 44

    CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
        'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
Line: 51

    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
    	);
Line: 60

        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;
Line: 69

     x_error_message := 'Group Data for Current Group successfully Inserted';
Line: 71

    CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Proc ',
       'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
Line: 80

     l_message   := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
Line: 81

     CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
Line: 82

END INSERT_MY_GROUP;
Line: 88

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';
Line: 108

    CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
       'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
Line: 116

   		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
    	);
Line: 126

     x_error_message := 'Group Data successfully Deleted';
Line: 127

     CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Proc ',
       'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_STATEMENT);
Line: 136

     l_message   := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP Procedure : for accessid '
      || l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
Line: 138

     CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_MY_GROUP',FND_LOG.LEVEL_EXCEPTION);
Line: 139

END DELETE_MY_GROUP;
Line: 141

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);
Line: 164

    CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
      'CSM_GROUP_DOWNLOAD.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
Line: 178

	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
    	);
Line: 187

        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;
Line: 202

     x_error_message := 'Group Data successfully Inserted';
Line: 204

    CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Proc ',
     'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
Line: 210

     CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
Line: 216

     l_message   := 'Exception in CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC Procedure :' || l_sqlerrno || ':' || l_sqlerrmsg;
Line: 217

     CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.INSERT_GROUP_ACC',FND_LOG.LEVEL_EXCEPTION);
Line: 218

END INSERT_GROUP_ACC;
Line: 224

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;
Line: 238

    CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
      'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
Line: 243

   		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
    	);
Line: 253

     x_error_message := 'Group Data successfully Deleted';
Line: 254

    CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Proc ',
      'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',FND_LOG.LEVEL_STATEMENT);
Line: 263

     l_message   := 'Exception in CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC Procedure : for accessid '
       || l_access_id ||': with error ' || l_sqlerrno || ':' || l_sqlerrmsg;
Line: 265

     CSM_UTIL_PKG.LOG(l_message, 'CSM_GROUP_DOWNLOAD_PVT.DELETE_GROUP_ACC',
       FND_LOG.LEVEL_EXCEPTION);
Line: 267

END DELETE_GROUP_ACC;