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

Line 148: l_period_num ja_cn_periods.period_num%TYPE;

144: --l_period_set_name GL_PERIODS.PERIOD_SET_NAME%TYPE;
145: l_period_wrong EXCEPTION;
146: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
147: l_period_year gl_periods.period_year%TYPE;
148: l_period_num ja_cn_periods.period_num%TYPE;
149: l_first_fiscal_period_flag CHAR(1);
150: l_prior_period_name gl_periods.period_name%TYPE;
151: l_prior_period_num ja_cn_periods.period_num%TYPE;
152:

Line 151: l_prior_period_num ja_cn_periods.period_num%TYPE;

147: l_period_year gl_periods.period_year%TYPE;
148: l_period_num ja_cn_periods.period_num%TYPE;
149: l_first_fiscal_period_flag CHAR(1);
150: l_prior_period_name gl_periods.period_name%TYPE;
151: l_prior_period_num ja_cn_periods.period_num%TYPE;
152:
153: l_period_month ja_cn_account_balances.period_mon%TYPE;
154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:

Line 252: FROM JA_CN_PERIODS

248: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel )
249:
250: SELECT COUNT(*)
251: INTO l_row_count
252: FROM JA_CN_PERIODS
253: WHERE period_name = p_period_name
254: AND ledger_id=p_ledger_id;
255:
256: IF l_row_count = 0 --The period is not processed before

Line 259: INSERT INTO JA_CN_PERIODS

255:
256: IF l_row_count = 0 --The period is not processed before
257: THEN
258: --open the period
259: INSERT INTO JA_CN_PERIODS
260: ( ledger_id
261: , START_DATE
262: , END_DATE
263: , PERIOD_NAME

Line 321: FROM JA_CN_PERIODS jjb

317: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel )
318:
319: SELECT MAX(period_num)
320: INTO l_prior_period_num
321: FROM JA_CN_PERIODS jjb
322: WHERE jjb.ledger_id=p_ledger_id
323: AND jjb.period_num 324:
325: IF( G_STATEMENT_LEVEL >= g_debug_devel )

Line 336: FROM JA_CN_PERIODS jjb

332: IF l_prior_period_num IS NOT NULL
333: THEN
334: SELECT period_name
335: INTO l_prior_period_name
336: FROM JA_CN_PERIODS jjb
337: WHERE jjb.ledger_id=p_ledger_id
338: AND jjb.period_num =l_prior_period_num;
339:
340: --transfer prior period end balance the period begin balance

Line 975: l_period_year ja_cn_periods.period_year%TYPE;

971: , p_legal_entity_ID IN NUMBER
972: )
973: IS
974: l_procedure_name VARCHAR2(30):='update_retained_account';
975: l_period_year ja_cn_periods.period_year%TYPE;
976: --l_period_name ja_cn_periods.period_name%TYPE;
977:
978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;

Line 976: --l_period_name ja_cn_periods.period_name%TYPE;

972: )
973: IS
974: l_procedure_name VARCHAR2(30):='update_retained_account';
975: l_period_year ja_cn_periods.period_year%TYPE;
976: --l_period_name ja_cn_periods.period_name%TYPE;
977:
978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
980: l_row_count NUMBER;

Line 982: l_period_num ja_cn_periods.period_num%TYPE;

978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
980: l_row_count NUMBER;
981: l_cost_center_second_tracking BOOLEAN:=FALSE;
982: l_period_num ja_cn_periods.period_num%TYPE;
983: l_last_period_num ja_cn_periods.period_num%TYPE;
984: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
985: i NUMBER;
986:

Line 983: l_last_period_num ja_cn_periods.period_num%TYPE;

979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
980: l_row_count NUMBER;
981: l_cost_center_second_tracking BOOLEAN:=FALSE;
982: l_period_num ja_cn_periods.period_num%TYPE;
983: l_last_period_num ja_cn_periods.period_num%TYPE;
984: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
985: i NUMBER;
986:
987: l_number NUMBER;

Line 1030: FROM ja_cn_periods

1026: END IF;
1027:
1028: SELECT period_year
1029: INTO l_period_year
1030: FROM ja_cn_periods
1031: WHERE period_name=p_period_name
1032: AND ledger_id=p_ledger_id;
1033:
1034: l_period_num:=l_period_year*1000+1;

Line 1038: FROM ja_cn_periods

1034: l_period_num:=l_period_year*1000+1;
1035:
1036: SELECT max(period_num)
1037: INTO l_last_period_num
1038: FROM ja_cn_periods
1039: WHERE ledger_id=p_ledger_id;
1040:
1041: SELECT ifs.flex_value_set_id
1042: INTO l_flex_value_set_id

Line 1126: , ja_cn_periods jcp

1122: , SYSDATE
1123: , fnd_global.LOGIN_ID
1124: FROM ja_cn_code_combination_v jcc
1125: , FND_FLEX_VALUES ffv
1126: , ja_cn_periods jcp
1127: WHERE jcc.ledger_id = p_ledger_id
1128: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1129: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1130: AND ffv.flex_value = jcc.account_segment

Line 1208: , ja_cn_periods jcp

1204: , SYSDATE
1205: , fnd_global.LOGIN_ID
1206: FROM ja_cn_code_combination_v jcc
1207: , FND_FLEX_VALUES ffv
1208: , ja_cn_periods jcp
1209: WHERE jcc.ledger_id = p_ledger_id
1210: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1211: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1212: AND ffv.flex_value = jcc.account_segment

Line 1303: FROM ja_cn_periods jcp;

1299:
1300: --update the other month balance
1301: SELECT max(jcp.period_num - l_period_year*1000)
1302: INTO l_number
1303: FROM ja_cn_periods jcp;
1304:
1305: FOR i IN 2..l_number
1306: LOOP
1307: UPDATE ja_cn_account_balances_post_gt u

Line 1424: FROM ja_cn_periods jcp

1420: DELETE ja_cn_account_balances jcb
1421: WHERE jcb.ledger_id = p_ledger_id
1422: AND jcb.legal_entity_id = p_legal_entity_ID
1423: AND EXISTS (SELECT jcp.ledger_id
1424: FROM ja_cn_periods jcp
1425: , fnd_flex_values ffv
1426: WHERE jcp.period_name=jcb.period_name
1427: AND jcp.ledger_id = p_ledger_id
1428: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num

Line 1521: FROM ja_cn_periods jcp

1517: DELETE ja_cn_account_balances jcb
1518: WHERE jcb.ledger_id = p_ledger_id
1519: AND jcb.legal_entity_id = p_legal_entity_ID
1520: AND EXISTS (SELECT jcp.ledger_id
1521: FROM ja_cn_periods jcp
1522: , fnd_flex_values ffv
1523: WHERE jcp.period_name=jcb.period_name
1524: AND jcp.ledger_id = p_ledger_id
1525: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num

Line 1657: , ja_cn_periods jcp

1653: , SYSDATE
1654: , fnd_global.LOGIN_ID
1655: FROM ja_cn_account_balances jcb
1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc
1657: , ja_cn_periods jcp
1658: WHERE jcc.child_account = jcb.account_segment
1659: AND jcp.ledger_id = p_ledger_id
1660: AND jcb.legal_entity_id = p_legal_entity_ID
1661: AND jcb.ledger_id = p_ledger_id

Line 1736: FROM ja_cn_periods jcp

1732: , SYSDATE
1733: , fnd_global.USER_ID
1734: , SYSDATE
1735: , fnd_global.LOGIN_ID
1736: FROM ja_cn_periods jcp
1737: , ja_cn_account_balances jca
1738: , FND_FLEX_VALUE_CHILDREN_V ffvc
1739: , fnd_flex_values ffv
1740: WHERE jca.account_segment = ffvc.flex_value*/

Line 1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;

1785: , p_legal_entity_ID IN NUMBER
1786: )
1787: IS
1788: l_procedure_name VARCHAR2(30):='post_journal_itemized';
1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
1790: --l_last_open_period ja_cn_periods.period_name%TYPE;
1791: l_period_year ja_cn_periods.period_year%TYPE;
1792: l_period_num ja_cn_periods.period_num%TYPE;
1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;

Line 1790: --l_last_open_period ja_cn_periods.period_name%TYPE;

1786: )
1787: IS
1788: l_procedure_name VARCHAR2(30):='post_journal_itemized';
1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
1790: --l_last_open_period ja_cn_periods.period_name%TYPE;
1791: l_period_year ja_cn_periods.period_year%TYPE;
1792: l_period_num ja_cn_periods.period_num%TYPE;
1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
1794: l_row_count NUMBER;

Line 1791: l_period_year ja_cn_periods.period_year%TYPE;

1787: IS
1788: l_procedure_name VARCHAR2(30):='post_journal_itemized';
1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
1790: --l_last_open_period ja_cn_periods.period_name%TYPE;
1791: l_period_year ja_cn_periods.period_year%TYPE;
1792: l_period_num ja_cn_periods.period_num%TYPE;
1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
1794: l_row_count NUMBER;
1795: l_balance_rec cnao_balance_rec;

Line 1792: l_period_num ja_cn_periods.period_num%TYPE;

1788: l_procedure_name VARCHAR2(30):='post_journal_itemized';
1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
1790: --l_last_open_period ja_cn_periods.period_name%TYPE;
1791: l_period_year ja_cn_periods.period_year%TYPE;
1792: l_period_num ja_cn_periods.period_num%TYPE;
1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
1794: l_row_count NUMBER;
1795: l_balance_rec cnao_balance_rec;
1796:

Line 1797: l_earliest_changed_year ja_cn_periods.period_year%TYPE;

1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
1794: l_row_count NUMBER;
1795: l_balance_rec cnao_balance_rec;
1796:
1797: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
1798: l_earliest_changed_period ja_cn_periods.period_name%TYPE;
1799:
1800: CURSOR c_periods(pc_year IN NUMBER
1801: ,pc_num IN NUMBER) IS

Line 1798: l_earliest_changed_period ja_cn_periods.period_name%TYPE;

1794: l_row_count NUMBER;
1795: l_balance_rec cnao_balance_rec;
1796:
1797: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
1798: l_earliest_changed_period ja_cn_periods.period_name%TYPE;
1799:
1800: CURSOR c_periods(pc_year IN NUMBER
1801: ,pc_num IN NUMBER) IS
1802: SELECT DISTINCT gp.period_name,gp.period_year,gp.period_num

Line 1871: FROM ja_cn_periods

1867:
1868: CURSOR c_after_periods(pc_period_num IN NUMBER) IS
1869: SELECT period_name
1870: , (period_num - period_year*1000) period_month
1871: FROM ja_cn_periods
1872: WHERE period_num>pc_period_num
1873: AND ledger_id=p_ledger_id
1874: AND status='O';
1875:

Line 1880: FROM ja_cn_periods

1876: CURSOR c_after_periods_in_year( pc_period_num IN NUMBER
1877: , pc_period_year IN NUMBER) IS
1878: SELECT period_name
1879: , (period_num - period_year*1000) period_month
1880: FROM ja_cn_periods
1881: WHERE period_num>pc_period_num
1882: AND status='O'
1883: AND period_year=pc_period_year
1884: AND ledger_id=p_ledger_id;

Line 1945: FROM ja_cn_periods

1941: put_log(G_MODULE_PREFIX||l_procedure_name||'.period name'
1942: ,rec_period.period_name||':'||to_char(SYSDATE,'hh:mi:ss'));
1943: SELECT COUNT(*)
1944: INTO l_row_count
1945: FROM ja_cn_periods
1946: WHERE period_name=rec_period.period_name
1947: AND ledger_id=p_ledger_id;
1948:
1949: IF( G_STATEMENT_LEVEL >= g_debug_devel )