[Home] [Help]
1: PACKAGE BODY jai_cmn_rgm_settlement_pkg AS
2: /* $Header: jai_cmn_rgm_stl.plb 120.16.12010000.2 2008/10/17 09:48:21 jmeena ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
32: Reason:
33: ------
34: Org_id in the form is populated when authority site is selected from the
35: front end. When 'Process' Button is pressed, form makes a call to
36: jai_cmn_rgm_settlement_pkg.create_invoice passing org_id.
37:
38: Presently, org_id is not passed to ap_utilities_pkg.get_open_gl_date and
39: ap_utilities_pkg.get_current_gl_date. This is defaulted from mo_global.GET_CURRENT_ORG_ID.
40: However the value is not retrieved from the same, hence the above reported error
43: ----
44: Added pn_org_id parameter while making a call to
45: 1. ap_utilities_pkg.get_open_gl_date
46: 2. ap_utilities_pkg.get_current_gl_date
47: in jai_cmn_rgm_settlement_pkg.create_invoice is modified to pass org_id, which is solving the problem.
48: i.e "APP-JA-460204: ORA 20001: No Open Period...after
49:
50: 02-Dec-2005 Bug 4774647. Added by Lakshmi Gopalsami Version 120.4
51: Passed operating unit also as this parameter has been added by base.
1644: WHERE party_id = pn_org_id
1645: AND tax_type = pv_tax_type);
1646:
1647: /* Added by Ramananda for bug#4407165 */
1648: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.get_last_balance_amount';
1649:
1650: BEGIN
1651: OPEN c_last_settlement_balance;
1652: FETCH c_last_settlement_balance INTO pn_debit_amount, pn_credit_amount;
1691: AND nvl(service_type_code,'-999') = nvl(pv_service_type_code, '-999' ) /* added by ssawant for bug 5879769 */
1692: AND tax_type = pv_tax_type);
1693:
1694: /* Added by Ramananda for bug#4407165 */
1695: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.get_last_balance_amount';
1696:
1697: BEGIN
1698: OPEN c_last_settlement_balance;
1699: FETCH c_last_settlement_balance INTO pn_debit_amount, pn_credit_amount;
1719: pv_process_message OUT NOCOPY VARCHAR2)
1720: IS
1721:
1722: /* Added by Ramananda for bug#4407165 */
1723: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.register_entry';
1724:
1725: CURSOR cur_distributions IS
1726: SELECT tax_type ,
1727: SUM(debit_balance) debit ,
2100:
2101: end get_last_settlement_date;
2102:
2103:
2104: END jai_cmn_rgm_settlement_pkg;