[Home] [Help]
PACKAGE: APPS.OKS_CVP_PVT
Source
1 Package OKS_CVP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSCVPS.pls 120.0 2005/05/25 17:45:36 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_COV_TYPES_V Record Spec
7 TYPE cvpv_rec_type IS RECORD (
8 code OKS_COV_TYPES_V.CODE%TYPE := OKC_API.G_MISS_CHAR
9 ,meaning OKS_COV_TYPES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR
10 ,description OKS_COV_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11 ,importance_level NUMBER := OKC_API.G_MISS_NUM
12 ,sfwt_flag OKS_COV_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
13 ,enabled_flag OKS_COV_TYPES_V.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR
14 ,start_date_active OKS_COV_TYPES_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE
15 ,end_date_active OKS_COV_TYPES_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE
16 ,created_by NUMBER := OKC_API.G_MISS_NUM
17 ,creation_date OKS_COV_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
20 ,last_update_date OKS_COV_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21 ,attribute_category OKS_COV_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
22 ,attribute1 OKS_COV_TYPES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
23 ,attribute2 OKS_COV_TYPES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
24 ,attribute3 OKS_COV_TYPES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute4 OKS_COV_TYPES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute5 OKS_COV_TYPES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute6 OKS_COV_TYPES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute7 OKS_COV_TYPES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute8 OKS_COV_TYPES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute9 OKS_COV_TYPES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute10 OKS_COV_TYPES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute11 OKS_COV_TYPES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute12 OKS_COV_TYPES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute13 OKS_COV_TYPES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute14 OKS_COV_TYPES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute15 OKS_COV_TYPES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37 G_MISS_cvpv_rec cvpv_rec_type;
38 TYPE cvpv_tbl_type IS TABLE OF cvpv_rec_type
39 INDEX BY BINARY_INTEGER;
40 -- OKS_COV_TYPES_TL Record Spec
41 TYPE oks_cov_types_tl_rec_type IS RECORD (
42 code OKS_COV_TYPES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR
43 ,language OKS_COV_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
44 ,source_lang OKS_COV_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
45 ,sfwt_flag OKS_COV_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
46 ,meaning OKS_COV_TYPES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR
47 ,description OKS_COV_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
48 ,created_by NUMBER := OKC_API.G_MISS_NUM
49 ,creation_date OKS_COV_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
50 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
51 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
52 ,last_update_date OKS_COV_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE);
53 G_MISS_oks_cov_types_tl_rec oks_cov_types_tl_rec_type;
54 TYPE oks_cov_types_tl_tbl_type IS TABLE OF oks_cov_types_tl_rec_type
55 INDEX BY BINARY_INTEGER;
56 -- OKS_COV_TYPES_B Record Spec
57 TYPE cvp_rec_type IS RECORD (
58 code OKS_COV_TYPES_B.CODE%TYPE := OKC_API.G_MISS_CHAR
59 ,importance_level NUMBER := OKC_API.G_MISS_NUM
60 ,enabled_flag OKS_COV_TYPES_B.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61 ,start_date_active OKS_COV_TYPES_B.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE
62 ,end_date_active OKS_COV_TYPES_B.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE
63 ,created_by NUMBER := OKC_API.G_MISS_NUM
64 ,creation_date OKS_COV_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67 ,last_update_date OKS_COV_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68 ,attribute_category OKS_COV_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69 ,attribute1 OKS_COV_TYPES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70 ,attribute2 OKS_COV_TYPES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71 ,attribute3 OKS_COV_TYPES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72 ,attribute4 OKS_COV_TYPES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73 ,attribute5 OKS_COV_TYPES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74 ,attribute6 OKS_COV_TYPES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75 ,attribute7 OKS_COV_TYPES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76 ,attribute8 OKS_COV_TYPES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77 ,attribute9 OKS_COV_TYPES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78 ,attribute10 OKS_COV_TYPES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79 ,attribute11 OKS_COV_TYPES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80 ,attribute12 OKS_COV_TYPES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81 ,attribute13 OKS_COV_TYPES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82 ,attribute14 OKS_COV_TYPES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83 ,attribute15 OKS_COV_TYPES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
84 G_MISS_cvp_rec cvp_rec_type;
85 TYPE cvp_tbl_type IS TABLE OF cvp_rec_type
86 INDEX BY BINARY_INTEGER;
87 ---------------------------------------------------------------------------
88 -- GLOBAL MESSAGE CONSTANTS
89 ---------------------------------------------------------------------------
90 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
101 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
102 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
103
104 ---------------------------------------------------------------------------
105 -- GLOBAL EXCEPTIONS
106 ---------------------------------------------------------------------------
107 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
108
109 ---------------------------------------------------------------------------
110 -- GLOBAL VARIABLES
111 ---------------------------------------------------------------------------
112 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CVP_PVT';
113 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
114 ---------------------------------------------------------------------------
115 -- Procedures and Functions
116 ---------------------------------------------------------------------------
117
118 PROCEDURE qc;
119 PROCEDURE change_version;
120 PROCEDURE api_copy;
121 PROCEDURE add_language;
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_cvpv_rec IN cvpv_rec_type,
129 x_cvpv_rec OUT NOCOPY cvpv_rec_type);
130 PROCEDURE insert_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_cvpv_tbl IN cvpv_tbl_type,
137 x_cvpv_tbl OUT NOCOPY cvpv_tbl_type,
138 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139 PROCEDURE insert_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_cvpv_tbl IN cvpv_tbl_type,
146 x_cvpv_tbl OUT NOCOPY cvpv_tbl_type);
147 PROCEDURE lock_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_cvpv_rec IN cvpv_rec_type);
154 PROCEDURE lock_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_cvpv_tbl IN cvpv_tbl_type,
161 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_cvpv_tbl IN cvpv_tbl_type);
169 PROCEDURE update_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_cvpv_rec IN cvpv_rec_type,
176 x_cvpv_rec OUT NOCOPY cvpv_rec_type);
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_cvpv_tbl IN cvpv_tbl_type,
184 x_cvpv_tbl OUT NOCOPY cvpv_tbl_type,
185 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
186 PROCEDURE update_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_cvpv_tbl IN cvpv_tbl_type,
193 x_cvpv_tbl OUT NOCOPY cvpv_tbl_type);
194 PROCEDURE delete_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_cvpv_rec IN cvpv_rec_type);
201 PROCEDURE delete_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_cvpv_tbl IN cvpv_tbl_type,
208 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_cvpv_tbl IN cvpv_tbl_type);
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_cvpv_rec IN cvpv_rec_type);
223 PROCEDURE validate_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_cvpv_tbl IN cvpv_tbl_type,
230 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_cvpv_tbl IN cvpv_tbl_type);
238 PROCEDURE MIGRATE_COVERAGE_TYPES(p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2);
243
244 PROCEDURE DELETE_COVERAGE_TYPES(p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2);
249 END OKS_CVP_PVT;