APPS.PO_LINE_LOCATIONS_PKG_S2 dependencies on PO_LINE_LOCATIONS_ALL

Line 130: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type;--

126: X_amount NUMBER, --
127: p_transaction_flow_header_id NUMBER,
128: p_manual_price_change_flag VARCHAR2 default null --< Manual Price Override FPJ >
129: ) IS
130: l_tax_attribute_update_code PO_LINE_LOCATIONS_ALL.tax_attribute_update_code%type;--
131: BEGIN
132:
133: --
134: IF X_Shipment_Type in ('STANDARD', 'PLANNED', 'BLANKET', 'SCHEDULED') AND

Line 289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;

285: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
286: l_return_status VARCHAR2(1);
287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(2000);
289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;
291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;

Line 290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;

286: l_return_status VARCHAR2(1);
287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(2000);
289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;
291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;
294: --

Line 291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(2000);
289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;
291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;
294: --
295:

Line 292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

288: l_msg_data VARCHAR2(2000);
289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;
291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;
294: --
295:
296: BEGIN

Line 293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;

289: l_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
290: l_po_release_id PO_LINE_LOCATIONS_ALL.po_release_id%TYPE;
291: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
292: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;
294: --
295:
296: BEGIN
297: DELETE FROM PO_LINE_LOCATIONS