APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_HEADER_HISTORY

Line 5: -- 1. oe_order_header_history

1: PACKAGE BODY OE_VERSION_HISTORY_UTIL AS
2: /* $Header: OEXHVERB.pls 120.8.12020000.3 2013/01/17 07:19:05 sujithku ship $ */
3:
4: -- This API will be used to create history records for entities.
5: -- 1. oe_order_header_history
6: -- 2. oe_order_lines_history
7: -- 3. oe_price_adjs_history
8: -- 4. oe_sales_credit_history
9: -- It will skip the records which already exists for the specified version.

Line 196: INSERT INTO OE_ORDER_HEADER_HISTORY

192: END IF;
193: END IF;
194:
195:
196: INSERT INTO OE_ORDER_HEADER_HISTORY
197: (
198: HEADER_ID,
199: HIST_CREATION_DATE,
200: ORG_ID,

Line 553: FROM OE_ORDER_HEADER_HISTORY b

549: l_instrument_id
550: FROM OE_ORDER_HEADERS a
551: WHERE a.header_id = p_header_id
552: AND NOT EXISTS (SELECT b.header_id
553: FROM OE_ORDER_HEADER_HISTORY b
554: WHERE a.header_id = b.header_id
555: AND b.version_number = l_version_number
556: AND b.version_flag = l_version_flag);
557: IF l_debug_level > 0 THEN

Line 2137: FROM OE_ORDER_HEADER_HISTORY

2133: , x_header_rec.source_document_version_number
2134: , x_header_rec.sold_to_site_use_id
2135: --key Transaction Dates
2136: , x_header_rec.order_firmed_date
2137: FROM OE_ORDER_HEADER_HISTORY
2138: WHERE HEADER_ID = p_header_id
2139: AND VERSION_NUMBER = l_version_number
2140: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2141: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'