APPS.JA_CN_POST_UTILITY_PKG dependencies on GL_PERIODS

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

140: )
141: IS
142: l_procedure_name VARCHAR2(30):='open_period';
143: l_row_count NUMBER;
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;

Line 147: l_period_year gl_periods.period_year%TYPE;

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

Line 150: l_prior_period_name gl_periods.period_name%TYPE;

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

Line 288: , gl_periods gp

284: , SYSDATE
285: , fnd_global.USER_ID
286: , fnd_global.LOGIN_ID
287: FROM gl_ledgers led
288: , gl_periods gp
289: WHERE led.ledger_id=p_ledger_id
290: AND led.period_set_name = gp.period_set_name
291: AND gp.period_name = p_period_name;
292:

Line 306: , gl_periods gp

302: INTO l_period_year
303: , l_period_num
304: , l_first_fiscal_period_flag
305: FROM gl_ledgers led
306: , gl_periods gp
307: WHERE led.ledger_id=p_ledger_id
308: AND led.period_set_name = gp.period_set_name
309: AND gp.period_name = p_period_name;
310:

Line 1804: , */gl_periods gp

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
1803: FROM /*JA_CN_JOURNAL_LINES jjl
1804: , */gl_periods gp
1805: , gl_ledgers led
1806: WHERE /*jjl.ledger_id = p_ledger_id
1807: AND jjl.legal_entity_id = p_legal_entity_ID
1808: AND jjl.status = 'U'

Line 1899: FROM gl_periods gp

1895: SELECT gp.period_year
1896: , gp.period_num
1897: INTO l_period_year
1898: , l_period_num
1899: FROM gl_periods gp
1900: , gl_ledgers led
1901: WHERE gp.period_name=p_period_name
1902: AND gp.period_set_name=led.period_set_name
1903: AND led.ledger_id=p_ledger_id;