[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: --Added by Xiao for Open Interface ER bug#11683927 on 16-Feb-2011, begin
265: --------------------------------------------------------------------------------------
297: * Defined variable for implementing caching logic.
298: */
299: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
300: BEGIN
301: pv_return_code := jai_constants.successful ;
302: /*------------------------------------------------------------------------------------------
303: FILENAME: JA_IN_AR_HDR_COMPLETE_TRG.sql
304:
305: CHANGE HISTORY:
450: Forward porting Budget07-08 changes of handling secondary and
451: Higher Secondary Education Cess from 11.5( bug no 5907436) to R12 (bug no 5989740).
452:
453: 19. 28-Jun-2007 CSahoo for bug#6155839 , File Version 120.6
454: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
455:
456:
457:
458: 20. 17-Sep-2007 Anujsax for bug#5636544 ,File Version 120.7
519: v_conv_rate := pr_new.Exchange_rate; --Ramananda for File.Sql.35
520: --2001/05/04 Vijay,Subbu.
521: v_trx_number := pr_new.Trx_Number; --Ramananda for File.Sql.35
522: v_source_name := 'Receivables India'; --Ramananda for File.Sql.35
523: v_category_name := jai_constants.je_category_rg_entry ; -- modified by csahoo for bug#6155839 --'RG Register Data Entry'; --Ramananda for File.Sql.35
524: v_ref_10 := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
525: v_ref_23 := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
526: v_ref_24 := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
527: v_ref_25 := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'
784: p_last_update_login => v_last_update_login ,
785: p_assessable_value => v_assessable_value ,
786: p_cess_amt => ln_trx_totcess_amt , /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
787: p_sh_cess_amt => ln_trx_totshcess_amt , /* added by ssawant for bug 5989740 */
788: p_source => jai_constants.source_ar
789: );
790:
791:
792: vsqlstmt := '20';
1125: */
1126: /* Added an exception block by Ramananda for bug#4570303 */
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: Pv_return_code := jai_constants.unexpected_error;
1130: Pv_return_message := 'Encountered an error in JAI_JAR_TRXS_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
1131:
1132: END ARU_T1 ;
1133: