APPS.JAI_CMN_RG_PERIOD_BALS_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 76: FROM JAI_CMN_RG_23AC_II_TRXS

72: /* bgowrava for forward porting bug#5674376. additional_cvd column added */
73: SELECT sum(nvl(cr_basic_ed,0)+ nvl(cr_additional_ed,0) + nvl(cr_other_ed,0) + nvl(cr_additional_cvd,0)
74: - nvl(dr_basic_ed,0) - nvl(dr_additional_ed,0) - nvl(dr_other_ed,0) - nvl(dr_additional_cvd,0)) total_modvat_amount,
75: min(fin_year)
76: FROM JAI_CMN_RG_23AC_II_TRXS
77: WHERE organization_id = cp_organization_id
78: AND location_id = cp_location_id
79: AND register_type = cp_register_type
80: AND trunc(creation_date) between cp_start_date and cp_end_date

Line 91: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b

87: (cp_organization_id in number, cp_location_id in number, cp_register_type in varchar2,
88: cp_start_date in date, cp_end_date in date, cp_tax_type in varchar2)
89: IS
90: SELECT sum(nvl(b.credit,0) - nvl(b.debit,0)) total_cess
91: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b
92: WHERE a.organization_id = cp_organization_id
93: AND a.location_id = cp_location_id
94: AND a.register_type = cp_register_type
95: AND trunc(a.creation_date) between cp_start_date and cp_end_date

Line 116: FROM JAI_CMN_RG_23AC_II_TRXS

112: cp_consolidate_till IN DATE)/*bug 5241875.Added
113: this parameter*/
114: IS
115: SELECT min(creation_date)
116: FROM JAI_CMN_RG_23AC_II_TRXS
117: WHERE organization_id = cp_organization_id
118: AND location_id = cp_location_id
119: AND register_type = cp_register_type
120: AND period_balance_id is null

Line 175: A first record created in JAI_CMN_RG_23AC_II_TRXS table is in 2nd August 2006.

171: Issue:
172: The concurrent is poulating wrong balances when it is run for the first time.
173: Fix:
174: Consider the following case:
175: A first record created in JAI_CMN_RG_23AC_II_TRXS table is in 2nd August 2006.
176: Now if we run the RG23 part II report it would ask the user to run
177: the "India RG Period balance calculation" concurrent till July 31. If we run this concurrent
178: it would do the following steps:
179:

Line 429: update JAI_CMN_RG_23AC_II_TRXS

425: );
426:
427: -- Punch the PERIOD_BALANCE_ID aginst all the records that have been considered
428: -- for consolidation
429: update JAI_CMN_RG_23AC_II_TRXS
430: set period_balance_id = ln_period_balance_id
431: WHERE organization_id = org.organization_id
432: AND location_id = org.location_id
433: AND register_type = p_register_type

Line 463: from JAI_CMN_RG_23AC_II_TRXS

459: -- loop thru all the rounding entries in the register that has not been consolidated.
460: for cur_rounding_rec in
461: (
462: select register_id
463: from JAI_CMN_RG_23AC_II_TRXS
464: where inventory_item_id = 0
465: and period_balance_id is null
466: and register_type = p_register_type /* added by bgowrava for forward porting bug#5674376*/
467: --and trunc(creation_date) <= ld_consolidate_till /*commented by bgowrava for forward porting bug#5674376 */

Line 510: from JAI_CMN_RG_23AC_II_TRXS

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
511: where register_id = cp_register_id;
512:
513:
514: cursor c_get_round_amount(cp_register_id number) is

Line 518: from JAI_CMN_RG_23AC_II_TRXS

514: cursor c_get_round_amount(cp_register_id number) is
515: /* bgowrava for forward porting bug#5674376. additional_cvd column added */
516: select (nvl(cr_basic_ed,0)+ nvl(cr_additional_ed,0) + nvl(cr_other_ed,0)+ nvl(cr_additional_cvd,0)
517: - nvl(dr_basic_ed,0) - nvl(dr_additional_ed,0) - nvl(dr_other_ed,0) - nvl(dr_additional_cvd,0)) rounding_amount
518: from JAI_CMN_RG_23AC_II_TRXS
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

Line 527: ln_parent_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type;

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;
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;

Line 627: update JAI_CMN_RG_23AC_II_TRXS

623:
624: where period_balance_id = ln_parent_period_balance_id;
625:
626: /* punch the balance id in the register rounding record */
627: update JAI_CMN_RG_23AC_II_TRXS
628: set period_balance_id = ln_parent_period_balance_id
629: where register_id = p_register_id_rounding;
630:
631: /* update all subsequent balance records */