[Home] [Help]
24: p_credit_amt => nvl(ln_settled_credit_balance,0) + delta_rec.credit_amt
25: 4. 25-Aug-2005 Bug4568078. Added by Lakshmi Gopalsami Version 120.3
26: (1) Added parameter p_pla_balance in procedure
27: insert_records_into_temp
28: (2) Added pla_balance while inserting into jai_rgm_balance_t
29: (3) Added nvl(pla_balance,0) in cursor c_balance_cur in
30: procedure calculate_balances_for_io. Added cursor
31: c_pla_cess_balance to fetch the pla_balance and
32: passed the same to insert_records_into_temp
44: sync with their corrsponding 11i counterparts
45:
46: 6. 19/12/2006 CSahoo for Bug 5073553, File Version 120.5
47: 1.Changed the procedure jai_rgm_distribution_pkg.calculate_balances_for_io such that in case
48: the pla balance is -ve, populate the column JAI_RGM_BALANCE_T debit_amt and JAI_RGM_BALANCE_T pla_balance as 0
49: else (+ve value for PLA balance) let the value of o be populated into JAI_RGM_BALANCE_T debit_amt and pla_balance
50: would be the register pla_amt amount for the IO.
51: 2.Added a new function f_get_io_register in both package spec and body .
52: 7. 30/01/2007 SACSETHI FOR BUG#5631784. FILE VERSION 120.7
45:
46: 6. 19/12/2006 CSahoo for Bug 5073553, File Version 120.5
47: 1.Changed the procedure jai_rgm_distribution_pkg.calculate_balances_for_io such that in case
48: the pla balance is -ve, populate the column JAI_RGM_BALANCE_T debit_amt and JAI_RGM_BALANCE_T pla_balance as 0
49: else (+ve value for PLA balance) let the value of o be populated into JAI_RGM_BALANCE_T debit_amt and pla_balance
50: would be the register pla_amt amount for the IO.
51: 2.Added a new function f_get_io_register in both package spec and body .
52: 7. 30/01/2007 SACSETHI FOR BUG#5631784. FILE VERSION 120.7
53: FORWARD PORTING BUG FROM 11I BUG 4742259
147: 20. 12-oct-2009 vkaranam for bug#9005474
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.
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: (
314: REQUEST_ID ,
315: REGIME_ID ,
316: PARTY_TYPE ,
400: AND attribute_code ='REGISTRATION_NO'
401: AND attribute_value = cp_regn_no
402: AND registration_id = cp_regn_id
403: AND (organization_id, location_id) NOT IN
404: (SELECT party_id, location_id FROM JAI_RGM_BALANCE_T where request_id=p_request_id
405: );
406:
407: /*uncommeneted the code done in bug#8671217 for bug#12706846*/
408: CURSOR cur_cr_bal(cp_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,cp_org_id number,cp_location_id number)
695: ln_sh_pla_cess_balance := 0; --added by csahoo for bug#6109941
696:
697: IF nvl(bal_rec.pla_balance,0) < 0 THEN
698: /*
699: ||-ve pla balance, then the amount should appear as the debit amt in the JAI_RGM_BALANCE_T table
700: */
701: /*Bug 8488788 - If the amount is represented on the debit side it infers that it is less than 0
702: Hence representing as positive. The net amount in Service Tax Distribution form is calculated by
703: subtracting debit from credit. If it is represented as -ve then it causes double effect*/
737: CLOSE c_pla_cess_balance;
738:
739: /*
740: ||Start of bug 5073553.added by CSahoo
741: ||If the cess balance is less than 0 then the same should appear in the debit_amt column of the JAI_RGM_BALANCE_T table
742: || else it should appear in the pla_balance column
743: */
744: IF nvl(ln_pla_cess_balance,0) < 0 THEN
745: /*Bug 8488788 - If the amount is represented on the debit side it infers that it is less than 0
2999:
3000: PROCEDURE delete_records(p_request_id number) IS
3001:
3002: BEGIN
3003: DELETE FROM JAI_RGM_BALANCE_T
3004: WHERE request_id = p_request_id;
3005: COMMIT;
3006:
3007: END delete_records;
3223: END create_io_register_entry;
3224: --END ;
3225:
3226:
3227: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
3228: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
3229: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
3230: )
3231: RETURN VARCHAR2
3224: --END ;
3225:
3226:
3227: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
3228: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
3229: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
3230: )
3231: RETURN VARCHAR2
3232: IS
3225:
3226:
3227: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
3228: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
3229: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
3230: )
3231: RETURN VARCHAR2
3232: IS
3233: /*