[Home] [Help]
1: PACKAGE BODY jai_cmn_rgm_tax_dist_pkg AS
2: /* $Header: jai_cmn_rgm_dist.plb 120.41.12020000.3 2012/12/25 08:47:31 qioliu ship $ */
3: /***************************************************************************************************
4: CREATED BY : ssumaith
5: CREATED DATE : 11-JAN-2005
148: issue:
149: TCS tax is geeting doubled during the settlement
150: Reason:
151: Issue is that jai_rgm_balance_tmp is popualted with double amount.
152: Issue is with the jai_cmn_rgm_tax_dist_pkg.CALCULATE_RGM_BALANCES procedure
153:
154: JAI_RGM_ORG_REGNS_V is retreiving 2 rows for TCS type of taxes.
155: This will occuer only if the organization is associated with more than one location.
156:
305: ,p_reverse_charge_flag VARCHAR2 DEFAULT NULL --Added by Qiong for reverse charge settlement
306: )
307: is
308: /* Added by Ramananda for bug#4407165 */
309: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.insert_records_into_temp';
310:
311: BEGIN
312: INSERT INTO JAI_RGM_BALANCE_T
313: (
614: p_request_id number,
615: p_service_type_code VARCHAR2 DEFAULT NULL/*Bug 5879769 bduvarag*/
616: ) is
617: /* Added by Ramananda for bug#4407165 */
618: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_io';
619: /*
620: ||CSahoo. Bug 5073553. removed the where clause that the nvl(rg23A_balance,0) + nvl(rg23c_balance,0) <> 0
621: ||instead now the criteria should be that in the form JAIRGMDT.fmb , user should not be able to select a IO with this sum = 0.
622: */
819: ,p_reverse_charge_flag VARCHAR2 default NULL--Added by Qiong for reverse charege settlement
820: )
821: is
822: /* Added by Ramananda for bug#4407165 */
823: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.punch_settlement_id';
824:
825: CURSOR cur_regime_code IS /* 4245365*/
826: SELECT regime_code
827: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784
893: p_service_type_code varchar2 default null -- bduvarag for Bug 5694855
894: ,p_reverse_charge_flag VARCHAR2 DEFAULT NULL --Added by Qiong for reverse charge settlement
895: ) is
896: /* Added by Ramananda for bug#4407165 */
897: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_ou';
898: lv_source_trx_type jai_rgm_trx_records.source_trx_type%TYPE ;--rchandan for bug#4428980
899: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;
900:
901: CURSOR c_regime_code IS
3279:
3280: END ;
3281: -- ended, Harshita for Bug 5096787
3282: ----------------------------------------------------------------------------------------------------------------
3283: END JAI_CMN_RGM_TAX_DIST_PKG;