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_23AC_II_TRXS

Line 21: FROM JAI_CMN_RG_23AC_II_TRXS jrg

17: IS
18:
19: CURSOR get_rg23_prev_slno IS
20: SELECT max(slno)
21: FROM JAI_CMN_RG_23AC_II_TRXS jrg
22: WHERE organization_id = p_organization_id
23: AND location_id = p_location_id
24: AND register_type = p_register_type
25: AND fin_year = p_fin_year

Line 35: FROM JAI_CMN_RG_23AC_II_TRXS jrg

31: AND source_register_id = jrg.register_id );
32:
33: CURSOR get_rg23_prev_fin_slno IS
34: SELECT max(slno)
35: FROM JAI_CMN_RG_23AC_II_TRXS jrg
36: WHERE organization_id = p_organization_id
37: AND location_id = p_location_id
38: AND register_type = p_register_type
39: AND fin_year = p_fin_year - 1

Line 52: FROM JAI_CMN_RG_23AC_II_TRXS

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
53: WHERE organization_id = p_organization_id
54: AND location_id = p_location_id
55: AND register_type = p_register_type
56: AND fin_year = p_fin_year

Line 161: FROM JAI_CMN_RG_23AC_II_TRXS

157: IS
158:
159: CURSOR get_rg23_prev_slno IS
160: SELECT max(slno)
161: FROM JAI_CMN_RG_23AC_II_TRXS
162: WHERE organization_id = p_organization_id
163: AND location_id = p_location_id
164: AND register_type = p_register_type
165: AND fin_year = p_fin_year

Line 170: FROM JAI_CMN_RG_23AC_II_TRXS

166: AND slno < p_slno ;
167:
168: CURSOR get_rg23_prev_fin_slno IS
169: SELECT max(slno)
170: FROM JAI_CMN_RG_23AC_II_TRXS
171: WHERE organization_id = p_organization_id
172: AND location_id = p_location_id
173: AND register_type = p_register_type
174: AND fin_year = p_fin_year - 1;

Line 178: FROM JAI_CMN_RG_23AC_II_TRXS

174: AND fin_year = p_fin_year - 1;
175:
176: CURSOR get_rg23_balance( cp_fin_year NUMBER,cp_slno NUMBER ) IS
177: SELECT closing_balance
178: FROM JAI_CMN_RG_23AC_II_TRXS
179: WHERE organization_id = p_organization_id
180: AND location_id = p_location_id
181: AND register_type = p_register_type
182: AND fin_year = p_fin_year

Line 276: UPDATE JAI_CMN_RG_23AC_II_TRXS

272: BEGIN
273:
274: IF p_register_type IN ('A','C') THEN
275:
276: UPDATE JAI_CMN_RG_23AC_II_TRXS
277: SET slno = slno + p_dup_cnt - 1
278: WHERE organization_id = p_organization_id
279: AND location_id = p_location_id
280: AND register_type = p_register_type

Line 293: FROM JAI_CMN_RG_23AC_II_TRXS

289: AND current_fin_year = p_fin_year;
290:
291: ln_cnt := 0;
292: FOR dup_rec in ( SELECT *
293: FROM JAI_CMN_RG_23AC_II_TRXS
294: WHERE organization_id = p_organization_id
295: AND location_id = p_location_id
296: AND register_type = p_register_type
297: AND fin_year = p_fin_year

Line 302: UPDATE JAI_CMN_RG_23AC_II_TRXS

298: AND slno = p_slno
299: ORDER BY register_id ) LOOP
300:
301:
302: UPDATE JAI_CMN_RG_23AC_II_TRXS
303: SET slno = slno + ln_cnt
304: WHERE register_id = dup_rec.register_id;
305:
306: ln_cnt := ln_cnt + 1;

Line 367: UPDATE JAI_CMN_RG_23AC_II_TRXS

363: AND location_id = p_location_id
364: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C')
365: AND start_date >= p_start_date;
366:
367: UPDATE JAI_CMN_RG_23AC_II_TRXS
368: SET period_balance_id = NULL
369: WHERE organization_id = p_organization_id
370: AND location_id = p_location_id
371: AND register_type = p_register_type

Line 394: FROM JAI_CMN_RG_23AC_II_TRXS

390: IS
391: CURSOR cur_get_tot_amt( cp_start_date DATE,cp_end_date DATE ) IS
392: SELECT sum(nvl(cr_basic_ed,0)+ nvl(cr_additional_ed,0) + nvl(cr_other_ed,0)
393: - nvl(dr_basic_ed,0) - nvl(dr_additional_ed,0) - nvl(dr_other_ed,0)) total_modvat_amount
394: FROM JAI_CMN_RG_23AC_II_TRXS
395: WHERE organization_id = p_organization_id
396: AND location_id = p_location_id
397: AND register_type = p_register_type
398: AND trunc(creation_date) between cp_start_date and cp_end_date

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 611: JAI_CMN_RG_23AC_II_TRXS rg23

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
615: AND slno >= p_slno)

Line 845: JAI_CMN_RG_23AC_II_TRXS rg23

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
849: AND register_type = p_register_type

Line 892: FROM JAI_CMN_RG_23AC_II_TRXS jrg

888: AND p_date between fin_year_start_date and fin_year_end_date;
889:
890: CURSOR cur_get_rg_slno(cp_fin_year NUMBER,cp_tax_type VARCHAR2,cp_date DATE) IS
891: SELECT max(slno),min(slno)
892: FROM JAI_CMN_RG_23AC_II_TRXS jrg
893: WHERE organization_id = p_organization_id
894: AND location_id = p_location_id
895: AND fin_year = cp_fin_year
896: AND register_type = p_register_type

Line 907: FROM JAI_CMN_RG_23AC_II_TRXS jrg

903:
904:
905: CURSOR cur_rg_tax_exists(cp_fin_year NUMBER,cp_tax_type VARCHAR2,cp_date DATE) IS
906: SELECT 1
907: FROM JAI_CMN_RG_23AC_II_TRXS jrg
908: WHERE organization_id = p_organization_id
909: AND location_id = p_location_id
910: AND fin_year = cp_fin_year
911: AND register_type = p_register_type

Line 955: FROM JAI_CMN_RG_23AC_II_TRXS

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
956: WHERE organization_id = p_organization_id
957: AND location_id = p_location_id
958: AND register_type = p_register_type
959: AND fin_year = cp_fin_year

Line 1303: WHERE table_name = 'JAI_CMN_RG_23AC_II_TRXS'

1299: CURSOR c_check_addl_cvd
1300: IS
1301: SELECT 1
1302: FROM all_tab_cols
1303: WHERE table_name = 'JAI_CMN_RG_23AC_II_TRXS'
1304: AND column_name IN ( 'DR_ADDITIONAL_CVD', 'CR_ADDITIONAL_CVD')
1305: AND owner = l_apps_short_name ; /*added by ssawant*/
1306:
1307: ln_prev_balance NUMBER;

Line 1338: FROM JAI_CMN_RG_23AC_II_TRXS

1334: lv_cursor_str := 'SELECT '||
1335: lv_trans_str||' ,
1336: register_id,
1337: slno
1338: FROM JAI_CMN_RG_23AC_II_TRXS
1339: WHERE organization_id ='|| p_organization_id||'
1340: AND location_id ='|| p_location_id||'
1341: AND register_type ='''|| p_register_type||'''
1342: AND ((fin_year ='|| p_fin_year||'

Line 1374: UPDATE JAI_CMN_RG_23AC_II_TRXS

1370: EXIT WHEN cur_next_rg_records%NOTFOUND;
1371: ln_opening_balance := ln_prev_balance;
1372: ln_closing_balance := ln_opening_balance + ln_trans_amt;
1373:
1374: UPDATE JAI_CMN_RG_23AC_II_TRXS
1375: SET opening_balance = ln_opening_balance,
1376: closing_balance = ln_closing_balance,
1377: last_updated_by = p_last_updated_by,
1378: last_update_date = sysdate

Line 1458: UPDATE JAI_CMN_RG_23AC_II_TRXS

1454: BEGIN
1455:
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 ),

Line 1767: PROCEDURE rg23_part_ii_validation( p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

1763:
1764:
1765:
1766: ------------------------------------ RG23_PART_II_VALIDATION ------------------------------------------------
1767: PROCEDURE rg23_part_ii_validation( p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1768: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1769: p_fin_year IN JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1770: p_register_type IN JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
1771: )

Line 1768: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,

1764:
1765:
1766: ------------------------------------ RG23_PART_II_VALIDATION ------------------------------------------------
1767: PROCEDURE rg23_part_ii_validation( p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1768: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1769: p_fin_year IN JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1770: p_register_type IN JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
1771: )
1772: IS

Line 1769: p_fin_year IN JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,

1765:
1766: ------------------------------------ RG23_PART_II_VALIDATION ------------------------------------------------
1767: PROCEDURE rg23_part_ii_validation( p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1768: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1769: p_fin_year IN JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1770: p_register_type IN JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
1771: )
1772: IS
1773:

Line 1770: p_register_type IN JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE

1766: ------------------------------------ RG23_PART_II_VALIDATION ------------------------------------------------
1767: PROCEDURE rg23_part_ii_validation( p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1768: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1769: p_fin_year IN JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1770: p_register_type IN JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
1771: )
1772: IS
1773:
1774: Cursor c_duplicate_slno

Line 1778: JAI_CMN_RG_23AC_II_TRXS

1774: Cursor c_duplicate_slno
1775: IS
1776: select slno , count(*) rowcount
1777: from
1778: JAI_CMN_RG_23AC_II_TRXS
1779: where
1780: organization_id = p_organization_id and
1781: location_id = p_location_id and
1782: fin_year = p_fin_year and

Line 1792: JAI_CMN_RG_23AC_II_TRXS

1788: Cursor c_transaction_balance
1789: is
1790: select slno
1791: from
1792: JAI_CMN_RG_23AC_II_TRXS
1793: where
1794: closing_balance <> nvl(opening_balance,0) +
1795: ( nvl(cr_basic_ed,0)+nvl(cr_additional_ed,0)+nvl(cr_other_ed,0) ) -
1796: ( nvl(dr_basic_ed,0)+nvl(dr_additional_ed,0)+nvl(dr_other_ed,0) ) AND

Line 1819: JAI_CMN_RG_23AC_II_TRXS

1815: opening_balance ,
1816: closing_balance ,
1817: nvl(other_tax_credit,other_tax_debit) rg_other_amt
1818: FROM
1819: JAI_CMN_RG_23AC_II_TRXS
1820: WHERE
1821: organization_id = p_organization_id AND
1822: location_id = p_location_id AND
1823: fin_year = p_fin_year AND

Line 1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

1829: fin_year ,
1830: register_type ,
1831: slno ;
1832:
1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE

Line 1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,

1830: register_type ,
1831: slno ;
1832:
1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE
1838: )

Line 1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,

1831: slno ;
1832:
1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE
1838: )
1839: is

Line 1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,

1832:
1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE
1838: )
1839: is
1840: select

Line 1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE

1833: cursor c_get_closing_balance ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
1834: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
1835: cp_fin_year JAI_CMN_RG_23AC_II_TRXS.FIN_YEAR%TYPE ,
1836: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
1837: cp_slno JAI_CMN_RG_23AC_II_TRXS.SLNO%TYPE
1838: )
1839: is
1840: select
1841: nvl(closing_balance,0)

Line 1843: JAI_CMN_RG_23AC_II_TRXS

1839: is
1840: select
1841: nvl(closing_balance,0)
1842: from
1843: JAI_CMN_RG_23AC_II_TRXS
1844: where
1845: organization_id = cp_organization_id AND
1846: location_id = cp_location_id AND
1847: fin_year = cp_fin_year AND

Line 1852: JAI_CMN_RG_23AC_II_TRXS

1848: register_type = cp_register_type AND
1849: slno =
1850: ( select max(slno)
1851: from
1852: JAI_CMN_RG_23AC_II_TRXS
1853: where
1854: organization_id = cp_organization_id and
1855: location_id = cp_location_id and
1856: fin_year = cp_fin_year and

Line 1865: from JAI_CMN_RG_23AC_II_TRXS

1861: cp_location_id IN NUMBER,
1862: cp_fin_year IN NUMBER,
1863: cp_register_type CHAR) IS
1864: select nvl(closing_balance,0)
1865: from JAI_CMN_RG_23AC_II_TRXS
1866: where organization_id = cp_organization_id
1867: and location_id = cp_location_id
1868: and register_type = cp_register_type
1869: and fin_year = cp_fin_year

Line 1872: from JAI_CMN_RG_23AC_II_TRXS

1868: and register_type = cp_register_type
1869: and fin_year = cp_fin_year
1870: and slno in
1871: ( select nvl(max(slno),0)
1872: from JAI_CMN_RG_23AC_II_TRXS
1873: where organization_id = cp_organization_id
1874: and location_id = cp_location_id
1875: and fin_year = cp_fin_year
1876: and register_type = cp_register_type);

Line 1939: JAI_CMN_RG_23AC_II_TRXS

1935: begin
1936: execute immediate
1937: ' select slno
1938: from
1939: JAI_CMN_RG_23AC_II_TRXS
1940: where
1941: closing_balance <> nvl(opening_balance,0) +
1942: ( nvl(cr_basic_ed,0)+nvl(cr_additional_ed,0)+nvl(cr_other_ed,0) + nvl(cr_additional_cvd,0)) -
1943: ( nvl(dr_basic_ed,0)+nvl(dr_additional_ed,0)+nvl(dr_other_ed,0) + nvl(dr_additional_cvd,0)) AND

Line 1956: JAI_CMN_RG_23AC_II_TRXS

1952:
1953: execute immediate
1954: ' select count(1)
1955: from
1956: JAI_CMN_RG_23AC_II_TRXS
1957: where
1958: closing_balance <> nvl(opening_balance,0) +
1959: ( nvl(cr_basic_ed,0)+nvl(cr_additional_ed,0)+nvl(cr_other_ed,0) ) -
1960: ( nvl(dr_basic_ed,0)+nvl(dr_additional_ed,0)+nvl(dr_other_ed,0) ) AND

Line 2195: from JAI_CMN_RG_23AC_II_TRXS

2191: cp_location_id number,
2192: cp_register_type varchar2 )
2193: is
2194: select closing_balance , slno
2195: from JAI_CMN_RG_23AC_II_TRXS
2196: where organization_id = cp_organization_id
2197: and location_id = cp_location_id
2198: and register_type = cp_register_type
2199: order by fin_year desc , slno desc ;

Line 2266: table_name = 'JAI_CMN_RG_23AC_II_TRXS'

2262: is
2263: select 1
2264: from all_tab_cols
2265: where
2266: table_name = 'JAI_CMN_RG_23AC_II_TRXS'
2267: and column_name IN ( 'DR_ADDITIONAL_CVD', 'CR_ADDITIONAL_CVD')
2268: AND owner = l_apps_short_name ; /*added by ssawant*/
2269:
2270: cursor c_get_rg23_open_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

Line 2270: cursor c_get_rg23_open_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

2266: table_name = 'JAI_CMN_RG_23AC_II_TRXS'
2267: and column_name IN ( 'DR_ADDITIONAL_CVD', 'CR_ADDITIONAL_CVD')
2268: AND owner = l_apps_short_name ; /*added by ssawant*/
2269:
2270: cursor c_get_rg23_open_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2271: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2272: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2273: cp_date date
2274: )

Line 2271: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,

2267: and column_name IN ( 'DR_ADDITIONAL_CVD', 'CR_ADDITIONAL_CVD')
2268: AND owner = l_apps_short_name ; /*added by ssawant*/
2269:
2270: cursor c_get_rg23_open_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2271: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2272: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2273: cp_date date
2274: )
2275: is

Line 2272: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,

2268: AND owner = l_apps_short_name ; /*added by ssawant*/
2269:
2270: cursor c_get_rg23_open_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2271: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2272: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2273: cp_date date
2274: )
2275: is
2276: select

Line 2279: JAI_CMN_RG_23AC_II_TRXS

2275: is
2276: select
2277: nvl(opening_balance,0)
2278: from
2279: JAI_CMN_RG_23AC_II_TRXS
2280: where
2281: organization_id = cp_organization_id AND
2282: location_id = cp_location_id AND
2283: register_type = cp_register_type AND

Line 2287: cursor c_get_rg23_tran_amt ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

2283: register_type = cp_register_type AND
2284: trunc(creation_date) >= cp_date
2285: order by fin_year, slno ;
2286:
2287: cursor c_get_rg23_tran_amt ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2288: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2289: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2290: cp_date date
2291: )

Line 2288: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,

2284: trunc(creation_date) >= cp_date
2285: order by fin_year, slno ;
2286:
2287: cursor c_get_rg23_tran_amt ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2288: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2289: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2290: cp_date date
2291: )
2292: is

Line 2289: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,

2285: order by fin_year, slno ;
2286:
2287: cursor c_get_rg23_tran_amt ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2288: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2289: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE ,
2290: cp_date date
2291: )
2292: is
2293: select

Line 2297: JAI_CMN_RG_23AC_II_TRXS

2293: select
2294: sum(nvl(cr_basic_ed,0)+nvl(cr_additional_ed,0)+nvl(cr_other_ed,0)) credit_amount ,
2295: sum(nvl(dr_basic_ed,0)+nvl(dr_additional_ed,0)+nvl(dr_other_ed,0)) debit_amount
2296: from
2297: JAI_CMN_RG_23AC_II_TRXS
2298: where
2299: organization_id = cp_organization_id AND
2300: location_id = cp_location_id AND
2301: register_type = cp_register_type AND

Line 2304: cursor c_rg_slno_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,

2300: location_id = cp_location_id AND
2301: register_type = cp_register_type AND
2302: trunc(creation_date) >= cp_date ;
2303:
2304: cursor c_rg_slno_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2305: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2306: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
2307: )
2308: is

Line 2305: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,

2301: register_type = cp_register_type AND
2302: trunc(creation_date) >= cp_date ;
2303:
2304: cursor c_rg_slno_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2305: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2306: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
2307: )
2308: is
2309: select balance

Line 2306: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE

2302: trunc(creation_date) >= cp_date ;
2303:
2304: cursor c_rg_slno_bal ( cp_organization_id JAI_CMN_RG_23AC_II_TRXS.ORGANIZATION_ID%TYPE ,
2305: cp_location_id JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID%TYPE ,
2306: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
2307: )
2308: is
2309: select balance
2310: from JAI_CMN_RG_SLNOS

Line 2382: FROM JAI_CMN_RG_23AC_II_TRXS jrg

2378: cp_fin_year NUMBER,
2379: cp_tax_type VARCHAR2,
2380: cp_date DATE) IS
2381: SELECT max(slno)
2382: FROM JAI_CMN_RG_23AC_II_TRXS jrg
2383: WHERE organization_id = p_organization_id
2384: AND location_id = p_location_id
2385: AND fin_year = cp_fin_year
2386: AND register_type = p_register_type

Line 2403: FROM JAI_CMN_RG_23AC_II_TRXS

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
2405: AND location_id = cp_location_id
2406: AND register_type = p_register_type
2407: AND trunc(creation_date) >= cp_date)

Line 2449: FROM JAI_CMN_RG_23AC_II_TRXS

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
2450: WHERE organization_id = p_organization_id
2451: AND location_id = p_location_id
2452: AND register_type = p_register_type
2453: AND fin_year = cp_fin_year

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 2573: from JAI_CMN_RG_23AC_II_TRXS

2569: then
2570: -- To verify intra table data
2571: for rec in ( select
2572: distinct organization_id, location_id, fin_year, register_type
2573: from JAI_CMN_RG_23AC_II_TRXS
2574: where
2575: trunc(creation_date) >= pv_date and
2576: register_type = nvl(p_register_type, register_type) and
2577: location_id = nvl(p_location_id , location_id) and

Line 2582: -- call to validate records in JAI_CMN_RG_23AC_II_TRXS

2578: organization_id = nvl(p_organization_id, organization_id)
2579: order by register_type, organization_id, location_id, fin_year )
2580: loop
2581:
2582: -- call to validate records in JAI_CMN_RG_23AC_II_TRXS
2583: rg23_part_ii_validation( p_organization_id => rec.organization_id ,
2584: p_location_id => rec.location_id ,
2585: p_fin_year => rec.fin_year ,
2586: p_register_type => rec.register_type

Line 2595: from JAI_CMN_RG_23AC_II_TRXS

2591:
2592: -- To verify inter table data
2593: for rg23_bal_rec in ( select
2594: distinct organization_id, location_id, register_type
2595: from JAI_CMN_RG_23AC_II_TRXS
2596: where
2597: register_type = nvl(p_register_type, register_type) and
2598: organization_id = nvl(p_organization_id, organization_id) and
2599: location_id = nvl(p_location_id , location_id) and

Line 2839: from JAI_CMN_RG_23AC_II_TRXS

2835: if p_register_type is null
2836: then
2837: For cons_rec in ( select
2838: distinct organization_id, location_id
2839: from JAI_CMN_RG_23AC_II_TRXS
2840: where
2841: organization_id = nvl(p_organization_id, organization_id) and
2842: location_id = nvl(p_location_id , location_id) and
2843: trunc(creation_date) >= pv_date

Line 2852: from JAI_CMN_RG_23AC_II_TRXS

2848: For rg23_cons_rec in ( select
2849: sum( nvl(dr_basic_ed,0) +nvl(dr_additional_ed,0) +nvl(dr_other_ed,0) ) rg23_cons_amt ,
2850: sum(other_tax_debit) rg23_oth_amt,
2851: trunc(creation_date) cons_date
2852: from JAI_CMN_RG_23AC_II_TRXS
2853: where
2854: transaction_source_num is null and
2855: organization_id = cons_rec.organization_id and
2856: location_id = cons_rec.location_id and

Line 2921: from JAI_CMN_RG_23AC_II_TRXS

2917: ' || ' ------ |'|| ' --------------- |' || '------------- |' || ' ------------ |' || ' --------------- |' || ' -------------------- |' || ' --------------------- |' ) ;
2918:
2919: for rg23_log_rec in ( select
2920: distinct organization_id, location_id, register_type
2921: from JAI_CMN_RG_23AC_II_TRXS
2922: where
2923: register_type = nvl(p_register_type, register_type) and
2924: organization_id = nvl(p_organization_id, organization_id) and
2925: location_id = nvl(p_location_id , location_id) and

Line 2956: JAI_CMN_RG_23AC_II_TRXS

2952: ' select
2953: sum(nvl(cr_basic_ed,0)+nvl(cr_additional_ed,0)+nvl(cr_other_ed,0) + nvl(cr_additional_cvd,0)) credit_amount ,
2954: sum(nvl(dr_basic_ed,0)+nvl(dr_additional_ed,0)+nvl(dr_other_ed,0) + nvl(dr_additional_cvd,0)) debit_amount
2955: from
2956: JAI_CMN_RG_23AC_II_TRXS
2957: where
2958: organization_id = ' || rg23_log_rec.organization_id || ' AND
2959: location_id = ' || rg23_log_rec.location_id || ' AND
2960: register_type = ''' || rg23_log_rec.register_type || ''' AND