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 GL_PERIODS

Line 181: --l_period_set_name GL_PERIODS.PERIOD_SET_NAME%TYPE;

177: )
178: IS
179: l_procedure_name VARCHAR2(30):='open_period';
180: l_row_count NUMBER;
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;

Line 184: l_period_year gl_periods.period_year%TYPE;

180: l_row_count NUMBER;
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;

Line 187: l_prior_period_name gl_periods.period_name%TYPE;

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:
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;

Line 325: , gl_periods gp

321: , SYSDATE
322: , fnd_global.USER_ID
323: , fnd_global.LOGIN_ID
324: FROM gl_ledgers led
325: , gl_periods gp
326: WHERE led.ledger_id=p_ledger_id
327: AND led.period_set_name = gp.period_set_name
328: AND gp.period_name = p_period_name;
329:

Line 343: , gl_periods gp

339: INTO l_period_year
340: , l_period_num
341: , l_first_fiscal_period_flag
342: FROM gl_ledgers led
343: , gl_periods gp
344: WHERE led.ledger_id=p_ledger_id
345: AND led.period_set_name = gp.period_set_name
346: AND gp.period_name = p_period_name;
347:

Line 2855: , */gl_periods gp

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
2854: FROM /*JA_CN_JOURNAL_LINES jjl
2855: , */gl_periods gp
2856: , gl_ledgers led
2857: WHERE /*jjl.ledger_id = p_ledger_id
2858: AND jjl.legal_entity_id = p_legal_entity_ID
2859: AND jjl.status = 'U'

Line 3014: FROM gl_periods gp

3010: SELECT gp.period_year
3011: , gp.period_num
3012: INTO l_period_year
3013: , l_period_num
3014: FROM gl_periods gp
3015: , gl_ledgers led
3016: WHERE gp.period_name=p_period_name
3017: AND gp.period_set_name=led.period_set_name
3018: AND led.ledger_id=p_ledger_id;