[Home] [Help]
333: p_last_update_login NUMBER,
334: p_operation_flag NUMBER DEFAULT NULL , -- for CRM this is used to hold aso_shipments.shipment_id
335: p_vat_assessable_value NUMBER DEFAULT 0
336: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
337: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%type default null -- tax type to be considered as base when calculating threshold taxes
338: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type default null
339: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%type default null
340: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
341: , p_action varchar2 default null
474:
475: cursor c_get_max_rgm_tax_line
476: is
477: select max(line_no) max_rgm_tax_line
478: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes
479: where cat.tax_category_id = p_tax_category_id
480: and taxes.tax_id = cat.tax_id
481: and taxes.tax_type = p_thhold_cat_base_tax_typ;
482:
503: )
504: ) tax_type_val,
505: b.mod_cr_percentage, b.vendor_id, b.tax_type,nvl(b.rounding_factor,0) rounding_factor
506: , inclusive_tax_flag --added by walton for inclusive tax 08-Dev-07
507: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,
508: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
509: WHERE a.tax_category_id = p_tax_category_id
510: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
511: AND a.tax_id = b.tax_id
564:
565: 1. 12/07/2003 Aiyer - Bug #3749294 File Version 115.1
566: Issue:-
567: Uom based taxes do not get calculated correctly if the transaction UOM is different from the
568: UOM setup in the tax definitions India Localization (JAI_CMN_TAXES_ALL table).
569:
570: Reason:-
571: --------
572: This was happening because the UOM calculation was previously happening only for cases of exact match
595:
596: This needs to be used for the calculation of the taxes registered under vat regime.
597:
598: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
599: JAI_CMN_TAXES_ALL table based on the tax type column.
600:
601: Parameter - p_vat_assessable_value NUMBER DEFAULT 0 has been added
602:
603: Dependency due to this bug - Huge
821: , b.adhoc_flag
822: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
823: $$EXTRA_SELECT_COLUMN_LIST$$
824: from $$TAX_SOURCE_TABLE$$ a
825: , JAI_CMN_TAXES_ALL b
826: , jai_regime_tax_types_v rttv
827: where $$SOURCE_TABLE_FILTER$$
828: and rttv.tax_type (+) = b.tax_type
829: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
1737: , nvl(b.rounding_factor,0) rounding_factor
1738: , b.adhoc_flag
1739: $$EXTRA_SELECT_COLUMN_LIST$$
1740: from $$TAX_SOURCE_TABLE$$ a
1741: , JAI_CMN_TAXES_ALL b
1742: , jai_regime_tax_types_v rttv
1743: where $$SOURCE_TABLE_FILTER$$
1744: and rttv.tax_type (+) = b.tax_type
1745: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
2713: operation VARCHAR2(2);
2714:
2715: CURSOR fetch_mod_cr_cur( taxid IN NUMBER ) IS
2716: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
2717: FROM JAI_CMN_TAXES_ALL
2718: WHERE Tax_Id = taxid;
2719:
2720: CURSOR fetch_vendor2_cur IS
2721: SELECT vendor_id
3447: , b.adhoc_flag
3448: , a.tax_category_id
3449: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
3450: from JAI_CMN_TAX_CTG_LINES a
3451: , JAI_CMN_TAXES_ALL b
3452: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3453: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3454: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
3455: and a.tax_id = b.tax_id
3520: , b.adhoc_flag
3521: , a.tax_category_id
3522: , b.inclusive_tax_flag --Add by Kevin Cheng
3523: from JAI_CMN_TAX_CTG_LINES a
3524: , JAI_CMN_TAXES_ALL b
3525: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3526: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3527: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
3528: and a.tax_id = b.tax_id