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.52.12020000.10 2013/03/26 09:42:53 mbarrett 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 2623: l_period_set_name gl_periods.period_set_name%TYPE;

2619: l_period_net_dr_prior_period jl_co_gl_balances.period_net_dr%TYPE;
2620: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
2621: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
2622: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
2623: l_period_set_name gl_periods.period_set_name%TYPE;
2624: l_max_period_num gl_periods.period_num%TYPE;
2625:
2626: -- right now the currency field in jl_co_gl_balances only holds
2627: -- functional_currency_code. But in the future if the functionality

Line 2624: l_max_period_num gl_periods.period_num%TYPE;

2620: l_period_net_cr_prior_period jl_co_gl_balances.period_net_cr%TYPE;
2621: l_begin_bal_dr jl_co_gl_balances.begin_balance_dr%TYPE;
2622: l_begin_bal_cr jl_co_gl_balances.begin_balance_cr%TYPE;
2623: l_period_set_name gl_periods.period_set_name%TYPE;
2624: l_max_period_num gl_periods.period_num%TYPE;
2625:
2626: -- right now the currency field in jl_co_gl_balances only holds
2627: -- functional_currency_code. But in the future if the functionality
2628: -- is changed to hold balances for multiple currencies then curreny_code

Line 2910: FROM gl_periods

2906: WHERE jlcgb.set_of_books_id = trx.sobid
2907: AND jlcgb.nit_id = trx.nitid
2908: AND jlcgb.code_combination_id = trx.ccid
2909: AND jlcgb.period_name IN (SELECT period_name
2910: FROM gl_periods
2911: WHERE period_set_name = g_period_set_name
2912: AND (period_year * 100 + period_num) >=
2913: (trx.peryear * 100 + trx.pernum)
2914: AND period_year BETWEEN trx.peryear AND

Line 3114: FROM gl_periods

3110: SELECT period_num,
3111: period_year
3112: INTO g_period_num,
3113: g_period_year
3114: FROM gl_periods
3115: WHERE period_set_name = g_period_set_name
3116: AND period_name = p_period;
3117: END IF;
3118: