[Home] [Help]
1: PACKAGE BODY jai_cmn_rgm_settlement_pkg AS
2: /* $Header: jai_cmn_rgm_stl.plb 120.28.12020000.3 2012/12/25 09:00:39 qioliu 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.
2250: WHERE party_id = pn_org_id
2251: AND tax_type = pv_tax_type);
2252:
2253: /* Added by Ramananda for bug#4407165 */
2254: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.get_last_balance_amount';
2255:
2256: BEGIN
2257: OPEN c_last_settlement_balance;
2258: FETCH c_last_settlement_balance INTO pn_debit_amount, pn_credit_amount;
2299: AND nvl(service_type_code,'-999') = nvl(pv_service_type_code,nvl(service_type_code,'-999') ) /* added nvl for bug#13865856*/
2300: AND tax_type = pv_tax_type);
2301:
2302: /* Added by Ramananda for bug#4407165 */
2303: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.get_last_balance_amount';
2304:
2305: BEGIN
2306: OPEN c_last_settlement_balance;
2307: FETCH c_last_settlement_balance INTO pn_debit_amount, pn_credit_amount;
2327: pv_process_message OUT NOCOPY VARCHAR2)
2328: IS
2329:
2330: /* Added by Ramananda for bug#4407165 */
2331: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_settlement_pkg.register_entry';
2332:
2333: CURSOR cur_distributions IS
2334: SELECT tax_type ,
2335: SUM(debit_balance) debit ,
2756:
2757: end get_last_settlement_date;
2758:
2759:
2760: END jai_cmn_rgm_settlement_pkg;