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

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: --NIKSHAH added below variables, bug # 8570053

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: --NIKSHAH added below variables, bug # 8570053
45: l_sec_rep_method okl_sys_acct_opts.SECONDARY_REP_METHOD%TYPE;

Line 46: l_rpt_book_type OKL_SYSTEM_PARAMS.rpt_prod_book_type_code%TYPE;

42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
43:
44: --NIKSHAH added below variables, bug # 8570053
45: l_sec_rep_method okl_sys_acct_opts.SECONDARY_REP_METHOD%TYPE;
46: l_rpt_book_type OKL_SYSTEM_PARAMS.rpt_prod_book_type_code%TYPE;
47: --NIKSHAH added above variables, bug # 8570053
48: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
49:
50: CURSOR c_tax_book_csr (cp_asst_add_book_type_code VARCHAR2, cp_tax_book VARCHAR2) IS

Line 74: from okl_system_params p, okl_sys_acct_opts a

70:
71: --NIKSHAH added below cursor, bug # 8570053
72: CURSOR c_get_sec_repr_method IS
73: select secondary_rep_method, rpt_prod_book_type_code
74: from okl_system_params p, okl_sys_acct_opts a
75: where p.org_id = a.org_id;
76:
77:
78: BEGIN

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

102:
103:
104:
105: -- DJANASWA Bug 6653304 start Proj: Asset Repo for a Loan
106: -- Added validations for the new columns added to the table okl_system_params_all.
107: -- 1. If any one or more of the following fields has values: Tax Asset Book 1, Tax Asset Book 2,
108: -- Asset Key, Fixed Asset Location, Asset Cost Formula
109: -- then ensure that all of the following fields have values:
110: -- Asset Addition Corporate Book, Tax Asset Book 1, Fixed Asset Location

Line 442: OKL_SYSTEM_PARAMS_ALL_PUB.insert_system_parameters(

438: -- If no id passed then insert else update
439: IF p_sypv_rec.id IS NULL OR p_sypv_rec.id = G_MISS_NUM THEN
440:
441: -- Call TAPI insert
442: OKL_SYSTEM_PARAMS_ALL_PUB.insert_system_parameters(
443: p_api_version => p_api_version,
444: p_init_msg_list => G_FALSE,
445: x_return_status => l_return_status,
446: x_msg_count => x_msg_count,

Line 460: OKL_SYSTEM_PARAMS_ALL_PUB.update_system_parameters(

456: END IF;
457: ELSE
458:
459: -- Call TAPI update
460: OKL_SYSTEM_PARAMS_ALL_PUB.update_system_parameters(
461: p_api_version => p_api_version,
462: p_init_msg_list => G_FALSE,
463: x_return_status => l_return_status,
464: x_msg_count => x_msg_count,