APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

417: l_header_rec OE_Order_PUB.Header_Rec_Type;
418: l_return_status_gen VARCHAR2(30);
419: -- GENESIS --
420: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
422: l_org_id oe_order_lines_all.org_id%TYPE;
423: /* Customer Acceptance */
424: l_pending_acceptance VARCHAR2(1) := 'N';
425: l_line_rec OE_ORDER_PUB.Line_rec_type;

Line 422: l_org_id oe_order_lines_all.org_id%TYPE;

418: l_return_status_gen VARCHAR2(30);
419: -- GENESIS --
420: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
422: l_org_id oe_order_lines_all.org_id%TYPE;
423: /* Customer Acceptance */
424: l_pending_acceptance VARCHAR2(1) := 'N';
425: l_line_rec OE_ORDER_PUB.Line_rec_type;
426: --

Line 485: FROM oe_order_lines_all

481: l_old_line_tbl(1).change_sequence,
482: l_old_line_tbl(1).source_document_type_id,
483: l_old_line_tbl(1).source_document_id,
484: l_old_line_tbl(1).source_document_line_id
485: FROM oe_order_lines_all
486: WHERE line_id = p_line_id
487: FOR UPDATE NOWAIT;
488:
489: OE_MSG_PUB.update_msg_context

Line 607: FROM oe_order_lines_all

603: IF oe_cogs_grp.is_revenue_event_line(p_line_id) = 'Y' AND l_pending_acceptance = 'N' THEN
604:
605: SELECT inventory_item_id, org_id
606: INTO l_inventory_item_id, l_org_id
607: FROM oe_order_lines_all
608: WHERE line_id = p_line_id;
609:
610:
611: cst_revenuecogsmatch_grp.receive_closelineevent (

Line 634: UPDATE oe_order_lines_all

630: -- as 'NOTIFY_COSTING_ERROR';
631:
632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
633:
634: UPDATE oe_order_lines_all
635: SET flow_status_code='NOTIFY_COSTING_ERROR'
636: WHERE line_id = p_line_id;
637: x_return_status := l_return_status;
638: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;