96: AND rcv_receipt_num is not null;
97:
98: CURSOR Get_recv_no IS
99: SELECT to_char(next_receipt_num + 1 )
100: FROM rcv_parameters
101: WHERE organization_id = v_ship_to_organization_id;
102:
103: x_header_interface_id NUMBER;
104: x_group_id NUMBER;
151: end if;
152: Close get_recv_no;
153:
154:
155: UPDATE rcv_parameters
156: set next_receipt_num = v_rcv_receipt_num
157: where organization_id = v_ship_to_organization_id ;
158:
159: else
187: end if;
188: Close get_recv_no;
189:
190:
191: UPDATE rcv_parameters
192: set next_receipt_num = v_rcv_receipt_num
193: where organization_id = v_ship_to_organization_id ;
194:
195: