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_BR_CALCBAL_PKG dependencies on GL_PERIODS

Line 55: l_min_period_year gl_periods.period_year%TYPE;

51: r_bal_error_flag_tbl bal_error_flag_type;
52:
53: l_user NUMBER := fnd_global.user_id;
54: l_login_id NUMBER := fnd_global.login_id;
55: l_min_period_year gl_periods.period_year%TYPE;
56: l_min_period_num gl_periods.period_num%TYPE;
57: l_min_period_ctr NUMBER;
58: l_max_period_year gl_periods.period_year%TYPE;
59: l_max_period_num gl_periods.period_num%TYPE;

Line 56: l_min_period_num gl_periods.period_num%TYPE;

52:
53: l_user NUMBER := fnd_global.user_id;
54: l_login_id NUMBER := fnd_global.login_id;
55: l_min_period_year gl_periods.period_year%TYPE;
56: l_min_period_num gl_periods.period_num%TYPE;
57: l_min_period_ctr NUMBER;
58: l_max_period_year gl_periods.period_year%TYPE;
59: l_max_period_num gl_periods.period_num%TYPE;
60: l_max_period_ctr NUMBER;

Line 58: l_max_period_year gl_periods.period_year%TYPE;

54: l_login_id NUMBER := fnd_global.login_id;
55: l_min_period_year gl_periods.period_year%TYPE;
56: l_min_period_num gl_periods.period_num%TYPE;
57: l_min_period_ctr NUMBER;
58: l_max_period_year gl_periods.period_year%TYPE;
59: l_max_period_num gl_periods.period_num%TYPE;
60: l_max_period_ctr NUMBER;
61: l_max_bal_perctr NUMBER;
62: l_api_name CONSTANT VARCHAR2(30) := 'Update_Balances';

Line 59: l_max_period_num gl_periods.period_num%TYPE;

55: l_min_period_year gl_periods.period_year%TYPE;
56: l_min_period_num gl_periods.period_num%TYPE;
57: l_min_period_ctr NUMBER;
58: l_max_period_year gl_periods.period_year%TYPE;
59: l_max_period_num gl_periods.period_num%TYPE;
60: l_max_period_ctr NUMBER;
61: l_max_bal_perctr NUMBER;
62: l_api_name CONSTANT VARCHAR2(30) := 'Update_Balances';
63:

Line 76: ,gl_periods gp

72: ,min((gp.period_year * 10000) + gp.period_num) min_jrl_perctr
73: ,max((gp.period_year * 10000) + gp.period_num) max_jrl_perctr
74: FROM jl_br_journals jl
75: ,gl_sets_of_books sb
76: ,gl_periods gp
77: WHERE jl.application_id = p_appl_id
78: AND nvl(jl.journal_balance_flag,'N') = 'N'
79: AND sb.set_of_books_id = jl.set_of_books_id
80: AND sb.period_set_name = jl.period_set_name

Line 102: ,p_period_type In gl_periods.period_type%Type

98: AND jb.code_combination_id = p_ccid
99: AND jb.period_set_name = p_set_name;
100:
101: CURSOR C_Period_Balances(p_set_name In jl_br_balances.period_set_name%Type
102: ,p_period_type In gl_periods.period_type%Type
103: ,p_min_per_ctr In NUMBER
104: ,p_max_per_ctr In NUMBER
105: ,p_appl_id In jl_br_balances.application_id%Type
106: ,p_sob_id In jl_br_balances.set_of_books_id%Type

Line 120: FROM gl_periods gp

116: ,nvl(gp.period_num,gp.period_num) pernum
117: ,((gp.period_year*10000) + gp.period_num) perctr
118: ,decode(jb.ending_balance_sign, 'D', -1 * nvl(jb.ending_balance,0), nvl(jb.ending_balance, 0)) ending_balance
119: ,nvl(jb.ending_balance_sign,'N') ending_balance_sign
120: FROM gl_periods gp
121: ,jl_br_balances jb
122: WHERE gp.period_set_name = p_set_name
123: AND gp.period_type = p_period_type
124: AND ((gp.period_year*10000)+ gp.period_num) between p_min_per_ctr and p_max_per_ctr

Line 438: l_min_period_year gl_periods.period_year%TYPE;

434:
435: l_user NUMBER := fnd_global.user_id;
436: l_login_id NUMBER := fnd_global.login_id;
437:
438: l_min_period_year gl_periods.period_year%TYPE;
439: l_min_period_num gl_periods.period_num%TYPE;
440: l_min_period_ctr NUMBER;
441: l_max_period_year gl_periods.period_year%TYPE;
442: l_max_period_num gl_periods.period_num%TYPE;

Line 439: l_min_period_num gl_periods.period_num%TYPE;

435: l_user NUMBER := fnd_global.user_id;
436: l_login_id NUMBER := fnd_global.login_id;
437:
438: l_min_period_year gl_periods.period_year%TYPE;
439: l_min_period_num gl_periods.period_num%TYPE;
440: l_min_period_ctr NUMBER;
441: l_max_period_year gl_periods.period_year%TYPE;
442: l_max_period_num gl_periods.period_num%TYPE;
443: l_max_period_ctr NUMBER;

Line 441: l_max_period_year gl_periods.period_year%TYPE;

437:
438: l_min_period_year gl_periods.period_year%TYPE;
439: l_min_period_num gl_periods.period_num%TYPE;
440: l_min_period_ctr NUMBER;
441: l_max_period_year gl_periods.period_year%TYPE;
442: l_max_period_num gl_periods.period_num%TYPE;
443: l_max_period_ctr NUMBER;
444: l_initial_balance jl_br_balances.ending_balance%TYPE;
445:

Line 442: l_max_period_num gl_periods.period_num%TYPE;

438: l_min_period_year gl_periods.period_year%TYPE;
439: l_min_period_num gl_periods.period_num%TYPE;
440: l_min_period_ctr NUMBER;
441: l_max_period_year gl_periods.period_year%TYPE;
442: l_max_period_num gl_periods.period_num%TYPE;
443: l_max_period_ctr NUMBER;
444: l_initial_balance jl_br_balances.ending_balance%TYPE;
445:
446: l_api_name CONSTANT VARCHAR2(30) := 'Rebuild_Balances';

Line 463: ,p_period_name In gl_periods.period_name%TYPE) Is

459: WHERE sb.set_of_books_id = jl_sob.set_of_books_id;
460:
461: CURSOR C_Period_Ctr(p_period_set_name In gl_sets_of_books.period_set_name%TYPE
462: ,p_period_type In gl_sets_of_books.accounted_period_type%TYPE
463: ,p_period_name In gl_periods.period_name%TYPE) Is
464: SELECT period_year peryear
465: ,period_num pernum
466: ,((period_year * 10000) + period_num) perctr
467: FROM gl_periods

Line 467: FROM gl_periods

463: ,p_period_name In gl_periods.period_name%TYPE) Is
464: SELECT period_year peryear
465: ,period_num pernum
466: ,((period_year * 10000) + period_num) perctr
467: FROM gl_periods
468: WHERE period_set_name = p_period_set_name
469: AND period_type = p_period_type
470: AND period_name = p_period_name;
471:

Line 495: CURSOR C_PERIODS(p_set_name In gl_periods.period_set_name%Type

491: AND jb.set_of_books_id = cp_sob_id
492: AND jb.personnel_id = nvl(p_vendor_id, jb.personnel_id)
493: GROUP BY jb.application_id, jb.org_id, jb.personnel_id, jb.code_combination_id;
494:
495: CURSOR C_PERIODS(p_set_name In gl_periods.period_set_name%Type
496: ,p_period_type In gl_periods.period_type%Type
497: ,p_min_per_ctr In NUMBER
498: ,p_max_per_ctr In NUMBER) Is
499: SELECT gp.period_set_name persetname

Line 496: ,p_period_type In gl_periods.period_type%Type

492: AND jb.personnel_id = nvl(p_vendor_id, jb.personnel_id)
493: GROUP BY jb.application_id, jb.org_id, jb.personnel_id, jb.code_combination_id;
494:
495: CURSOR C_PERIODS(p_set_name In gl_periods.period_set_name%Type
496: ,p_period_type In gl_periods.period_type%Type
497: ,p_min_per_ctr In NUMBER
498: ,p_max_per_ctr In NUMBER) Is
499: SELECT gp.period_set_name persetname
500: ,gp.period_name pername

Line 503: FROM gl_periods gp

499: SELECT gp.period_set_name persetname
500: ,gp.period_name pername
501: ,gp.period_year peryear
502: ,gp.period_num pernum
503: FROM gl_periods gp
504: WHERE gp.period_set_name = p_set_name
505: AND gp.period_type = p_period_type
506: AND ((gp.period_year*10000)+ gp.period_num) between p_min_per_ctr and p_max_per_ctr
507: AND gp.adjustment_period_flag = 'N'