DBA Data[Home] [Help]

APPS.PO_LINES_PKG_SI dependencies on PO_LINES

Line 1: PACKAGE BODY PO_LINES_PKG_SI as

1: PACKAGE BODY PO_LINES_PKG_SI as
2: /* $Header: POXPIL1B.pls 120.5 2005/09/20 02:39:59 sjadhav noship $ */
3:
4: /*History
5: Preetam Bamb (GML) 10-feb-2000 Added 5 columns to the insert_row procedure

Line 141: CURSOR C IS SELECT rowid FROM PO_LINES

137: p_manual_price_change_flag IN VARCHAR2 DEFAULT NULL, --
138: p_org_id IN NUMBER DEFAULT NULL, --
139: p_ip_category_id IN NUMBER DEFAULT NULL --
140: ) IS
141: CURSOR C IS SELECT rowid FROM PO_LINES
142: WHERE po_line_id = X_Po_Line_Id;
143:
144: CURSOR S IS SELECT po_lines_s.nextval FROM sys.dual;
145:

Line 144: CURSOR S IS SELECT po_lines_s.nextval FROM sys.dual;

140: ) IS
141: CURSOR C IS SELECT rowid FROM PO_LINES
142: WHERE po_line_id = X_Po_Line_Id;
143:
144: CURSOR S IS SELECT po_lines_s.nextval FROM sys.dual;
145:
146: x_progress VARCHAR2(3) := '';
147: --
148: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;

Line 148: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;

144: CURSOR S IS SELECT po_lines_s.nextval FROM sys.dual;
145:
146: x_progress VARCHAR2(3) := '';
147: --
148: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;
149: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
150: --
151:
152:

Line 177: INSERT INTO PO_LINES (

173: --
174:
175: x_progress := '030';
176:
177: INSERT INTO PO_LINES (
178: po_line_id,
179: last_update_date,
180: last_updated_by,
181: po_header_id,

Line 456: END PO_LINES_PKG_SI;

452: CLOSE C;
453:
454: END Insert_Row;
455:
456: END PO_LINES_PKG_SI;