APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PRICE_ADJS_HISTORY

Line 7: -- 3. oe_price_adjs_history

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.
10: --
11: -- If the API is called just for Phase_Change then p_version_number should

Line 1287: INSERT INTO OE_PRICE_ADJS_HISTORY(

1283:
1284: -- Create History Records for Adjustments
1285: l_api_name := 'Create_Price_Adjs_History';
1286:
1287: INSERT INTO OE_PRICE_ADJS_HISTORY(
1288: PRICE_ADJUSTMENT_ID,
1289: HEADER_ID,
1290: HIST_CREATION_DATE,
1291: CREATION_DATE,

Line 1507: FROM OE_PRICE_ADJS_HISTORY b

1503: p_phase_change_flag --PHASE_CHANGE_FLAG
1504: FROM OE_PRICE_ADJUSTMENTS a
1505: WHERE a.header_id = p_header_id
1506: AND NOT EXISTS ( SELECT price_adjustment_id
1507: FROM OE_PRICE_ADJS_HISTORY b
1508: WHERE b.price_adjustment_id = a.price_adjustment_id
1509: AND a.header_id = b.header_id
1510: AND b.version_number = l_version_number
1511: AND b.version_flag = l_version_flag);

Line 1652: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p

1648: WHERE h.header_id = p.header_id
1649: AND p.price_adjustment_id = p_price_adjustment_id;
1650: EXCEPTION WHEN NO_DATA_FOUND THEN
1651: SELECT h.version_number INTO l_current_version_number
1652: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
1653: WHERE h.header_id = p.header_id
1654: AND p.price_adjustment_id = p_price_adjustment_id
1655: AND rownum = 1;
1656: END;

Line 2353: FROM OE_PRICE_ADJS_HISTORY

2349: -- , OPERAND_PER_PQTY
2350: -- , ADJUSTED_AMOUNT_PER_PQTY
2351: --uom end
2352: , LOCK_CONTROL
2353: FROM OE_PRICE_ADJS_HISTORY
2354: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
2355: AND VERSION_NUMBER = l_version_number
2356: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2357: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 2462: FROM OE_PRICE_ADJS_HISTORY

2458: -- , OPERAND_PER_PQTY
2459: -- , ADJUSTED_AMOUNT_PER_PQTY
2460: --uom end
2461: , LOCK_CONTROL
2462: FROM OE_PRICE_ADJS_HISTORY
2463: WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL
2464: AND VERSION_NUMBER = l_version_number
2465: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2466: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4696: FROM OE_PRICE_ADJS_HISTORY

4692: --uom end
4693: , LOCK_CONTROL
4694: -- eBTax changes
4695: , TAX_RATE_ID
4696: FROM OE_PRICE_ADJS_HISTORY
4697: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
4698: and version_number = l_version_number
4699: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4700: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4808: FROM OE_PRICE_ADJS_HISTORY

4804: , LOCK_CONTROL
4805: -- eBTax changes
4806: , TAX_RATE_ID
4807:
4808: FROM OE_PRICE_ADJS_HISTORY
4809: WHERE line_id = p_line_id
4810: and version_number = l_version_number
4811: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4812: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4919: FROM OE_PRICE_ADJS_HISTORY

4915: --uom end
4916: , LOCK_CONTROL
4917: -- eBTax changes
4918: , TAX_RATE_ID
4919: FROM OE_PRICE_ADJS_HISTORY
4920: WHERE header_id = p_header_id
4921: and line_id is not null
4922: and version_number = l_version_number
4923: AND (PHASE_CHANGE_FLAG = p_phase_change_flag