APPS.CSM_USER_EVENT_PKG dependencies on DUAL

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 1177: IF l_user_id <> l_owner_id THEN --Do not do mark dirty for individual users and owners

1173: OPEN c_user_acc(p_user_id);
1174: FETCH c_user_acc INTO l_access_id,l_user_id,l_owner_id;
1175: --Do mark dirty only for the User
1176: IF c_user_acc%FOUND THEN
1177: IF l_user_id <> l_owner_id THEN --Do not do mark dirty for individual users and owners
1178: l_markdirty := asg_download.mark_dirty(
1179: p_pub_item => g_pub_item
1180: , p_accessid => l_access_id
1181: , p_userid => l_owner_id

Line 1186: --delete for owner,member or individual user

1182: , p_dml => 'D'
1183: , P_TIMESTAMP => sysdate
1184: );
1185: END IF;
1186: --delete for owner,member or individual user
1187: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1188:
1189: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,
1190: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

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: