APPS.CSM_USER_EVENT_PKG dependencies on CSM_USER_ACC_S

Line 1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;

1079: IF c_user_acc%FOUND THEN
1080: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1081: END IF;
1082:
1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1084:
1085: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1086: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1087: CLOSE c_user_acc;

Line 1240: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;

1236: FETCH c_user_acc INTO l_access_id;
1237: IF c_user_acc%FOUND THEN
1238: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',
1239: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1240: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;
1241: CLOSE c_user_acc;
1242: ELSE
1243:
1244: CLOSE c_user_acc;

Line 1246: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;

1242: ELSE
1243:
1244: CLOSE c_user_acc;
1245:
1246: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1247:
1248: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1249: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1250:

Line 1312: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id

1308:
1309: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1310: AND OWNER_ID=p_owner_id;
1311: ELSE
1312: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1313: AND OWNER_ID=p_owner_id;
1314: END IF;
1315: END IF;
1316: