[Home] [Help]
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;
105: v_bonded JAI_INV_SUBINV_DTLS.bonded % TYPE;
106: v_claimable_amount JAI_RCV_LINE_TAXES.claimable_amount % TYPE;
107: -- Start of addition by Srihari on 30-NOV-99
108: v_uom_rate NUMBER;
109: v_po_uom mtl_units_of_measure.unit_of_measure % TYPE;
110: v_po_uom_code mtl_units_of_measure.uom_code % TYPE;
108: v_uom_rate NUMBER;
109: v_po_uom mtl_units_of_measure.unit_of_measure % TYPE;
110: v_po_uom_code mtl_units_of_measure.uom_code % TYPE;
111: v_rcv_uom_code mtl_units_of_measure.unit_of_measure % TYPE;
112: v_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag % TYPE;
113: v_chk_excise NUMBER;
114: v_chk_receipt_lines NUMBER; --File.Sql.35 Cbabu :=0;
115: v_chk_receipt_tax_lines NUMBER; --File.Sql.35 Cbabu :=0;
116: --v_receipt_routing NUMBER; --Added by Nagaraj.s for Bug#2499017
251: r_rcv_rgm_dtl c_rcv_rgm_dtl%ROWTYPE;
252: /* End of VAT Impl. */
253:
254: --v_tax_vendor_site_id JAI_CMN_VENDOR_SITES.vendor_site_id%type; Commented by by nprshar for bug # 10193326 --Added by Nagaraj.s for Bug3037075
255: v_third_party_flag JAI_RCV_LINE_TAXES.third_party_flag%type; --Added by Nagaraj.s for Bug3037075
256: --Ends over here.
257: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319
258:
259: CURSOR uom_cur(c_uom VARCHAR2) IS
642: FOR lines_rec IN (SELECT rtl.tax_amount,
643: rtl.tax_type,
644: rtl.tax_line_no,
645: jtc.rounding_factor
646: FROM JAI_RCV_LINE_TAXES rtl,
647: JAI_CMN_TAXES_ALL jtc
648: WHERE rtl.shipment_line_id = p_shipment_line_id
649: AND jtc.tax_id = rtl.tax_id)
650: LOOP
649: AND jtc.tax_id = rtl.tax_id)
650: LOOP
651: v_current_tax := ROUND((lines_rec.tax_amount * v_cor_quantity),
652: NVL(lines_rec.rounding_factor, 0));
653: UPDATE JAI_RCV_LINE_TAXES
654: SET tax_amount = v_current_tax
655: WHERE shipment_line_id = p_shipment_line_id
656: AND tax_line_no = lines_rec.tax_line_no;
657: IF lines_rec.tax_type NOT IN ('TDS', 'Modvat Recovery')
1067: precedence 1 as, when tax line 1 was calculated, that is already taken care of.
1068:
1069: 14. 08/05/2003 Nagaraj.s for Bug#2915783. Version#615.14
1070: The Initialization of v_item_modvat_flag and v_item_trading_flag was not done at the
1071: proper place as a result of which Modvat_flag of JAI_RCV_LINE_TAXES
1072: was not populated properly. This has been moved to a location which is proper,
1073: so that Proper comparison happens.
1074:
1075: 15. 13/05/2003 Vijay Shankar for bug # 2943558. Version#615.15
1098: order line.source document line id = requisition line. requisition line id.
1099:
1100: 19. 30/07/2003 Nagaraj.s for Bug#3037075. Version#:616.4
1101: The Vendor site id is now fetched in the lines_rec cursor and
1102: the same is populated into JAI_RCV_LINE_TAXES table.
1103: This change is applicable for only PO type of Transaction. Huge Dependency
1104:
1105: 20. 22/08/2003 Nagaraj.s for Bug#3057752. Version#:616.5
1106: The changes are as below:
1138: 26. 18/06/2004 ssumaith - bug# 3683666 - File Version 115.2
1139:
1140: When a RMA receipt is done without navigating from Receipts-localised form and not entering
1141: the values in the DFF of RCV_SHIPMENT_HEADERS or RCV_TRANSACTIONS, it was observed that
1142: taxes are not defaulted into localization tables (JAI_RCV_LINE_TAXES).
1143: The reason this was happening is because the if condition which was checking this to be a
1144: RMA receipt was also checking the chk_form to be not null with an "AND" to other required
1145: conditions. Hence the problem
1146:
1180: RMA JAI_OM_OE_RMA_TAXES
1181: PO JAI_PO_TAXES
1182: ISO JAI_OM_WSH_LINE_TAXES
1183: ----------------------------------------------------------------------------------------
1184: In these 3 cases a insert into JAI_RCV_LINE_TAXES is present and this is,
1185: changed to incorporate precedences as well as transaction id.
1186:
1187: 30. 05/11/2004 Vijay Shankar - Bugs#3949408. File version : 115.5
1188: Commented the redundant code for MATCH processing
1234: (1) Added CVD, Excise and customs education cess
1235:
1236: 36 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.12
1237: .Implemented VAT Tax Calculation based on VAT Assessable value by making a call to jai_general_pkg.ja_in_vat_assessable_value
1238: .JAI_RCV_LINE_TAXES.modvat_flag is set to proper value for VAT Taxes based on RECOVERABLE item attribute
1239: of item. If item setup is not done, then Default value is taken as "Y" (meaning, tax is recoverable)
1240: .modified the main SQL's to fetch taxes from various sources to use jai_regime_tax_types_v to fetch regime_code
1241: against each tax so that the information can be used for MODVAT_FLAG setting of tax
1242: .RTV will raise an exception incase recoverable VAT exists in the receipt line and it is neither Claimed or
1479: 69. 07/Jul/2011 Qiong fix bug12717416 Taxes modified on RECEIPT
1480: 70. 03-feb-2012 vkaranam for bug#12800001
1481: Issue :RG23D register is not getting updated for ISO receipt
1482: Cause :
1483: jai_rcv_line_taxes.modvat_flag is populated as 'N' even if the tax has the cr percentage >0.
1484: fix:
1485: for trading organization as per the userguide/PM
1486: the below setup has to be there for the item:
1487: item excisable : "Y"
1487: item excisable : "Y"
1488: item tradable : "Y"
1489: item modvatable : "N".
1490:
1491: item_trading_flag has been added for setting the jai_rcv_line_taxes.modvat_flag
1492:
1493: 70. 13-Aug-2012 Bug 14010660
1494: Description: Excise Invoice Number and Date provided in ASN is not reflected in Receipts
1495: Localized form.
1519: Fix:Added a condition for handling non adhoc UOM based taxes along with code for Adhoc UOM based taxes
1520:
1521: ===============================================================================================================
1522: Bug Number Dependency
1523: 3037075 JAI_RCV_LINE_TAXES has been altered.
1524:
1525: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1526: altered.
1527:
2160:
2161: --Added by GSRI on 21-OCT-01
2162: SELECT COUNT(*)
2163: INTO v_chk_receipt_tax_lines
2164: FROM JAI_RCV_LINE_TAXES
2165: WHERE shipment_line_id = p_shipment_line_id
2166: AND shipment_header_id = p_shipment_header_id
2167: AND tax_id = lines_rec.tax_id;
2168:
2167: AND tax_id = lines_rec.tax_id;
2168:
2169: IF v_chk_receipt_tax_lines = 0 THEN
2170: /*
2171: DELETE FROM JAI_RCV_LINE_TAXES
2172: WHERE shipment_line_id = p_shipment_line_id AND
2173: shipment_header_id = p_shipment_header_id AND
2174: tax_id = lines_rec.tax_id;*/
2175: --End Addition by on GSRI 21-OCT-01
2174: tax_id = lines_rec.tax_id;*/
2175: --End Addition by on GSRI 21-OCT-01
2176:
2177: v_tax_modvat_flag := NVL(v_tax_modvat_flag,'N') ;
2178: INSERT INTO JAI_RCV_LINE_TAXES
2179: (
2180: shipment_line_id,
2181: tax_line_no,
2182: shipment_header_id,
3955: --commented out by shyan for bug 10100899 on 12/11/2010, End
3956:
3957: -- Added by Eric Ma for bug 10100899 on 17-Nov-2010,Begin
3958: ---------------------------------------------------------------
3959: --1. When populating the JAI_RCV_LINE_TAXES (OFI Receipt Tax Line), amount should be with the currency in corresponding PO tax line
3960: --2. When populating the JAI_RCV_LINES (OFI Receipt Line Detail), amount should be converted to its corresponding PO currency amount.
3961: --3. tax_amt_tab(i) saved the amount in 'INR' before currency conversion
3962: --4. v_cor_amount saved the amount in 'INR' before currency conversion
3963: ---------------------------------------------------------------
4019:
4020: --Added by GSRI on 21-OCT-01
4021: SELECT COUNT(*)
4022: INTO v_chk_receipt_tax_lines
4023: FROM JAI_RCV_LINE_TAXES
4024: WHERE shipment_line_id = p_shipment_line_id
4025: AND shipment_header_id = p_shipment_header_id
4026: AND tax_id = po_lines_rec.tax_id;
4027:
4025: AND shipment_header_id = p_shipment_header_id
4026: AND tax_id = po_lines_rec.tax_id;
4027:
4028: IF v_chk_receipt_tax_lines = 0 THEN
4029: /*DELETE FROM JAI_RCV_LINE_TAXES
4030: WHERE shipment_line_id = p_shipment_line_id AND
4031: shipment_header_id = p_shipment_header_id AND
4032: tax_id = tax_rec.tax_id;*/
4033: --End Addition by on GSRI 21-OCT-01
4031: shipment_header_id = p_shipment_header_id AND
4032: tax_id = tax_rec.tax_id;*/
4033: --End Addition by on GSRI 21-OCT-01
4034:
4035: INSERT INTO JAI_RCV_LINE_TAXES
4036: (
4037: shipment_line_id,
4038: tax_line_no,
4039: shipment_header_id,
4339:
4340: -- Added by GSRI on 21-OCT-01
4341: SELECT COUNT(*)
4342: INTO v_chk_receipt_tax_lines
4343: FROM JAI_RCV_LINE_TAXES
4344: WHERE shipment_line_id = p_shipment_line_id
4345: AND shipment_header_id = p_shipment_header_id
4346: AND tax_id = tax_rec.tax_id;
4347:
4347:
4348: -- END of Addition by GSRI on 21-OCT-01
4349: IF v_chk_receipt_tax_lines = 0 THEN
4350:
4351: INSERT INTO JAI_RCV_LINE_TAXES
4352: (
4353: shipment_line_id,
4354: tax_line_no,
4355: shipment_header_id,
4477: RTV creation should have taken care of this check
4478: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
4479: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
4480: , nvl(tax_types.regime_code, 'XXXX') regime_code
4481: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
4482: WHERE shipment_line_id = p_shipment_line_id
4483: AND NVL(modvat_flag, 'N') = 'Y'
4484: AND jtc.tax_type = tax_types.tax_type(+)
4485: AND jrtl.tax_id = jtc.tax_id)