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.7 2006/06/12 22:26:15 lkxu noship $ */
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 149: INSERT INTO OE_ORDER_HEADER_HISTORY

145: END IF;
146: END IF;
147:
148:
149: INSERT INTO OE_ORDER_HEADER_HISTORY
150: (
151: HEADER_ID,
152: HIST_CREATION_DATE,
153: ORG_ID,

Line 506: FROM OE_ORDER_HEADER_HISTORY b

502: l_instrument_id
503: FROM OE_ORDER_HEADERS a
504: WHERE a.header_id = p_header_id
505: AND NOT EXISTS (SELECT b.header_id
506: FROM OE_ORDER_HEADER_HISTORY b
507: WHERE a.header_id = b.header_id
508: AND b.version_number = l_version_number
509: AND b.version_flag = l_version_flag);
510: IF l_debug_level > 0 THEN

Line 2074: FROM OE_ORDER_HEADER_HISTORY

2070: , x_header_rec.source_document_version_number
2071: , x_header_rec.sold_to_site_use_id
2072: --key Transaction Dates
2073: , x_header_rec.order_firmed_date
2074: FROM OE_ORDER_HEADER_HISTORY
2075: WHERE HEADER_ID = p_header_id
2076: AND VERSION_NUMBER = l_version_number
2077: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2078: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'