318: ( x_resource_id NUMBER
319: )
320: IS
321: SELECT server_id
322: FROM asg_server_resources
323: WHERE resource_id = x_resource_id;
324:
325: BEGIN
326: OPEN c_server_id
1368: ( v_resource_id number
1369: )
1370: IS
1371: SELECT server_id
1372: FROM asg_server_resources
1373: WHERE resource_id = v_resource_id;
1374:
1375: v_server_id NUMBER;
1376: v_old_server_id NUMBER;
1570: ( v_resource_id number
1571: )
1572: IS
1573: SELECT server_id
1574: FROM asg_server_resources
1575: WHERE resource_id = v_resource_id;
1576:
1577: CURSOR c_party
1578: ( v_party_id NUMBER