APPS.OKL_AM_LOAD_CAT_BK_PVT dependencies on OKL_AMORT_HOLD_SETUPS

Line 9: -- okl_amort_hold_setups_v. Before loading the data into okl_amort_hold_setups_v, API

5: --
6: -- Procedure Name : create_hold_setup_trx
7: -- Description : The main body of the package. This procedure finds all the unique combinations of
8: -- category_id and book_type_code from fa_category_book_defaults and loads them into
9: -- okl_amort_hold_setups_v. Before loading the data into okl_amort_hold_setups_v, API
10: -- queries this view to make sure that the category and book type code combination
11: -- does not already exist.
12: -- Business Rules :
13: -- Version : 1.0

Line 49: -- fa_category_book_defaults already exists in okl_amort_hold_setups_v

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
49: -- fa_category_book_defaults already exists in okl_amort_hold_setups_v
50: CURSOR l_amortholdsetup_csr(p_id number, p_code varchar2) IS
51: SELECT 'x'
52: FROM OKL_AMORT_HOLD_SETUPS
53: WHERE category_id = p_id

Line 52: FROM OKL_AMORT_HOLD_SETUPS

48: -- This cursor is used to check if the unique combination of category_id and book_type_code from
49: -- fa_category_book_defaults already exists in okl_amort_hold_setups_v
50: CURSOR l_amortholdsetup_csr(p_id number, p_code varchar2) IS
51: SELECT 'x'
52: FROM OKL_AMORT_HOLD_SETUPS
53: WHERE category_id = p_id
54: AND book_type_code = p_code;
55:
56:

Line 78: -- those rows don't already exist in okl_amort_hold_setups_v

74:
75: i := 0;
76:
77: -- loop thru all the rows from cursor l_facatbookdef_csr and put them in the table lp_amhv_tbl if
78: -- those rows don't already exist in okl_amort_hold_setups_v
79: FOR l_facatbookdef_rec IN l_facatbookdef_csr(p_book_type_code) LOOP
80: OPEN l_amortholdsetup_csr(l_facatbookdef_rec.category_id, l_facatbookdef_rec.book_type_code);
81: FETCH l_amortholdsetup_csr INTO l_dummy;
82:

Line 96: okl_amort_hold_setups_pub.insert_amort_hold_setups(

92: END LOOP;
93:
94:
95: IF (lp_amhv_tbl.COUNT > 0 ) THEN
96: okl_amort_hold_setups_pub.insert_amort_hold_setups(
97: p_api_version => 1.0
98: ,p_init_msg_list => FND_API.G_FALSE
99: ,x_return_status => x_return_status
100: ,x_msg_count => x_msg_count