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;
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;
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;
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;
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;
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;
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;
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;
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:
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
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
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);