APPS.RCV_UPDATE_RTI_LC dependencies on RCV_TRANSACTIONS_INTERFACE

Line 46: UPDATE rcv_transactions_interface

42: if (p_int_rec(i).unit_landed_cost is not null
43: and p_int_rec(i).lcm_shipment_line_id is not null
44: and p_int_rec(i).interface_id is not null) then
45:
46: UPDATE rcv_transactions_interface
47: SET lcm_shipment_line_id = p_int_rec(i).lcm_shipment_line_id,
48: unit_landed_cost = p_int_rec(i).unit_landed_cost
49: WHERE interface_transaction_id = p_int_rec(i).interface_id
50: AND processing_status_code = 'LC_INTERFACED'

Line 83: from rcv_transactions_interface

79:
80: begin
81: select lpn_group_id
82: into l_lpn_group_id
83: from rcv_transactions_interface
84: where interface_transaction_id = p_int_rec(i).interface_id;
85: exception
86: when others then
87: l_lpn_group_id := NULL;

Line 100: from rcv_transactions_interface

96: IF (l_lpn_group_id IS NOT NULL) THEN
97:
98: select count(1)
99: into l_lpn_group_rti_count
100: from rcv_transactions_interface
101: where lpn_group_id = l_lpn_group_id
102: and (lcm_shipment_line_id is NULL OR unit_landed_cost is NULL)
103: and processing_status_code in ('LC_PENDING','LC_INTERFACED');
104:

Line 109: UPDATE rcv_transactions_interface

105: asn_debug.put_line('LPN Group check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count);
106:
107: if (l_lpn_group_rti_count = 0) then
108:
109: UPDATE rcv_transactions_interface
110: SET processing_status_code = 'PENDING',
111: group_id = l_group_id
112: WHERE lpn_group_id = l_lpn_group_id
113: and ( ( lcm_shipment_line_id is not NULL

Line 124: and exists( select 'exists' from rcv_transactions_interface rti

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
125: WHERE rti.lpn_group_id = l_lpn_group_id
126: and rti.header_interface_id IS NOT NULL
127: and rti.header_interface_id = rhi.header_interface_id
128: and ( ( rti.lcm_shipment_line_id is not NULL

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 164: from rcv_transactions_interface

160: IF (l_asn_type = 'ASN'
161: AND g_fail_if_one_line_fails = 'Y') THEN
162: select count(1)
163: into l_lpn_group_rti_count
164: from rcv_transactions_interface
165: where header_interface_id = l_header_interface_id
166: and group_id = l_rhi_group_id
167: and (lcm_shipment_line_id is NULL OR unit_landed_cost is NULL)
168: and processing_status_code in ('LC_PENDING','LC_INTERFACED');

Line 175: UPDATE rcv_transactions_interface

171:
172:
173: if (l_lpn_group_rti_count = 0) then
174:
175: UPDATE rcv_transactions_interface
176: SET processing_status_code = 'PENDING',
177: group_id = l_group_id
178: WHERE header_interface_id = l_header_interface_id
179: AND group_id = l_rhi_group_id

Line 191: and exists( select 'exists' from rcv_transactions_interface rti

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
192: WHERE rti.header_interface_id = rhi.header_interface_id
193: and rti.header_interface_id = l_header_interface_id
194: and group_id = l_rhi_group_id
195: and ( ( rti.lcm_shipment_line_id is not NULL

Line 209: UPDATE rcv_transactions_interface

205: callRTP := TRUE;
206:
207: end if;
208: ELSE
209: UPDATE rcv_transactions_interface
210: SET processing_status_code = 'PENDING',
211: group_id = l_group_id
212: WHERE interface_transaction_id = p_int_rec(i).interface_id
213: AND processing_status_code = 'LC_INTERFACED'

Line 222: and exists( select 'exists' from rcv_transactions_interface rti

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
223: WHERE rti.interface_transaction_id = p_int_rec(i).interface_id
224: and rti.header_interface_id IS NOT NULL
225: and rti.header_interface_id = rhi.header_interface_id
226: AND processing_status_code = 'PENDING' -- Bug 7677015