APPS.PO_SHIPMENTS_SV6 dependencies on PO_LINE_LOCATIONS

Line 177: FROM po_line_locations pll

173: begin
174:
175: SELECT nvl(sum(pll.quantity - nvl(pll.quantity_cancelled,0)),0)
176: INTO X_scheduled_quantity
177: FROM po_line_locations pll
178: WHERE pll.po_line_id = X_po_line_id
179: AND pll.source_shipment_id = X_line_location_id
180: AND pll.shipment_type = 'SCHEDULED';
181:

Line 204: po_line_locations_pkg_s3.check_unique(

200: -- Otherwise, display a message to the user and
201: -- abort insert_row.
202:
203: X_progress := '015';
204: po_line_locations_pkg_s3.check_unique(
205: X_rowid,
206: X_shipment_num,
207: X_po_line_id,
208: null,

Line 215: po_line_locations_pkg_s0.insert_row(

211:
212: /*
213: ** Call the insert row routine with all parameters.
214: */
215: po_line_locations_pkg_s0.insert_row(
216: X_Rowid,
217: X_Line_Location_Id,
218: X_Last_Update_Date,
219: X_Last_Updated_By,