APPS.RCV_UPDATE_RTI_LC dependencies on RCV_HEADERS_INTERFACE

Line 120: UPDATE rcv_headers_interface rhi

116: )
117: OR processing_status_code = 'WLC_PENDING'
118: );
119:
120: UPDATE rcv_headers_interface rhi
121: SET rhi.processing_status_code = 'PENDING',
122: group_id = l_group_id -- Bug 7677015
123: WHERE rhi.processing_status_code <> 'RUNNING'
124: and exists( select 'exists' from rcv_transactions_interface rti

Line 146: from rcv_transactions_interface rti, rcv_headers_interface rhi

142:
143: begin
144: select rhi.asn_type, rhi.header_interface_id, rhi.group_id
145: into l_asn_type, l_header_interface_id, l_rhi_group_id
146: from rcv_transactions_interface rti, rcv_headers_interface rhi
147: where rhi.header_interface_id = rti.header_interface_id
148: and rti.interface_transaction_id = p_int_rec(i).interface_id;
149: exception
150: when others then

Line 187: UPDATE rcv_headers_interface rhi

183: )
184: OR processing_status_code = 'WLC_PENDING'
185: );
186:
187: UPDATE rcv_headers_interface rhi
188: SET rhi.processing_status_code = 'PENDING',
189: group_id = l_group_id -- Bug 7677015
190: WHERE rhi.processing_status_code <> 'RUNNING'
191: and exists( select 'exists' from rcv_transactions_interface rti

Line 218: UPDATE rcv_headers_interface rhi

214: and lcm_shipment_line_id is not NULL
215: and unit_landed_cost is not NULL;
216:
217:
218: UPDATE rcv_headers_interface rhi
219: SET rhi.processing_status_code = 'PENDING',
220: group_id = l_group_id -- Bug 7677015
221: WHERE rhi.processing_status_code <> 'RUNNING'
222: and exists( select 'exists' from rcv_transactions_interface rti