[Home] [Help]
453: l_call_tax VARCHAR2(1) := 'N';
454: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
455: l_precision fnd_currencies.precision%type;
456: l_ship_from_location_id NUMBER;
457: l_commitment_id oe_order_lines.commitment_id%type;
458: l_currency_code VARCHAR2(30);
459: l_inventory_org_id NUMBER;
460: l_header_org_id NUMBER;
461: l_conversion_rate NUMBER;
517: and cust_acct.party_id = party.party_id
518: and acct_site_ship.party_site_id = party_site_ship.party_site_id
519: and party_site_ship.location_id = loc_ship.location_id;
520:
521: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
522: -- p_line_id oe_order_lines.line_id%type)
523: is
524: select * from
525: ZX_DETAIL_TAX_LINES_GT
518: and acct_site_ship.party_site_id = party_site_ship.party_site_id
519: and party_site_ship.location_id = loc_ship.location_id;
520:
521: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
522: -- p_line_id oe_order_lines.line_id%type)
523: is
524: select * from
525: ZX_DETAIL_TAX_LINES_GT
526: where
1644: SELECT hsecs INTO l_end_time from v$timer;
1645:
1646: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));
1647:
1648: --Need to Update TAX_VALUE on oe_order_lines_all if in post insert mode.
1649: IF p_post_insert AND G_Tax_Line_Id.COUNT > 0
1650: THEN
1651:
1652: IF l_debug_level > 0 THEN
1654: END IF;
1655:
1656:
1657: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103
1658: UPDATE OE_ORDER_LINES
1659: SET TAX_VALUE = 0
1660: WHERE LINE_ID = G_Tax_Line_Id(i);
1661:
1662: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103
1659: SET TAX_VALUE = 0
1660: WHERE LINE_ID = G_Tax_Line_Id(i);
1661:
1662: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103
1663: UPDATE OE_ORDER_LINES
1664: SET TAX_VALUE = TAX_VALUE + G_Tax_Line_Value(i)
1665: WHERE LINE_ID = G_Tax_Line_Id(i);
1666:
1667: