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_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_RG_OTHERS

Line 28: FROM JAI_CMN_RG_OTHERS

24: AND register_type = p_register_type
25: AND fin_year = p_fin_year
26: AND slno < p_slno
27: AND EXISTS ( SELECT 1
28: FROM JAI_CMN_RG_OTHERS
29: WHERE source_type = 1
30: AND tax_type = p_tax_type
31: AND source_register_id = jrg.register_id );
32:

Line 41: FROM JAI_CMN_RG_OTHERS

37: AND location_id = p_location_id
38: AND register_type = p_register_type
39: AND fin_year = p_fin_year - 1
40: AND exists ( SELECT 1
41: FROM JAI_CMN_RG_OTHERS
42: WHERE source_type = 1
43: AND tax_type = p_tax_type
44: AND source_register_id = jrg.register_id );
45:

Line 48: FROM JAI_CMN_RG_OTHERS

44: AND source_register_id = jrg.register_id );
45:
46: CURSOR get_rg23_balance( cp_fin_year NUMBER,cp_slno NUMBER ) IS
47: SELECT closing_balance
48: FROM JAI_CMN_RG_OTHERS
49: WHERE source_type = 1
50: AND tax_type = p_tax_type
51: AND source_register_id = ( SELECT register_id
52: FROM JAI_CMN_RG_23AC_II_TRXS

Line 67: FROM JAI_CMN_RG_OTHERS

63: AND location_id = p_location_id
64: AND fin_year = p_fin_year
65: AND slno < p_slno
66: AND EXISTS ( SELECT 1
67: FROM JAI_CMN_RG_OTHERS
68: WHERE source_type = 2
69: AND tax_type = p_tax_type
70: AND source_register_id = jpl.register_id );
71:

Line 80: FROM JAI_CMN_RG_OTHERS

76: WHERE organization_id = p_organization_id
77: AND location_id = p_location_id
78: AND fin_year = p_fin_year - 1
79: AND EXISTS ( SELECT 1
80: FROM JAI_CMN_RG_OTHERS
81: WHERE source_type = 2
82: AND tax_type = p_tax_type
83: AND source_register_id = jpl.register_id );
84:

Line 87: FROM JAI_CMN_RG_OTHERS

83: AND source_register_id = jpl.register_id );
84:
85: CURSOR get_pla_balance( cp_fin_year NUMBER,cp_slno NUMBER ) IS
86: SELECT closing_balance
87: FROM JAI_CMN_RG_OTHERS
88: WHERE source_type = 2
89: AND tax_type = p_tax_type
90: AND source_register_id = ( SELECT register_id
91: FROM JAI_CMN_RG_PLA_TRXS

Line 413: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b

409:
410:
411: CURSOR c_total_cess_amount(cp_start_date in date, cp_end_date in date, cp_tax_type in varchar2) IS
412: SELECT sum(nvl(b.credit,0) - nvl(b.debit,0)) total_cess
413: FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_RG_OTHERS b
414: WHERE a.organization_id = p_organization_id
415: AND a.location_id = p_location_id
416: AND a.register_type = p_register_type
417: AND trunc(a.creation_date) between cp_start_date and cp_end_date

Line 610: FROM JAI_CMN_RG_OTHERS jrg,

606: jrg.rg_other_id,
607: rg23.slno,
608: rg23.organization_id,
609: rg23.location_id
610: FROM JAI_CMN_RG_OTHERS jrg,
611: JAI_CMN_RG_23AC_II_TRXS rg23
612: WHERE organization_id = p_organization_id
613: AND location_id = p_location_id
614: AND ((fin_year = p_fin_year

Line 638: FROM JAI_CMN_RG_OTHERS jrg,

634: jrg.rg_other_id,
635: jpl.slno,
636: jpl.organization_id,
637: jpl.location_id
638: FROM JAI_CMN_RG_OTHERS jrg,
639: JAI_CMN_RG_PLA_TRXS jpl
640: WHERE source_type = 2
641: and tax_type = p_tax_type
642: and source_register_id = jpl.register_id

Line 688: UPDATE JAI_CMN_RG_OTHERS

684:
685: ln_opening_balance := ln_prev_balance;
686: ln_closing_balance := ln_opening_balance + records.transaction_amount;
687:
688: UPDATE JAI_CMN_RG_OTHERS
689: SET opening_balance = ln_opening_balance,
690: closing_balance = ln_closing_balance,
691: last_updated_by = p_last_updated_by,
692: last_update_date = sysdate

Line 717: UPDATE JAI_CMN_RG_OTHERS

713:
714: ln_opening_balance := ln_prev_balance;
715: ln_closing_balance := ln_opening_balance + records.transaction_amount;
716:
717: UPDATE JAI_CMN_RG_OTHERS
718: SET opening_balance = ln_opening_balance,
719: closing_balance = ln_closing_balance,
720: last_updated_by = p_last_updated_by,
721: last_update_date = sysdate

Line 844: FROM JAI_CMN_RG_OTHERS jrg,

840: jrg.rg_other_id,
841: rg23.slno,
842: rg23.organization_id,
843: rg23.location_id
844: FROM JAI_CMN_RG_OTHERS jrg,
845: JAI_CMN_RG_23AC_II_TRXS rg23
846: WHERE organization_id = p_organization_id
847: AND location_id = p_location_id
848: AND fin_year = cp_fin_year

Line 867: FROM JAI_CMN_RG_OTHERS jrg,

863: jrg.rg_other_id,
864: jpl.slno,
865: jpl.organization_id,
866: jpl.location_id
867: FROM JAI_CMN_RG_OTHERS jrg,
868: JAI_CMN_RG_PLA_TRXS jpl
869: WHERE source_type = 2
870: and tax_type = cp_tax_type
871: and source_register_id = jpl.register_id

Line 899: FROM JAI_CMN_RG_OTHERS

895: AND fin_year = cp_fin_year
896: AND register_type = p_register_type
897: AND trunc(creation_date) < cp_date
898: AND EXISTS ( SELECT 1
899: FROM JAI_CMN_RG_OTHERS
900: WHERE source_type = 1
901: AND source_register_id = jrg.register_id
902: AND tax_type = cp_tax_type );
903:

Line 914: FROM JAI_CMN_RG_OTHERS

910: AND fin_year = cp_fin_year
911: AND register_type = p_register_type
912: AND trunc(creation_date) < cp_date
913: AND EXISTS ( SELECT 1
914: FROM JAI_CMN_RG_OTHERS
915: WHERE source_type = 1
916: AND source_register_id = jrg.register_id
917: AND tax_type = cp_tax_type );
918: ln_rg_tax_exists NUMBER;

Line 929: FROM JAI_CMN_RG_OTHERS

925: AND location_id = p_location_id
926: AND fin_year = cp_fin_year
927: AND trunc(creation_date) < cp_date
928: AND EXISTS ( SELECT 1
929: FROM JAI_CMN_RG_OTHERS
930: WHERE source_type = 2
931: AND source_register_id = jpl.register_id
932: AND tax_type = cp_tax_type );
933:

Line 942: FROM JAI_CMN_RG_OTHERS

938: AND location_id = p_location_id
939: AND fin_year = cp_fin_year
940: AND trunc(creation_date) < cp_date
941: AND EXISTS ( SELECT 1
942: FROM JAI_CMN_RG_OTHERS
943: WHERE source_type = 2
944: AND source_register_id = jpl.register_id
945: AND tax_type = cp_tax_type );
946: ln_pla_tax_exists NUMBER;

Line 951: FROM JAI_CMN_RG_OTHERS

947:
948:
949: CURSOR get_rg_closing_bal(cp_fin_year NUMBER,cp_slno NUMBER,cp_tax_type VARCHAR2) IS
950: SELECT closing_balance
951: FROM JAI_CMN_RG_OTHERS
952: WHERE source_type = 1
953: AND tax_type = cp_tax_type
954: AND source_register_id in ( SELECT register_id
955: FROM JAI_CMN_RG_23AC_II_TRXS

Line 964: FROM JAI_CMN_RG_OTHERS

960: AND slno = nvl(cp_slno,1) );
961:
962: CURSOR get_pla_closing_bal(cp_fin_year NUMBER,cp_slno NUMBER,cp_tax_type VARCHAR2) IS
963: SELECT closing_balance
964: FROM JAI_CMN_RG_OTHERS
965: WHERE source_type = 2
966: AND tax_type = cp_tax_type
967: AND source_register_id in ( SELECT register_id
968: FROM JAI_CMN_RG_PLA_TRXS

Line 1460: FROM JAI_CMN_RG_OTHERS

1456: IF p_register_type IN ( 'A','C') THEN
1457:
1458: UPDATE JAI_CMN_RG_23AC_II_TRXS
1459: SET other_tax_credit = ( SELECT sum(credit)
1460: FROM JAI_CMN_RG_OTHERS
1461: WHERE source_type = 1
1462: AND source_register_id = p_register_id ),
1463: other_tax_debit = ( SELECT sum(debit)
1464: FROM JAI_CMN_RG_OTHERS

Line 1464: FROM JAI_CMN_RG_OTHERS

1460: FROM JAI_CMN_RG_OTHERS
1461: WHERE source_type = 1
1462: AND source_register_id = p_register_id ),
1463: other_tax_debit = ( SELECT sum(debit)
1464: FROM JAI_CMN_RG_OTHERS
1465: WHERE source_type = 1
1466: AND source_register_id = p_register_id )
1467: WHERE register_id = p_register_id;
1468:

Line 1473: FROM JAI_CMN_RG_OTHERS

1469: ELSIF p_register_type = 'PLA' THEN
1470:
1471: UPDATE JAI_CMN_RG_PLA_TRXS
1472: SET other_tax_credit = ( SELECT sum(credit)
1473: FROM JAI_CMN_RG_OTHERS
1474: WHERE source_type = 2
1475: AND source_register_id = p_register_id ),
1476: other_tax_debit = ( SELECT sum(debit)
1477: FROM JAI_CMN_RG_OTHERS

Line 1477: FROM JAI_CMN_RG_OTHERS

1473: FROM JAI_CMN_RG_OTHERS
1474: WHERE source_type = 2
1475: AND source_register_id = p_register_id ),
1476: other_tax_debit = ( SELECT sum(debit)
1477: FROM JAI_CMN_RG_OTHERS
1478: WHERE source_type = 2
1479: AND source_register_id = p_register_id )
1480: WHERE register_id = p_register_id;
1481:

Line 1596: from JAI_CMN_RG_OTHERS

1592:
1593: cursor c_rg_others(cp_source_register_id number)
1594: is
1595: select nvl(sum(credit), sum(debit))
1596: from JAI_CMN_RG_OTHERS
1597: where source_register = 'PLA'
1598: and source_register_id = cp_source_register_id
1599: and source_type = 2 ;
1600:

Line 1881: from JAI_CMN_RG_OTHERS

1877:
1878: cursor c_rg_others(cp_source_register_id number , cp_register_type varchar2)
1879: is
1880: select nvl(sum(credit), sum(debit))
1881: from JAI_CMN_RG_OTHERS
1882: where source_register = decode(cp_register_type,'A','RG23A_P2','C','RG23C_P2')
1883: and source_register_id = cp_source_register_id
1884: and source_type = 1 ;
1885:

Line 2389: FROM JAI_CMN_RG_OTHERS

2385: AND fin_year = cp_fin_year
2386: AND register_type = p_register_type
2387: AND trunc(creation_date) < cp_date
2388: AND EXISTS ( SELECT 1
2389: FROM JAI_CMN_RG_OTHERS
2390: WHERE source_type = 1
2391: AND source_register_id = jrg.register_id
2392: AND tax_type = cp_tax_type );
2393:

Line 2400: FROM JAI_CMN_RG_OTHERS

2396: cp_date DATE ,
2397: cp_tax_type VARCHAR2)
2398: IS
2399: SELECT sum(credit),sum(debit)
2400: FROM JAI_CMN_RG_OTHERS
2401: WHERE source_register = decode(p_register_type,'A','RG23A_P2','C','RG23C_P2')
2402: AND source_register_id in ( SELECT register_id
2403: FROM JAI_CMN_RG_23AC_II_TRXS
2404: WHERE organization_id = cp_organization_id

Line 2416: FROM JAI_CMN_RG_OTHERS

2412: cp_date DATE ,
2413: cp_tax_type VARCHAR2)
2414: IS
2415: SELECT sum(credit),sum(debit)
2416: FROM JAI_CMN_RG_OTHERS
2417: WHERE source_register = 'PLA'
2418: AND source_register_id in ( SELECT register_id
2419: FROM JAI_CMN_RG_PLA_TRXS
2420: WHERE organization_id = cp_organization_id

Line 2438: FROM JAI_CMN_RG_OTHERS

2434: AND location_id = p_location_id
2435: AND fin_year = cp_fin_year
2436: AND trunc(creation_date) < cp_date
2437: AND EXISTS ( SELECT 1
2438: FROM JAI_CMN_RG_OTHERS
2439: WHERE source_type = 2
2440: AND source_register_id = jpl.register_id
2441: AND tax_type = cp_tax_type );
2442:

Line 2445: FROM JAI_CMN_RG_OTHERS

2441: AND tax_type = cp_tax_type );
2442:
2443: CURSOR get_rg23_cess_closing_bal(cp_fin_year NUMBER,cp_slno NUMBER,cp_tax_type VARCHAR2) IS
2444: SELECT closing_balance
2445: FROM JAI_CMN_RG_OTHERS
2446: WHERE source_type = 1
2447: AND tax_type = cp_tax_type
2448: AND source_register_id in ( SELECT register_id
2449: FROM JAI_CMN_RG_23AC_II_TRXS

Line 2458: FROM JAI_CMN_RG_OTHERS

2454: AND slno = nvl(cp_slno,1) );
2455:
2456: CURSOR get_pla_cess_closing_bal(cp_fin_year NUMBER,cp_slno NUMBER,cp_tax_type VARCHAR2) IS
2457: SELECT closing_balance
2458: FROM JAI_CMN_RG_OTHERS
2459: WHERE source_type = 2
2460: AND tax_type = cp_tax_type
2461: AND source_register_id in ( SELECT register_id
2462: FROM JAI_CMN_RG_PLA_TRXS

Line 2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;

2557: gn_exists := null ;
2558:
2559: if p_action = 3 and nvl(p_backup,'N') = 'N' then
2560: raise_application_error(-20054, ' Pls take a backup of the following tables from JA before you
2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;
2562: end if ;
2563:
2564: open c_check_addl_cvd ;
2565: fetch c_check_addl_cvd into gn_exists ;

Line 3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;

3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;
3620:
3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

Line 3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

Line 3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

Line 3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;

3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;
3646:
3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;
3648:
3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;
3650:
3651: end if ;
3652:
3653: exception