DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_TAXES_ALL

Line 30: UOM setup in the tax definitions India Localization (JAI_CMN_TAXES_ALL table).

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

Line 111: tax_id JAI_CMN_TAXES_ALL.tax_id%type

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

Line 123: , tax_rate JAI_CMN_TAXES_ALL.tax_rate%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

Line 124: , tax_amount JAI_CMN_TAXES_ALL.tax_amount%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
128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%type

Line 125: , uom_code JAI_CMN_TAXES_ALL.uom_code%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

Line 126: , valid_date JAI_CMN_TAXES_ALL.end_date%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

Line 128: , mod_cr_percentage JAI_CMN_TAXES_ALL.mod_cr_percentage%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

Line 129: , vendor_id JAI_CMN_TAXES_ALL.vendor_id%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

Line 130: , tax_type JAI_CMN_TAXES_ALL.tax_type%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

Line 131: , rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%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
135: );

Line 132: , adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type

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 */

Line 134: , inclusive_tax_flag JAI_CMN_TAXES_ALL.inclusive_tax_flag%type --added by walton for inclusive tax

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(

Line 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

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