6: ---------------------------------------------------------------------------
7: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_VALIDATIONS_UNEXPECTED_ERROR';
10: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
11: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
13: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
14:
7: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_VALIDATIONS_UNEXPECTED_ERROR';
10: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
11: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
13: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
14:
15: G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_VALIDATIONS_UNEXPECTED_ERROR';
10: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
11: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
13: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
14:
15: G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
16: G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
18: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
19: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23:
24:
25: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23:
24:
25: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
23:
24:
25: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31:
24:
25: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31:
32:
25: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31:
32:
33: ---------------------------------------------------------------------------
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31:
32:
33: ---------------------------------------------------------------------------
34: -- GLOBAL VARIABLES
34: -- GLOBAL VARIABLES
35: ---------------------------------------------------------------------------
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VALIDATION_SET_PVT';
37: G_API_TYPE CONSTANT varchar2(4) := '_PVT';
38: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
39: --------------------------------------------------------------------------------
40: -- ERRORS AND EXCEPTIONS
41: --------------------------------------------------------------------------------
42: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
62: ,p_vldv_tbl IN vldv_tbl_type
63: ,x_vldv_tbl OUT NOCOPY vldv_tbl_type);
64:
65: PROCEDURE update_vls(p_api_version IN number
66: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
67: ,x_return_status OUT NOCOPY varchar2
68: ,x_msg_count OUT NOCOPY number
69: ,x_msg_data OUT NOCOPY varchar2
70: ,p_vlsv_rec IN vlsv_rec_type
72: ,p_vldv_tbl IN vldv_tbl_type
73: ,x_vldv_tbl OUT NOCOPY vldv_tbl_type);
74:
75: PROCEDURE delete_vls(p_api_version IN number
76: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
77: ,x_return_status OUT NOCOPY varchar2
78: ,x_msg_count OUT NOCOPY number
79: ,x_msg_data OUT NOCOPY varchar2
80: ,p_vlsv_rec IN vlsv_rec_type);
79: ,x_msg_data OUT NOCOPY varchar2
80: ,p_vlsv_rec IN vlsv_rec_type);
81:
82: PROCEDURE delete_vld(p_api_version IN number
83: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
84: ,x_return_status OUT NOCOPY varchar2
85: ,x_msg_count OUT NOCOPY number
86: ,x_msg_data OUT NOCOPY varchar2
87: ,p_vldv_rec IN vldv_rec_type);