[Home] [Help]
107: --| Fix - Change the accounting for inclusive tax |
108: --| Modified the procedure acct_inclu_taxes |
109: --| and function get_tax_account_id to get the |
110: --| correct accounting and insert into |
111: --| GL_INTERFACE table |
112: --| |
113: --| 02-JUL-2010 Bo Li Modified for Bug#9803555 |
114: --| Issue - Issue with "AR Tax and Freight |
115: --| Defaultation (India - AR Tax and Freight |
121: --| |
122: --| 09-JUL-2010 Bo Li Modified for Bug#9765108 |
123: --| Issue - The account code is not right for the |
124: --| non-shippable item RMA flow in the |
125: --| gl_interface table when the RMA order |
126: --| lines contain the inclusive tax |
127: --| Fix - Add the logic for handling with the inclusive|
128: --| tax for the non-shippable item RMA flow |
129: --| |
4590: -- acct_inclu_taxes Public
4591: --
4592: -- DESCRIPTION:
4593: --
4594: -- This procedure is written that whould pass GL entries for inclusive taxes in GL interface
4595: --
4596: -- PARAMETERS:
4597: -- In: pn_customer_trx_id Indicates the customer trx id
4598: -- pn_org_id Indicates the transaction org id
4614: -- when inclusive VAT taxes are used.
4615: -- Fixed: Used Revenue account to replace Receivables account for Inclusive Dr Accounting
4616: --
4617: -- 01-Mar-2011 Xiao Lv Modified for Open Interface ER bug#11683927.
4618: -- 1. When 'External' event, accounting for inclusive tax to gl interface,
4619: -- ccid will be be directly fetched from jai_interface_lines.
4620: -- 2. Fetch ccid from tax definition for 'Excise' and other taxes.
4621: -- As the orginal code only handles accounting for taxes under 'Service'
4622: -- and 'VAT' regime.
4632: -- Fix: If jai_cmn_rgm_Recording_pkg.get_account does not derive the Tax Account ID then the
4633: -- same shall be fetched from Tax Definition
4634: -- 08-Apr-2011 Xiao Lv Modified for bug#11936390.
4635: -- 1. Accounting for Open Interface ER is changed.
4636: -- For external, do not generate accounting for inclusive tax in GL Interface.
4637: -- 2. Fixed rounding issue for dr/cr when accounting is generated in GL.
4638: --
4639: -- 29-Sep-2011 Zhiwei Hou Modified for bug#13023443.
4640: -- 1. Accounting for Open Interface ER is changed for POT.
4637: -- 2. Fixed rounding issue for dr/cr when accounting is generated in GL.
4638: --
4639: -- 29-Sep-2011 Zhiwei Hou Modified for bug#13023443.
4640: -- 1. Accounting for Open Interface ER is changed for POT.
4641: -- 2. For External & Service % GL < POT should insert gl_interface, and accounting from setup.
4642: -- 20-Jun-2012 mmurtuza for bug 14194526
4643: -- Description: INDIA - LOCAL CONCURRENT FOR PROCESSING ORDER LINES TO AR
4644: -- Fix: Added logic to eliminate to_char(line_id) in get_rma_flag_cur and inclu_rma_tax
4645: --
4990: xv_process_message := Sqlerrm||'. Get gl date in acct_inclu_taxes procedure.';
4991: RAISE exception_error;
4992: END;
4993:
4994: -- Insert inclusive taxes into GL Interface table
4995: ln_total_inclu_tax_amt := 0;
4996:
4997: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4998: -----------------------------------------------------------------
5060: END;
5061: --Add by Xiao for bug#11936390, rounding issue for inclusive tax accounting in gl
5062: ln_amount := round(inclu_tax_csr.tax_amount, inclu_tax_csr.rounding_factor);
5063:
5064: INSERT INTO gl_interface
5065: ( status
5066: , set_of_books_id
5067: , user_je_source_name
5068: , user_je_category_name
5107: , ln_cur_conversion_rate
5108: , lv_inv_org_code -- inventory organization code
5109: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5110: , 'India Localization Entry' -- hard code string
5111: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5112: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5113: , 'CUSTOMER_TRX_ID' -- hard code string
5114: , pn_customer_trx_id -- value of customer_trx_id
5115: , ln_inv_org_id -- organization id of the inventory organization id
5156: || For Service Tax
5157: if 1) From Open Interface
5158: 2) External
5159: 3) GL > POT
5160: not populate gl_interface
5161: else
5162: populate gl_interface.
5163:
5164: For Other Tax
5158: 2) External
5159: 3) GL > POT
5160: not populate gl_interface
5161: else
5162: populate gl_interface.
5163:
5164: For Other Tax
5165: if 1) From Open Interface
5166: 2) External
5163:
5164: For Other Tax
5165: if 1) From Open Interface
5166: 2) External
5167: not populate gl_interface
5168: else
5169: populate gl_interface
5170:
5171: ----------------------------------------
5165: if 1) From Open Interface
5166: 2) External
5167: not populate gl_interface
5168: else
5169: populate gl_interface
5170:
5171: ----------------------------------------
5172: In another side :
5173: Do Inclusive Tax accounting:
5209: ld_trx_date := get_transaction_date(pn_customer_trx_id);
5210:
5211: --Added by zhiwei for POT Change Bug#13023443 on 20110929 begin
5212: ----------------------------------------------------------------------------------
5213: --For Service Tax ,not populate gl_interface only while From Open Interface and External Event and GL >= POT
5214: if( nvl(ln_external_flag,0) = 1
5215: and
5216: ld_trx_date >= ld_st_accrual_date
5217: )then
5247: ELSE
5248:
5249: --Added by zhiwei for POT Change Bug#13023443 on 20110929 begin
5250: ----------------------------------------------------------------------------------
5251: --For other tax except Service, not populate gl_interface while From Open APi and External Event.
5252: if( nvl(ln_external_flag,0) = 1 )then
5253: ln_process_flag := 0;
5254: else
5255: ln_process_flag := 1;
5285: END IF;
5286:
5287: -----------------------------------------------------------------------------------
5288: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, end
5289: --Add by Xiao for bug#11936390, rounding issue for inclusive tax accounting in GL interface.
5290: ln_amount := round(inclu_tax_csr.tax_amount , inclu_tax_csr.rounding_factor);
5291:
5292: --Added by zhiwei for POT change Bug#13023443 on 20110929 begin
5293: ----------------------------------------------------------------------
5293: ----------------------------------------------------------------------
5294: if (nvl(ln_process_flag,0) = 1) then
5295: ----------------------------------------------------------------------
5296: --Added by zhiwei for POT change Bug#13023443 on 20110929 end
5297: INSERT INTO gl_interface
5298: ( status
5299: , set_of_books_id
5300: , user_je_source_name
5301: , user_je_category_name
5340: , ln_cur_conversion_rate
5341: , lv_inv_org_code -- inventory organization code
5342: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5343: , 'India Localization Entry' -- hard code string
5344: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5345: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5346: , 'CUSTOMER_TRX_ID' -- hard code string
5347: , pn_customer_trx_id -- value of customer_trx_id
5348: , ln_inv_org_id -- organization id of the inventory organization id
5368: END LOOP; -- inclu_tax cusor
5369:
5370: END IF; --ln_rma_line_number > 0 Added by Bo Li for Bug#9765108 on 09-JUL-2010
5371:
5372: /*9892611 - Check if Inclusive Tax Amount is non zero before inserting into gl_interface
5373: Dummy records are inserted into GL_INTERFACE with zero amounts otherwise*/
5374:
5375: IF ln_total_inclu_tax_amt <> 0 THEN
5376: -- Insert revenue amount into GL Interface table
5369:
5370: END IF; --ln_rma_line_number > 0 Added by Bo Li for Bug#9765108 on 09-JUL-2010
5371:
5372: /*9892611 - Check if Inclusive Tax Amount is non zero before inserting into gl_interface
5373: Dummy records are inserted into GL_INTERFACE with zero amounts otherwise*/
5374:
5375: IF ln_total_inclu_tax_amt <> 0 THEN
5376: -- Insert revenue amount into GL Interface table
5377:
5372: /*9892611 - Check if Inclusive Tax Amount is non zero before inserting into gl_interface
5373: Dummy records are inserted into GL_INTERFACE with zero amounts otherwise*/
5374:
5375: IF ln_total_inclu_tax_amt <> 0 THEN
5376: -- Insert revenue amount into GL Interface table
5377:
5378: INSERT INTO gl_interface
5379: ( status
5380: , set_of_books_id
5374:
5375: IF ln_total_inclu_tax_amt <> 0 THEN
5376: -- Insert revenue amount into GL Interface table
5377:
5378: INSERT INTO gl_interface
5379: ( status
5380: , set_of_books_id
5381: , user_je_source_name
5382: , user_je_category_name
5420: , ln_cur_conversion_rate
5421: , lv_inv_org_code -- inventory organization code
5422: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5423: , 'India Localization Entry' -- hard code string
5424: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5425: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5426: , 'CUSTOMER_TRX_ID' -- hard code string
5427: , pn_customer_trx_id -- value of customer_trx_id
5428: , ln_inv_org_id -- organization id of the inventory organization id
5436:
5437: END IF;
5438:
5439: xv_process_flag := 'SS';
5440: xv_process_message := 'Inclusive taxes have successed into GL Interface';
5441:
5442: --logging for debug
5443: IF (ln_proc_level >= ln_dbg_level)
5444: THEN