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 JL_BR_BALANCES

Line 87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type

83: AND gp.period_name = jl.period_name
84: GROUP BY jl.application_id, jl.org_id, jl.set_of_books_id, jl.personnel_id,
85: jl.code_combination_id, jl.period_set_name, gp.period_type;
86:
87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type
88: ,p_sob In jl_br_balances.set_of_books_id%Type
89: ,p_vendor_id In jl_br_balances.personnel_id%Type
90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is

Line 88: ,p_sob In jl_br_balances.set_of_books_id%Type

84: GROUP BY jl.application_id, jl.org_id, jl.set_of_books_id, jl.personnel_id,
85: jl.code_combination_id, jl.period_set_name, gp.period_type;
86:
87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type
88: ,p_sob In jl_br_balances.set_of_books_id%Type
89: ,p_vendor_id In jl_br_balances.personnel_id%Type
90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is
92: SELECT min((period_year * 10000) + period_num) min_bal_perctr

Line 89: ,p_vendor_id In jl_br_balances.personnel_id%Type

85: jl.code_combination_id, jl.period_set_name, gp.period_type;
86:
87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type
88: ,p_sob In jl_br_balances.set_of_books_id%Type
89: ,p_vendor_id In jl_br_balances.personnel_id%Type
90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is
92: SELECT min((period_year * 10000) + period_num) min_bal_perctr
93: ,max((period_year * 10000) + period_num) max_bal_perctr

Line 90: ,p_ccid In jl_br_balances.code_combination_id%Type

86:
87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type
88: ,p_sob In jl_br_balances.set_of_books_id%Type
89: ,p_vendor_id In jl_br_balances.personnel_id%Type
90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is
92: SELECT min((period_year * 10000) + period_num) min_bal_perctr
93: ,max((period_year * 10000) + period_num) max_bal_perctr
94: FROM jl_br_balances jb

Line 91: ,p_set_name In jl_br_balances.period_set_name%Type) Is

87: CURSOR C_Bal_Periods(p_appl_id In jl_br_balances.application_id%Type
88: ,p_sob In jl_br_balances.set_of_books_id%Type
89: ,p_vendor_id In jl_br_balances.personnel_id%Type
90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is
92: SELECT min((period_year * 10000) + period_num) min_bal_perctr
93: ,max((period_year * 10000) + period_num) max_bal_perctr
94: FROM jl_br_balances jb
95: WHERE jb.application_id = p_appl_id

Line 94: FROM jl_br_balances jb

90: ,p_ccid In jl_br_balances.code_combination_id%Type
91: ,p_set_name In jl_br_balances.period_set_name%Type) Is
92: SELECT min((period_year * 10000) + period_num) min_bal_perctr
93: ,max((period_year * 10000) + period_num) max_bal_perctr
94: FROM jl_br_balances jb
95: WHERE jb.application_id = p_appl_id
96: AND jb.set_of_books_id = p_sob
97: AND jb.personnel_id = p_vendor_id
98: AND jb.code_combination_id = p_ccid

Line 101: CURSOR C_Period_Balances(p_set_name In jl_br_balances.period_set_name%Type

97: AND jb.personnel_id = p_vendor_id
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

Line 105: ,p_appl_id In jl_br_balances.application_id%Type

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
107: ,p_vendor_id In jl_br_balances.personnel_id%Type
108: ,p_ccid In jl_br_balances.code_combination_id%Type) Is
109: SELECT nvl(jb.application_id, p_appl_id) appl_id

Line 106: ,p_sob_id In jl_br_balances.set_of_books_id%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
107: ,p_vendor_id In jl_br_balances.personnel_id%Type
108: ,p_ccid In jl_br_balances.code_combination_id%Type) Is
109: SELECT nvl(jb.application_id, p_appl_id) appl_id
110: ,nvl(jb.set_of_books_id, p_sob_id) sob_id

Line 107: ,p_vendor_id In jl_br_balances.personnel_id%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
107: ,p_vendor_id In jl_br_balances.personnel_id%Type
108: ,p_ccid In jl_br_balances.code_combination_id%Type) Is
109: SELECT nvl(jb.application_id, p_appl_id) appl_id
110: ,nvl(jb.set_of_books_id, p_sob_id) sob_id
111: ,nvl(jb.personnel_id, p_vendor_id) vendor_id

Line 108: ,p_ccid In jl_br_balances.code_combination_id%Type) Is

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
107: ,p_vendor_id In jl_br_balances.personnel_id%Type
108: ,p_ccid In jl_br_balances.code_combination_id%Type) Is
109: SELECT nvl(jb.application_id, p_appl_id) appl_id
110: ,nvl(jb.set_of_books_id, p_sob_id) sob_id
111: ,nvl(jb.personnel_id, p_vendor_id) vendor_id
112: ,nvl(jb.code_combination_id, p_ccid) ccid

Line 121: ,jl_br_balances jb

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
125: AND gp.adjustment_period_flag = 'N'

Line 134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type

130: AND jb.period_set_name(+) = gp.period_set_name
131: AND jb.period_name(+) = gp.period_name
132: ORDER BY ((gp.period_year*10000)+ gp.period_num);
133:
134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type
135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type

Line 135: ,p_sob_id In jl_br_balances.set_of_books_id%Type

131: AND jb.period_name(+) = gp.period_name
132: ORDER BY ((gp.period_year*10000)+ gp.period_num);
133:
134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type
135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is

Line 136: ,p_vendor_id In jl_br_balances.personnel_id%Type

132: ORDER BY ((gp.period_year*10000)+ gp.period_num);
133:
134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type
135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is
140: SELECT

Line 137: ,p_ccid In jl_br_balances.code_combination_id%Type

133:
134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type
135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is
140: SELECT
141: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance

Line 138: ,p_set_name In jl_br_balances.period_set_name%Type

134: CURSOR C_Journals(p_appl_id In jl_br_balances.application_id%Type
135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is
140: SELECT
141: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
142: FROM jl_br_journals jb

Line 139: ,p_name In jl_br_balances.period_name%Type) Is

135: ,p_sob_id In jl_br_balances.set_of_books_id%Type
136: ,p_vendor_id In jl_br_balances.personnel_id%Type
137: ,p_ccid In jl_br_balances.code_combination_id%Type
138: ,p_set_name In jl_br_balances.period_set_name%Type
139: ,p_name In jl_br_balances.period_name%Type) Is
140: SELECT
141: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
142: FROM jl_br_journals jb
143: WHERE jb.application_id = p_appl_id

Line 268: Delete From jl_br_balances

264: ,l_old_end_bal_tbl
265: ,l_old_end_bal_sign_tbl;
266: Close C_Period_Balances;
267:
268: Delete From jl_br_balances
269: Where application_id = PersonnelCCID_Rec.appl_id
270: and set_of_books_id = PersonnelCCID_Rec.sob_id
271: and personnel_id = PersonnelCCID_Rec.vendor_id
272: and code_combination_id = PersonnelCCID_Rec.ccid

Line 335: Insert Into jl_br_balances_all

331: End If; -- End of the array count condition
332:
333: -- Insert New Computed Balances since old balances were deleted
334: Forall k in l_period_num_tbl.First .. l_period_num_tbl.Last
335: Insert Into jl_br_balances_all
336: (application_id
337: ,set_of_books_id
338: ,period_set_name
339: ,period_name

Line 444: l_initial_balance jl_br_balances.ending_balance%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';
447:
448: l_invalid_initial_period EXCEPTION;

Line 472: CURSOR C_PersonnelCCID(cp_sob_id In jl_br_balances.set_of_books_id%Type) Is

468: WHERE period_set_name = p_period_set_name
469: AND period_type = p_period_type
470: AND period_name = p_period_name;
471:
472: CURSOR C_PersonnelCCID(cp_sob_id In jl_br_balances.set_of_books_id%Type) Is
473: SELECT jl.application_id appl_id
474: ,jl.org_id
475: ,jl.personnel_id vendor_id
476: ,jl.code_combination_id ccid

Line 488: FROM jl_br_balances_all jb

484: SELECT jb.application_id appl_id
485: ,jb.org_id
486: ,jb.personnel_id vendor_id
487: ,jb.code_combination_id ccid
488: FROM jl_br_balances_all jb
489: WHERE jb.application_id = nvl(p_appl_id, jb.application_id)
490: AND jb.org_id = nvl(p_org_id, jb.org_id)
491: AND jb.set_of_books_id = cp_sob_id
492: AND jb.personnel_id = nvl(p_vendor_id, jb.personnel_id)

Line 510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%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'
508: ORDER BY ((gp.period_year*10000)+ gp.period_num);
509:
510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%Type
511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type

Line 511: ,cp_org_id In jl_br_balances.org_id%Type

507: AND gp.adjustment_period_flag = 'N'
508: ORDER BY ((gp.period_year*10000)+ gp.period_num);
509:
510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%Type
511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type

Line 512: ,cp_sob In jl_br_balances.set_of_books_id%Type

508: ORDER BY ((gp.period_year*10000)+ gp.period_num);
509:
510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%Type
511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type
516: ,cp_name In jl_br_balances.period_name%Type) Is

Line 513: ,cp_vendor_id In jl_br_balances.personnel_id%Type

509:
510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%Type
511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type
516: ,cp_name In jl_br_balances.period_name%Type) Is
517: SELECT

Line 514: ,cp_ccid In jl_br_balances.code_combination_id%Type

510: CURSOR C_Initial_Bal(cp_appl_id In jl_br_balances.application_id%Type
511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type
516: ,cp_name In jl_br_balances.period_name%Type) Is
517: SELECT
518: NVL(sum(decode(ending_balance_sign,'D', -1 * ending_balance,

Line 515: ,cp_set_name In jl_br_balances.period_set_name%Type

511: ,cp_org_id In jl_br_balances.org_id%Type
512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type
516: ,cp_name In jl_br_balances.period_name%Type) Is
517: SELECT
518: NVL(sum(decode(ending_balance_sign,'D', -1 * ending_balance,
519: ending_balance)),0) ending_balance

Line 516: ,cp_name In jl_br_balances.period_name%Type) Is

512: ,cp_sob In jl_br_balances.set_of_books_id%Type
513: ,cp_vendor_id In jl_br_balances.personnel_id%Type
514: ,cp_ccid In jl_br_balances.code_combination_id%Type
515: ,cp_set_name In jl_br_balances.period_set_name%Type
516: ,cp_name In jl_br_balances.period_name%Type) Is
517: SELECT
518: NVL(sum(decode(ending_balance_sign,'D', -1 * ending_balance,
519: ending_balance)),0) ending_balance
520: FROM jl_br_balances_all jb

Line 520: FROM jl_br_balances_all jb

516: ,cp_name In jl_br_balances.period_name%Type) Is
517: SELECT
518: NVL(sum(decode(ending_balance_sign,'D', -1 * ending_balance,
519: ending_balance)),0) ending_balance
520: FROM jl_br_balances_all jb
521: WHERE jb.application_id = cp_appl_id
522: AND jb.org_id = cp_org_id
523: AND jb.set_of_books_id = cp_sob
524: AND jb.personnel_id = cp_vendor_id

Line 529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type

525: AND jb.code_combination_id = cp_ccid
526: AND jb.period_set_name = cp_set_name
527: AND jb.period_name = cp_name;
528:
529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type
530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type

Line 530: ,cp_org_id In jl_br_balances.org_id%Type

526: AND jb.period_set_name = cp_set_name
527: AND jb.period_name = cp_name;
528:
529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type
530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type

Line 531: ,cp_sob In jl_br_balances.set_of_books_id%Type

527: AND jb.period_name = cp_name;
528:
529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type
530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is

Line 532: ,cp_vendor_id In jl_br_balances.personnel_id%Type

528:
529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type
530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is
536: SELECT

Line 533: ,cp_ccid In jl_br_balances.code_combination_id%Type

529: CURSOR C_Journals(cp_appl_id In jl_br_balances.application_id%Type
530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is
536: SELECT
537: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance

Line 534: ,cp_set_name In jl_br_balances.period_set_name%Type

530: ,cp_org_id In jl_br_balances.org_id%Type
531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is
536: SELECT
537: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
538: FROM jl_br_journals_all jb

Line 535: ,cp_name In jl_br_balances.period_name%Type) Is

531: ,cp_sob In jl_br_balances.set_of_books_id%Type
532: ,cp_vendor_id In jl_br_balances.personnel_id%Type
533: ,cp_ccid In jl_br_balances.code_combination_id%Type
534: ,cp_set_name In jl_br_balances.period_set_name%Type
535: ,cp_name In jl_br_balances.period_name%Type) Is
536: SELECT
537: NVL(SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)),0) balance
538: FROM jl_br_journals_all jb
539: WHERE jb.application_id = cp_appl_id

Line 629: Delete from JL_BR_BALANCES_ALL

625: End If;
626:
627: -- Purge the Balances Tables
628:
629: Delete from JL_BR_BALANCES_ALL
630: Where application_id = nvl(p_appl_id, application_id)
631: and org_id = nvl(p_org_id, org_id)
632: and set_of_books_id = Sob_Rec.sob_id
633: and ((period_year*10000) + period_num) > l_min_period_ctr

Line 732: Insert Into jl_br_balances_all

728: End Loop; -- End Loop of Periods Table
729:
730: -- Insert Balances
731: Forall j in l_period_num_tbl.First .. l_period_num_tbl.Last
732: Insert Into jl_br_balances_all
733: (application_id
734: ,set_of_books_id
735: ,period_set_name
736: ,period_name