[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_tmps debit_amt and jai_rgm_balance_tmps pla_balance as 0
49: else (+ve value for PLA balance) let the value of o be populated into jai_rgm_balance_tmps 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_tmps debit_amt and jai_rgm_balance_tmps pla_balance as 0
49: else (+ve value for PLA balance) let the value of o be populated into jai_rgm_balance_tmps 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
152: /* Added by Ramananda for bug#4407165 */
153: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.insert_records_into_temp';
154:
155: BEGIN
156: INSERT INTO JAI_RGM_BALANCE_T
157: (
158: REQUEST_ID ,
159: REGIME_ID ,
160: PARTY_TYPE ,
296: ln_sh_pla_cess_balance := 0; --added by csahoo for bug#6109941
297:
298: IF nvl(bal_rec.pla_balance,0) < 0 THEN
299: /*
300: ||-ve pla balance, then the amount should appear as the debit amt in the jai_rgm_balance_tmps table
301: */
302: ln_debit_amt := bal_rec.pla_balance;
303: ELSE
304: /*
335: CLOSE c_pla_cess_balance;
336:
337: /*
338: ||Start of bug 5073553.added by CSahoo
339: ||If the cess balance is less than 0 then the same should appear in the debit_amt column of the jai_rgm_balance_tmps table
340: || else it should appear in the pla_balance column
341: */
342: IF nvl(ln_pla_cess_balance,0) < 0 THEN
343: ln_debit_amt := ln_pla_cess_balance;
2026:
2027: PROCEDURE delete_records(p_request_id number) IS
2028:
2029: BEGIN
2030: DELETE FROM JAI_RGM_BALANCE_T
2031: WHERE request_id = p_request_id;
2032: COMMIT;
2033:
2034: END delete_records;
2233: END create_io_register_entry;
2234: --END ;
2235:
2236:
2237: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
2238: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
2239: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
2240: )
2241: RETURN VARCHAR2
2234: --END ;
2235:
2236:
2237: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
2238: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
2239: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
2240: )
2241: RETURN VARCHAR2
2242: IS
2235:
2236:
2237: FUNCTION f_get_io_register ( p_party_id JAI_RGM_BALANCE_T.PARTY_ID%TYPE ,
2238: p_from_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE ,
2239: p_to_party_type JAI_RGM_BALANCE_T.PARTY_TYPE%TYPE
2240: )
2241: RETURN VARCHAR2
2242: IS
2243: /*