APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

427: l_header_rec OE_Order_PUB.Header_Rec_Type;
428: l_return_status_gen VARCHAR2(30);
429: -- GENESIS --
430: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
432: l_org_id oe_order_lines_all.org_id%TYPE;
433: /* Customer Acceptance */
434: l_pending_acceptance VARCHAR2(1) := 'N';
435: l_line_rec OE_ORDER_PUB.Line_rec_type;

Line 432: l_org_id oe_order_lines_all.org_id%TYPE;

428: l_return_status_gen VARCHAR2(30);
429: -- GENESIS --
430: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
432: l_org_id oe_order_lines_all.org_id%TYPE;
433: /* Customer Acceptance */
434: l_pending_acceptance VARCHAR2(1) := 'N';
435: l_line_rec OE_ORDER_PUB.Line_rec_type;
436: --

Line 495: FROM oe_order_lines_all

491: l_old_line_tbl(1).change_sequence,
492: l_old_line_tbl(1).source_document_type_id,
493: l_old_line_tbl(1).source_document_id,
494: l_old_line_tbl(1).source_document_line_id
495: FROM oe_order_lines_all
496: WHERE line_id = p_line_id
497: FOR UPDATE NOWAIT;
498:
499: OE_MSG_PUB.update_msg_context

Line 617: FROM oe_order_lines_all

613: IF oe_cogs_grp.is_revenue_event_line(p_line_id) = 'Y' AND l_pending_acceptance = 'N' THEN
614:
615: SELECT inventory_item_id, org_id
616: INTO l_inventory_item_id, l_org_id
617: FROM oe_order_lines_all
618: WHERE line_id = p_line_id;
619:
620:
621: cst_revenuecogsmatch_grp.receive_closelineevent (

Line 644: UPDATE oe_order_lines_all

640: -- as 'NOTIFY_COSTING_ERROR';
641:
642: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
643:
644: UPDATE oe_order_lines_all
645: SET flow_status_code='NOTIFY_COSTING_ERROR'
646: WHERE line_id = p_line_id;
647: x_return_status := l_return_status;
648: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;