26: issue.
27: 5. 12/07/2003 Aiyer - Bug #3749294 File Version 115.1
28: Issue:-
29: Uom based taxes do not get calculated correctly if the transaction UOM is different from the
30: UOM setup in the tax definitions India Localization (JAI_CMN_TAXES_ALL table).
31:
32: Fix:-
33: ----
34: Modified the procedure ja_in_calc_prec_taxes.For more details please refer the change history
107: */
108: type ref_cur_typ is ref cursor;
109: type tax_rec_typ is record
110: (
111: tax_id JAI_CMN_TAXES_ALL.tax_id%type
112: , lno JAI_CMN_TAX_CTG_LINES.line_no%type
113: , p_1 JAI_CMN_TAX_CTG_LINES.precedence_1%type
114: , p_2 JAI_CMN_TAX_CTG_LINES.precedence_2%type
115: , p_3 JAI_CMN_TAX_CTG_LINES.precedence_3%type
119: , p_7 JAI_CMN_TAX_CTG_LINES.precedence_7%type
120: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%type
121: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%type
122: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%type
123: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%type
124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
120: , p_8 JAI_CMN_TAX_CTG_LINES.precedence_8%type
121: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%type
122: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%type
123: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%type
124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
121: , p_9 JAI_CMN_TAX_CTG_LINES.precedence_9%type
122: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%type
123: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%type
124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
122: , p_10 JAI_CMN_TAX_CTG_LINES.precedence_10%type
123: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%type
124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
125: , uom_code JAI_CMN_TAXES_ALL.uom_code%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
133: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
126: , valid_date JAI_CMN_TAXES_ALL.end_date%type
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
133: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
134: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%type --added by walton for inclusive tax
127: , tax_type_val number
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
133: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
134: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%type --added by walton for inclusive tax
135: );
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type
129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%type
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
133: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
134: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%type --added by walton for inclusive tax
135: );
136: /*end of bug#5631784 */
130: , tax_type JAI_CMN_TAXES_ALL.tax_type%type
131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type
132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type
133: , tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
134: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%type --added by walton for inclusive tax
135: );
136: /*end of bug#5631784 */
137:
138: PROCEDURE ja_in_cust_default_taxes(
181: p_last_update_login NUMBER,
182: p_operation_flag NUMBER DEFAULT NULL,
183: p_vat_assessable_value NUMBER DEFAULT 0
184: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
185: , 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
186: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type default null
187: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%type default null
188: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
189: , p_action varchar2 default null