eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_SYSTEM_PARAMS_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 7: -- Description : procedure to create or update rec in OKL_SYSTEM_PARAMS_ALL_V

3:
4: -- Start of comments
5: --
6: -- Procedure Name : process_system_params
7: -- Description : procedure to create or update rec in OKL_SYSTEM_PARAMS_ALL_V
8: -- Business Rules :
9: -- Parameters :
10: -- Version : 1.0
11: -- History : RMUNJULU Created

Line 30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;

26:
27:
28: -- DJANASWA Bug 6653304 start Proj: Asset Repo for a Loan
29:
30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;

Line 31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;

27:
28: -- DJANASWA Bug 6653304 start Proj: Asset Repo for a Loan
29:
30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;

Line 32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;

28: -- DJANASWA Bug 6653304 start Proj: Asset Repo for a Loan
29:
30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

Line 33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;

29:
30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

Line 34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;

30: l_tax_book_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

Line 35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;

31: l_tax_book_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:

Line 36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;

32: l_fa_location_id OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type;
33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;

Line 40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;

36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
43:
44: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;

37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
43:
44: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
45:

Line 95: -- Added validations for the new columns added to the table okl_system_params_all.

91:
92:
93:
94: -- DJANASWA Bug 6653304 start Proj: Asset Repo for a Loan
95: -- Added validations for the new columns added to the table okl_system_params_all.
96: -- 1. If any one or more of the following fields has values: Tax Asset Book 1, Tax Asset Book 2,
97: -- Asset Key, Fixed Asset Location, Asset Cost Formula
98: -- then ensure that all of the following fields have values:
99: -- Asset Addition Corporate Book, Tax Asset Book 1, Fixed Asset Location

Line 405: OKL_SYSTEM_PARAMS_ALL_PUB.insert_system_parameters(

401: -- If no id passed then insert else update
402: IF p_sypv_rec.id IS NULL OR p_sypv_rec.id = G_MISS_NUM THEN
403:
404: -- Call TAPI insert
405: OKL_SYSTEM_PARAMS_ALL_PUB.insert_system_parameters(
406: p_api_version => p_api_version,
407: p_init_msg_list => G_FALSE,
408: x_return_status => l_return_status,
409: x_msg_count => x_msg_count,

Line 423: OKL_SYSTEM_PARAMS_ALL_PUB.update_system_parameters(

419: END IF;
420: ELSE
421:
422: -- Call TAPI update
423: OKL_SYSTEM_PARAMS_ALL_PUB.update_system_parameters(
424: p_api_version => p_api_version,
425: p_init_msg_list => G_FALSE,
426: x_return_status => l_return_status,
427: x_msg_count => x_msg_count,