APPS.JAI_CMN_RG_PERIOD_BALS_PKG dependencies on JAI_CMN_RG_PERIOD_BALS_PKG

Line 1: PACKAGE BODY jai_cmn_rg_period_bals_pkg AS

1: PACKAGE BODY jai_cmn_rg_period_bals_pkg AS
2: /* $Header: jai_cmn_rg_pbal.plb 120.4 2007/05/04 04:51:42 bduvarag ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 29: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_period_bals_pkg.consolidate_balances';

25: )
26: is
27:
28: /* Added by Ramananda for bug#4407165 */
29: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_period_bals_pkg.consolidate_balances';
30:
31: ld_consolidate_from date;
32: ld_consolidate_till date;
33:

Line 154: Change History for Filename - jai_cmn_rg_period_bals_pkg.sql

150: lc_end_date := to_date(' 31/03/2003', 'dd/mm/yyyy'); -- File.Sql.35 by Brathod
151: p_consolidate_till := fnd_date.canonical_to_date(pv_consolidate_till); -- File.Sql.35 by Brathod
152:
153: /*--------------------------------------------------------------------------------------------------------------------------------
154: Change History for Filename - jai_cmn_rg_period_bals_pkg.sql
155: S.No dd/mm/yyyy Author and Details
156: ----------------------------------------------------------------------------------------------------------------------------------
157: 1 14/08/2004 Vijay Shankar for Bug# 3810344 Version : 115.1
158: Created the Package to populate data into JAI_CMN_RG_PERIOD_BALS

Line 506: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_period_bals_pkg.adjust_rounding';

502: )
503: is
504:
505: /* Added by Ramananda for bug#4407165 */
506: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_period_bals_pkg.adjust_rounding';
507:
508: cursor c_get_parent_balance_id (cp_register_id number) is
509: select period_balance_id
510: from JAI_CMN_RG_23AC_II_TRXS

Line 714: end jai_cmn_rg_period_bals_pkg;

710: return ln_cess_op_bal;
711:
712: end get_cess_opening_balance;
713:
714: end jai_cmn_rg_period_bals_pkg;