DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1598: DELETE FROM OE_PRICE_ADJUSTMENTS

1594:
1595:
1596: begin
1597: FORALL i IN 1..G_LINE_ADJ_REC.LINE_ID.COUNT --bug7685103
1598: DELETE FROM OE_PRICE_ADJUSTMENTS
1599: where list_line_type_code = 'TAX'
1600: and LINE_ID = G_LINE_ADJ_REC.LINE_ID(i);
1601: Exception
1602: when others then

Line 1610: INSERT INTO OE_PRICE_ADJUSTMENTS

1606: End ;
1607:
1608:
1609: FORALL i IN 1..G_LINE_ADJ_REC.LINE_ID.COUNT
1610: INSERT INTO OE_PRICE_ADJUSTMENTS
1611: ( PRICE_ADJUSTMENT_ID
1612: , CREATED_BY
1613: , CREATION_DATE
1614: , LAST_UPDATE_DATE

Line 1627: ( oe_price_adjustments_s.nextval

1623: , arithmetic_operator
1624: , tax_rate_id --bug7685103
1625: )
1626: VALUES
1627: ( oe_price_adjustments_s.nextval
1628: , FND_GLOBAL.USER_ID
1629: , SYSDATE
1630: , SYSDATE
1631: , FND_GLOBAL.USER_ID