APPS.INV_WIP_PICKING_PVT dependencies on DUAL

Line 1757: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO l_pick_slip_number FROM DUAL;

1753: RAISE fnd_api.g_exc_unexpected_error;
1754: END IF;
1755: ELSE
1756: BEGIN
1757: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO l_pick_slip_number FROM DUAL;
1758: EXCEPTION
1759: WHEN OTHERS THEN
1760: fnd_message.set_name('INV','INV_NO_PICK_SLIP_NUMBER');
1761: fnd_msg_pub.add;

Line 1960: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO x_pick_slip_number FROM DUAL;

1956: END IF;
1957:
1958: -- Pick Slip Number
1959: IF p_get_pick_slip_number THEN
1960: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO x_pick_slip_number FROM DUAL;
1961: END IF;
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: x_return_status := fnd_api.g_ret_sts_error;