DBA Data[Home] [Help]

APPS.OKL_VALIDATION_SET_PVT dependencies on OKL_API

Line 10: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

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:

Line 11: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

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';

Line 12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

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';

Line 22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

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;

Line 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;

Line 27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

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:

Line 28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

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:

Line 29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;

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: ---------------------------------------------------------------------------

Line 30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

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

Line 38: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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;

Line 66: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

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

Line 76: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

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);

Line 83: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

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);