APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_LINES

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;

Line 653: UPDATE oe_order_lines

649: THEN
650: --Customer Acceptance
651: IF l_pending_acceptance = 'Y' THEN
652:
653: UPDATE oe_order_lines
654: SET flow_status_code = 'POST-BILLING_ACCEPTANCE'
655: , last_updated_by = NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID)
656: , last_update_login = FND_GLOBAL.LOGIN_ID
657: , last_update_date = SYSDATE

Line 672: UPDATE oe_order_lines

668:
669: END IF;
670: ELSE
671: --Customer Acceptance
672: UPDATE oe_order_lines
673: SET open_flag = 'N'
674: , calculate_price_flag = 'N'
675: , flow_status_code = DECODE(l_old_line_tbl(1).cancelled_flag,'Y',
676: 'CANCELLED','CLOSED')

Line 722: UPDATE oe_order_lines

718: l_line_tbl(1).last_update_date := SYSDATE;
719: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
720: END IF;
721:
722: UPDATE oe_order_lines
723: SET open_flag = l_line_tbl(1).open_flag
724: , calculate_price_flag = l_line_tbl(1).calculate_price_flag
725: , flow_status_code = l_line_tbl(1).flow_status_code
726: , last_updated_by = l_line_tbl(1).last_updated_by