6: ---------------------------------------------------------------------------
7: ---------------------------------------------------------------------------
8: -- GLOBAL VARIABLES
9: ---------------------------------------------------------------------------
10: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
11: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
12: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
13: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
14: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_REPORTS_PVT';
11: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
12: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
13: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
14: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_REPORTS_PVT';
15: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
16: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
12: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
13: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
14: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_REPORTS_PVT';
15: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
16: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
20: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
13: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
14: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_REPORTS_PVT';
15: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
16: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
20: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
21: g_representation_type VARCHAR2(20) := 'PRIMARY';
15: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
16: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
20: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
21: g_representation_type VARCHAR2(20) := 'PRIMARY';
22: g_exception_halt_validation EXCEPTION;
23:
16: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
17: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
18: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
20: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
21: g_representation_type VARCHAR2(20) := 'PRIMARY';
22: g_exception_halt_validation EXCEPTION;
23:
24: ---------------------------------------------------------------------------