DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on RCV_PARAMETERS

Line 100: FROM rcv_parameters

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;

Line 155: UPDATE rcv_parameters

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

Line 191: UPDATE rcv_parameters

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: