[Home] [Help]
195: SELECT a.tax_rate, b.rounding_factor
196: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
197: WHERE a.tax_id = b.tax_id
198: AND a.link_to_cust_trx_line_id = p_cust_trx_line_id
199: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /*'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
200: --added by GD
201:
202: /* Bug 5243532. Added by Lakshmi Gopalsami
203: * Removed the cursor set_of_books_cur and implemented using caching logic.
242: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
243: jrcttl.tax_id = jtc.tax_id AND
244: -- commented by ssawant
245: --jrctl.customer_trx_id = :old.customer_trx_id;
246: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND /* added by ssawant for bug 5989740 */
247: jrctl.customer_trx_line_id = cp_trx_line_id; /* added by ssawant for bug 5989740 */
248:
249: -- This cursor is added by ssawant to account for the total sh cess amount for bug 5989740
250: CURSOR cur_get_trx_sh_cess_amt (cp_trx_line_id in number)
257: jai_cmn_taxes_all jtc
258: WHERE
259: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
260: jrcttl.tax_id = jtc.tax_id AND
261: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
262: jrctl.customer_trx_line_id = cp_trx_line_id;
263:
264: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
271: * Defined variable for implementing caching logic.
272: */
273: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
274: BEGIN
275: pv_return_code := jai_constants.successful ;
276: /*------------------------------------------------------------------------------------------
277: FILENAME: JA_IN_AR_HDR_COMPLETE_TRG.sql
278:
279: CHANGE HISTORY:
424: Forward porting Budget07-08 changes of handling secondary and
425: Higher Secondary Education Cess from 11.5( bug no 5907436) to R12 (bug no 5989740).
426:
427: 19. 28-Jun-2007 CSahoo for bug#6155839 , File Version 120.6
428: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
429:
430: 20. 17-Sep-2007 Anujsax for bug#5636544 ,File Version 120.7
431: Forward porting for R11 bug 5629319 into R12 bug 5636544
432: Issue : excise_invoice_number need to be updated in the ra_customer_trx_all.ct_reference table.
481: v_conv_rate := pr_new.Exchange_rate; --Ramananda for File.Sql.35
482: --2001/05/04 Vijay,Subbu.
483: v_trx_number := pr_new.Trx_Number; --Ramananda for File.Sql.35
484: v_source_name := 'Receivables India'; --Ramananda for File.Sql.35
485: v_category_name := jai_constants.je_category_rg_entry ; -- modified by csahoo for bug#6155839 --'RG Register Data Entry'; --Ramananda for File.Sql.35
486: v_ref_10 := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
487: v_ref_23 := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
488: v_ref_24 := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
489: v_ref_25 := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'
705: p_last_update_login => v_last_update_login ,
706: p_assessable_value => v_assessable_value ,
707: p_cess_amt => ln_trx_totcess_amt , /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
708: p_sh_cess_amt => ln_trx_totshcess_amt , /* added by ssawant for bug 5989740 */
709: p_source => jai_constants.source_ar
710: );
711:
712:
713: vsqlstmt := '20';
1020: */
1021: /* Added an exception block by Ramananda for bug#4570303 */
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: Pv_return_code := jai_constants.unexpected_error;
1025: Pv_return_message := 'Encountered an error in JAI_JAR_TRXS_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
1026:
1027: END ARU_T1 ;
1028: