358: --TaxER start
359: IF NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' then
360: BEGIN
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
360: BEGIN
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;
369: END IF ;
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
370:
371: IF (OE_Order_Cache.g_order_type_rec.order_type_id = OE_Order_Cache.g_header_rec.Order_Type_id) THEN
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
372: if (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'ENTERING') then
373: l_tax_calculation_event_code := 0;
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
379: l_tax_calculation_event_code := 3;
380: else
374: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'BOOKING') then
375: l_tax_calculation_event_code := 1;
376: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'SHIPPING') then
377: l_tax_calculation_event_code := 2;
378: elsif (OE_Order_Cache.g_order_type_rec.tax_calculation_event_code = 'INVOICING') then
379: l_tax_calculation_event_code := 3;
380: else
381: l_tax_calculation_event_code := -1;
382: end if ;