APPS.CSM_USER_EVENT_PKG dependencies on DUAL

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

1116: OPEN c_user_acc(p_user_id);
1117: FETCH c_user_acc INTO l_access_id,l_user_id,l_owner_id;
1118: --Do mark dirty only for the User
1119: IF c_user_acc%FOUND THEN
1120: IF l_user_id <> l_owner_id THEN --Do not do mark dirty for individual users and owners
1121: l_markdirty := asg_download.mark_dirty(
1122: p_pub_item => g_pub_item
1123: , p_accessid => l_access_id
1124: , p_userid => l_owner_id

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

1125: , p_dml => 'D'
1126: , P_TIMESTAMP => sysdate
1127: );
1128: END IF;
1129: --delete for owner,member or individual user
1130: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1131:
1132: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,
1133: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

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: