[Home] [Help]
490: a.precedence_5 p_5, a.precedence_6 p_6, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
491: a.precedence_7 p_7, a.precedence_8 p_8,
492: a.precedence_9 p_9, a.precedence_10 p_10,
493: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
494: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
495: DECODE(UPPER(b.tax_type),
496: 'EXCISE', 1,
497: 'ADDL. EXCISE', 1,
498: 'OTHER EXCISE', 1,
709: /** Both driving parameter tax_category_id and threshol_tax_category_id are invalid hence no need to do anything */
710: return;
711: end if;
712:
713: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then
714: /** Assign tax defaultation cursor object to refc_tax_cur reference by using. Call to get_tax_cat_taxes_cur will return
715: a reference cursor */
716:
717: if p_threshold_tax_cat_id is not null and p_threshold_tax_cat_id > 0 then
758: );
759:
760: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Cursor is opened');*/ --commented by bgowrava for bug#5631784
761:
762: elsif p_action = jai_constants.recalculate_taxes then
763: /**
764: Following is a dynamic sql string which can be modifed as per requirement
765:
766: The sql has four place holders defined as below
801: , a.tax_rate
802: , a.tax_amount
803: , b.uom_code
804: , b.end_date valid_date
805: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
806: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
807: , ''ADDL. EXCISE'', 1
808: , ''OTHER EXCISE'', 1
809: , ''TDS'' , 2
807: , ''ADDL. EXCISE'', 1
808: , ''OTHER EXCISE'', 1
809: , ''TDS'' , 2
810: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
811: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
812: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
813: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
814: , 0
815: )
809: , ''TDS'' , 2
810: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
811: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
812: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
813: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
814: , 0
815: )
816: ) tax_type_val
817: , b.mod_cr_percentage
853: , '$$ADDITIONAL_ORDER_BY$$'
854: , ''
855: );
856:
857: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then
858:
859: /** replace the correct tax source table */
860: lv_recalculation_sql :=
861: replace ( lv_recalculation_sql
867: replace ( lv_recalculation_sql
868: , '$$SOURCE_TABLE_FILTER$$'
869: , 'a.delivery_detail_id = ' || p_line_id
870: );
871: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then
872:
873: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
874: lv_recalculation_sql :=
875: replace ( lv_recalculation_sql
890:
891: -- Date 24-Apr-2007 Added by SACSETHI for bug 6012570 (5876390)
892: -- in This , Recalculation will be happen in Draft invoice
893: ---------------------------------------------------------
894: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then
895:
896: lv_recalculation_sql :=
897: replace ( lv_recalculation_sql
898: , 'a.tax_amount'
907: /** replace join condition */
908: lv_recalculation_sql :=
909: replace ( lv_recalculation_sql
910: , '$$SOURCE_TABLE_FILTER$$'
911: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''
912: );
913:
914: -- Added by Jason Liu for standalone invoice on 2007/08/23
915: ----------------------------------------------------------------------
913:
914: -- Added by Jason Liu for standalone invoice on 2007/08/23
915: ----------------------------------------------------------------------
916: ELSIF upper(p_source_trx_type) =
917: jai_constants.G_AP_STANDALONE_INVOICE
918: THEN
919:
920: lv_recalculation_sql :=
921: REPLACE( lv_recalculation_sql
933: REPLACE( lv_recalculation_sql
934: , '$$SOURCE_TABLE_FILTER$$'
935: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id ||
936: ' and SOURCE_DOC_TYPE ='''||
937: jai_constants.G_AP_STANDALONE_INVOICE || ''''
938: );
939: ----------------------------------------------------------------------
940: end if; /*pv_tax_source_table*/
941:
1022: tax_type_tab(row_count) := rec.tax_type_val;
1023: /*End of bug 4691616 */
1024: -- tax_amt_tab(row_count) := 0;
1025: /*added for bug#6498072, start*/
1026: IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes
1027: NVL(rec.adhoc_flag,'N') = 'Y' --adhoc_flag='Y'
1028: THEN
1029: tax_amt_tab(row_count) := nvl(rec.tax_amount,0) ;
1030: ELSE
1063: IF NVL(v_conversion_rate, 0) <= 0 THEN
1064:
1065: /* for cash receipt there will be no lines. sacsethi for 6012570 (5876390) */
1066: if (p_uom_code is null and p_inventory_item_id is null )
1067: and p_source_trx_type = jai_constants.ar_cash
1068: then --
1069: v_conversion_rate := 1;
1070:
1071: /*
1072: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
1073: in This , Recalculation will be happen in Draft invoice
1074: */
1075: elsif (p_uom_code is null and p_inventory_item_id is null )
1076: and p_source_trx_type in (jai_constants.pa_draft_invoice
1077: ,jai_constants.G_AP_STANDALONE_INVOICE)
1078: then
1079: v_conversion_rate := 0;
1080:
1073: in This , Recalculation will be happen in Draft invoice
1074: */
1075: elsif (p_uom_code is null and p_inventory_item_id is null )
1076: and p_source_trx_type in (jai_constants.pa_draft_invoice
1077: ,jai_constants.G_AP_STANDALONE_INVOICE)
1078: then
1079: v_conversion_rate := 0;
1080:
1081: else
1085: END IF;
1086: END IF;
1087: --tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity; -- cbabu for EnhancementBug# 2427465, compact code
1088: /*added for bug#6498072, start*/
1089: IF p_action = jai_constants.recalculate_taxes THEN
1090: /*tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) ;*/ --commented out by walton for inclusive tax
1091: lt_tax_amt_non_rate_tab(rec.lno):=NVL(rec.tax_amount * v_conversion_rate, 0); --added by walton for inclusive tax
1092: ELSE
1093: /*tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity ;*/ --commented out by walton for inclusive tax
1625: /** Both driving parameter tax_category_id and threshol_tax_category_id are invalid hence no need to do anything */
1626: return;
1627: end if;
1628:
1629: if nvl(p_action, jai_constants.default_taxes) = jai_constants.default_taxes then
1630: /** Assign tax defaultation cursor object to refc_tax_cur reference by using. Call to get_tax_cat_taxes_cur will return
1631: a reference cursor */
1632:
1633: if p_threshold_tax_cat_id is not null and p_threshold_tax_cat_id > 0 then
1675: );
1676:
1677: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Cursor is opened');*/ --commented by bgowrava for bug#5631784
1678:
1679: elsif p_action = jai_constants.recalculate_taxes then
1680: /**
1681: Following is a dynamic sql string which can be modifed as per requirement
1682:
1683: The sql has four place holders defined as below
1718: , a.tax_rate
1719: , a.tax_amount
1720: , b.uom_code
1721: , b.end_date valid_date
1722: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
1723: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
1724: , ''ADDL. EXCISE'', 1
1725: , ''OTHER EXCISE'', 1
1726: , ''TDS'' , 2
1724: , ''ADDL. EXCISE'', 1
1725: , ''OTHER EXCISE'', 1
1726: , ''TDS'' , 2
1727: , ''EXCISE_EDUCATION_CESS'',1
1728: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
1729: , ''CVD_EDUCATION_CESS'' ,1
1730: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
1731: , 0
1732: )
1726: , ''TDS'' , 2
1727: , ''EXCISE_EDUCATION_CESS'',1
1728: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
1729: , ''CVD_EDUCATION_CESS'' ,1
1730: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 1 /*bduvarag for the bug#5989740*/
1731: , 0
1732: )
1733: ) tax_type_val
1734: , b.mod_cr_percentage
1769: , '$$ADDITIONAL_ORDER_BY$$'
1770: , ''
1771: );
1772:
1773: if upper(p_source_trx_type) = jai_constants.source_ttype_delivery then
1774:
1775: /** replace the correct tax source table */
1776: lv_recalculation_sql :=
1777: replace ( lv_recalculation_sql
1783: replace ( lv_recalculation_sql
1784: , '$$SOURCE_TABLE_FILTER$$'
1785: , 'a.delivery_detail_id = ' || p_line_id
1786: );
1787: elsif upper(p_source_trx_type) = jai_constants.bill_only_invoice then
1788:
1789: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
1790: lv_recalculation_sql :=
1791: replace ( lv_recalculation_sql
1806:
1807: -- Date 24-Apr-2007 Added by SACSETHI for bug 6012570 (5876390)
1808: -- in This , Recalculation will be happen in Draft invoice
1809: ---------------------------------------------------------
1810: elsif upper(p_source_trx_type) = jai_constants.PA_DRAFT_INVOICE then
1811:
1812: lv_recalculation_sql :=
1813: replace ( lv_recalculation_sql
1814: , 'a.tax_amount'
1823: /** replace join condition */
1824: lv_recalculation_sql :=
1825: replace ( lv_recalculation_sql
1826: , '$$SOURCE_TABLE_FILTER$$'
1827: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id || ' and SOURCE_DOC_TYPE ='''|| jai_constants.PA_DRAFT_INVOICE || ''''
1828: );
1829:
1830: -- Added by Jason Liu for standalone invoice on 2007/08/23
1831: ----------------------------------------------------------------------
1829:
1830: -- Added by Jason Liu for standalone invoice on 2007/08/23
1831: ----------------------------------------------------------------------
1832: ELSIF upper(p_source_trx_type) =
1833: jai_constants.G_AP_STANDALONE_INVOICE
1834: THEN
1835:
1836: lv_recalculation_sql :=
1837: REPLACE( lv_recalculation_sql
1849: REPLACE( lv_recalculation_sql
1850: , '$$SOURCE_TABLE_FILTER$$'
1851: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id ||
1852: ' and SOURCE_DOC_TYPE ='''||
1853: jai_constants.G_AP_STANDALONE_INVOICE || ''''
1854: );
1855: ----------------------------------------------------------------------
1856: end if; /*pv_tax_source_table*/
1857:
1931: /*End of bug 4691616 */
1932: -- tax_amt_tab(row_count) := 0;
1933: /*added for bug#6498072, start*/
1934: --Comment out by Kevin Cheng
1935: /*IF p_action = jai_constants.recalculate_taxes AND --recalculate_taxes
1936: NVL(rec.adhoc_flag,'N') = 'Y' --adhoc_flag='Y'
1937: THEN
1938: tax_amt_tab(row_count) := nvl(rec.tax_amount,0) ;
1939: ELSE
2063: IF NVL(v_conversion_rate, 0) <= 0 THEN
2064:
2065: \* for cash receipt there will be no lines. sacsethi for 6012570 (5876390) *\
2066: if (p_uom_code is null and p_inventory_item_id is null )
2067: and p_source_trx_type = jai_constants.ar_cash
2068: then --
2069: v_conversion_rate := 1;
2070:
2071: \*
2072: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
2073: in This , Recalculation will be happen in Draft invoice
2074: *\
2075: elsif (p_uom_code is null and p_inventory_item_id is null )
2076: and p_source_trx_type= jai_constants.pa_draft_invoice
2077: then
2078: v_conversion_rate := 0;
2079:
2080: else
2084: END IF;
2085: END IF;
2086: --tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity; -- cbabu for EnhancementBug# 2427465, compact code
2087: \*added for bug#6498072, start*\
2088: IF p_action = jai_constants.recalculate_taxes THEN
2089: tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) ;
2090: ELSE
2091: tax_amt_tab(rec.lno) := nvl(rec.tax_amount * v_conversion_rate, 0) * p_line_quantity ;
2092: END IF ;
2489: ELSIF rec.mod_cr_percentage IS NULL THEN
2490: v_modvat_flag := 'N';
2491: END IF;
2492: -- bug 6436825
2493: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
2494: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
2495: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
2496: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2497: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
2490: v_modvat_flag := 'N';
2491: END IF;
2492: -- bug 6436825
2493: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
2494: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
2495: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
2496: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2497: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
2498: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
2491: END IF;
2492: -- bug 6436825
2493: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
2494: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
2495: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
2496: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2497: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
2498: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
2499:
2492: -- bug 6436825
2493: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
2494: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
2495: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
2496: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2497: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
2498: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
2499:
2500: INSERT INTO jai_cmn_document_taxes(
2493: IF REC.TAX_TYPE NOT IN ('Service', JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS,
2494: JAI_CONSTANTS.TAX_TYPE_SERVICE_EDU_CESS,
2495: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
2496: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
2497: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
2498: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
2499:
2500: INSERT INTO jai_cmn_document_taxes(
2501: DOC_TAX_ID,
2791: END IF;
2792:
2793: IF v_transaction_name IN ( 'OTHERS', 'QUOTATION', 'BLANKET' ) THEN
2794: IF upper(rec.tax_type) IN ( 'CVD',
2795: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2796: 'CUSTOMS' ,
2797: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2798: jai_constants.tax_type_cvd_edu_cess ,
2799: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2793: IF v_transaction_name IN ( 'OTHERS', 'QUOTATION', 'BLANKET' ) THEN
2794: IF upper(rec.tax_type) IN ( 'CVD',
2795: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2796: 'CUSTOMS' ,
2797: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2798: jai_constants.tax_type_cvd_edu_cess ,
2799: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2800: jai_constants.tax_type_customs_edu_cess
2801: ) THEN
2794: IF upper(rec.tax_type) IN ( 'CVD',
2795: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2796: 'CUSTOMS' ,
2797: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2798: jai_constants.tax_type_cvd_edu_cess ,
2799: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2800: jai_constants.tax_type_customs_edu_cess
2801: ) THEN
2802: v_vendor_id := NULL;
2795: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2796: 'CUSTOMS' ,
2797: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2798: jai_constants.tax_type_cvd_edu_cess ,
2799: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2800: jai_constants.tax_type_customs_edu_cess
2801: ) THEN
2802: v_vendor_id := NULL;
2803: ELSIF UPPER( rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN
2796: 'CUSTOMS' ,
2797: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2798: jai_constants.tax_type_cvd_edu_cess ,
2799: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2800: jai_constants.tax_type_customs_edu_cess
2801: ) THEN
2802: v_vendor_id := NULL;
2803: ELSIF UPPER( rec.tax_type ) LIKE UPPER( '%EXCISE%' ) THEN
2804: v_vendor_id := p_vendor_id;
2936: END IF;
2937: IF rec.tax_type = 'TDS' THEN
2938: v_vendor_id := rec.vendor_id;
2939: ELSIF UPPER(rec.tax_type) IN ('CVD',
2940: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2941: 'CUSTOMS',
2942: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2943: jai_constants.tax_type_cvd_edu_cess ,
2944: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2938: v_vendor_id := rec.vendor_id;
2939: ELSIF UPPER(rec.tax_type) IN ('CVD',
2940: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2941: 'CUSTOMS',
2942: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2943: jai_constants.tax_type_cvd_edu_cess ,
2944: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2945: jai_constants.tax_type_customs_edu_cess
2946: ) THEN
2939: ELSIF UPPER(rec.tax_type) IN ('CVD',
2940: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2941: 'CUSTOMS',
2942: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2943: jai_constants.tax_type_cvd_edu_cess ,
2944: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2945: jai_constants.tax_type_customs_edu_cess
2946: ) THEN
2947: v_vendor_id := NULL;
2940: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2941: 'CUSTOMS',
2942: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2943: jai_constants.tax_type_cvd_edu_cess ,
2944: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2945: jai_constants.tax_type_customs_edu_cess
2946: ) THEN
2947: v_vendor_id := NULL;
2948: ELSIF UPPER( rec.tax_type ) LIKE '%EXCISE%' THEN
2941: 'CUSTOMS',
2942: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2943: jai_constants.tax_type_cvd_edu_cess ,
2944: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2945: jai_constants.tax_type_customs_edu_cess
2946: ) THEN
2947: v_vendor_id := NULL;
2948: ELSIF UPPER( rec.tax_type ) LIKE '%EXCISE%' THEN
2949: v_vendor_id := p_vendor_id;
2955: v_currency := p_currency;
2956: END IF;
2957: IF NVL( p_operation_flag, 0 ) < 0 AND ( UPPER( rec.tax_type ) LIKE '%EXCISE%' OR UPPER(rec.tax_type)
2958: NOT IN ( 'CVD',
2959: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2960: 'CUSTOMS',
2961: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2962: jai_constants.tax_type_cvd_edu_cess ,
2963: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2957: IF NVL( p_operation_flag, 0 ) < 0 AND ( UPPER( rec.tax_type ) LIKE '%EXCISE%' OR UPPER(rec.tax_type)
2958: NOT IN ( 'CVD',
2959: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2960: 'CUSTOMS',
2961: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2962: jai_constants.tax_type_cvd_edu_cess ,
2963: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2964: jai_constants.tax_type_customs_edu_cess
2965: ) )
2958: NOT IN ( 'CVD',
2959: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2960: 'CUSTOMS',
2961: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2962: jai_constants.tax_type_cvd_edu_cess ,
2963: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2964: jai_constants.tax_type_customs_edu_cess
2965: ) )
2966: THEN /* Indiactes an Internal Requisition */
2959: jai_constants.tax_type_add_cvd, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2960: 'CUSTOMS',
2961: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2962: jai_constants.tax_type_cvd_edu_cess ,
2963: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2964: jai_constants.tax_type_customs_edu_cess
2965: ) )
2966: THEN /* Indiactes an Internal Requisition */
2967: v_vendor_id := p_operation_flag;
2960: 'CUSTOMS',
2961: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,/*bduvarag for the bug#5989740*/
2962: jai_constants.tax_type_cvd_edu_cess ,
2963: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,/*bduvarag for the bug#5989740*/
2964: jai_constants.tax_type_customs_edu_cess
2965: ) )
2966: THEN /* Indiactes an Internal Requisition */
2967: v_vendor_id := p_operation_flag;
2968: END IF;
2997:
2998: /* bgowrava for forward porting bug#5631784 */
2999: /* Added OR condition as we are passing p_action as null in case of 'CASH' Receipt. by JMEENA */
3000: elsif (p_source_trx_type in (
3001: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
3002: , jai_constants.G_AP_STANDALONE_INVOICE
3003: -- Added by Jason Liu on 2007/08/23
3004: )
3005: and p_action = jai_constants.default_taxes )
2998: /* bgowrava for forward porting bug#5631784 */
2999: /* Added OR condition as we are passing p_action as null in case of 'CASH' Receipt. by JMEENA */
3000: elsif (p_source_trx_type in (
3001: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
3002: , jai_constants.G_AP_STANDALONE_INVOICE
3003: -- Added by Jason Liu on 2007/08/23
3004: )
3005: and p_action = jai_constants.default_taxes )
3006: OR (p_source_trx_type = jai_constants.ar_cash)
3001: jai_constants.pa_draft_invoice /* 6012570 (5876390) */
3002: , jai_constants.G_AP_STANDALONE_INVOICE
3003: -- Added by Jason Liu on 2007/08/23
3004: )
3005: and p_action = jai_constants.default_taxes )
3006: OR (p_source_trx_type = jai_constants.ar_cash)
3007: then
3008: -- Added by Jason Liu for standalone invoice on 2007/08/23
3009: ----------------------------------------------------------------------
3002: , jai_constants.G_AP_STANDALONE_INVOICE
3003: -- Added by Jason Liu on 2007/08/23
3004: )
3005: and p_action = jai_constants.default_taxes )
3006: OR (p_source_trx_type = jai_constants.ar_cash)
3007: then
3008: -- Added by Jason Liu for standalone invoice on 2007/08/23
3009: ----------------------------------------------------------------------
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3006: OR (p_source_trx_type = jai_constants.ar_cash)
3007: then
3008: -- Added by Jason Liu for standalone invoice on 2007/08/23
3009: ----------------------------------------------------------------------
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3011: AND rec.tax_type IN ( jai_constants.tax_type_value_added
3012: , jai_constants.tax_type_sales
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3007: then
3008: -- Added by Jason Liu for standalone invoice on 2007/08/23
3009: ----------------------------------------------------------------------
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3011: AND rec.tax_type IN ( jai_constants.tax_type_value_added
3012: , jai_constants.tax_type_sales
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3015: THEN
3008: -- Added by Jason Liu for standalone invoice on 2007/08/23
3009: ----------------------------------------------------------------------
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3011: AND rec.tax_type IN ( jai_constants.tax_type_value_added
3012: , jai_constants.tax_type_sales
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3015: THEN
3016: v_modvat_flag := 'N';
3009: ----------------------------------------------------------------------
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3011: AND rec.tax_type IN ( jai_constants.tax_type_value_added
3012: , jai_constants.tax_type_sales
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3015: THEN
3016: v_modvat_flag := 'N';
3017: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE
3010: IF p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE
3011: AND rec.tax_type IN ( jai_constants.tax_type_value_added
3012: , jai_constants.tax_type_sales
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3015: THEN
3016: v_modvat_flag := 'N';
3017: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE
3018: ----------------------------------------------------------------------
3013: , jai_constants.tax_type_cst
3014: , jai_constants.tax_type_other)
3015: THEN
3016: v_modvat_flag := 'N';
3017: END IF; --p_source_trx_type = jai_constants.AP_STANDALONE_INVOICE
3018: ----------------------------------------------------------------------
3019:
3020: /*
3021: || When currency conversion rate is null it means the transaction is in the INR only
3042: || ',source_doc_type -> '||p_source_trx_type ||CHR(10)
3043: || ',source_doc_id -> '||p_header_id ||CHR(10)
3044: || ',source_doc_line_id -> '||p_line_id ||CHR(10)
3045: || ',source_table_name -> '||p_source_table_name ||CHR(10)
3046: || ',tax_modified_by -> '||jai_constants.tax_modified_by_system ||CHR(10)
3047: || ',precedence_1 -> '||rec.p_1 ||CHR(10)
3048: || ',precedence_2 -> '||rec.p_2 ||CHR(10)
3049: || ',precedence_3 -> '||rec.p_3 ||CHR(10)
3050: || ',precedence_4 -> '||rec.p_4 ||CHR(10)
3061: || ',last_update_login -> '||p_last_update_login ||CHR(10)
3062: ); */ --commented by bgowrava for bug#5631784
3063: -- Added by Eric Ma for standalone invoice on 2007/09/27
3064: ----------------------------------------------------------------------
3065: IF (p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
3066: THEN
3067: INSERT INTO jai_cmn_document_taxes
3068: ( doc_tax_id
3069: , tax_line_no
3121: , p_header_id -- source_doc_id
3122: , p_line_id -- source_doc_line_id
3123: , p_line_id -- source_doc_parent_line_no,added by Eric Ma
3124: , p_source_table_name -- source_table_name
3125: , jai_constants.tax_modified_by_system
3126: --tax_modified_by(SYSTEM=system defaulted, MANUAL=User Modified)
3127: , rec.p_1 -- precedence_1
3128: , rec.p_2 -- precedence_2
3129: , rec.p_3 -- precedence_3
3139: , p_last_update_date -- last_update_date
3140: , p_last_updated_by -- last_updated_by
3141: , p_last_update_login -- last_update_login
3142: );
3143: ELSE --(p_source_trx_type <>jai_constants.G_AP_STANDALONE_INVOICE );
3144: ------------------------------------------------------------------
3145: insert into jai_cmn_document_taxes
3146: ( doc_tax_id
3147: , tax_line_no
3198: , p_source_trx_type -- source_doc_type
3199: , p_header_id -- source_doc_id
3200: , p_line_id -- source_doc_line_id
3201: , p_source_table_name -- source_table_name
3202: , jai_constants.tax_modified_by_system -- tax_modified_by (SYSTEM=system defaulted, MANUAL=User Modified)
3203: , rec.p_1 -- precedence_1
3204: , rec.p_2 -- precedence_2
3205: , rec.p_3 -- precedence_3
3206: , rec.p_4 -- precedence_4
3215: , p_last_update_date -- last_update_date
3216: , p_last_updated_by -- last_updated_by
3217: , p_last_update_login -- last_update_login
3218: );
3219: END IF; --(p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
3220: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Record inserted into jai_cmn_document_taxes');*/ --commented by bgowrava for bug#5631784
3221:
3222: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
3223: in This , Recalculation will be happen in Draft invoice */
3221:
3222: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
3223: in This , Recalculation will be happen in Draft invoice */
3224: elsif
3225: p_source_trx_type = jai_constants.pa_draft_invoice
3226: and p_action = jai_constants.recalculate_taxes
3227: then
3228:
3229: update jai_cmn_document_taxes
3222: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
3223: in This , Recalculation will be happen in Draft invoice */
3224: elsif
3225: p_source_trx_type = jai_constants.pa_draft_invoice
3226: and p_action = jai_constants.recalculate_taxes
3227: then
3228:
3229: update jai_cmn_document_taxes
3230: set tax_amt = tax_amt_tab(row_count)
3233: ,last_updated_by = p_last_updated_by
3234: ,last_update_login = p_last_update_login
3235: where source_doc_line_id = p_line_id
3236: and tax_id = rec.tax_id
3237: and source_doc_type = jai_constants.pa_draft_invoice;
3238:
3239: elsif p_source_trx_type = jai_constants.source_ttype_delivery
3240: then
3241:
3235: where source_doc_line_id = p_line_id
3236: and tax_id = rec.tax_id
3237: and source_doc_type = jai_constants.pa_draft_invoice;
3238:
3239: elsif p_source_trx_type = jai_constants.source_ttype_delivery
3240: then
3241:
3242: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
3243: ,'Value of variables used for updating ja_in_so_picking_tax_lines'||chr(10)
3246: ||'base_tax_amount = '||round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor) ||chr(10)
3247: ||'tax_id = '||rec.tax_id
3248: ); */ --commented by bgowrava for bug#5631784
3249:
3250: if p_action = jai_constants.recalculate_taxes then
3251:
3252: update JAI_OM_WSH_LINE_TAXES
3253: set tax_amount = tax_amt_tab(row_count)
3254: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
3260: and tax_id = rec.tax_id;
3261:
3262: end if;
3263:
3264: elsif p_source_trx_type = jai_constants.bill_only_invoice then
3265:
3266: /*
3267: || When currency conversion rate is null it means the transaction is in the INR only
3268: */
3277: ||'base_tax_amount = '||round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor) ||chr(10)
3278: ||'tax_id = '||rec.tax_id
3279: ); */ --commented by bgowrava for bug#5631784
3280:
3281: if p_action = jai_constants.recalculate_taxes then
3282:
3283: update JAI_AR_TRX_TAX_LINES
3284: set tax_amount = tax_amt_tab(row_count)
3285: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
3426: , b.tax_rate
3427: , b.tax_amount
3428: , b.uom_code
3429: , b.end_date valid_date
3430: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
3431: DECODE(UPPER(b.tax_type),
3432: 'EXCISE', 1,
3433: 'ADDL. EXCISE', 1,
3434: 'OTHER EXCISE', 1,
3433: 'ADDL. EXCISE', 1,
3434: 'OTHER EXCISE', 1,
3435: 'TDS', 2,
3436: 'EXCISE_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
3437: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 6 , /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
3438: 'CVD_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
3439: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 6 , /*bduvarag for the bug#5989740*/--modified by walton for inclusive tax
3440: 0
3441: )
3435: 'TDS', 2,
3436: 'EXCISE_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
3437: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 6 , /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
3438: 'CVD_EDUCATION_CESS' ,6, --modified by walton for inclusive tax
3439: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 6 , /*bduvarag for the bug#5989740*/--modified by walton for inclusive tax
3440: 0
3441: )
3442: ) tax_type_val
3443: , b.mod_cr_percentage
3499: , b.tax_rate
3500: , b.tax_amount
3501: , b.uom_code
3502: , b.end_date valid_date
3503: , DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, /* added by ssumaith - bug# 4245053*/
3504: DECODE(UPPER(b.tax_type),
3505: 'EXCISE', 1,
3506: 'ADDL. EXCISE', 1,
3507: 'OTHER EXCISE', 1,
3506: 'ADDL. EXCISE', 1,
3507: 'OTHER EXCISE', 1,
3508: 'TDS', 2,
3509: 'EXCISE_EDUCATION_CESS' ,1,
3510: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 1 , /*bduvarag for the bug#5989740*/
3511: 'CVD_EDUCATION_CESS' ,1,
3512: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 1 , /*bduvarag for the bug#5989740*/
3513: 0
3514: )
3508: 'TDS', 2,
3509: 'EXCISE_EDUCATION_CESS' ,1,
3510: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS , 1 , /*bduvarag for the bug#5989740*/
3511: 'CVD_EDUCATION_CESS' ,1,
3512: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS, 1 , /*bduvarag for the bug#5989740*/
3513: 0
3514: )
3515: ) tax_type_val
3516: , b.mod_cr_percentage