APPS.OKL_AM_LOAD_CAT_BK_PVT dependencies on FA_BOOK_CONTROLS

Line 20: p_book_type_code IN fa_book_controls.book_type_code%TYPE,

16:
17:
18: PROCEDURE create_hold_setup_trx( p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
20: p_book_type_code IN fa_book_controls.book_type_code%TYPE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: x_amhv_tbl OUT NOCOPY amhv_tbl_type

Line 41: CURSOR l_facatbookdef_csr(p_book_type_code fa_book_controls.book_type_code%TYPE) IS

37: l_api_version CONSTANT NUMBER := 1;
38: l_api_name CONSTANT VARCHAR2(30) := 'create_hold_setup_trx';
39:
40: -- This cursor selects all unique combinations of category_id and book_type_code from fa_category_book_defaults
41: CURSOR l_facatbookdef_csr(p_book_type_code fa_book_controls.book_type_code%TYPE) IS
42: -- SECHAWLA 05-MAY-04 3578894 : fetch category/book combinations for both corporate and tax books
43: SELECT DISTINCT fac.category_id, fac.book_type_code
44: FROM fa_category_book_defaults fac, fa_book_controls fbc
45: WHERE fac.book_type_code = fbc.book_type_code AND fbc.book_class IN ('CORPORATE','TAX')

Line 44: FROM fa_category_book_defaults fac, fa_book_controls fbc

40: -- This cursor selects all unique combinations of category_id and book_type_code from fa_category_book_defaults
41: CURSOR l_facatbookdef_csr(p_book_type_code fa_book_controls.book_type_code%TYPE) IS
42: -- SECHAWLA 05-MAY-04 3578894 : fetch category/book combinations for both corporate and tax books
43: SELECT DISTINCT fac.category_id, fac.book_type_code
44: FROM fa_category_book_defaults fac, fa_book_controls fbc
45: WHERE fac.book_type_code = fbc.book_type_code AND fbc.book_class IN ('CORPORATE','TAX')
46: AND fbc.distribution_source_book = NVL(p_book_type_code, fbc.distribution_source_book);
47:
48: -- This cursor is used to check if the unique combination of category_id and book_type_code from