[Home] [Help]
PACKAGE: APPS.OKC_LINE_STYLES_PUB
Source
1 PACKAGE OKC_LINE_STYLES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPLSES.pls 120.0 2005/06/02 03:45:41 appldev noship $ */
3
4 --------------------------------------------------------------------------
5 -- Global Variables
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_LINE_STYLES_PUB';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
11 --------------------------------------------------------------------------
12 --Global Exception
13 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
14
15 --------------------------------------------------------------------------
16 ---The following procedures cater to handling of OKC_LINE_STYLES
17 --------------------------------------------------------------------------
18
19 SUBTYPE lsev_rec_type is okc_line_styles_pvt.lsev_rec_type;
20 TYPE lsev_tbl_type is table of okc_line_styles_pvt.lsev_rec_type index by binary_integer;
21
22 g_lsev_rec lsev_rec_type;
23 g_lsev_tbl lsev_tbl_type;
24
25
26 PROCEDURE add_language;
27
28 PROCEDURE CREATE_LINE_STYLES(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_lsev_rec IN lsev_rec_type,
35 x_lsev_rec OUT NOCOPY lsev_rec_type) ;
36
37 PROCEDURE CREATE_LINE_STYLES(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_lsev_tbl IN lsev_tbl_type,
44 x_lsev_tbl OUT NOCOPY lsev_tbl_type) ;
45
46 PROCEDURE UPDATE_LINE_STYLES(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_lsev_rec IN lsev_rec_type,
53 x_lsev_rec OUT NOCOPY lsev_rec_type) ;
54
55 PROCEDURE UPDATE_LINE_STYLES(
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_lsev_tbl IN lsev_tbl_type,
62 x_lsev_tbl OUT NOCOPY lsev_tbl_type) ;
63
64 PROCEDURE DELETE_LINE_STYLES(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_lsev_rec IN lsev_rec_type) ;
71
72 PROCEDURE DELETE_LINE_STYLES(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_lsev_tbl IN lsev_tbl_type) ;
79
80 PROCEDURE LOCK_LINE_STYLES(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_lsev_rec IN lsev_rec_type) ;
87
88 PROCEDURE LOCK_LINE_STYLES(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_lsev_tbl IN lsev_tbl_type) ;
95
96 PROCEDURE VALID_LINE_STYLES(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_lsev_rec IN lsev_rec_type) ;
103
104 PROCEDURE VALID_LINE_STYLES(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_lsev_tbl IN lsev_tbl_type) ;
111
112 --finds if theline style is being used by a contract line. returns error if yes
113 FUNCTION USED_IN_K_LINES( p_lsev_tbl IN lsev_tbl_type) RETURN VARCHAR2;
114 --finds if theline style is being used by roles,rule groups or subclass top line. returns error if yes
115 FUNCTION USED_IN_SETUPS( p_lsev_tbl IN lsev_tbl_type) RETURN VARCHAR2;
116 --finds if theline style is being used by line style sources or valid line operations. returns error if yes
117 FUNCTION USED_IN_SRC_OPS( p_lsev_tbl IN lsev_tbl_type) RETURN VARCHAR2;
118
119 --------------------------------------------------------------------------
120 ---The following procedures cater to handling of OKC_LINE_STYLE_SOURCES
121 --------------------------------------------------------------------------
122
123 SUBTYPE lssv_rec_type is okc_line_styles_pvt.lssv_rec_type;
124 TYPE lssv_tbl_type is table of okc_line_styles_pvt.lssv_rec_type index by binary_integer;
125
126 g_lssv_rec lssv_rec_type;
127 g_lssv_tbl lssv_tbl_type;
128
129 PROCEDURE CREATE_LINE_STYLE_SOURCES(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_lssv_rec IN lssv_rec_type,
136 x_lssv_rec OUT NOCOPY lssv_rec_type) ;
137
138 PROCEDURE CREATE_LINE_STYLE_SOURCES(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_lssv_tbl IN lssv_tbl_type,
145 x_lssv_tbl OUT NOCOPY lssv_tbl_type) ;
146
147 PROCEDURE UPDATE_LINE_STYLE_SOURCES(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_lssv_rec IN lssv_rec_type,
154 x_lssv_rec OUT NOCOPY lssv_rec_type) ;
155
156 PROCEDURE UPDATE_LINE_STYLE_SOURCES(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_lssv_tbl IN lssv_tbl_type,
163 x_lssv_tbl OUT NOCOPY lssv_tbl_type) ;
164
165 PROCEDURE DELETE_LINE_STYLE_SOURCES(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_lssv_rec IN lssv_rec_type) ;
172
173 PROCEDURE DELETE_LINE_STYLE_SOURCES(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_lssv_tbl IN lssv_tbl_type) ;
180
181 PROCEDURE LOCK_LINE_STYLE_SOURCES(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_lssv_rec IN lssv_rec_type) ;
188
189 PROCEDURE LOCK_LINE_STYLE_SOURCES(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_lssv_tbl IN lssv_tbl_type) ;
196
197 PROCEDURE VALID_LINE_STYLE_SOURCES(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_lssv_rec IN lssv_rec_type) ;
204
205 PROCEDURE VALID_LINE_STYLE_SOURCES(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_lssv_tbl IN lssv_tbl_type) ;
212
213 --added by smhanda
214
215 --------------------------------------------------------------------------
216 ---The following procedures cater to handling of OKC_VAL_LINE_OPERATION
217 --------------------------------------------------------------------------
218
219 SUBTYPE vlov_rec_type is okc_line_styles_pvt.vlov_rec_type;
220 SUBTYPE vlov_tbl_type is okc_line_styles_pvt.vlov_tbl_type ;
221
222 g_vlov_rec vlov_rec_type;
223 g_vlov_tbl vlov_tbl_type;
224
225 PROCEDURE CREATE_VAL_LINE_OPERATION(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_vlov_rec IN vlov_rec_type,
232 x_vlov_rec OUT NOCOPY vlov_rec_type) ;
233
234 PROCEDURE CREATE_VAL_LINE_OPERATION(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_vlov_tbl IN vlov_tbl_type,
241 x_vlov_tbl OUT NOCOPY vlov_tbl_type) ;
242
243 PROCEDURE UPDATE_VAL_LINE_OPERATION(
244 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 p_vlov_rec IN vlov_rec_type,
250 x_vlov_rec OUT NOCOPY vlov_rec_type) ;
251
252 PROCEDURE UPDATE_VAL_LINE_OPERATION(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_vlov_tbl IN vlov_tbl_type,
259 x_vlov_tbl OUT NOCOPY vlov_tbl_type) ;
260
261 PROCEDURE DELETE_VAL_LINE_OPERATION(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_vlov_rec IN vlov_rec_type) ;
268
269 PROCEDURE DELETE_VAL_LINE_OPERATION(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_vlov_tbl IN vlov_tbl_type) ;
276
277 PROCEDURE LOCK_VAL_LINE_OPERATION(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_vlov_rec IN vlov_rec_type) ;
284
285 PROCEDURE LOCK_VAL_LINE_OPERATION(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_vlov_tbl IN vlov_tbl_type) ;
292
293 PROCEDURE VALIDATE_VAL_LINE_OPERATION(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_vlov_rec IN vlov_rec_type) ;
300
301 PROCEDURE VALIDATE_VAL_LINE_OPERATION(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_vlov_tbl IN vlov_tbl_type) ;
308
309
310 END OKC_LINE_STYLES_PUB;