APPS.INV_WIP_PICKING_PVT dependencies on DUAL

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

1705: RAISE fnd_api.g_exc_unexpected_error;
1706: END IF;
1707: ELSE
1708: BEGIN
1709: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO l_pick_slip_number FROM DUAL;
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: fnd_message.set_name('INV','INV_NO_PICK_SLIP_NUMBER');
1713: fnd_msg_pub.add;

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

1908: END IF;
1909:
1910: -- Pick Slip Number
1911: IF p_get_pick_slip_number THEN
1912: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL INTO x_pick_slip_number FROM DUAL;
1913: END IF;
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: x_return_status := fnd_api.g_ret_sts_error;