APPS.OE_ACCEPTANCE_PVT dependencies on OE_ORDER_LINES_ALL

Line 106: UPDATE oe_order_lines_all

102: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - before bulk update' , 1);
103: END IF;
104:
105: FORALL i in g_line_id_tbl.FIRST .. g_line_id_tbl.LAST
106: UPDATE oe_order_lines_all
107: SET revrec_comments = g_revrec_comments_tbl(i),
108: Revrec_reference_document = g_revrec_ref_doc_tbl(i),
109: Revrec_signature = g_revrec_signature_tbl(i),
110: Revrec_implicit_flag = g_revrec_implicit_flag_tbl(i),

Line 159: FROM oe_order_lines_all

155: l_header_id NUMBER := p_request_rec.entity_id;
156: l_line_id NUMBER;
157: CURSOR order_lines is
158: SELECT line_id
159: FROM oe_order_lines_all
160: WHERE header_id = l_header_id
161: AND open_flag = 'Y'
162: AND flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE');
163: --

Line 213: FROM oe_order_lines_all

209: l_shipped_quantity NUMBER;
210:
211: CURSOR model_children is
212: SELECT line_id, fulfilled_quantity,shipped_quantity, ordered_quantity,header_id, flow_status_code
213: FROM oe_order_lines_all
214: WHERE header_id = l_header_id
215: AND open_flag = 'Y'
216: AND top_model_line_id = l_line_id;
217:

Line 220: FROM oe_order_lines_all

216: AND top_model_line_id = l_line_id;
217:
218: CURSOR c_service_lines is
219: SELECT line_id, fulfilled_quantity, shipped_quantity, ordered_quantity, header_id, flow_status_code
220: FROM oe_order_lines_all
221: WHERE open_flag='Y'
222: AND service_reference_line_id = l_line_id;
223:
224:

Line 240: FROM oe_order_lines_all

236: SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
237: shipped_quantity, ordered_quantity, flow_status_code
238: INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
239: l_shipped_quantity, l_ordered_quantity, l_flow_status_code
240: FROM oe_order_lines_all
241: WHERE line_id=l_line_id;
242:
243: l_line_count := l_line_count + 1;
244: G_LINE_ID_TBL(l_line_count) := l_line_id;

Line 294: FROM oe_order_lines_all

290: SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
291: shipped_quantity, ordered_quantity, flow_status_code
292: INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
293: l_shipped_quantity, l_ordered_quantity, l_flow_status_code
294: FROM oe_order_lines_all
295: WHERE line_id=l_line_id;
296:
297:
298: --Entering children lines in to global tbls