[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
229: r_rcv_rgm_dtl c_rcv_rgm_dtl%ROWTYPE;
230: /* End of VAT Impl. */
231:
232: v_tax_vendor_site_id JAI_CMN_VENDOR_SITES.vendor_site_id%type; --Added by Nagaraj.s for Bug3037075
233: v_third_party_flag JAI_RCV_LINE_TAXES.third_party_flag%type; --Added by Nagaraj.s for Bug3037075
234: --Ends over here.
235: v_item_class JAI_INV_ITM_SETUPS.item_class%type; --3202319
236:
237: CURSOR uom_cur(c_uom VARCHAR2) IS
565: FOR lines_rec IN (SELECT rtl.tax_amount,
566: rtl.tax_type,
567: rtl.tax_line_no,
568: jtc.rounding_factor
569: FROM JAI_RCV_LINE_TAXES rtl,
570: JAI_CMN_TAXES_ALL jtc
571: WHERE rtl.shipment_line_id = p_shipment_line_id
572: AND jtc.tax_id = rtl.tax_id)
573: LOOP
572: AND jtc.tax_id = rtl.tax_id)
573: LOOP
574: v_current_tax := ROUND((lines_rec.tax_amount * v_cor_quantity),
575: NVL(lines_rec.rounding_factor, 0));
576: UPDATE JAI_RCV_LINE_TAXES
577: SET tax_amount = v_current_tax
578: WHERE shipment_line_id = p_shipment_line_id
579: AND tax_line_no = lines_rec.tax_line_no;
580: IF lines_rec.tax_type NOT IN ('TDS', 'Modvat Recovery')
975: precedence 1 as, when tax line 1 was calculated, that is already taken care of.
976:
977: 14. 08/05/2003 Nagaraj.s for Bug#2915783. Version#615.14
978: The Initialization of v_item_modvat_flag and v_item_trading_flag was not done at the
979: proper place as a result of which Modvat_flag of JAI_RCV_LINE_TAXES
980: was not populated properly. This has been moved to a location which is proper,
981: so that Proper comparison happens.
982:
983: 15. 13/05/2003 Vijay Shankar for bug # 2943558. Version#615.15
1006: order line.source document line id = requisition line. requisition line id.
1007:
1008: 19. 30/07/2003 Nagaraj.s for Bug#3037075. Version#:616.4
1009: The Vendor site id is now fetched in the lines_rec cursor and
1010: the same is populated into JAI_RCV_LINE_TAXES table.
1011: This change is applicable for only PO type of Transaction. Huge Dependency
1012:
1013: 20. 22/08/2003 Nagaraj.s for Bug#3057752. Version#:616.5
1014: The changes are as below:
1046: 26. 18/06/2004 ssumaith - bug# 3683666 - File Version 115.2
1047:
1048: When a RMA receipt is done without navigating from Receipts-localised form and not entering
1049: the values in the DFF of RCV_SHIPMENT_HEADERS or RCV_TRANSACTIONS, it was observed that
1050: taxes are not defaulted into localization tables (JAI_RCV_LINE_TAXES).
1051: The reason this was happening is because the if condition which was checking this to be a
1052: RMA receipt was also checking the chk_form to be not null with an "AND" to other required
1053: conditions. Hence the problem
1054:
1088: RMA JAI_OM_OE_RMA_TAXES
1089: PO JAI_PO_TAXES
1090: ISO JAI_OM_WSH_LINE_TAXES
1091: ----------------------------------------------------------------------------------------
1092: In these 3 cases a insert into JAI_RCV_LINE_TAXES is present and this is,
1093: changed to incorporate precedences as well as transaction id.
1094:
1095: 30. 05/11/2004 Vijay Shankar - Bugs#3949408. File version : 115.5
1096: Commented the redundant code for MATCH processing
1142: (1) Added CVD, Excise and customs education cess
1143:
1144: 36 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.12
1145: .Implemented VAT Tax Calculation based on VAT Assessable value by making a call to jai_general_pkg.ja_in_vat_assessable_value
1146: .JAI_RCV_LINE_TAXES.modvat_flag is set to proper value for VAT Taxes based on RECOVERABLE item attribute
1147: of item. If item setup is not done, then Default value is taken as "Y" (meaning, tax is recoverable)
1148: .modified the main SQL's to fetch taxes from various sources to use jai_regime_tax_types_v to fetch regime_code
1149: against each tax so that the information can be used for MODVAT_FLAG setting of tax
1150: .RTV will raise an exception incase recoverable VAT exists in the receipt line and it is neither Claimed or
1314:
1315:
1316: ===============================================================================================================
1317: Bug Number Dependency
1318: 3037075 JAI_RCV_LINE_TAXES has been altered.
1319:
1320: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1321: altered.
1322:
1914:
1915: --Added by GSRI on 21-OCT-01
1916: SELECT COUNT(*)
1917: INTO v_chk_receipt_tax_lines
1918: FROM JAI_RCV_LINE_TAXES
1919: WHERE shipment_line_id = p_shipment_line_id
1920: AND shipment_header_id = p_shipment_header_id
1921: AND tax_id = lines_rec.tax_id;
1922:
1921: AND tax_id = lines_rec.tax_id;
1922:
1923: IF v_chk_receipt_tax_lines = 0 THEN
1924: /*
1925: DELETE FROM JAI_RCV_LINE_TAXES
1926: WHERE shipment_line_id = p_shipment_line_id AND
1927: shipment_header_id = p_shipment_header_id AND
1928: tax_id = lines_rec.tax_id;*/
1929: --End Addition by on GSRI 21-OCT-01
1928: tax_id = lines_rec.tax_id;*/
1929: --End Addition by on GSRI 21-OCT-01
1930:
1931: v_tax_modvat_flag := NVL(v_tax_modvat_flag,'N') ;
1932: INSERT INTO JAI_RCV_LINE_TAXES
1933: (
1934: shipment_line_id,
1935: tax_line_no,
1936: shipment_header_id,
2886:
2887: --Added by GSRI on 21-OCT-01
2888: SELECT COUNT(*)
2889: INTO v_chk_receipt_tax_lines
2890: FROM JAI_RCV_LINE_TAXES
2891: WHERE shipment_line_id = p_shipment_line_id
2892: AND shipment_header_id = p_shipment_header_id
2893: AND tax_id = po_lines_rec.tax_id;
2894:
2892: AND shipment_header_id = p_shipment_header_id
2893: AND tax_id = po_lines_rec.tax_id;
2894:
2895: IF v_chk_receipt_tax_lines = 0 THEN
2896: /*DELETE FROM JAI_RCV_LINE_TAXES
2897: WHERE shipment_line_id = p_shipment_line_id AND
2898: shipment_header_id = p_shipment_header_id AND
2899: tax_id = tax_rec.tax_id;*/
2900: --End Addition by on GSRI 21-OCT-01
2898: shipment_header_id = p_shipment_header_id AND
2899: tax_id = tax_rec.tax_id;*/
2900: --End Addition by on GSRI 21-OCT-01
2901:
2902: INSERT INTO JAI_RCV_LINE_TAXES
2903: (
2904: shipment_line_id,
2905: tax_line_no,
2906: shipment_header_id,
3205:
3206: -- Added by GSRI on 21-OCT-01
3207: SELECT COUNT(*)
3208: INTO v_chk_receipt_tax_lines
3209: FROM JAI_RCV_LINE_TAXES
3210: WHERE shipment_line_id = p_shipment_line_id
3211: AND shipment_header_id = p_shipment_header_id
3212: AND tax_id = tax_rec.tax_id;
3213:
3213:
3214: -- END of Addition by GSRI on 21-OCT-01
3215: IF v_chk_receipt_tax_lines = 0 THEN
3216:
3217: INSERT INTO JAI_RCV_LINE_TAXES
3218: (
3219: shipment_line_id,
3220: tax_line_no,
3221: shipment_header_id,
3343: RTV creation should have taken care of this check
3344: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
3345: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
3346: , nvl(tax_types.regime_code, 'XXXX') regime_code
3347: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
3348: WHERE shipment_line_id = p_shipment_line_id
3349: AND NVL(modvat_flag, 'N') = 'Y'
3350: AND jtc.tax_type = tax_types.tax_type(+)
3351: AND jrtl.tax_id = jtc.tax_id)