1 PACKAGE OKC_XPRT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVXUTLS.pls 120.19.12020000.2 2012/07/18 11:39:55 harchand ship $ */
3
4 TYPE expert_articles_tbl_type IS TABLE OF NUMBER -- column of article IDs
5 INDEX BY BINARY_INTEGER;
6
7 -- Begin: Added for R12
8 TYPE expert_deviations_list IS TABLE OF NUMBER -- column of Deviation Rule IDs
9 INDEX BY BINARY_INTEGER;
10
11 TYPE expert_dev_line_nbr_list IS TABLE OF NUMBER -- column of Deviation Rule Line Numbers
12 INDEX BY BINARY_INTEGER;
13
14 TYPE dev_rule_rec_type IS RECORD (
15 line_number varchar2(250),
16 rule_id OKC_XPRT_RULE_HDRS_ALL.rule_id%TYPE
17 );
18
19 TYPE dev_rule_variables_rec_type IS RECORD (
20 line_number varchar2(250),
21 rule_id OKC_XPRT_RULE_HDRS_ALL.rule_id%TYPE,
22 variable_id OKC_BUS_VARIABLES_B.variable_code%TYPE
23 );
24
25 TYPE dev_rule_questions_rec_type IS RECORD (
26 --line_number varchar2(250),
27 rule_id OKC_XPRT_RULE_HDRS_ALL.rule_id%TYPE,
28 question_id OKC_XPRT_QUESTIONS_B.question_id%TYPE
29 );
30
31 TYPE dev_rule_var_values_rec_type IS RECORD (
32 line_number varchar2(250),
33 rule_id OKC_XPRT_RULE_HDRS_ALL.rule_id%TYPE,
34 variable_id OKC_BUS_VARIABLES_B.variable_code%TYPE,
35 variable_value VARCHAR2(40)
36 );
37
38 TYPE dev_rule_qst_values_rec_type IS RECORD (
39 --line_number varchar2(250),
40 rule_id OKC_XPRT_RULE_HDRS_ALL.rule_id%TYPE,
41 question_id OKC_XPRT_QUESTIONS_B.question_id%TYPE,
42 question_value VARCHAR2(40)
43 );
44
45 TYPE dev_rule_tbl_type IS TABLE OF dev_rule_rec_type
46 INDEX BY BINARY_INTEGER;
47
48 TYPE dev_rule_variables_tbl_type IS TABLE OF dev_rule_variables_rec_type
49 INDEX BY BINARY_INTEGER;
50
51 TYPE dev_rule_questions_tbl_type IS TABLE OF dev_rule_questions_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 TYPE dev_rule_var_values_tbl_type IS TABLE OF dev_rule_var_values_rec_type
55 INDEX BY BINARY_INTEGER;
56
57 TYPE dev_rule_qst_values_tbl_type IS TABLE OF dev_rule_qst_values_rec_type
58 INDEX BY BINARY_INTEGER;
59
60 -- End: Added for R12
61
62 ---------------------------------------------------
63 -- Procedure:
64 ---------------------------------------------------
65 PROCEDURE check_import_status
66 (
67 p_run_id IN NUMBER,
68 p_import_status IN VARCHAR2,
69 p_model_type IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER
73 );
74
75 --Bug 4723548 Added new function
76 FUNCTION is_value_set_changed (
77 p_object_code IN VARCHAR2,
78 p_object_value_set_id IN NUMBER)
79 RETURN VARCHAR2;
80
81 FUNCTION get_value_set_id
82 (
83 p_value_set_name IN VARCHAR2
84 ) RETURN NUMBER;
85
86 FUNCTION is_rule_line_level
87 (
88 p_rule_id IN NUMBER
89 ) RETURN VARCHAR2;
90
91 FUNCTION xprt_enabled_template
92 (
93 p_template_id IN NUMBER
94 ) RETURN VARCHAR2;
95
96 PROCEDURE create_test_publication
97 (
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER
101 );
102
103 PROCEDURE populate_questions_order
104 (
105 p_Template_Id IN NUMBER,
106 p_Commit_Flag IN VARCHAR2,
107 p_Mode IN VARCHAR2,
108 x_Return_Status OUT NOCOPY VARCHAR2,
109 x_Msg_Count OUT NOCOPY NUMBER,
110 x_Msg_Data OUT NOCOPY VARCHAR2
111 );
112
113 FUNCTION Ok_To_Delete_Question
114 (
115 p_question_id IN NUMBER
116 ) RETURN VARCHAR2;
117
118 PROCEDURE create_production_publication
119 (
120 p_calling_mode IN VARCHAR2,
121 p_template_id IN NUMBER,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER
125 );
126
127 PROCEDURE validate_template_for_expert
128 (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2,
131 p_template_id IN NUMBER,
132 x_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_GRP.qa_result_tbl_type,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138 PROCEDURE build_cz_xml_init_msg
139 (
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2,
142 p_document_id IN NUMBER,
143 p_document_type IN VARCHAR2,
144 p_config_header_id IN NUMBER,
145 p_config_rev_nbr IN NUMBER,
146 p_template_id IN NUMBER,
147 x_cz_xml_init_msg OUT NOCOPY LONG,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE parse_cz_xml_terminate_msg
154 (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 p_cz_xml_terminate_msg IN LONG,
158 x_valid_config OUT NOCOPY VARCHAR2,
159 x_complete_config OUT NOCOPY VARCHAR2,
160 x_config_header_id OUT NOCOPY NUMBER,
161 x_config_rev_nbr OUT NOCOPY NUMBER,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166
167 PROCEDURE process_qa_result
168 (
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2,
171 p_document_id IN NUMBER,
172 p_document_type IN VARCHAR2,
173 p_config_header_id IN NUMBER,
174 p_config_rev_nbr IN NUMBER,
175 x_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_GRP.qa_result_tbl_type,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE get_expert_articles
182 (
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 p_document_id IN NUMBER,
186 p_document_type IN VARCHAR2,
187 p_config_header_id IN NUMBER,
188 p_config_rev_nbr IN NUMBER,
189 x_expert_articles_tbl OUT NOCOPY expert_articles_tbl_type,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 );
194
195 /*PROCEDURE contract_expert_bv
196 (
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2,
199 p_document_id IN NUMBER,
200 p_document_type IN VARCHAR2,
201 p_bv_mode IN VARCHAR2,
202 p_sequence_id IN NUMBER,
203 x_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_GRP.qa_result_tbl_type,
204 x_expert_articles_tbl OUT NOCOPY expert_articles_tbl_type,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2
208 );*/
209
210 PROCEDURE update_ce_config
211 (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2,
214 p_document_id IN NUMBER,
215 p_document_type IN VARCHAR2,
216 p_config_header_id IN NUMBER,
217 p_config_rev_nbr IN NUMBER,
218 p_doc_update_mode IN VARCHAR2,
219 x_count_articles_dropped OUT NOCOPY NUMBER ,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2
223 ,p_lock_xprt_yn IN VARCHAR2 := 'N' -- Conc Mod changes
224 ,p_lock_terms_yn IN VARCHAR2 := 'N' -- Conc Mod changes
225 );
226
227 PROCEDURE update_config_id_rev_nbr
228 (
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2,
231 p_document_id IN NUMBER,
232 p_document_type IN VARCHAR2,
233 p_config_header_id IN NUMBER,
234 p_config_rev_nbr IN NUMBER,
235 p_template_id IN NUMBER,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2
239 ,p_lock_xprt_yn IN VARCHAR2 := 'N' -- Conc Mod changes
240 );
241
242 PROCEDURE get_article_details
243 (
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2,
246 p_document_id IN NUMBER,
247 p_document_type IN VARCHAR2,
248 p_article_id IN NUMBER,
249 p_effectivity_date IN DATE,
250 x_article_id OUT NOCOPY NUMBER,
251 x_article_version_id OUT NOCOPY NUMBER,
252 x_doc_lib OUT NOCOPY VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2
256 );
257
258 FUNCTION check_clause_exists (
259 p_rule_id IN NUMBER,
260 p_clause_id IN NUMBER)
261 RETURN VARCHAR2;
262
263 FUNCTION check_variable_exists (
264 p_rule_id IN NUMBER,
265 p_variable_code IN VARCHAR2)
266 RETURN VARCHAR2;
267
268 FUNCTION check_question_exists (
269 p_rule_id IN NUMBER,
270 p_question_id IN NUMBER)
271 RETURN VARCHAR2;
272
273 FUNCTION check_template_exists(
274 p_rule_id IN NUMBER,
275 p_template_id IN NUMBER)
276 RETURN VARCHAR2;
277
278 FUNCTION check_orgwide_rule_exists
279 RETURN VARCHAR2;
280
281 FUNCTION get_object_name (
282 p_object_name IN VARCHAR2,
283 p_object_code IN VARCHAR2)
284 RETURN VARCHAR2;
285
286 FUNCTION get_value_display (
287 p_object_value_type IN VARCHAR2,
288 p_object_value_code IN VARCHAR2,
289 p_object_value_set_id IN NUMBER,
290 p_validation_type IN VARCHAR2,
291 p_longlist_flag IN VARCHAR2,
292 p_mode IN VARCHAR2 DEFAULT NULL)
293 RETURN VARCHAR2;
294
295 FUNCTION get_value_desc (
296 p_object_value_type IN VARCHAR2,
297 p_object_value_code IN VARCHAR2,
298 p_object_value_set_id IN NUMBER,
299 p_validation_type IN VARCHAR2,
300 p_longlist_flag IN VARCHAR2)
301 RETURN VARCHAR2;
302
303 FUNCTION get_valueset_value (
304 p_object_value_set_id IN NUMBER,
305 p_object_value_code IN VARCHAR2,
306 p_validation_type IN VARCHAR2)
307 RETURN VARCHAR2 ;
308
309 FUNCTION get_valueset_value_desc (
310 p_object_value_set_id IN NUMBER,
311 p_object_value_code IN VARCHAR2,
312 p_validation_type IN VARCHAR2)
313 RETURN VARCHAR2;
314
315 FUNCTION get_value_desc (
316 p_rule_condition_id IN NUMBER,
317 p_object_value_code IN VARCHAR2)
318 RETURN VARCHAR2;
319
320 FUNCTION get_value_display (
321 p_rule_condition_id IN NUMBER,
322 p_object_value_code IN VARCHAR2)
323 RETURN VARCHAR2 ;
324
325 -- Added for Policy Deviations Project
326 FUNCTION get_concat_condition_values (
327 p_rule_condition_id IN NUMBER)
328 RETURN VARCHAR2;
329
330 -- Bug#4728299 Added for Policy Deviations Project
331 FUNCTION get_deviation_document_value (
332 p_rule_id IN NUMBER,
333 p_object_type IN VARCHAR2,
334 p_object_code IN VARCHAR2,
335 p_sequence_id IN VARCHAR2,
336 p_value_set_id IN NUMBER,
337 p_object_value_type IN VARCHAR2,
338 p_object_value_code IN VARCHAR2,
339 p_line_number IN VARCHAR2)
340 RETURN VARCHAR2;
341
342 PROCEDURE publish_rule_with_no_tmpl
343 (
344 p_calling_mode IN VARCHAR2,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER
348 );
349
350 PROCEDURE check_rules_validity
351 (
352 p_qa_mode IN VARCHAR2,
353 p_template_id IN NUMBER,
354 x_sequence_id OUT NOCOPY NUMBER,
355 x_qa_status OUT NOCOPY VARCHAR2,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_data OUT NOCOPY VARCHAR2,
358 x_msg_count OUT NOCOPY NUMBER
359 );
360
361 FUNCTION is_valid (
362 p_object_id IN NUMBER,
363 p_object_type IN VARCHAR2)
364 RETURN VARCHAR2 ;
365
366 FUNCTION is_value_valid (
367 p_object_code IN VARCHAR2,
368 p_rule_condition_id IN NUMBER)
369 RETURN VARCHAR2 ;
370
371 FUNCTION get_message(p_appl_name IN VARCHAR2,
372 p_msg_name IN VARCHAR2)
373 RETURN VARCHAR2;
374
375 PROCEDURE get_publication_id
376 (
377 p_api_version IN NUMBER,
378 p_init_msg_list IN VARCHAR2,
379 p_template_id IN NUMBER,
380 x_publication_id OUT NOCOPY NUMBER,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2
384 );
385
386 FUNCTION ok_to_delete_clause
387 (
388 p_article_id IN NUMBER
389 ) RETURN VARCHAR2;
390
391 PROCEDURE get_qa_code_detail
392 (
393 p_document_type IN VARCHAR2,
394 p_qa_code IN VARCHAR2,
395 x_perform_qa OUT NOCOPY VARCHAR2,
396 x_qa_name OUT NOCOPY VARCHAR2,
397 x_severity_flag OUT NOCOPY VARCHAR2,
398 x_return_status OUT NOCOPY VARCHAR2
399 );
400
401 PROCEDURE enable_expert_button
402 (
403 p_api_version IN NUMBER,
404 p_init_msg_list IN VARCHAR2,
405 p_template_id IN NUMBER,
406 p_document_id IN NUMBER,
407 p_document_type IN VARCHAR2,
408 x_enable_expert_button OUT NOCOPY VARCHAR2, -- FND_API.G_FALSE or G_TRUE
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2
412 );
413
414
415
416 --Under development - Arun
417 PROCEDURE contract_expert_bv
418 (
419 p_api_version IN NUMBER,
420 p_init_msg_list IN VARCHAR2,
421 p_document_id IN NUMBER,
422 p_document_type IN VARCHAR2,
423 p_bv_mode IN VARCHAR2,
424 p_sequence_id IN NUMBER DEFAULT NULL,
425 x_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_GRP.qa_result_tbl_type,
426 x_expert_articles_tbl OUT NOCOPY expert_articles_tbl_type,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY NUMBER,
429 x_msg_data OUT NOCOPY VARCHAR2
430 );
431
432 PROCEDURE get_expert_selections(
433 p_api_version IN NUMBER,
434 p_init_msg_list IN VARCHAR2,
435 p_document_id IN NUMBER,
436 p_document_type IN VARCHAR2,
437 p_config_header_id IN NUMBER,
438 p_config_rev_nbr IN NUMBER,
439 x_expert_clauses_tbl OUT NOCOPY expert_articles_tbl_type,
440 x_expert_deviations_tbl OUT NOCOPY dev_rule_tbl_type,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2);
444
445 PROCEDURE get_rule_details(
446 p_api_version IN NUMBER,
447 p_init_msg_list IN VARCHAR2,
448 p_dev_rule_tbl IN dev_rule_tbl_type,
449 x_dev_rule_questions_tbl OUT NOCOPY dev_rule_questions_tbl_type,
450 x_dev_rule_variables_tbl OUT NOCOPY dev_rule_variables_tbl_type,
451 x_return_status OUT NOCOPY VARCHAR2,
452 x_msg_count OUT NOCOPY NUMBER,
453 x_msg_data OUT NOCOPY VARCHAR2);
454
455 PROCEDURE get_rule_variable_values(
456 p_api_version IN NUMBER,
457 p_init_msg_list IN VARCHAR2,
458 p_sequence_id IN NUMBER,
459 p_dev_rule_variables_tbl IN dev_rule_variables_tbl_type,
460 x_dev_rule_var_values_tbl OUT NOCOPY dev_rule_var_values_tbl_type,
461 x_return_status OUT NOCOPY VARCHAR2,
462 x_msg_count OUT NOCOPY NUMBER,
463 x_msg_data OUT NOCOPY VARCHAR2);
464
465 PROCEDURE get_rule_question_values(
466 p_api_version IN NUMBER,
467 p_init_msg_list IN VARCHAR2,
468 p_config_header_id IN NUMBER,
469 p_config_rev_nbr IN NUMBER,
470 p_dev_rule_questions_tbl IN dev_rule_questions_tbl_type,
471 x_dev_rule_qst_values_tbl OUT NOCOPY dev_rule_qst_values_tbl_type,
472 x_return_status OUT NOCOPY VARCHAR2,
473 x_msg_count OUT NOCOPY NUMBER,
474 x_msg_data OUT NOCOPY VARCHAR2);
475
476 PROCEDURE get_article_details(
477 p_api_version IN NUMBER,
478 p_init_msg_list IN VARCHAR2,
479 p_document_id IN NUMBER,
480 p_document_type IN VARCHAR2,
481 p_article_id IN NUMBER,
482 p_effectivity_date IN DATE,
483 x_article_id OUT NOCOPY NUMBER,
484 x_article_version_id OUT NOCOPY NUMBER,
485 x_article_title OUT NOCOPY VARCHAR2,
486 x_article_description OUT NOCOPY VARCHAR2,
487 x_doc_lib OUT NOCOPY VARCHAR2,
488 x_scn_heading OUT NOCOPY VARCHAR2,
489 x_return_status OUT NOCOPY VARCHAR2,
490 x_msg_count OUT NOCOPY NUMBER,
491 x_msg_data OUT NOCOPY VARCHAR2);
492
493 PROCEDURE populate_terms_deviations_tbl(
494 p_api_version IN NUMBER,
495 p_init_msg_list IN VARCHAR2,
496 p_document_id IN NUMBER,
497 p_document_type IN VARCHAR2,
498 p_sequence_id IN NUMBER,
499 p_config_header_id IN NUMBER,
500 p_config_rev_nbr IN NUMBER,
501 p_rule_qst_values_tbl IN dev_rule_qst_values_tbl_type,
502 p_rule_var_values_tbl IN dev_rule_var_values_tbl_type,
503 p_clause_tbl IN expert_articles_tbl_type,
504 p_mode IN VARCHAR2,
505 x_return_status OUT NOCOPY VARCHAR2,
506 x_msg_count OUT NOCOPY NUMBER,
507 x_msg_data OUT NOCOPY VARCHAR2);
508
509 PROCEDURE get_expert_results(
510 p_api_version IN NUMBER,
511 p_init_msg_list IN VARCHAR2,
512 p_document_id IN NUMBER,
513 p_document_type IN VARCHAR2,
514 p_config_header_id IN NUMBER,
515 p_config_rev_nbr IN NUMBER,
516 p_mode IN VARCHAR2,
517 p_sequence_id IN OUT NOCOPY NUMBER,
518 x_return_status OUT NOCOPY VARCHAR2,
519 x_msg_count OUT NOCOPY NUMBER,
520 x_msg_data OUT NOCOPY VARCHAR2);
521
522 -- Rajendra
523 PROCEDURE is_template_applied (
524 p_api_version IN NUMBER,
525 p_init_msg_list IN VARCHAR2,
526 p_document_type IN VARCHAR2,
527 p_document_id IN NUMBER,
528 p_template_id IN NUMBER,
529 x_template_applied_yn OUT NOCOPY VARCHAR2,
530 x_return_status OUT NOCOPY VARCHAR2,
531 x_msg_count OUT NOCOPY NUMBER,
532 x_msg_data OUT NOCOPY VARCHAR2
533 );
534
535 PROCEDURE get_current_config_dtls (
536 p_api_version IN NUMBER,
537 p_init_msg_list IN VARCHAR2,
538 p_document_type IN VARCHAR2,
539 p_document_id IN NUMBER,
540 p_template_id IN NUMBER,
541 x_expert_enabled_yn OUT NOCOPY VARCHAR2,
542 x_config_header_id OUT NOCOPY NUMBER,
543 x_config_rev_nbr OUT NOCOPY NUMBER,
544 x_return_status OUT NOCOPY VARCHAR2,
545 x_msg_count OUT NOCOPY NUMBER,
546 x_msg_data OUT NOCOPY VARCHAR2
547 );
548
549 FUNCTION check_rule_type_has_questions (
550 p_template_id IN NUMBER,
551 p_rule_type IN VARCHAR2)
552 RETURN VARCHAR2;
553
554 PROCEDURE contract_expert_bv(
555 p_api_version IN NUMBER,
556 p_init_msg_list IN VARCHAR2,
557 p_document_id IN NUMBER,
558 p_document_type IN VARCHAR2,
559 p_bv_mode IN VARCHAR2 ,
560 x_return_status OUT NOCOPY VARCHAR2,
561 x_msg_count OUT NOCOPY NUMBER,
562 x_msg_data OUT NOCOPY VARCHAR2);
563
564 FUNCTION is_config_complete(
565 p_document_type IN VARCHAR2,
566 p_document_id IN NUMBER
567 ) RETURN VARCHAR2;
568
569 FUNCTION has_unanswered_questions(
570 p_document_type IN VARCHAR2,
571 p_document_id IN NUMBER,
572 p_rule_type IN VARCHAR2
573 ) RETURN VARCHAR2;
574
575 PROCEDURE update_document(
576 p_api_version IN NUMBER,
577 p_init_msg_list IN VARCHAR2,
578 p_document_id IN NUMBER,
579 p_document_type IN VARCHAR2,
580 p_doc_update_mode IN VARCHAR2,
581 x_count_articles_dropped OUT NOCOPY NUMBER,
582 x_return_status OUT NOCOPY VARCHAR2,
583 x_msg_count OUT NOCOPY NUMBER,
584 x_msg_data OUT NOCOPY VARCHAR2
585 ,p_lock_xprt_yn IN VARCHAR2 := 'N' -- Conc Mod changes
586 ,p_lock_terms_yn IN VARCHAR2 := 'N' -- Conc Mod changes
587 );
588
589 END OKC_XPRT_UTIL_PVT ;