DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on PO_LINE_LOCATIONS

Line 136: -- po_line_locations_sv.lock_row (line_location_id);

132: ** over-receive the PO.
133: */
134: X_progress := '030';
135:
136: -- po_line_locations_sv.lock_row (line_location_id);
137: /* Bug 4773978: Added the following code for logging error messages
138: in PO_INTERFACE_ERRORS table. */
139: RCV_ERROR_PKG.initialize(rcv_trx.transaction_type,
140: rcv_trx.group_id,

Line 191: from po_line_locations

187: */
188: begin
189: select nvl(matching_basis,'QUANTITY')
190: into l_matching_basis
191: from po_line_locations
192: where line_location_id =rcv_trx.po_line_location_id;
193: exception
194: /* Bug 3417961 : If the receipt_source_code is not PO then the above sql
195: will fetch null in l_matching_basis. This will cause set_trx_defaults()

Line 276: from po_line_locations

272: /* getting the match option from the PO */
273:
274: select match_option
275: into x_match_option
276: from po_line_locations
277: where line_location_id = rcv_trx.po_line_location_id;
278:
279: /* bug 4356092 - currency conversion rate code was incorrect */
280: IF (x_match_option = 'R') THEN