APPS.PO_LINES_PKG_SUD dependencies on PO_LINES

Line 1: PACKAGE BODY PO_LINES_PKG_SUD as

1: PACKAGE BODY PO_LINES_PKG_SUD as
2: /* $Header: POXPIL4B.pls 120.3.12010000.2 2008/12/18 07:46:02 mugoel ship $ */
3:
4: PROCEDURE Update_Row(X_Rowid VARCHAR2,
5: X_Po_Line_Id NUMBER,

Line 129: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;

125: p_ip_category_id NUMBER -- Bug 7577670
126: ) IS
127:
128: --
129: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;
130: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
131: --
132:
133: BEGIN

Line 138: FROM po_headers_all poh, po_lines_all pol

134:
135: --
136: SELECT poh.type_lookup_code
137: INTO l_type_lookup_code
138: FROM po_headers_all poh, po_lines_all pol
139: WHERE pol.po_line_id = X_Po_Line_Id
140: AND pol.po_header_id = poh.po_header_id;
141:
142: IF l_type_lookup_code IN ('STANDARD', 'PLANNED') AND

Line 155: UPDATE PO_LINES

151: END IF;
152: --
153:
154:
155: UPDATE PO_LINES
156: SET
157: po_line_id = X_Po_Line_Id,
158: last_update_date = X_Last_Update_Date,
159: last_updated_by = X_Last_Updated_By,

Line 300: DELETE FROM PO_LINES

296: END Update_Row;
297:
298: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
299: BEGIN
300: DELETE FROM PO_LINES
301: WHERE rowid = X_Rowid;
302:
303: if (SQL%NOTFOUND) then
304: Raise NO_DATA_FOUND;

Line 308: END PO_LINES_PKG_SUD;

304: Raise NO_DATA_FOUND;
305: end if;
306: END Delete_Row;
307:
308: END PO_LINES_PKG_SUD;