186: ***************************************************************************************************/
187: AS
188:
189: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
190: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
191: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
192: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
193: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
194:
187: AS
188:
189: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
190: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
191: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
192: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
193: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
194:
195: lv_process_flag VARCHAR2(2) ;
188:
189: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
190: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
191: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
192: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
193: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
194:
195: lv_process_flag VARCHAR2(2) ;
196: lv_process_message VARCHAR2(1996) ;
189: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
190: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
191: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
192: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
193: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
194:
195: lv_process_flag VARCHAR2(2) ;
196: lv_process_message VARCHAR2(1996) ;
197: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
197: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
198: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
199:
200: --Date 14/06/2007 by sacsethi for bug 6072461 (for VAT Reversal)
201: ln_recov_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
202: ln_expense_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
203: lc_account_name VARCHAR2(50);
204: -- End 6072461
205: /*added the below cursors for performance issue,for bug#6030615*/
198: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
199:
200: --Date 14/06/2007 by sacsethi for bug 6072461 (for VAT Reversal)
201: ln_recov_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
202: ln_expense_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
203: lc_account_name VARCHAR2(50);
204: -- End 6072461
205: /*added the below cursors for performance issue,for bug#6030615*/
206: --start