[Home] [Help]
367: p_vat_assessable_value NUMBER DEFAULT 0
368: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
369: , 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
370: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type default null
371: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%type default null
372: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
373: , p_action varchar2 default null
374: /** End bug 5631784 */
375: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
368: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
369: , 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
370: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type default null
371: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%type default null
372: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
373: , p_action varchar2 default null
374: /** End bug 5631784 */
375: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
376: , p_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type default NULL /*Added for Bug 8241905*/
671:
672: Issue:
673: 1. As a part of TCS enh. there was a requirement to default taxes using the tax category attached to
674: threshold setup for TCS regime in the India-Threshold setup UI.
675: 2. Package should provide an API for inserting taxes in to new table jai_cmn_document_taxes
676:
677: Fix:
678: To support above functionalities the following approach is used.
679: 1. New parameters are added to this procedure to get the tax category defined for threshold limit.
747: 19. 11-Mar-2011 Bo Li for BOE Enhancement bug#11684111
748:
749: 20. 16-Jan-2012 Qinglei for Bug#13547239
750: Issue: FUNCTIONAL TAX AMOUNT IN INDIA LOCALIZATION TAXES UI IS INACCURATE
751: Fix: Rounded the functional tax amount before insert into jai_cmn_document_taxes.
752:
753: 21. 07-Jun-2012 mmurtuza for bug 14591926
754: Issue: TAX CALCUALTION IS GOING WRONG WITH INCLUSIVE TAXES
755: Fix: While calculating the tax amount for exclusive taxes, added condition to check if the corresponding tax line no of precedence of
1091:
1092: lv_recalculation_sql :=
1093: replace ( lv_recalculation_sql
1094: , '$$TAX_SOURCE_TABLE$$'
1095: , 'JAI_CMN_DOCUMENT_TAXES'
1096: );
1097: /** replace join condition */
1098: lv_recalculation_sql :=
1099: replace ( lv_recalculation_sql
1115:
1116: lv_recalculation_sql :=
1117: REPLACE( lv_recalculation_sql
1118: , '$$TAX_SOURCE_TABLE$$'
1119: , 'JAI_CMN_DOCUMENT_TAXES'
1120: );
1121: -- replace join condition
1122: lv_recalculation_sql :=
1123: REPLACE( lv_recalculation_sql
2830:
2831: lv_recalculation_sql :=
2832: replace ( lv_recalculation_sql
2833: , '$$TAX_SOURCE_TABLE$$'
2834: , 'JAI_CMN_DOCUMENT_TAXES'
2835: );
2836: /** replace join condition */
2837: lv_recalculation_sql :=
2838: replace ( lv_recalculation_sql
2854:
2855: lv_recalculation_sql :=
2856: REPLACE( lv_recalculation_sql
2857: , '$$TAX_SOURCE_TABLE$$'
2858: , 'JAI_CMN_DOCUMENT_TAXES'
2859: );
2860: -- replace join condition
2861: lv_recalculation_sql :=
2862: REPLACE( lv_recalculation_sql
3542: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
3543: 'CVD_EDUCATION_CESS', JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,
3544: 'Customs', 'CVD', 'ADDITIONAL_CVD' ,'TDS' , 'Modvat Recovery') THEN
3545:
3546: INSERT INTO jai_cmn_document_taxes(
3547: DOC_TAX_ID,
3548: tax_line_no,
3549: tax_id ,
3550: tax_type,
3577: last_update_date ,
3578: last_updated_by ,
3579: last_update_login )
3580: VALUES (
3581: jai_cmn_document_taxes_s.nextval ,
3582: v_line_num,
3583: rec.tax_id,
3584: rec.tax_type,
3585: p_currency,
4225: end if;
4226:
4227: /* jai_cmn_debug_contexts_pkg.print
4228: (ln_reg_id
4229: ,'Values before insert into jai_cmn_document_taxes' ||chr(10)
4230: || ',tax_line_no -> '||row_count ||CHR(10)
4231: || ',tax_id -> '||rec.tax_id ||CHR(10)
4232: || ',tax_type -> '||rec.tax_type ||CHR(10)
4233: || ',currency_code -> '||p_currency ||CHR(10)
4263: -- Added by Eric Ma for standalone invoice on 2007/09/27
4264: ----------------------------------------------------------------------
4265: IF (p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
4266: THEN
4267: INSERT INTO jai_cmn_document_taxes
4268: ( doc_tax_id
4269: , tax_line_no
4270: , tax_id
4271: , tax_type
4300: , last_updated_by
4301: , last_update_login
4302: )
4303: VALUES
4304: ( jai_cmn_document_taxes_s.nextval -- doc_tax_id
4305: , row_count -- tax_line_no
4306: , rec.tax_id -- tax_id
4307: , rec.tax_type -- tax_type
4308: , p_currency -- currency
4341: , p_last_update_login -- last_update_login
4342: );
4343: ELSE --(p_source_trx_type <>jai_constants.G_AP_STANDALONE_INVOICE );
4344: ------------------------------------------------------------------
4345: insert into jai_cmn_document_taxes
4346: ( doc_tax_id
4347: , tax_line_no
4348: , tax_id
4349: , tax_type
4378: , last_update_login
4379: )
4380: values
4381: (
4382: jai_cmn_document_taxes_s.nextval -- doc_tax_id
4383: , row_count -- tax_line_no
4384: , rec.tax_id -- tax_id
4385: , rec.tax_type -- tax_type
4386: , p_currency -- currency
4420: , p_last_updated_by -- last_updated_by
4421: , p_last_update_login -- last_update_login
4422: );
4423: END IF; --(p_source_trx_type = jai_constants.G_AP_STANDALONE_INVOICE )
4424: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Record inserted into jai_cmn_document_taxes');*/ --commented by bgowrava for bug#5631784
4425:
4426: /* Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
4427: in This , Recalculation will be happen in Draft invoice */
4428: elsif
4429: p_source_trx_type = jai_constants.pa_draft_invoice
4430: and p_action = jai_constants.recalculate_taxes
4431: then
4432:
4433: update jai_cmn_document_taxes
4434: set tax_amt = tax_amt_tab(row_count)
4435: ,func_tax_amt = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
4436: ,last_update_date = p_last_update_date
4437: ,last_updated_by = p_last_updated_by