eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RG_PERIOD_BALS_PKG dependencies on JAI_CMN_RG_PERIOD_BALS

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 38: ln_fin_year JAI_CMN_RG_PERIOD_BALS.fin_year%type;

34: ld_start_date date;
35: ld_end_date date;
36: ln_period_opening_bal number;
37: ln_period_closing_bal number;
38: ln_fin_year JAI_CMN_RG_PERIOD_BALS.fin_year%type;
39: lv_register_type JAI_CMN_RG_PERIOD_BALS.register_type%type;
40:
41: ln_previous_closing_bal number;
42: ld_previous_end_date date;

Line 39: lv_register_type JAI_CMN_RG_PERIOD_BALS.register_type%type;

35: ld_end_date date;
36: ln_period_opening_bal number;
37: ln_period_closing_bal number;
38: ln_fin_year JAI_CMN_RG_PERIOD_BALS.fin_year%type;
39: lv_register_type JAI_CMN_RG_PERIOD_BALS.register_type%type;
40:
41: ln_previous_closing_bal number;
42: ld_previous_end_date date;
43:

Line 45: r_last_record JAI_CMN_RG_PERIOD_BALS%rowtype;

41: ln_previous_closing_bal number;
42: ld_previous_end_date date;
43:
44: ln_total_rg_amount number;
45: r_last_record JAI_CMN_RG_PERIOD_BALS%rowtype;
46:
47: /* rallamse bug#4336482 */
48: p_consolidate_till DATE; -- DEFAULT fnd_date.canonical_to_date(pv_consolidate_till) File.Sql.35 by Brathod
49: /* End of Bug# 4336482 */

Line 55: FROM JAI_CMN_RG_PERIOD_BALS

51: lc_end_date date ; -- := to_date('31-MAR-2003', 'dd-mon-yyyy') File.Sql.35 by Brathod
52:
53: CURSOR c_last_record(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
54: SELECT *
55: FROM JAI_CMN_RG_PERIOD_BALS
56: WHERE organization_id = cp_organization_id
57: AND location_id = cp_location_id
58: AND register_type = cp_register_type
59: AND (start_date, end_date) =

Line 62: FROM JAI_CMN_RG_PERIOD_BALS

58: AND register_type = cp_register_type
59: AND (start_date, end_date) =
60: (
61: SELECT max(start_date), max(end_date)
62: FROM JAI_CMN_RG_PERIOD_BALS
63: WHERE organization_id = cp_organization_id
64: AND location_id = cp_location_id
65: AND register_type = cp_register_type
66: );

Line 124: select JAI_CMN_RG_PERIOD_BALS_S.nextval

120: AND period_balance_id is null
121: AND trunc(creation_date) <= cp_consolidate_till;/*bug 5241875*/
122:
123: cursor c_get_period_balance_id is
124: select JAI_CMN_RG_PERIOD_BALS_S.nextval
125: from dual;
126:
127: ln_period_balance_id JAI_CMN_RG_PERIOD_BALS.period_balance_id%type;
128: ln_no_balances_updated number;

Line 127: ln_period_balance_id JAI_CMN_RG_PERIOD_BALS.period_balance_id%type;

123: cursor c_get_period_balance_id is
124: select JAI_CMN_RG_PERIOD_BALS_S.nextval
125: from dual;
126:
127: ln_period_balance_id JAI_CMN_RG_PERIOD_BALS.period_balance_id%type;
128: ln_no_balances_updated number;
129:
130: ln_cumulative_adjustment number := 0;
131:

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 158: Created the Package to populate data into JAI_CMN_RG_PERIOD_BALS

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
159: Huge Dependency
160: The Whole Patch should accompany this patch.
161:
162: 2 28/04/2005 rallamse for Bug#4336482, Version 116.1

Line 353: insert into JAI_CMN_RG_PERIOD_BALS

349: fetch c_get_period_balance_id into ln_period_balance_id;
350: close c_get_period_balance_id;
351:
352:
353: insert into JAI_CMN_RG_PERIOD_BALS
354: (
355: period_balance_id,
356: organization_id,
357: location_id,

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 523: from JAI_CMN_RG_PERIOD_BALS

519: where register_id = cp_register_id;
520:
521: cursor c_get_start_balance_detail(cp_starting_period_balance_id number) is
522: select organization_id, location_id, register_type, end_date
523: from JAI_CMN_RG_PERIOD_BALS
524: where period_balance_id = cp_starting_period_balance_id;
525:
526: r_get_start_balance_detail c_get_start_balance_detail%rowtype;
527: ln_parent_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type;

Line 528: ln_parent_period_balance_id JAI_CMN_RG_PERIOD_BALS.period_balance_id%type;

524: where period_balance_id = cp_starting_period_balance_id;
525:
526: r_get_start_balance_detail c_get_start_balance_detail%rowtype;
527: ln_parent_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type;
528: ln_parent_period_balance_id JAI_CMN_RG_PERIOD_BALS.period_balance_id%type;
529: lv_error_flag varchar(1); -- := 'N' -- File.Sql.35 by Brathod
530: lv_error_message varchar2(100);
531: ln_round_amount number;
532:

Line 617: update JAI_CMN_RG_PERIOD_BALS

613: goto exit_adjust_rounding;
614: end if;
615:
616: /* update the parent_balance record */
617: update JAI_CMN_RG_PERIOD_BALS
618: set rounding_adjustment = nvl(rounding_adjustment, 0) + ln_round_amount
619: , exc_edu_cess_adj = nvl(exc_edu_cess_adj, 0) + ln_exc_edu_cess_adj -- bgowrava for forward porting bug#5674376
620: , cvd_edu_cess_adj = nvl(cvd_edu_cess_adj, 0) + ln_cvd_edu_cess_adj -- bgowrava for forward porting bug#5674376
621: , sh_exc_edu_cess_adj = nvl(sh_exc_edu_cess_adj, 0) + ln_sh_exc_edu_cess_adj /*Bug 5989740 bduvarag*/

Line 636: update JAI_CMN_RG_PERIOD_BALS

632: open c_get_start_balance_detail(ln_parent_period_balance_id);
633: fetch c_get_start_balance_detail into r_get_start_balance_detail;
634: close c_get_start_balance_detail;
635:
636: update JAI_CMN_RG_PERIOD_BALS
637: set cumulative_rounding_adjustment =
638: nvl(cumulative_rounding_adjustment, 0) + ln_round_amount
639: -- bgowrava for forward porting bug#5674376
640: , exc_edu_cess_adj_op_bal = nvl(exc_edu_cess_adj_op_bal, 0) + ln_exc_edu_cess_adj

Line 676: from JAI_CMN_RG_PERIOD_BALS

672:
673: /* get the period balance record of previous period to know the opening cess balances */
674: cursor c_period_balance_record is
675: select *
676: from JAI_CMN_RG_PERIOD_BALS
677: where organization_id = cp_organization_id
678: and location_id = cp_location_id
679: and register_type = cp_register_type
680: and end_date = cp_period_start_date-1;

Line 681: r_period_bal_rec JAI_CMN_RG_PERIOD_BALS%rowtype;

677: where organization_id = cp_organization_id
678: and location_id = cp_location_id
679: and register_type = cp_register_type
680: and end_date = cp_period_start_date-1;
681: r_period_bal_rec JAI_CMN_RG_PERIOD_BALS%rowtype;
682:
683: ln_cess_op_bal number;
684: ln_sh_cess_op_bal number; /*Bug 5989740 bduvarag*/
685:

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;