APPS.CSM_USER_EVENT_PKG dependencies on CSM_USER_ACC_S

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

1022: IF c_user_acc%FOUND THEN
1023: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1024: END IF;
1025:
1026: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1027:
1028: 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)
1029: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1030: CLOSE c_user_acc;

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

1179: FETCH c_user_acc INTO l_access_id;
1180: IF c_user_acc%FOUND THEN
1181: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',
1182: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1183: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;
1184: CLOSE c_user_acc;
1185: ELSE
1186:
1187: CLOSE c_user_acc;

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

1185: ELSE
1186:
1187: CLOSE c_user_acc;
1188:
1189: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1190:
1191: 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)
1192: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1193:

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

1251:
1252: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1253: AND OWNER_ID=p_owner_id;
1254: ELSE
1255: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1256: AND OWNER_ID=p_owner_id;
1257: END IF;
1258: END IF;
1259: