1 PACKAGE JL_BR_CALCBAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlbrcbls.pls 120.0 2008/10/23 12:13:56 nivnaray noship $ */
3
4 TYPE appl_id_type is table of jl_br_balances.application_id%TYPE index by BINARY_INTEGER;
5 TYPE sob_id_type is table of jl_br_balances.set_of_books_id%TYPE index by BINARY_INTEGER;
6 TYPE period_set_name_type is table of jl_br_balances.period_set_name%TYPE index by BINARY_INTEGER;
7 TYPE period_name_type is table of jl_br_balances.period_name%TYPE index by BINARY_INTEGER;
8 TYPE period_year_type is table of jl_br_balances.period_year%TYPE index by BINARY_INTEGER;
9 TYPE period_num_type is table of jl_br_balances.period_num%TYPE index by BINARY_INTEGER;
10 TYPE ccid_type is table of jl_br_balances.code_combination_id%TYPE index by BINARY_INTEGER;
11 TYPE personnel_id_type is table of jl_br_balances.personnel_id%TYPE index by BINARY_INTEGER;
12 TYPE end_bal_sign_type is table of jl_br_balances.ending_balance_sign%TYPE index by BINARY_INTEGER;
13 TYPE end_bal_type is table of jl_br_balances.ending_balance%TYPE index by BINARY_INTEGER;
14 TYPE bal_error_flag_type is table of jl_br_balances.balance_error_flag%TYPE index by BINARY_INTEGER;
15 TYPE org_id_type is table of jl_br_balances.org_id%TYPE index by BINARY_INTEGER;
16
17 Procedure Update_Balances(errbuf Out NOCOPY VARCHAR2
18 ,retcode Out NOCOPY NUMBER
19 ,p_appl_id In NUMBER);
20
21 -- Datafix Routine
22 Procedure Rebuild_Balances(errbuf Out NOCOPY VARCHAR2
23 ,retcode Out NOCOPY NUMBER
24 ,p_appl_id In NUMBER
25 ,p_org_id In NUMBER
26 ,p_sob_id In NUMBER
27 ,p_initial_period In VARCHAR2
28 ,p_last_period In VARCHAR2
29 ,p_vendor_id In NUMBER);
30
31 END JL_BR_CALCBAL_PKG;