DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_PKG_S1 dependencies on PO_LINES_ALL

Line 129: l_purchase_basis po_lines_all.purchase_basis%TYPE;

125: WHERE rowid = X_Rowid
126: FOR UPDATE of Line_Location_Id NOWAIT;
127: Recinfo C%ROWTYPE;
128:
129: l_purchase_basis po_lines_all.purchase_basis%TYPE;
130: -- For debug purposes
131: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
132:
133: BEGIN

Line 150: FROM po_lines_all

146: -- SQL Why : To use in the lock row to not compare amounts for temp
147: -- labor lines
148: SELECT purchase_basis
149: INTO l_purchase_basis
150: FROM po_lines_all
151: WHERE po_line_id = Recinfo.po_line_id;
152: Exception
153: when others then
154: APP_EXCEPTION.RAISE_EXCEPTION;