DBA Data[Home] [Help]

APPS.JL_BR_CALCBAL_PKG dependencies on JL_BR_BALANCES

Line 4: TYPE appl_id_type is table of jl_br_balances.application_id%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;

Line 5: TYPE sob_id_type is table of jl_br_balances.set_of_books_id%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;

Line 6: TYPE period_set_name_type is table of jl_br_balances.period_set_name%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;

Line 7: TYPE period_name_type is table of jl_br_balances.period_name%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;

Line 8: TYPE period_year_type is table of jl_br_balances.period_year%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;

Line 9: TYPE period_num_type is table of jl_br_balances.period_num%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;

Line 10: TYPE ccid_type is table of jl_br_balances.code_combination_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;

Line 11: TYPE personnel_id_type is table of jl_br_balances.personnel_id%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;

Line 12: TYPE end_bal_sign_type is table of jl_br_balances.ending_balance_sign%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:

Line 13: TYPE end_bal_type is table of jl_br_balances.ending_balance%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

Line 14: TYPE bal_error_flag_type is table of jl_br_balances.balance_error_flag%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

Line 15: TYPE org_id_type is table of jl_br_balances.org_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);