[Home] [Help]
1725:
1726: CURSOR freight_charges(ORDER_Line_id NUMBER)
1727: IS
1728: SELECT *
1729: FROM oe_price_adjustments
1730: WHERE LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
1731: AND line_id = ORDER_Line_id;
1732:
1733:
1753:
1754:
1755: begin
1756: FORALL i IN 1..G_LINE_ADJ_REC.LINE_ID.COUNT --bug7685103
1757: DELETE FROM OE_PRICE_ADJUSTMENTS
1758: where list_line_type_code = 'TAX'
1759: and header_ID = G_LINE_ADJ_REC.header_ID(i);
1760: Exception
1761: when others then
1765: End ;
1766:
1767:
1768: FORALL i IN 1..G_LINE_ADJ_REC.LINE_ID.COUNT
1769: INSERT INTO OE_PRICE_ADJUSTMENTS
1770: ( PRICE_ADJUSTMENT_ID
1771: , CREATED_BY
1772: , CREATION_DATE
1773: , LAST_UPDATE_DATE
1783: , tax_rate_id --bug7685103
1784: , parent_adjustment_id
1785: )
1786: VALUES
1787: ( oe_price_adjustments_s.nextval
1788: , FND_GLOBAL.USER_ID
1789: , SYSDATE
1790: , SYSDATE
1791: , FND_GLOBAL.USER_ID
1834:
1835: FOR i IN 1..G_LINE_ID.COUNT LOOP
1836: total_freight_tax:=0;
1837:
1838: oe_debug_pub.add( 'Updating oe_price_Adjustments for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ) ;
1839:
1840:
1841: FOR j IN freight_charges(G_LINE_ID(i)) LOOP
1842:
1839:
1840:
1841: FOR j IN freight_charges(G_LINE_ID(i)) LOOP
1842:
1843: oe_debug_pub.add( 'Updating oe_price_Adjustments'||j.PRICE_ADJUSTMENT_ID ) ;
1844:
1845: begin
1846:
1847: SELECT Sum(Nvl(adjusted_amount,0))
1845: begin
1846:
1847: SELECT Sum(Nvl(adjusted_amount,0))
1848: INTO charge_tax
1849: FROM oe_price_adjustments
1850: WHERE parent_adjustment_id = j.PRICE_ADJUSTMENT_ID
1851: AND list_line_type_code = 'TAX';
1852:
1853: oe_debug_pub.add( 'Updating tax amount'||charge_tax ) ;