APPS.WMS_UT_PKG dependencies on OE_HEADERS_INTERFACE

Line 1465: l_orig_sys oe_headers_interface%ROWTYPE;

1461: l_return_status VARCHAR2(80);
1462:
1463: l_dummy VARCHAR2(10);
1464:
1465: l_orig_sys oe_headers_interface%ROWTYPE;
1466:
1467:
1468: type los_tt is TABLE of oe_headers_interface%ROWTYPE index by BINARY_INTEGER;
1469:

Line 1468: type los_tt is TABLE of oe_headers_interface%ROWTYPE index by BINARY_INTEGER;

1464:
1465: l_orig_sys oe_headers_interface%ROWTYPE;
1466:
1467:
1468: type los_tt is TABLE of oe_headers_interface%ROWTYPE index by BINARY_INTEGER;
1469:
1470: l_orig_sys_tbl los_tt;
1471:
1472: CURSOR l_orig_sys_reference_cursor IS

Line 1475: FROM oe_headers_interface

1471:
1472: CURSOR l_orig_sys_reference_cursor IS
1473: SELECT * --order_source_id
1474: --,ORIG_SYS_DOCUMENT_REF
1475: FROM oe_headers_interface
1476: WHERE request_id=l_request_id;
1477:
1478: CURSOR c_solines (p_header_id NUMBER) IS
1479: SELECT mso.sales_order_id as header_id, ol.line_id, nvl(oh.source_document_type_id,11) as source_doc_type_id

Line 1803: update oe_headers_interface

1799:
1800: l_order_source_id := l_orig_sys.order_source_id;
1801: l_orig_sys_document_ref := l_orig_sys.orig_sys_document_ref;
1802:
1803: update oe_headers_interface
1804: set error_flag = 'N'
1805: where request_id = l_request_id
1806: and order_source_id = l_order_source_id
1807: and orig_sys_document_ref = l_orig_sys_document_ref;