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.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_PERIODS

Line 4: g_period_set_name gl_periods.period_set_name%TYPE;

1: PACKAGE BODY jl_co_gl_nit_management AS
2: /* $Header: jlcoglbb.pls 120.23.12010000.7 2008/08/29 06:02:43 vspuli ship $ */
3:
4: g_period_set_name gl_periods.period_set_name%TYPE;
5: g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;
6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_period_year gl_periods.period_year%TYPE;

Line 7: g_period_num gl_periods.period_num%TYPE;

3:
4: g_period_set_name gl_periods.period_set_name%TYPE;
5: g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;
6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_period_year gl_periods.period_year%TYPE;
9: g_func_currency gl_sets_of_books.currency_code%TYPE;
10: g_default_nit_id jl_co_gl_nits.nit_id%TYPE;
11: g_login_id jl_co_gl_trx.last_update_login%TYPE;

Line 8: g_period_year gl_periods.period_year%TYPE;

4: g_period_set_name gl_periods.period_set_name%TYPE;
5: g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;
6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_period_year gl_periods.period_year%TYPE;
9: g_func_currency gl_sets_of_books.currency_code%TYPE;
10: g_default_nit_id jl_co_gl_nits.nit_id%TYPE;
11: g_login_id jl_co_gl_trx.last_update_login%TYPE;
12:

Line 1762: l_period_set_name gl_periods.period_set_name%TYPE;

1758: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;
1764:
1765: -- right now the currency field in jl_co_gl_balances only holds
1766: -- functional_currency_code. But in the future if the functionality

Line 1763: l_max_period_num gl_periods.period_num%TYPE;

1759: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
1760: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
1761: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
1762: l_period_set_name gl_periods.period_set_name%TYPE;
1763: l_max_period_num gl_periods.period_num%TYPE;
1764:
1765: -- right now the currency field in jl_co_gl_balances only holds
1766: -- functional_currency_code. But in the future if the functionality
1767: -- is changed to hold balances for multiple currencies then curreny_code

Line 2050: FROM gl_periods

2046: WHERE jlcgb.set_of_books_id = trx.sobid
2047: AND jlcgb.nit_id = trx.nitid
2048: AND jlcgb.code_combination_id = trx.ccid
2049: AND jlcgb.period_name IN (SELECT period_name
2050: FROM gl_periods
2051: WHERE period_set_name = g_period_set_name
2052: AND (period_year * 100 + period_num) >=
2053: (trx.peryear * 100 + trx.pernum)
2054: AND period_year BETWEEN trx.peryear AND

Line 2243: FROM gl_periods

2239: SELECT period_num,
2240: period_year
2241: INTO g_period_num,
2242: g_period_year
2243: FROM gl_periods
2244: WHERE period_set_name = g_period_set_name
2245: AND period_name = p_period;
2246: END IF;
2247: