DBA Data[Home] [Help]

APPS.OE_BULK_PRICE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 16: -- from interface tables into oe_price_adjustments table.

12: ---------------------------------------------------------------------
13: -- PROCEDURE Insert_Adjustments
14: --
15: -- Inserts manual price adjustments for this bulk import batch,
16: -- from interface tables into oe_price_adjustments table.
17: -- This API should be called before Price_Orders to ensure that
18: -- manual adjustments are applied when pricing the order.
19: ---------------------------------------------------------------------
20:

Line 33: INSERT INTO OE_PRICE_ADJUSTMENTS

29: BEGIN
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: INSERT INTO OE_PRICE_ADJUSTMENTS
34: (PRICE_ADJUSTMENT_ID
35: ,CREATION_DATE
36: ,CREATED_BY
37: ,LAST_UPDATE_DATE

Line 136: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

132: ,ADJUSTED_AMOUNT_PER_PQTY
133: ,LOCK_CONTROL
134: )
135: SELECT
136: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
137: ,sysdate
138: ,FND_GLOBAL.USER_ID
139: ,sysdate
140: ,FND_GLOBAL.USER_ID