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.

[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_BALANCES

Line 1678: FROM jl_co_gl_balances bal

1674:
1675:
1676: SELECT count(*)
1677: INTO l_bal_count
1678: FROM jl_co_gl_balances bal
1679: WHERE bal.period_name = p_period
1680: AND bal.period_year = p_period_year
1681: AND bal.set_of_books_id = p_sobid
1682: AND rownum = 1;

Line 1688: FROM jl_co_gl_balances bal

1684: IF l_bal_count = 0 THEN
1685: BEGIN
1686: SELECT max((bal.period_year * 100 + bal.period_num))
1687: INTO l_pre_period_num
1688: FROM jl_co_gl_balances bal
1689: WHERE (bal.period_year * 100 + bal.period_num) < p_period_year * 100 + p_period_num
1690: AND bal.set_of_books_id = p_sobid;
1691:
1692: INSERT INTO jl_co_gl_balances (

Line 1692: INSERT INTO jl_co_gl_balances (

1688: FROM jl_co_gl_balances bal
1689: WHERE (bal.period_year * 100 + bal.period_num) < p_period_year * 100 + p_period_num
1690: AND bal.set_of_books_id = p_sobid;
1691:
1692: INSERT INTO jl_co_gl_balances (
1693: balance_id,
1694: set_of_books_id,
1695: code_combination_id,
1696: account_code,

Line 1711: (select jl_co_gl_balances_s.nextval,

1707: created_by,
1708: last_update_date,
1709: last_updated_by,
1710: last_update_login)
1711: (select jl_co_gl_balances_s.nextval,
1712: bal.set_of_books_id,
1713: bal.code_combination_id,
1714: bal.account_code,
1715: bal.nit_id,

Line 1729: FROM jl_co_gl_balances bal

1725: bal.created_by,
1726: sysdate,
1727: bal.last_updated_by,
1728: bal.last_update_login
1729: FROM jl_co_gl_balances bal
1730: WHERE (bal.period_year * 100 + bal.period_num) = l_pre_period_num
1731: AND bal.set_of_books_id = p_sobid);
1732:
1733: FND_FILE.PUT_LINE(FND_FILE.log,'p_sobid :'||to_char(p_sobid)||'-'||to_char(l_pre_period_num));

Line 1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;

1751: PROCEDURE Calculate_Balance(p_cid IN NUMBER,
1752: p_sobid IN NUMBER,
1753: p_userid IN NUMBER) IS
1754:
1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;
1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;

Line 1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;

1752: p_sobid IN NUMBER,
1753: p_userid IN NUMBER) IS
1754:
1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;
1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;

Line 1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;

1753: p_userid IN NUMBER) IS
1754:
1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;
1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;

Line 1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;

1754:
1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;
1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;

Line 1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;

1755: l_balance_id jl_co_gl_balances.balance_id%TYPE;
1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;

Line 1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;

1756: l_begin_bal_dr_prior_period jl_co_gl_balances.begin_balance_dr%TYPE;
1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;
1764:

Line 1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;

1757: l_begin_bal_cr_prior_period jl_co_gl_balances.begin_balance_cr%TYPE;
1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;
1764:
1765: -- right now the currency field in jl_co_gl_balances only holds

Line 1765: -- right now the currency field in jl_co_gl_balances only holds

1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;
1764:
1765: -- right now the currency field in jl_co_gl_balances only holds
1766: -- functional_currency_code. But in the future if the functionality
1767: -- is changed to hold balances for multiple currencies then curreny_code
1768: -- should be added to the BALANCE_TRX cursor and in other sql joins also
1769:

Line 1820: FROM jl_co_gl_balances jlcgb

1816: BEGIN
1817:
1818: SELECT balance_id
1819: INTO l_balance_id
1820: FROM jl_co_gl_balances jlcgb
1821: WHERE jlcgb.set_of_books_id = trx.sobid
1822: AND jlcgb.nit_id = trx.nitid
1823: AND jlcgb.code_combination_id = trx.ccid
1824: AND jlcgb.period_name = trx.period_name;

Line 1855: FROM jl_co_gl_balances jlcgb

1851: INTO l_begin_bal_dr_prior_period,
1852: l_begin_bal_cr_prior_period,
1853: l_period_net_dr_prior_period,
1854: l_period_net_cr_prior_period
1855: FROM jl_co_gl_balances jlcgb
1856: WHERE jlcgb.nit_id = trx.nitid
1857: AND jlcgb.set_of_books_id = trx.sobid
1858: AND jlcgb.code_combination_id = trx.ccid
1859: AND (jlcgb.period_year * 100 + jlcgb.period_num) =

Line 1862: FROM jl_co_gl_balances jlcgb1

1858: AND jlcgb.code_combination_id = trx.ccid
1859: AND (jlcgb.period_year * 100 + jlcgb.period_num) =
1860: (SELECT max(jlcgb1.period_year * 100 +
1861: jlcgb1.period_num)
1862: FROM jl_co_gl_balances jlcgb1
1863: WHERE jlcgb1.nit_id = trx.nitid
1864: AND jlcgb1.set_of_books_id = trx.sobid
1865: AND jlcgb1.code_combination_id = trx.ccid
1866: AND (jlcgb1.period_year * 100 + jlcgb1.period_num) <

Line 1892: INSERT INTO jl_co_gl_balances (

1888: l_period_net_dr_prior_period ;
1889: l_begin_bal_cr := l_begin_bal_cr_prior_period +
1890: l_period_net_cr_prior_period ;
1891:
1892: INSERT INTO jl_co_gl_balances (
1893: balance_id,
1894: set_of_books_id,
1895: code_combination_id,
1896: account_code,

Line 1911: VALUES ( jl_co_gl_balances_s.nextval,

1907: created_by,
1908: last_update_date,
1909: last_updated_by,
1910: last_update_login)
1911: VALUES ( jl_co_gl_balances_s.nextval,
1912: trx.sobid,
1913: trx.ccid,
1914: trx.acccode,
1915: trx.nitid,

Line 1934: UPDATE jl_co_gl_balances jlcgb

1930: ELSE
1931: -- Balance record exists - Update period_net of current record
1932: FND_FILE.PUT_LINE(FND_FILE.log,
1933: 'If l_balance_id is non 0 then update :' ||to_char(trx.acc_dr));
1934: UPDATE jl_co_gl_balances jlcgb
1935: SET period_net_dr = (period_net_dr + trx.acc_dr) ,
1936: period_net_cr = (period_net_cr + trx.acc_cr),
1937: last_update_date = sysdate,
1938: last_updated_by = p_userid,

Line 1952: UPDATE jl_co_gl_balances jlcgb

1948: -- each balance_trx.
1949: -- For income statement accounts only the records in the same year
1950: -- as the transaction needs to be updated
1951:
1952: UPDATE jl_co_gl_balances jlcgb
1953: SET begin_balance_dr = (begin_balance_dr + trx.acc_dr),
1954: begin_balance_cr = (begin_balance_cr + trx.acc_cr),
1955: last_update_date = sysdate,
1956: last_updated_by = p_userid,

Line 2026: UPDATE jl_co_gl_balances jlcgb

2022:
2023: FOR trx IN reversal_trx
2024: LOOP
2025:
2026: UPDATE jl_co_gl_balances jlcgb
2027: -- period_net should be updated only for the purge period
2028: SET period_net_dr =
2029: (period_net_dr - DECODE(jlcgb.period_name, trx.period_name,
2030: trx.acc_dr,0)),

Line 2063: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT

2059: -- After the update if the period_net_dr and cr amounts are 0
2060: -- delete the balance record so that one would be able to delete
2061: -- an invalid NIT via the Define Third Party form.
2062: -- The form does not let you delete a NIT if there are records
2063: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT
2064:
2065: DELETE FROM jl_co_gl_balances jlcgb
2066: WHERE jlcgb.set_of_books_id = trx.sobid
2067: AND jlcgb.nit_id = trx.nitid

Line 2065: DELETE FROM jl_co_gl_balances jlcgb

2061: -- an invalid NIT via the Define Third Party form.
2062: -- The form does not let you delete a NIT if there are records
2063: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT
2064:
2065: DELETE FROM jl_co_gl_balances jlcgb
2066: WHERE jlcgb.set_of_books_id = trx.sobid
2067: AND jlcgb.nit_id = trx.nitid
2068: AND jlcgb.code_combination_id = trx.ccid
2069: AND jlcgb.period_name = trx.period_name