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 286: from po_line_locations

282: /* getting the match option from the PO */
283:
284: select match_option
285: into x_match_option
286: from po_line_locations
287: where line_location_id = rcv_trx.po_line_location_id;
288:
289: /* bug 4356092 - currency conversion rate code was incorrect */
290: IF (x_match_option = 'R') THEN

Line 1294: l_pll_lcm_flag po_line_locations_all.lcm_flag%TYPE; -- Bug 9575796

1290: l_locator_id number;
1291:
1292: l_mp_lcm_flag mtl_parameters.lcm_enabled_flag%TYPE; -- Bug 9575796
1293: l_pre_receive_flag rcv_parameters.pre_receive%TYPE; -- Bug 9575796
1294: l_pll_lcm_flag po_line_locations_all.lcm_flag%TYPE; -- Bug 9575796
1295:
1296: BEGIN
1297:
1298: /*

Line 1341: FROM po_line_locations_all pll,

1337: -- Bug 9575796 : Start
1338: IF (rcv_trx.source_document_code = 'PO' and rcv_trx.po_line_location_id is not null) THEN
1339: SELECT nvl(mp.lcm_enabled_flag,'N'), nvl(rp.pre_receive,'N'),nvl(pll.lcm_flag,'N')
1340: INTO l_mp_lcm_flag, l_pre_receive_flag, l_pll_lcm_flag
1341: FROM po_line_locations_all pll,
1342: mtl_parameters mp,
1343: rcv_parameters rp
1344: WHERE pll.line_location_id = rcv_trx.po_line_location_id
1345: AND mp.organization_id = rcv_trx.to_organization_id