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_PERIODS

Line 185: l_period_num ja_cn_periods.period_num%TYPE;

181: --l_period_set_name GL_PERIODS.PERIOD_SET_NAME%TYPE;
182: l_period_wrong EXCEPTION;
183: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
184: l_period_year gl_periods.period_year%TYPE;
185: l_period_num ja_cn_periods.period_num%TYPE;
186: l_first_fiscal_period_flag CHAR(1);
187: l_prior_period_name gl_periods.period_name%TYPE;
188: l_prior_period_num ja_cn_periods.period_num%TYPE;
189:

Line 188: l_prior_period_num ja_cn_periods.period_num%TYPE;

184: l_period_year gl_periods.period_year%TYPE;
185: l_period_num ja_cn_periods.period_num%TYPE;
186: l_first_fiscal_period_flag CHAR(1);
187: l_prior_period_name gl_periods.period_name%TYPE;
188: l_prior_period_num ja_cn_periods.period_num%TYPE;
189:
190: l_period_month ja_cn_account_balances.period_mon%TYPE;
191: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
192:

Line 289: FROM JA_CN_PERIODS

285: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel )
286:
287: SELECT COUNT(*)
288: INTO l_row_count
289: FROM JA_CN_PERIODS
290: WHERE period_name = p_period_name
291: AND ledger_id=p_ledger_id;
292:
293: IF l_row_count = 0 --The period is not processed before

Line 296: INSERT INTO JA_CN_PERIODS

292:
293: IF l_row_count = 0 --The period is not processed before
294: THEN
295: --open the period
296: INSERT INTO JA_CN_PERIODS
297: ( ledger_id
298: , START_DATE
299: , END_DATE
300: , PERIOD_NAME

Line 358: FROM JA_CN_PERIODS jjb

354: END IF; --( G_STATEMENT_LEVEL >= g_debug_devel )
355:
356: SELECT MAX(period_num)
357: INTO l_prior_period_num
358: FROM JA_CN_PERIODS jjb
359: WHERE jjb.ledger_id=p_ledger_id
360: AND jjb.period_num 361:
362: IF( G_STATEMENT_LEVEL >= g_debug_devel )

Line 373: FROM JA_CN_PERIODS jjb

369: IF l_prior_period_num IS NOT NULL
370: THEN
371: SELECT period_name
372: INTO l_prior_period_name
373: FROM JA_CN_PERIODS jjb
374: WHERE jjb.ledger_id=p_ledger_id
375: AND jjb.period_num =l_prior_period_num;
376:
377: --transfer prior period end balance the period begin balance

Line 1323: l_period_year ja_cn_periods.period_year%TYPE;

1319: , p_legal_entity_ID IN NUMBER
1320: )
1321: IS
1322: l_procedure_name VARCHAR2(30):='update_retained_account';
1323: l_period_year ja_cn_periods.period_year%TYPE;
1324: --l_period_name ja_cn_periods.period_name%TYPE;
1325:
1326: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
1327: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;

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

1320: )
1321: IS
1322: l_procedure_name VARCHAR2(30):='update_retained_account';
1323: l_period_year ja_cn_periods.period_year%TYPE;
1324: --l_period_name ja_cn_periods.period_name%TYPE;
1325:
1326: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
1327: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
1328: l_row_count NUMBER;

Line 1330: l_period_num ja_cn_periods.period_num%TYPE;

1326: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
1327: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
1328: l_row_count NUMBER;
1329: l_cost_center_second_tracking BOOLEAN:=FALSE;
1330: l_period_num ja_cn_periods.period_num%TYPE;
1331: l_last_period_num ja_cn_periods.period_num%TYPE;
1332: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
1333: i NUMBER;
1334:

Line 1331: l_last_period_num ja_cn_periods.period_num%TYPE;

1327: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
1328: l_row_count NUMBER;
1329: l_cost_center_second_tracking BOOLEAN:=FALSE;
1330: l_period_num ja_cn_periods.period_num%TYPE;
1331: l_last_period_num ja_cn_periods.period_num%TYPE;
1332: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
1333: i NUMBER;
1334:
1335: l_number NUMBER;

Line 1384: FROM ja_cn_periods

1380: END IF;
1381:
1382: SELECT period_year
1383: INTO l_period_year
1384: FROM ja_cn_periods
1385: WHERE period_name=p_period_name
1386: AND ledger_id=p_ledger_id;
1387:
1388: l_period_num:=l_period_year*1000+1;

Line 1392: FROM ja_cn_periods

1388: l_period_num:=l_period_year*1000+1;
1389:
1390: SELECT max(period_num)
1391: INTO l_last_period_num
1392: FROM ja_cn_periods
1393: WHERE ledger_id=p_ledger_id;
1394:
1395: SELECT ifs.flex_value_set_id
1396: INTO l_flex_value_set_id

Line 1535: , ja_cn_periods jcp

1531: , jcc.SEGMENT29
1532: , jcc.SEGMENT30
1533: FROM ja_cn_code_combination_v jcc
1534: , FND_FLEX_VALUES ffv
1535: , ja_cn_periods jcp
1536: , gl_balances gb
1537: , ja_cn_code_combination_v jcc1
1538: WHERE jcc.ledger_id = p_ledger_id --parameter: p_ledger_id
1539: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL

Line 1762: , ja_cn_periods jcp

1758: , jcc.SEGMENT29
1759: , jcc.SEGMENT30
1760: FROM ja_cn_code_combination_v jcc
1761: , FND_FLEX_VALUES ffv
1762: , ja_cn_periods jcp
1763: WHERE jcc.ledger_id = p_ledger_id
1764: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1765: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1766: AND ffv.flex_value = jcc.account_segment

Line 1902: , ja_cn_periods jcp

1898: , jcc.SEGMENT29
1899: , jcc.SEGMENT30
1900: FROM ja_cn_code_combination_v jcc
1901: , FND_FLEX_VALUES ffv
1902: , ja_cn_periods jcp
1903: WHERE jcc.ledger_id = p_ledger_id
1904: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1905: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1906: AND ffv.flex_value = jcc.account_segment

Line 2059: FROM ja_cn_periods jcp;

2055:
2056: /* --update the other month balance
2057: SELECT max(jcp.period_num - l_period_year*1000)
2058: INTO l_number
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

Line 2304: FROM ja_cn_periods jcp

2300: DELETE ja_cn_account_balances jcb
2301: WHERE jcb.ledger_id = p_ledger_id
2302: AND jcb.legal_entity_id = p_legal_entity_ID
2303: AND EXISTS (SELECT jcp.ledger_id
2304: FROM ja_cn_periods jcp
2305: , fnd_flex_values ffv
2306: WHERE jcp.period_name=jcb.period_name
2307: AND jcp.ledger_id = p_ledger_id
2308: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num

Line 2401: FROM ja_cn_periods jcp

2397: DELETE ja_cn_account_balances jcb
2398: WHERE jcb.ledger_id = p_ledger_id
2399: AND jcb.legal_entity_id = p_legal_entity_ID
2400: AND EXISTS (SELECT jcp.ledger_id
2401: FROM ja_cn_periods jcp
2402: , fnd_flex_values ffv
2403: WHERE jcp.period_name=jcb.period_name
2404: AND jcp.ledger_id = p_ledger_id
2405: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num

Line 2602: , ja_cn_periods jcp

2598: , NULL
2599: , NULL
2600: FROM ja_cn_account_balances jcb
2601: , JA_CN_ACCOUNT_CHILDREN_GT jcc
2602: , ja_cn_periods jcp
2603: WHERE jcc.child_account = jcb.account_segment
2604: AND jcp.ledger_id = p_ledger_id
2605: AND jcb.legal_entity_id = p_legal_entity_ID
2606: AND jcb.ledger_id = p_ledger_id

Line 2683: FROM ja_cn_periods jcp

2679: , SYSDATE
2680: , fnd_global.USER_ID
2681: , SYSDATE
2682: , fnd_global.LOGIN_ID
2683: FROM ja_cn_periods jcp
2684: , ja_cn_account_balances jca
2685: , FND_FLEX_VALUE_CHILDREN_V ffvc
2686: , fnd_flex_values ffv
2687: WHERE jca.account_segment = ffvc.flex_value*/

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

2836: , p_legal_entity_ID IN NUMBER
2837: )
2838: IS
2839: l_procedure_name VARCHAR2(30):='post_journal_itemized';
2840: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
2841: --l_last_open_period ja_cn_periods.period_name%TYPE;
2842: l_period_year ja_cn_periods.period_year%TYPE;
2843: l_period_num ja_cn_periods.period_num%TYPE;
2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;

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

2837: )
2838: IS
2839: l_procedure_name VARCHAR2(30):='post_journal_itemized';
2840: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
2841: --l_last_open_period ja_cn_periods.period_name%TYPE;
2842: l_period_year ja_cn_periods.period_year%TYPE;
2843: l_period_num ja_cn_periods.period_num%TYPE;
2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
2845: l_row_count NUMBER;

Line 2842: l_period_year ja_cn_periods.period_year%TYPE;

2838: IS
2839: l_procedure_name VARCHAR2(30):='post_journal_itemized';
2840: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
2841: --l_last_open_period ja_cn_periods.period_name%TYPE;
2842: l_period_year ja_cn_periods.period_year%TYPE;
2843: l_period_num ja_cn_periods.period_num%TYPE;
2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
2845: l_row_count NUMBER;
2846: l_balance_rec cnao_balance_rec;

Line 2843: l_period_num ja_cn_periods.period_num%TYPE;

2839: l_procedure_name VARCHAR2(30):='post_journal_itemized';
2840: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
2841: --l_last_open_period ja_cn_periods.period_name%TYPE;
2842: l_period_year ja_cn_periods.period_year%TYPE;
2843: l_period_num ja_cn_periods.period_num%TYPE;
2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
2845: l_row_count NUMBER;
2846: l_balance_rec cnao_balance_rec;
2847:

Line 2848: l_earliest_changed_year ja_cn_periods.period_year%TYPE;

2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
2845: l_row_count NUMBER;
2846: l_balance_rec cnao_balance_rec;
2847:
2848: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
2849: l_earliest_changed_period ja_cn_periods.period_name%TYPE;
2850:
2851: CURSOR c_periods(pc_year IN NUMBER
2852: ,pc_num IN NUMBER) IS

Line 2849: l_earliest_changed_period ja_cn_periods.period_name%TYPE;

2845: l_row_count NUMBER;
2846: l_balance_rec cnao_balance_rec;
2847:
2848: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
2849: l_earliest_changed_period ja_cn_periods.period_name%TYPE;
2850:
2851: CURSOR c_periods(pc_year IN NUMBER
2852: ,pc_num IN NUMBER) IS
2853: SELECT DISTINCT gp.period_name,gp.period_year,gp.period_num

Line 2982: FROM ja_cn_periods

2978:
2979: CURSOR c_after_periods(pc_period_num IN NUMBER) IS
2980: SELECT period_name
2981: , (period_num - period_year*1000) period_month
2982: FROM ja_cn_periods
2983: WHERE period_num>pc_period_num
2984: AND ledger_id=p_ledger_id
2985: AND status='O';
2986:

Line 2991: FROM ja_cn_periods

2987: CURSOR c_after_periods_in_year( pc_period_num IN NUMBER
2988: , pc_period_year IN NUMBER) IS
2989: SELECT period_name
2990: , (period_num - period_year*1000) period_month
2991: FROM ja_cn_periods
2992: WHERE period_num>pc_period_num
2993: AND status='O'
2994: AND period_year=pc_period_year
2995: AND ledger_id=p_ledger_id;

Line 3060: FROM ja_cn_periods

3056: put_log(G_MODULE_PREFIX||l_procedure_name||'.period name'
3057: ,rec_period.period_name||':'||to_char(SYSDATE,'hh:mi:ss'));
3058: SELECT COUNT(*)
3059: INTO l_row_count
3060: FROM ja_cn_periods
3061: WHERE period_name=rec_period.period_name
3062: AND ledger_id=p_ledger_id;
3063:
3064: IF( G_STATEMENT_LEVEL >= g_debug_devel )