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.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_ACCOUNT_BALANCES_POST_GT

Line 1420: --Step2: Insert balances of retained account into table ja_cn_account_balances_post_gt

1416: IF ja_cn_utility.populate_ledger_le_bsv_gt(p_ledger_id, p_legal_entity_id) <> 'S'
1417: THEN
1418: RETURN;
1419: END IF;
1420: --Step2: Insert balances of retained account into table ja_cn_account_balances_post_gt
1421: INSERT INTO ja_cn_account_balances_post_gt(
1422: LEDGER_ID
1423: , LEGAL_ENTITY_ID
1424: , COMPANY_SEGMENT

Line 1421: INSERT INTO ja_cn_account_balances_post_gt(

1417: THEN
1418: RETURN;
1419: END IF;
1420: --Step2: Insert balances of retained account into table ja_cn_account_balances_post_gt
1421: INSERT INTO ja_cn_account_balances_post_gt(
1422: LEDGER_ID
1423: , LEGAL_ENTITY_ID
1424: , COMPANY_SEGMENT
1425: , PERIOD_NAME

Line 1638: /* INSERT INTO ja_cn_account_balances_post_gt(

1634: --Begin: Deleted for fixing bug 9582957
1635: /* IF l_cost_center_second_tracking
1636: THEN*/
1637: --insert all possible retain account into temp table
1638: /* INSERT INTO ja_cn_account_balances_post_gt(
1639: ledger_id
1640: , LEGAL_ENTITY_ID
1641: , COMPANY_SEGMENT
1642: , PERIOD_NAME

Line 1779: INSERT INTO ja_cn_account_balances_post_gt(

1775: AND nvl(jcc1.project_number,'0') =nvl(jcc.project_number,'0') ) )*//*;*/
1776:
1777: /* ELSE --l_cost_center_second_tracking = false
1778:
1779: INSERT INTO ja_cn_account_balances_post_gt(
1780: ledger_id
1781: , LEGAL_ENTITY_ID
1782: , COMPANY_SEGMENT
1783: , PERIOD_NAME

Line 1921: /* UPDATE ja_cn_account_balances_post_gt u

1917:
1918: END IF;--l_cost_center_second_tracking*/
1919:
1920: --update the period net occurance DR and CR
1921: /* UPDATE ja_cn_account_balances_post_gt u
1922: SET (FUNC_PERIOD_NET_DR
1923: , FUNC_PERIOD_NET_CR
1924: , ORIG_PERIOD_NET_DR
1925: , ORIG_PERIOD_NET_CR

Line 1981: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;

1977: AND nvl(SEGMENT29,'0')= nvl(u.SEGMENT29,'0')
1978: AND nvl(SEGMENT30,'0')= nvl(u.SEGMENT30,'0')
1979: );*/
1980:
1981: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1982:
1983: --update the first priod begin balance in each year
1984: /* UPDATE ja_cn_account_balances_post_gt u
1985: SET ( FUNC_BEGIN_BALANCE_DR

Line 1984: /* UPDATE ja_cn_account_balances_post_gt u

1980:
1981: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1982:
1983: --update the first priod begin balance in each year
1984: /* UPDATE ja_cn_account_balances_post_gt u
1985: SET ( FUNC_BEGIN_BALANCE_DR
1986: , FUNC_BEGIN_BALANCE_CR
1987: , ORIG_BEGIN_BALANCE_DR
1988: , ORIG_BEGIN_BALANCE_CR)=

Line 2015: UPDATE ja_cn_account_balances_post_gt u

2011: AND gb.actual_flag = 'A'
2012: )
2013: WHERE period_mon=1;
2014:
2015: UPDATE ja_cn_account_balances_post_gt u
2016: SET ( FUNC_BEGIN_BALANCE_DR
2017: , FUNC_BEGIN_BALANCE_CR
2018: , ORIG_BEGIN_BALANCE_DR
2019: , ORIG_BEGIN_BALANCE_CR)=

Line 2046: UPDATE ja_cn_account_balances_post_gt u

2042: AND gb.actual_flag = 'A'
2043: )
2044: WHERE period_mon=1;*/
2045:
2046: UPDATE ja_cn_account_balances_post_gt u
2047: SET FUNC_BEGIN_BALANCE_DR = nvl(FUNC_BEGIN_BALANCE_DR,0)
2048: , FUNC_BEGIN_BALANCE_CR = nvl(FUNC_BEGIN_BALANCE_CR,0)
2049: , ORIG_BEGIN_BALANCE_DR = nvl(ORIG_BEGIN_BALANCE_DR,0)
2050: , ORIG_BEGIN_BALANCE_CR = nvl(ORIG_BEGIN_BALANCE_CR,0)

Line 2063: UPDATE ja_cn_account_balances_post_gt u

2059: FROM ja_cn_periods jcp;
2060:
2061: FOR i IN 2..l_number
2062: LOOP
2063: UPDATE ja_cn_account_balances_post_gt u
2064: SET (FUNC_BEGIN_BALANCE_DR
2065: , FUNC_BEGIN_BALANCE_CR
2066: , ORIG_BEGIN_BALANCE_DR
2067: , ORIG_BEGIN_BALANCE_CR )=

Line 2072: FROM ja_cn_account_balances_post_gt

2068: (SELECT FUNC_BEGIN_BALANCE_DR + FUNC_PERIOD_NET_DR
2069: , FUNC_BEGIN_BALANCE_CR + FUNC_PERIOD_NET_CR
2070: , ORIG_BEGIN_BALANCE_DR + ORIG_PERIOD_NET_DR
2071: , ORIG_BEGIN_BALANCE_CR + ORIG_PERIOD_NET_CR
2072: FROM ja_cn_account_balances_post_gt
2073: WHERE period_num=u.period_num - 1
2074: AND ledger_id = p_ledger_id
2075: AND LEGAL_ENTITY_ID = p_legal_entity_ID
2076: AND COMPANY_SEGMENT = u.company_segment

Line 2127: FROM ja_cn_account_balances_post_gt t

2123: -- replace the new balance of retain earning account
2124: DELETE ja_cn_account_balances u
2125: WHERE EXISTS
2126: (SELECT *
2127: FROM ja_cn_account_balances_post_gt t
2128: WHERE t.ledger_id =u.ledger_id
2129: AND t.LEGAL_ENTITY_ID =u.LEGAL_ENTITY_ID
2130: AND t.COMPANY_SEGMENT =u.COMPANY_SEGMENT
2131: AND t.CURRENCY_CODE =u.CURRENCY_CODE

Line 2297: FROM ja_cn_account_balances_post_gt;

2293: , SEGMENT27
2294: , SEGMENT28
2295: , SEGMENT29
2296: , SEGMENT30
2297: FROM ja_cn_account_balances_post_gt;
2298:
2299: /* -- delete the old parent account balance
2300: DELETE ja_cn_account_balances jcb
2301: WHERE jcb.ledger_id = p_ledger_id

Line 2619: DELETE ja_cn_account_balances_post_gt;*/

2615: --Calculate balance based on currency to support foreign currency
2616: , jcb.currency_code;
2617:
2618: /* --initiate the working area
2619: DELETE ja_cn_account_balances_post_gt;*/
2620:
2621: --insert all parent account having only non-parent account
2622: /* INSERT INTO ja_cn_account_balances(
2623: ledger_id