APPS.OE_BULK_TAX_UTIL dependencies on OE_ORDER_LINES

Line 457: l_commitment_id oe_order_lines.commitment_id%type;

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;

Line 535: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)

531: AND acct_site_ship.cust_account_id = cust_acct.cust_account_id
532: AND cust_acct.party_id = party.party_id
533: AND acct_site_ship.party_site_id = party_site_ship.party_site_id
534: AND party_site_ship.location_id = loc_ship.location_id;
535: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
536: -- p_line_id oe_order_lines.line_id%type)
537: IS
538: SELECT *
539: FROM ZX_DETAIL_TAX_LINES_GT

Line 536: -- p_line_id oe_order_lines.line_id%type)

532: AND cust_acct.party_id = party.party_id
533: AND acct_site_ship.party_site_id = party_site_ship.party_site_id
534: AND party_site_ship.location_id = loc_ship.location_id;
535: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type)
536: -- p_line_id oe_order_lines.line_id%type)
537: IS
538: SELECT *
539: FROM ZX_DETAIL_TAX_LINES_GT
540: WHERE application_id = l_application_id

Line 1810: --Need to Update TAX_VALUE on oe_order_lines_all if in post insert mode.

1806: SELECT hsecs INTO l_end_time from v$timer;
1807:
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));
1809:
1810: --Need to Update TAX_VALUE on oe_order_lines_all if in post insert mode.
1811: IF p_post_insert AND G_Tax_Line_Id.COUNT > 0
1812: THEN
1813:
1814: IF l_debug_level > 0 THEN

Line 1820: UPDATE OE_ORDER_LINES

1816: END IF;
1817:
1818:
1819: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103
1820: UPDATE OE_ORDER_LINES
1821: SET TAX_VALUE = 0
1822: WHERE LINE_ID = G_Tax_Line_Id(i);
1823:
1824: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103

Line 1825: UPDATE OE_ORDER_LINES

1821: SET TAX_VALUE = 0
1822: WHERE LINE_ID = G_Tax_Line_Id(i);
1823:
1824: FORALL i IN 1..G_Tax_Line_Id.COUNT --bug7685103
1825: UPDATE OE_ORDER_LINES
1826: SET TAX_VALUE = TAX_VALUE + G_Tax_Line_Value(i)
1827: WHERE LINE_ID = G_Tax_Line_Id(i);
1828:
1829:

Line 1833: oe_debug_pub.add( 'Updating OE_ORDER_LINES tax value' ) ;

1829:
1830: --TAXER
1831:
1832:
1833: oe_debug_pub.add( 'Updating OE_ORDER_LINES tax value' ) ;
1834:
1835: FOR i IN 1..G_LINE_ID.COUNT LOOP
1836: total_freight_tax:=0;
1837:

Line 1867: UPDATE OE_ORDER_LINES

1863: total_freight_tax:= total_freight_tax + charge_tax;
1864:
1865: END LOOP;
1866:
1867: UPDATE OE_ORDER_LINES
1868: SET TAX_VALUE = TAX_VALUE + total_freight_tax ,
1869: TAX_LINE_VALUE = total_freight_tax
1870: WHERE LINE_ID = G_LINE_ID(i);
1871: