APPS.PO_LINE_LOCATIONS_PKG_S2 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S2 as

1: PACKAGE BODY PO_LINE_LOCATIONS_PKG_S2 as
2: /* $Header: POXP3PSB.pls 120.9.12020000.3 2013/02/10 12:21:44 vegajula ship $ */
3:
4: PROCEDURE Update_Row(X_Rowid VARCHAR2,
5: X_Line_Location_Id NUMBER,

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 151: UPDATE PO_LINE_LOCATIONS

147: END IF;
148: --
149:
150:
151: UPDATE PO_LINE_LOCATIONS
152: SET
153: line_location_id = X_Line_Location_Id,
154: last_update_date = X_Last_Update_Date,
155: last_updated_by = X_Last_Updated_By,

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

Line 297: DELETE FROM PO_LINE_LOCATIONS

293: l_org_id PO_LINE_LOCATIONS_ALL.org_id%type;
294: --
295:
296: BEGIN
297: DELETE FROM PO_LINE_LOCATIONS
298: WHERE rowid = X_Rowid
299: --
300: RETURNING shipment_type, po_header_id, po_release_id, line_location_id,org_id
301: INTO l_shipment_type, l_po_header_id, l_po_release_id, l_line_location_id,l_org_id;

Line 341: END PO_LINE_LOCATIONS_PKG_S2;

337: --
338:
339: END Delete_Row;
340:
341: END PO_LINE_LOCATIONS_PKG_S2;