DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_PVT dependencies on OE_ORDER_LINES_ALL

Line 110: UPDATE oe_order_lines_all

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

Line 215: FROM oe_order_lines_all

211: l_header_id NUMBER := p_request_rec.entity_id;
212: l_line_id NUMBER;
213: CURSOR order_lines is
214: SELECT line_id
215: FROM oe_order_lines_all
216: WHERE header_id = l_header_id
217: AND open_flag = 'Y'
218: AND flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE');
219: --

Line 269: FROM oe_order_lines_all

265: l_shipped_quantity NUMBER;
266:
267: CURSOR model_children is
268: SELECT line_id, fulfilled_quantity,shipped_quantity, ordered_quantity,header_id, flow_status_code
269: FROM oe_order_lines_all
270: WHERE header_id = l_header_id
271: AND open_flag = 'Y'
272: AND top_model_line_id = l_line_id;
273:

Line 276: FROM oe_order_lines_all

272: AND top_model_line_id = l_line_id;
273:
274: CURSOR c_service_lines is
275: SELECT line_id, fulfilled_quantity, shipped_quantity, ordered_quantity, header_id, flow_status_code
276: FROM oe_order_lines_all
277: WHERE open_flag='Y'
278: AND service_reference_line_id = l_line_id;
279:
280:

Line 296: FROM oe_order_lines_all

292: SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
293: shipped_quantity, ordered_quantity, flow_status_code
294: INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
295: l_shipped_quantity, l_ordered_quantity, l_flow_status_code
296: FROM oe_order_lines_all
297: WHERE line_id=l_line_id;
298:
299: l_line_count := l_line_count + 1;
300: G_LINE_ID_TBL(l_line_count) := l_line_id;

Line 350: FROM oe_order_lines_all

346: SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
347: shipped_quantity, ordered_quantity, flow_status_code
348: INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
349: l_shipped_quantity, l_ordered_quantity, l_flow_status_code
350: FROM oe_order_lines_all
351: WHERE line_id=l_line_id;
352:
353:
354: --Entering children lines in to global tbls

Line 583: l_org_id oe_order_lines_all.org_id%TYPE; -- Bug 8859412

579: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
582: --
583: l_org_id oe_order_lines_all.org_id%TYPE; -- Bug 8859412
584: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
585: BEGIN
586:
587: IF l_debug_level > 0 THEN

Line 584: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
582: --
583: l_org_id oe_order_lines_all.org_id%TYPE; -- Bug 8859412
584: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
585: BEGIN
586:
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add('ENTERING Progress_ Accepted_Lines' , 1);

Line 625: FROM oe_order_lines_all

621: oe_debug_pub.add('Customer is Rejected');
622:
623: SELECT inventory_item_id, org_id
624: INTO l_inventory_item_id, l_org_id
625: FROM oe_order_lines_all
626: WHERE line_id = g_line_id_tbl(i);
627:
628:
629:

Line 656: UPDATE oe_order_lines_all

652:
653:
654: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
655:
656: UPDATE oe_order_lines_all
657: SET flow_status_code='NOTIFY_COSTING_ERROR'
658: WHERE line_id = g_line_id_tbl(i);
659: x_return_status := l_return_status;
660: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;