[Home] [Help]
PACKAGE: APPS.OKL_VLS_PVT
Source
1 PACKAGE OKL_VLS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSVLSS.pls 120.1 2005/10/30 04:58:19 appldev noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_VLS_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
19 G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';
20 G_OVN_ERROR2 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR2';
21 G_OVN_ERROR3 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR3';
22 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
23 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
24 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
27
28 ------------------
29 -- DATA STRUCTURES
30 ------------------
31
32 -- Do not include WHO columns in the base table record structure
33 TYPE vls_rec_type IS RECORD (
34 id okl_validation_sets_b.id%TYPE
35 ,object_version_number okl_validation_sets_b.object_version_number%TYPE
36 ,attribute_category okl_validation_sets_b.attribute_category%TYPE
37 ,attribute1 okl_validation_sets_b.attribute1%TYPE
38 ,attribute2 okl_validation_sets_b.attribute2%TYPE
39 ,attribute3 okl_validation_sets_b.attribute3%TYPE
40 ,attribute4 okl_validation_sets_b.attribute4%TYPE
41 ,attribute5 okl_validation_sets_b.attribute5%TYPE
42 ,attribute6 okl_validation_sets_b.attribute6%TYPE
43 ,attribute7 okl_validation_sets_b.attribute7%TYPE
44 ,attribute8 okl_validation_sets_b.attribute8%TYPE
45 ,attribute9 okl_validation_sets_b.attribute9%TYPE
46 ,attribute10 okl_validation_sets_b.attribute10%TYPE
47 ,attribute11 okl_validation_sets_b.attribute11%TYPE
48 ,attribute12 okl_validation_sets_b.attribute12%TYPE
49 ,attribute13 okl_validation_sets_b.attribute13%TYPE
50 ,attribute14 okl_validation_sets_b.attribute14%TYPE
51 ,attribute15 okl_validation_sets_b.attribute15%TYPE
52 ,org_id okl_validation_sets_b.org_id%TYPE
53 ,validation_set_name okl_validation_sets_b.validation_set_name%TYPE
54 ,effective_from okl_validation_sets_b.effective_from%TYPE
55 ,effective_to okl_validation_sets_b.effective_to%TYPE
56 );
57
58 -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
59 TYPE vlstl_rec_type IS RECORD (
60 id okl_validation_sets_tl.id%TYPE
61 ,short_description okl_validation_sets_tl.short_description%TYPE
62 ,description okl_validation_sets_tl.description%TYPE
63 ,comments okl_validation_sets_tl.comments%TYPE
64 );
65
66 -- view record structure
67 TYPE vlsv_rec_type IS RECORD (
68 id okl_validation_sets_b.id%TYPE
69 ,object_version_number okl_validation_sets_b.object_version_number%TYPE
70 ,attribute_category okl_validation_sets_b.attribute_category%TYPE
71 ,attribute1 okl_validation_sets_b.attribute1%TYPE
72 ,attribute2 okl_validation_sets_b.attribute2%TYPE
73 ,attribute3 okl_validation_sets_b.attribute3%TYPE
74 ,attribute4 okl_validation_sets_b.attribute4%TYPE
75 ,attribute5 okl_validation_sets_b.attribute5%TYPE
76 ,attribute6 okl_validation_sets_b.attribute6%TYPE
77 ,attribute7 okl_validation_sets_b.attribute7%TYPE
78 ,attribute8 okl_validation_sets_b.attribute8%TYPE
79 ,attribute9 okl_validation_sets_b.attribute9%TYPE
80 ,attribute10 okl_validation_sets_b.attribute10%TYPE
81 ,attribute11 okl_validation_sets_b.attribute11%TYPE
82 ,attribute12 okl_validation_sets_b.attribute12%TYPE
83 ,attribute13 okl_validation_sets_b.attribute13%TYPE
84 ,attribute14 okl_validation_sets_b.attribute14%TYPE
85 ,attribute15 okl_validation_sets_b.attribute15%TYPE
86 ,org_id okl_validation_sets_b.org_id%TYPE
87 ,validation_set_name okl_validation_sets_b.validation_set_name%TYPE
88 ,effective_from okl_validation_sets_b.effective_from%TYPE
89 ,effective_to okl_validation_sets_b.effective_to%TYPE
90 ,short_description okl_validation_sets_tl.short_description%TYPE
91 ,description okl_validation_sets_tl.description%TYPE
92 ,comments okl_validation_sets_tl.comments%TYPE
93 );
94
95 TYPE vlsv_tbl_type IS TABLE OF vlsv_rec_type INDEX BY BINARY_INTEGER;
96
97 ----------------
98 -- PROGRAM UNITS
99 ----------------
100 PROCEDURE add_language;
101
102 PROCEDURE insert_row(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_vlsv_tbl IN vlsv_tbl_type,
109 x_vlsv_tbl OUT NOCOPY vlsv_tbl_type);
110
111 PROCEDURE update_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_vlsv_tbl IN vlsv_tbl_type,
118 x_vlsv_tbl OUT NOCOPY vlsv_tbl_type);
119
120 PROCEDURE delete_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_vlsv_tbl IN vlsv_tbl_type);
127
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_vlsv_rec IN vlsv_rec_type,
135 x_vlsv_rec OUT NOCOPY vlsv_rec_type);
136
137 PROCEDURE update_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_vlsv_rec IN vlsv_rec_type,
144 x_vlsv_rec OUT NOCOPY vlsv_rec_type);
145
146 PROCEDURE delete_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_vlsv_rec IN vlsv_rec_type);
153
154 END OKL_VLS_PVT;