APPS.PO_LINE_LOCATIONS_SV1 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_SV1 AS

1: PACKAGE BODY PO_LINE_LOCATIONS_SV1 AS
2: /* $Header: POXPILLB.pls 120.0 2005/06/02 00:30:35 appldev noship $ */
3:
4:
5: /*================================================================

Line 29: FROM po_line_locations

25: --Removed "AND shipment_type = 'PRICE BREAK'" clause. This clause was overriding
26: --the clause "shipment_type = x_shipment_type" and the code was breaking for QUOTATIONS.
27: SELECT count(*)
28: INTO x_temp
29: FROM po_line_locations
30: WHERE shipment_num = x_shipment_num
31: AND shipment_type = x_shipment_type
32: AND po_header_id = x_po_header_id
33: AND po_line_id = x_po_line_id

Line 104: /* derive the line_location_id from po_line_locations based on

100: BEGIN
101:
102: X_progress := '010';
103:
104: /* derive the line_location_id from po_line_locations based on
105: po_header_id, po_line_id and shipment_num which was provided
106: from the input parameter and shipment type of PRICE BREAK */
107: --Bug4040677 Start
108: --This SQL only considers BPAs. Added shipment_type clauses for SPO and QUOTATIONS.

Line 113: FROM po_line_locations

109: --Its OK because a line will only have one type of shipments listed.
110:
111: SELECT line_location_id
112: INTO X_line_location_id_v
113: FROM po_line_locations
114: WHERE po_header_id = X_po_header_id
115: AND po_line_id = X_po_line_id
116: AND shipment_num = X_shipment_num
117: AND shipment_type in ('PRICE BREAK','QUOTATION', 'STANDARD');

Line 214: END PO_LINE_LOCATIONS_SV1;

210: raise;
211: END val_location_id;
212:
213:
214: END PO_LINE_LOCATIONS_SV1;