APPS.OE_ORDER_PVT dependencies on OE_ORDER_HEADERS

Line 342: from oe_order_headers_all

338: (g_header_id IS NULL)
339: THEN
340: select UPGRADED_FLAG, booked_flag into
341: g_upgraded_flag, g_booked_flag
342: from oe_order_headers_all
343: where header_id = p_header_id;
344: g_header_id := p_header_id;
345: END IF;
346:

Line 1015: FROM OE_ORDER_HEADERS_ALL

1011: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1012: source_document_type_id, source_document_id
1013: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1014: l_source_document_type_id, l_source_document_id
1015: FROM OE_ORDER_HEADERS_ALL
1016: WHERE header_id = l_header_Scredit_rec.header_id;
1017: EXCEPTION
1018: WHEN NO_DATA_FOUND THEN
1019: l_order_source_id := null;

Line 1058: FROM OE_ORDER_HEADERS_ALL

1054: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1055: source_document_type_id, source_document_id
1056: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1057: l_source_document_type_id, l_source_document_id
1058: FROM OE_ORDER_HEADERS_ALL
1059: WHERE header_id = l_old_header_Scredit_rec.header_id;
1060: EXCEPTION
1061: WHEN NO_DATA_FOUND THEN
1062: l_order_source_id := null;

Line 1321: select booked_flag into l_booked_flag from oe_order_headers where header_id = l_header_scredit_rec.header_id;

1317: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1318: SAVEPOINT DELETE_SCREDIT_FAILED; --bug 5331854
1319: --bug 5049879
1320: select quota_flag into l_quota_flag from oe_sales_credit_types where sales_credit_type_id = l_header_scredit_rec.sales_credit_type_id;
1321: select booked_flag into l_booked_flag from oe_order_headers where header_id = l_header_scredit_rec.header_id;
1322: OE_Header_Scredit_Util.Delete_Row
1323: ( p_sales_credit_id => l_Header_Scredit_rec.sales_credit_id
1324: );
1325:

Line 1598: FROM OE_ORDER_HEADERS_ALL

1594: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1595: source_document_type_id, source_document_id
1596: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1597: l_source_document_type_id, l_source_document_id
1598: FROM OE_ORDER_HEADERS_ALL
1599: WHERE header_id = l_header_Payment_rec.header_id;
1600: EXCEPTION
1601: WHEN NO_DATA_FOUND THEN
1602: l_order_source_id := null;

Line 1641: FROM OE_ORDER_HEADERS_ALL

1637: SELECT order_source_id, orig_sys_document_ref, change_sequence,
1638: source_document_type_id, source_document_id
1639: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
1640: l_source_document_type_id, l_source_document_id
1641: FROM OE_ORDER_HEADERS_ALL
1642: WHERE header_id = l_old_header_Payment_rec.header_id;
1643: EXCEPTION
1644: WHEN NO_DATA_FOUND THEN
1645: l_order_source_id := null;

Line 7937: FROM oe_order_headers_all

7933:
7934: -- Bug 8435946
7935: IF ( l_hdr_flow_status_refresh = 'Y' ) THEN
7936: SELECT flow_status_code into p_x_header_rec.flow_status_code
7937: FROM oe_order_headers_all
7938: WHERE header_id = p_x_header_rec.header_id;
7939: END IF;
7940:
7941: END IF;