9: -----------------------------------------------------------------------------------------
10:
11: -- GLOBAL MESSAGE CONSTANTS
12: -----------------------------------------------------------------------------------------
13: g_true CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
10:
11: -- GLOBAL MESSAGE CONSTANTS
12: -----------------------------------------------------------------------------------------
13: g_true CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
11: -- GLOBAL MESSAGE CONSTANTS
12: -----------------------------------------------------------------------------------------
13: g_true CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: -----------------------------------------------------------------------------------------
13: g_true CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
13: g_true CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
14: g_false CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: g_child_table_token CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
15: g_ret_sts_success CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: g_child_table_token CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
16: g_ret_sts_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: g_child_table_token CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
24: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
17: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: g_child_table_token CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
24: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
25: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLerrm';
18: g_required_value CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: g_invlaid_value CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: g_col_name_token CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: g_parent_table_token CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: g_child_table_token CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
24: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
25: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLerrm';
26: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLcode';