[Home] [Help]
210:
211:
212: -- added by sriram -- bug # 2769440
213:
214: v_ref_10 gl_interface.reference10%type; -- := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
215: v_ref_23 gl_interface.reference23%type; -- := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
216: v_ref_24 gl_interface.reference24%type; -- := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
217: v_ref_25 gl_interface.reference25%type; -- := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'
218: v_ref_26 gl_interface.reference26%type; -- := v_customer_trx_id; -- holds the column value -- eg -- 13645
467:
468: 22. 10-Feb-2011 Xiao Lv for Open Interface ER bug#11683927 on 10-Feb-2011.
469: Issue: For the Open Interface ER, imported Excise taxes by OFI tax importing to AR,
470: didn't update the RG register, nor genreate accounting.
471: Fixed: For 'Standard' source, Excise Taxes should also update the RG register and
472: generate accounting, while for 'External' source, should not.
473: Add check condition to make sure the programs will work for AR transaction
474: from 'Standard' source.
475:
470: didn't update the RG register, nor genreate accounting.
471: Fixed: For 'Standard' source, Excise Taxes should also update the RG register and
472: generate accounting, while for 'External' source, should not.
473: Add check condition to make sure the programs will work for AR transaction
474: from 'Standard' source.
475:
476: 23. 08-Apr-2011 Xiao for bug#11936390
477: Fixed: Add nvl(ln_external_flag, 0) condition.
478:
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'
528: v_ref_26 := v_customer_trx_id; -- holds the column value -- eg -- 13645
543: FETCH get_open_source_cur INTO ln_open_source;
544: CLOSE get_open_source_cur;
545:
546: IF ln_open_source > 0 THEN
547: --For 'Standard' source, manually set v_trx_date to avoid directly return.
548: --RG register will not be udpated, but will be generated.
549: IF (ln_external_flag = 0)THEN
550: OPEN get_trx_date_cur;
551: FETCH get_trx_date_cur INTO v_trx_date;
566: CLOSE org_loc_cur;
567:
568: --Add by Xiao for Open Interface ER bug#11683927 on 16-Feb-2011, begin
569: ----------------------------------------------------------------------------
570: --For 'Standard' source, manually set v_org_id/v_loc_id to avoid directly return.
571: IF ln_open_source > 0 THEN
572: v_org_id := pr_new.organization_id;
573: v_loc_id := pr_new.location_id;
574: END IF;