[Home] [Help]
357: line_id = pr_new.source_line_id AND
358: header_id = pr_new.source_header_id;
359:
360:
361: -- The following cursor gets the sum of tax amount for the line_id from JAI_OM_OE_SO_TAXES table
362: CURSOR c_ja_in_so_tax_lines_tax_amt
363: IS
364: SELECT
365: nvl(sum(so_tax.tax_amount),0)
363: IS
364: SELECT
365: nvl(sum(so_tax.tax_amount),0)
366: FROM
367: JAI_OM_OE_SO_TAXES so_tax
368: , jai_cmn_taxes_all tax -- Added by Jia Li for inclusive tax on 2008/01/07
369: WHERE
370: line_id = pr_new.source_line_id AND
371: header_id = pr_new.source_header_id
374:
375:
376:
377: v_line_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the tax amount for a line - based on JAI_OM_OE_SO_LINES
378: v_sum_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the sum of taxes for a line - based on JAI_OM_OE_SO_TAXES
379: -- ends here -- cursors added by sriram - bug # 2689417
380:
381:
382: /*
433: lv_applicable JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE;
434: lv_process_flag VARCHAR2 (2);
435: lv_process_message VARCHAR2 (1000);
436:
437: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
438: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
439: )
440: IS
441: SELECT 1
434: lv_process_flag VARCHAR2 (2);
435: lv_process_message VARCHAR2 (1000);
436:
437: CURSOR cur_chk_vat_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
438: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
439: )
440: IS
441: SELECT 1
442: FROM JAI_OM_OE_SO_TAXES jstl ,
438: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
439: )
440: IS
441: SELECT 1
442: FROM JAI_OM_OE_SO_TAXES jstl ,
443: JAI_CMN_TAXES_ALL jtc ,
444: jai_regime_tax_types_v tax_types
445: WHERE jstl.line_id = cp_line_id
446: AND jstl.header_id = cp_header_id
448: AND jtc.tax_type = tax_types.tax_type
449: AND tax_types.regime_code = jai_constants.vat_regime;
450:
451: --added the following cursor for bug#8538431
452: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
453: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
454: )
455: IS
456: SELECT 1
449: AND tax_types.regime_code = jai_constants.vat_regime;
450:
451: --added the following cursor for bug#8538431
452: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
453: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
454: )
455: IS
456: SELECT 1
457: FROM JAI_OM_OE_SO_TAXES jstl ,
453: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
454: )
455: IS
456: SELECT 1
457: FROM JAI_OM_OE_SO_TAXES jstl ,
458: JAI_CMN_TAXES_ALL jtc
459: WHERE jstl.line_id = cp_line_id
460: AND jstl.header_id = cp_header_id
461: AND jtc.tax_id = jstl.tax_id
559: Also the update statement , which updates the released_flag in the JAI_OM_LC_MATCHINGS table
560: has been commented , because the update should happen after the shipping has completed.
561:
562: Also an error message has to be thrown , when shipping is done , for an order
563: where the tax amounts in the JAI_OM_OE_SO_TAXES and JAI_OM_OE_SO_LINES do not tally.
564:
565: 3. Avishek - Bug # 2928261
566: Added a RAISE_APPLICATION_ERROR to give an error message when a sub-inventory is not
567: associated properly with a location ID.
806: /*
807: This code has been added by aiyer for the bug 3392528.
808: Call the function jai_om_utils_pkg.validate_excise_exemption to validate the different valid combination of values
809: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the
810: table JAI_OM_OE_SO_TAXES
811: */
812:
813: OPEN c_chk_exc_exmpt_rule;
814: FETCH c_chk_exc_exmpt_rule INTO lv_excise_exempt_type,ln_line_number,ln_shipment_line_number,v_quantity;
1476: A.Uom,
1477: A.Tax_Amount,
1478: A.Base_Tax_Amount,
1479: A.Func_Tax_Amount
1480: FROM JAI_OM_OE_SO_TAXES A,
1481: JAI_CMN_TAXES_ALL b
1482: WHERE Line_id = v_source_line_id
1483: AND A.Tax_Id = b.Tax_Id
1484: ORDER BY A.Tax_Line_No;
1663: AND B.organization_id = p_organization_id
1664: AND B.location_id = p_location_id );
1665: CURSOR Get_Tax_Lines_Details_Cur1 IS
1666: SELECT A.Tax_Rate, NVL(b.Rounding_Factor,0) Rounding_Factor
1667: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
1668: WHERE Line_id = v_source_line_id
1669: AND A.Tax_Id = b.Tax_Id
1670: AND b.tax_type = 'Modvat Recovery'
1671: ORDER BY A.Tax_Line_No;
1960: With this the check becomes that if a organization is trdable, item is tradable , excisable and the order
1961: associated to the bond register is Trading Domestic With Excise and Export With Excise only then
1962: it can be assumed that there would be data in table JAI_CMN_MATCH_TAXES (Match receipts has been performed).
1963: In such a case take the tax_amoutn ,base_tax_amount and func_tax_amoutn for the above table.
1964: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.
1965:
1966:
1967: Dependency Introduced Due to this Bug : -
1968: None
2001: applicable on the date of shipment should be considerd for all processing rather than the creation
2002: date of the Sales order.
2003: Added the procedure call jai_cmn_utils_pkg.currency_conversion to calculated the currency conversion rate.
2004: Also changed the population logic of v_func_tax_amt variable, such that
2005: during shipping the functional tax amount gets recalculated from the tax_amount column in JAI_OM_OE_SO_TAXES
2006: and hence logic is ->
2007: v_func_tax_amt = v_tax_amt * nvl((v_curr_conv_rate ,1)
2008:
2009: Fix Of Bug#3158282:-
2605: v_base_tax_amt := (v_shipped_quantity * (rec.base_tax_amount/v_quantity)) ;
2606: /*
2607: Code modified by aiyer for the bug 3139718
2608: As the Conversion rate can be different while the sales order was booked and when the sales order would be shipped.
2609: So during shipping the functional tax amount needs to be recalculated from the tax_amount column in JAI_OM_OE_SO_TAXES
2610: , hence setting the v_func_tax_amt = v_tax_amt * nvl((v_curr_conv_rate ,1)
2611: */
2612: v_func_tax_amt := (v_tax_amt * nvl(v_curr_conv_rate,1)) ; -- added by ssumaith - bug#3609172
2613: --END IF; Commented by JMEENA for bug#6280735