APPS.PO_LINES_SV11 dependencies on PO_LINES_ALL

Line 182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883

178: X_ship_org_id NUMBER := NULL;
179: X_secondary_quantity_ship NUMBER := NULL;
180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:

Line 183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883

179: X_secondary_quantity_ship NUMBER := NULL;
180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:

Line 184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883

180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:
188: --OPM bug3455686

Line 185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670

181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:
188: --OPM bug3455686
189: CURSOR opm_fetch_quantity IS

Line 213: --Bug 13536036, retrieving the ip_category_id from the po_lines_all tbale for that line_id.

209:
210: X_progress := '010';
211:
212: --Bug 13067295, added one more variable to retrieve the category_id from the db.
213: --Bug 13536036, retrieving the ip_category_id from the po_lines_all tbale for that line_id.
214: --In case if the po_category_id gets updated then we will over ride l_ip_Category_id value later.
215:
216:
217:

Line 220: from po_lines_all

216:
217:
218: select order_type_lookup_code,purchase_basis,amount,category_id, ip_category_id
219: into l_line_type,l_purchase_basis ,l_orig_amount,l_orig_category_id,l_ip_category_id
220: from po_lines_all
221: where po_line_id = X_po_line_id;
222:
223:
224: if ( (p_type_lookup_code = 'STANDARD') OR

Line 405: from po_lines_all

401: ---Bug 13067295, Moved the below query to the begining of this procedure.
402:
403: /* select order_type_lookup_code,purchase_basis,amount
404: into l_line_type,l_purchase_basis ,l_orig_amount
405: from po_lines_all
406: where po_line_id = X_po_line_id;*/
407:
408: if ((X_orig_quantity <> X_quantity ) or (l_orig_amount <> X_amount_db))
409: then