[Home] [Help]
PACKAGE: APPS.OKL_VALIDATION_SET_PVT
Source
1 PACKAGE OKL_VALIDATION_SET_PVT AS
2 /* $Header: OKLRVLSS.pls 120.3 2005/10/03 06:41:47 ssdeshpa noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
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
15 G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
16 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
17 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
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;
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
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;
43 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
44 G_EXCEPTION_ERROR EXCEPTION;
45 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
46
47 -- Validation Set
48 SUBTYPE vlsv_rec_type IS okl_vls_pvt.vlsv_rec_type;
49
50 -- Individual Validation Lines
51 SUBTYPE vldv_rec_type IS okl_vld_pvt.vldv_rec_type;
52
53 SUBTYPE vldv_tbl_type IS okl_vld_pvt.vldv_tbl_type;
54
55 PROCEDURE create_vls(p_api_version IN number
56 ,p_init_msg_list IN varchar2
57 ,x_return_status OUT NOCOPY varchar2
58 ,x_msg_count OUT NOCOPY number
59 ,x_msg_data OUT NOCOPY varchar2
60 ,p_vlsv_rec IN vlsv_rec_type
61 ,x_vlsv_rec OUT NOCOPY vlsv_rec_type
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
71 ,x_vlsv_rec OUT NOCOPY 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);
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);
88 FUNCTION validate_header(p_vlsv_rec IN vlsv_rec_type) RETURN varchar2;
89 --FUNCTION validate_duplicate(p_vldv_tbl IN vldv_tbl_type) RETURN varchar2;
90
91 END OKL_VALIDATION_SET_PVT;