1 PACKAGE CLN_CH_COLLABORATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: ECXCHCHS.pls 120.1 2005/08/26 06:55:20 nparihar noship $ */
3 /*#
4 * This package is called by both inbound and outbound operations from the application whenever a new collaboration has to be started. Also, the details of any existing collaboration can also be retrieved/updated by calling this package.
5 * @rep:scope private
6 * @rep:product CLN
7 * @rep:displayname CLN API for Collaboration History core functionality
8 * @rep:category BUSINESS_ENTITY CLN_TRADING_PARTNER_COLL
9 * @rep:category BUSINESS_ENTITY CLN_TRADING_PARTNER_COLL_EVENT
10 * @rep:compatibility S
11 * @rep:lifecycle active
12 */
13 -- Package
14 -- CLN_CH_COLLABORATION_PKG
15 --
16 -- Purpose
17 -- Spec of package CLN_CH_COLLABORATION_PKG. This package
18 -- is called by both inbound and outbound operations from the application
19 -- when ever a new collaboration has to be started.Also,the details of any
20 -- existing collaboration can also be retrieved/updated by calling this package.
21 --
22 -- History
23 -- Mar-26-2002 Rahul Krishan Created
24 -- Apr-12-2002 Rahul Krishan Updated
25
26 g_xmlg_oag_application_ref_id VARCHAR2(255); -- Global variable which is set by CLNCHETB with the default ref id
27 -- CLNCHETB obtains it by processing ECX_EVENT_MESSAGE attribute
28
29
30 -- Name
31 -- GET_CONTROL_AREA_REFID
32 -- Purpose
33 -- This procedure is called to retrieve application reference ID based on
34 -- XML message ID from control area of the payload
35 -- Arguments
36 -- XML Gateway Message ID
37 -- Notes
38 -- Uses a DOM Parser to parse the document and retrieve the application reference ID
39 /*#
40 * This procedure is called to retrieve application reference ID based on XML message ID from control area of the payload.
41 * @param p_msgId value
42 * @param p_collaboration_standard value
43 * @param x_app_ref_id value
44 * @param p_app_id value
45 * @param p_coll_type value
46 * @rep:scope private
47 * @rep:lifecycle active
48 * @rep:displayname Gets Control Area Refid
49 */
50 PROCEDURE GET_CONTROL_AREA_REFID(
51 p_msgId IN RAW,
52 p_collaboration_standard IN VARCHAR2,
53 x_app_ref_id IN OUT NOCOPY VARCHAR2,
54 p_app_id IN VARCHAR2,
55 p_coll_type IN VARCHAR2);
56
57 -- Name
58 -- GET_DATA_AREA_REFID
59 -- Purpose
60 -- This procedure is called to retrieve application reference ID based on
61 -- XML message ID from data area of the payload
62 -- Arguments
63 -- XML Gateway Message ID
64 -- Notes
65 -- Uses a DOM Parser to parse the document and retrieve the application reference ID
66 /*#
67 * This procedure is called to retrieve application reference ID based on XML message ID from data area of the payload.
68 * @param p_msgId value
69 * @param p_collaboration_standard value
70 * @param x_app_ref_id value
71 * @param p_app_id value
72 * @param p_coll_type value
73 * @rep:scope private
74 * @rep:lifecycle active
75 * @rep:displayname Gets Data Area Refid
76 */
77
78 PROCEDURE GET_DATA_AREA_REFID(
79 p_msgId IN RAW,
80 p_collaboration_standard IN VARCHAR2,
81 x_app_ref_id IN OUT NOCOPY VARCHAR2,
82 p_app_id IN VARCHAR2,
83 p_coll_type IN VARCHAR2);
84
85 -- Name
86 -- CREATE_COLLABORATION
87 -- Purpose
88 -- This is the public procedure which starts a new Collaboration
89 -- and adds the initial details corresponding to it in both the CLN_COLL_HIST_HDR
90 -- and CLN_COLL_HIST_DTL Tables.
91 -- Arguments
92 --
93 -- Notes
94 -- No specific notes.
95 /*#
96 * This procedure starts a new Collaboration and adds the initial details corresponding to it in both the CLN_COLL_HIST_HDR and CLN_COLL_HIST_DTL Tables.
97 * @param x_return_status value
98 * @param x_msg_data value
99 * @param p_app_id value
100 * @param p_ref_id value
101 * @param p_org_id value
102 * @param p_rel_no value
103 * @param p_doc_no value
104 * @param p_doc_rev_no value
105 * @param p_xmlg_transaction_type value
106 * @param p_xmlg_transaction_subtype value
107 * @param p_xmlg_document_id value
108 * @param p_partner_doc_no value
109 * @param p_coll_type value
110 * @param p_tr_partner_type value
111 * @param p_tr_partner_id value
112 * @param p_tr_partner_site value
113 * @param p_resend_flag value
114 * @param p_resend_count value
115 * @param p_doc_owner value
116 * @param p_init_date value
117 * @param p_doc_creation_date value
118 * @param p_doc_revision_date value
119 * @param p_doc_type value
120 * @param p_doc_dir value
121 * @param p_coll_pt value
122 * @param p_xmlg_msg_id value
123 * @param p_unique1 value
124 * @param p_unique2 value
125 * @param p_unique3 value
126 * @param p_unique4 value
127 * @param p_unique5 value
128 * @param p_sender_component value
129 * @param p_rosettaNet_check_required value
130 * @param x_coll_id value
131 * @param p_xmlg_internal_control_number value
132 * @param p_xmlg_int_transaction_type value
133 * @param p_xmlg_int_transaction_subtype value
134 * @param p_collaboration_standard value
135 * @param p_msg_text value
136 * @param p_xml_event_key value
137 * @param p_attribute1 value
138 * @param p_attribute2 value
139 * @param p_attribute3 value
140 * @param p_attribute4 value
141 * @param p_attribute5 value
142 * @param p_attribute6 value
143 * @param p_attribute7 value
144 * @param p_attribute8 value
145 * @param p_attribute9 value
146 * @param p_attribute10 value
147 * @param p_attribute11 value
148 * @param p_attribute12 value
149 * @param p_attribute13 value
150 * @param p_attribute14 value
151 * @param p_attribute15 value
152 * @param p_dattribute1 value
153 * @param p_dattribute2 value
154 * @param p_dattribute3 value
155 * @param p_dattribute4 value
156 * @param p_dattribute5 value
157 * @param p_owner_role value
158 * @rep:scope private
159 * @rep:lifecycle active
160 * @rep:displayname Creates a Collaboration
161 */
162 PROCEDURE CREATE_COLLABORATION(
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_app_id IN VARCHAR2 DEFAULT NULL,
166 p_ref_id IN VARCHAR2 DEFAULT NULL,
167 p_org_id IN NUMBER DEFAULT NULL,
168 p_rel_no IN VARCHAR2 DEFAULT NULL,
169 p_doc_no IN VARCHAR2 DEFAULT NULL,
170 p_doc_rev_no IN VARCHAR2 DEFAULT NULL,
171 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
172 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
173 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
174 p_partner_doc_no IN VARCHAR2 DEFAULT NULL,
175 p_coll_type IN VARCHAR2 DEFAULT NULL,
176 p_tr_partner_type IN VARCHAR2 DEFAULT NULL,
177 p_tr_partner_id IN VARCHAR2 DEFAULT NULL,
178 p_tr_partner_site IN VARCHAR2 DEFAULT NULL,
179 p_resend_flag IN VARCHAR2 DEFAULT NULL,
180 p_resend_count IN NUMBER DEFAULT NULL,
181 p_doc_owner IN VARCHAR2 DEFAULT NULL,
182 p_init_date IN DATE DEFAULT SYSDATE,
183 p_doc_creation_date IN DATE DEFAULT NULL,
184 p_doc_revision_date IN DATE DEFAULT NULL,
185 p_doc_type IN VARCHAR2 DEFAULT NULL,
186 p_doc_dir IN VARCHAR2 DEFAULT NULL,
187 p_coll_pt IN VARCHAR2 DEFAULT 'APPS',
188 p_xmlg_msg_id IN VARCHAR2,
189 p_unique1 IN VARCHAR2 DEFAULT NULL,
190 p_unique2 IN VARCHAR2 DEFAULT NULL,
191 p_unique3 IN VARCHAR2 DEFAULT NULL,
192 p_unique4 IN VARCHAR2 DEFAULT NULL,
193 p_unique5 IN VARCHAR2 DEFAULT NULL,
194 p_sender_component IN VARCHAR2 DEFAULT NULL,
195 p_rosettanet_check_required IN BOOLEAN DEFAULT TRUE,
196 x_coll_id OUT NOCOPY NUMBER,
197 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
198 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,
199 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,
200 p_msg_text IN VARCHAR2 DEFAULT NULL,
201 p_xml_event_key IN VARCHAR2 DEFAULT NULL,
202 p_collaboration_standard IN VARCHAR2 DEFAULT NULL,
203 p_attribute1 IN VARCHAR2 DEFAULT NULL,
204 p_attribute2 IN VARCHAR2 DEFAULT NULL,
205 p_attribute3 IN VARCHAR2 DEFAULT NULL,
206 p_attribute4 IN VARCHAR2 DEFAULT NULL,
207 p_attribute5 IN VARCHAR2 DEFAULT NULL,
208 p_attribute6 IN VARCHAR2 DEFAULT NULL,
209 p_attribute7 IN VARCHAR2 DEFAULT NULL,
210 p_attribute8 IN VARCHAR2 DEFAULT NULL,
211 p_attribute9 IN VARCHAR2 DEFAULT NULL,
212 p_attribute10 IN VARCHAR2 DEFAULT NULL,
213 p_attribute11 IN VARCHAR2 DEFAULT NULL,
214 p_attribute12 IN VARCHAR2 DEFAULT NULL,
215 p_attribute13 IN VARCHAR2 DEFAULT NULL,
216 p_attribute14 IN VARCHAR2 DEFAULT NULL,
217 p_attribute15 IN VARCHAR2 DEFAULT NULL,
218 p_dattribute1 IN DATE DEFAULT NULL,
219 p_dattribute2 IN DATE DEFAULT NULL,
220 p_dattribute3 IN DATE DEFAULT NULL,
221 p_dattribute4 IN DATE DEFAULT NULL,
222 p_dattribute5 IN DATE DEFAULT NULL,
223 p_owner_role IN VARCHAR2 DEFAULT NULL );
224
225
226
227 -- Name
228 -- UPDATE_COLLABORATION
229 -- Purpose
230 -- This is the public procedure which is called at subsequent stages after creation,
231 -- to update collaboration with the progress.It creates a new row in the CLN_COLL_HIST_DTL
232 -- table and also modifies the CLN_COLL_HIST_HDR if the need may be.
233 -- Arguments
234 --
235 -- Notes
236 -- No specific notes.
237 /*#
238 * This procedure is called at subsequent stages after creation to update collaboration with the progress. It creates a new row in the CLN_COLL_HIST_DTL table and also modifies the CLN_COLL_HIST_HDR if the need may be.
239 * @param x_return_status value
240 * @param x_msg_data value
241 * @param p_coll_id value
242 * @param p_app_id value
243 * @param p_ref_id value
244 * @param p_rel_no value
245 * @param p_doc_no value
246 * @param p_doc_rev_no value
247 * @param p_xmlg_transaction_type value
248 * @param p_xmlg_transaction_subtype value
249 * @param p_xmlg_document_id value
250 * @param p_resend_flag value
251 * @param p_resend_count value
252 * @param p_disposition value
253 * @param p_coll_status value
254 * @param p_doc_type value
255 * @param p_doc_dir value
256 * @param p_coll_pt value
257 * @param p_org_ref value
258 * @param p_doc_status value
259 * @param p_notification_id value
260 * @param p_msg_text value
261 * @param p_bsr_verb value
262 * @param p_bsr_noun value
263 * @param p_bsr_rev value
264 * @param p_sdr_logical_id value
265 * @param p_sdr_component value
266 * @param p_sdr_task value
267 * @param p_sdr_refid value
268 * @param p_sdr_confirmation value
269 * @param p_sdr_language value
270 * @param p_sdr_codepage value
271 * @param p_sdr_authid value
272 * @param p_sdr_datetime_qualifier value
273 * @param p_sdr_datetime value
274 * @param p_sdr_timezone value
275 * @param p_attr1 value
276 * @param p_attr2 value
277 * @param p_attr3 value
278 * @param p_attr4 value
279 * @param p_attr5 value
280 * @param p_attr6 value
281 * @param p_attr7 value
282 * @param p_attr8 value
283 * @param p_attr9 value
284 * @param p_attr10 value
285 * @param p_attr11 value
286 * @param p_attr12 value
287 * @param p_attr13 value
288 * @param p_attr14 value
289 * @param p_attr15 value
290 * @param p_xmlg_msg_id value
291 * @param p_unique1 value
292 * @param p_unique2 value
293 * @param p_unique3 value
294 * @param p_unique4 value
295 * @param p_unique5 value
296 * @param p_tr_partner_type value
297 * @param p_tr_partner_id value
298 * @param p_tr_partner_site value
299 * @param p_sender_component value
300 * @param p_RosettaNet_check_required value
301 * @param x_dtl_coll_id value
302 * @param p_xmlg_internal_control_number value
303 * @param p_partner_doc_no value
304 * @param p_org_id value
305 * @param p_doc_creation_date value
306 * @param p_doc_revision_date value
307 * @param p_doc_owner value
308 * @param p_xmlg_int_transaction_type value
309 * @param p_xmlg_int_transaction_subtype value
310 * @param p_xml_event_key value
311 * @param p_collaboration_standard value
312 * @param p_attribute1 value
313 * @param p_attribute2 value
314 * @param p_attribute3 value
315 * @param p_attribute4 value
316 * @param p_attribute5 value
317 * @param p_attribute6 value
318 * @param p_attribute7 value
319 * @param p_attribute8 value
320 * @param p_attribute9 value
321 * @param p_attribute10 value
322 * @param p_attribute11 value
323 * @param p_attribute12 value
324 * @param p_attribute13 value
325 * @param p_attribute14 value
326 * @param p_attribute15 value
327 * @param p_dattribute1 value
328 * @param p_dattribute2 value
329 * @param p_dattribute3 value
330 * @param p_dattribute4 value
331 * @param p_dattribute5 value
332 * @param p_owner_role value
333 * @rep:scope private
334 * @rep:lifecycle active
335 * @rep:displayname Updates a Collaboration
336 */
337 PROCEDURE UPDATE_COLLABORATION(
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_data OUT NOCOPY VARCHAR2,
340 p_coll_id IN NUMBER DEFAULT NULL,
341 p_app_id IN VARCHAR2 DEFAULT NULL,
342 p_ref_id IN VARCHAR2 DEFAULT NULL,
343 p_rel_no IN VARCHAR2 DEFAULT NULL,
344 p_doc_no IN VARCHAR2 DEFAULT NULL,
345 p_doc_rev_no IN VARCHAR2 DEFAULT NULL,
346 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
347 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
348 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
349 p_resend_flag IN VARCHAR2 DEFAULT NULL,
350 p_resend_count IN NUMBER DEFAULT NULL,
351 p_disposition IN VARCHAR2 DEFAULT NULL,
352 p_coll_status IN VARCHAR2 DEFAULT NULL,
353 p_doc_type IN VARCHAR2 DEFAULT NULL,
354 p_doc_dir IN VARCHAR2 DEFAULT NULL,
355 p_coll_pt IN VARCHAR2 DEFAULT 'APPS',
356 p_org_ref IN VARCHAR2 DEFAULT NULL,
360 p_bsr_verb IN VARCHAR2 DEFAULT NULL,
357 p_doc_status IN VARCHAR2 DEFAULT 'SUCCESS',
358 p_notification_id IN VARCHAR2 DEFAULT NULL,
359 p_msg_text IN VARCHAR2,
361 p_bsr_noun IN VARCHAR2 DEFAULT NULL,
362 p_bsr_rev IN VARCHAR2 DEFAULT NULL,
363 p_sdr_logical_id IN VARCHAR2 DEFAULT NULL,
364 p_sdr_component IN VARCHAR2 DEFAULT NULL,
365 p_sdr_task IN VARCHAR2 DEFAULT NULL,
366 p_sdr_refid IN VARCHAR2 DEFAULT NULL,
367 p_sdr_confirmation IN VARCHAR2 DEFAULT NULL,
368 p_sdr_language IN VARCHAR2 DEFAULT NULL,
369 p_sdr_codepage IN VARCHAR2 DEFAULT NULL,
370 p_sdr_authid IN VARCHAR2 DEFAULT NULL,
371 p_sdr_datetime_qualifier IN VARCHAR2 DEFAULT NULL,
372 p_sdr_datetime IN VARCHAR2 DEFAULT NULL,
373 p_sdr_timezone IN VARCHAR2 DEFAULT NULL,
374 p_attr1 IN VARCHAR2 DEFAULT NULL,
375 p_attr2 IN VARCHAR2 DEFAULT NULL,
376 p_attr3 IN VARCHAR2 DEFAULT NULL,
377 p_attr4 IN VARCHAR2 DEFAULT NULL,
378 p_attr5 IN VARCHAR2 DEFAULT NULL,
379 p_attr6 IN VARCHAR2 DEFAULT NULL,
380 p_attr7 IN VARCHAR2 DEFAULT NULL,
381 p_attr8 IN VARCHAR2 DEFAULT NULL,
382 p_attr9 IN VARCHAR2 DEFAULT NULL,
383 p_attr10 IN VARCHAR2 DEFAULT NULL,
384 p_attr11 IN VARCHAR2 DEFAULT NULL,
385 p_attr12 IN VARCHAR2 DEFAULT NULL,
386 p_attr13 IN VARCHAR2 DEFAULT NULL,
387 p_attr14 IN VARCHAR2 DEFAULT NULL,
388 p_attr15 IN VARCHAR2 DEFAULT NULL,
389 p_xmlg_msg_id IN VARCHAR2,
390 p_unique1 IN VARCHAR2 DEFAULT NULL,
391 p_unique2 IN VARCHAR2 DEFAULT NULL,
392 p_unique3 IN VARCHAR2 DEFAULT NULL,
393 p_unique4 IN VARCHAR2 DEFAULT NULL,
394 p_unique5 IN VARCHAR2 DEFAULT NULL,
395 p_tr_partner_type IN VARCHAR2 DEFAULT NULL,
396 p_tr_partner_id IN VARCHAR2 DEFAULT NULL,
397 p_tr_partner_site IN VARCHAR2 DEFAULT NULL,
398 p_sender_component IN VARCHAR2 DEFAULT NULL,
399 p_rosettanet_check_required IN BOOLEAN DEFAULT TRUE,
400 x_dtl_coll_id OUT NOCOPY NUMBER,
404 p_doc_creation_date IN DATE DEFAULT NULL,
401 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
402 p_partner_doc_no IN VARCHAR2 DEFAULT NULL,
403 p_org_id IN NUMBER DEFAULT NULL,
405 p_doc_revision_date IN DATE DEFAULT NULL,
406 p_doc_owner IN VARCHAR2 DEFAULT NULL,
407 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,
408 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,
409 p_xml_event_key IN VARCHAR2 DEFAULT NULL,
410 p_collaboration_standard IN VARCHAR2 DEFAULT NULL,
411 p_attribute1 IN VARCHAR2 DEFAULT NULL,
412 p_attribute2 IN VARCHAR2 DEFAULT NULL,
413 p_attribute3 IN VARCHAR2 DEFAULT NULL,
414 p_attribute4 IN VARCHAR2 DEFAULT NULL,
415 p_attribute5 IN VARCHAR2 DEFAULT NULL,
416 p_attribute6 IN VARCHAR2 DEFAULT NULL,
417 p_attribute7 IN VARCHAR2 DEFAULT NULL,
418 p_attribute8 IN VARCHAR2 DEFAULT NULL,
419 p_attribute9 IN VARCHAR2 DEFAULT NULL,
420 p_attribute10 IN VARCHAR2 DEFAULT NULL,
421 p_attribute11 IN VARCHAR2 DEFAULT NULL,
422 p_attribute12 IN VARCHAR2 DEFAULT NULL,
423 p_attribute13 IN VARCHAR2 DEFAULT NULL,
424 p_attribute14 IN VARCHAR2 DEFAULT NULL,
425 p_attribute15 IN VARCHAR2 DEFAULT NULL,
426 p_dattribute1 IN DATE DEFAULT NULL,
427 p_dattribute2 IN DATE DEFAULT NULL,
428 p_dattribute3 IN DATE DEFAULT NULL,
429 p_dattribute4 IN DATE DEFAULT NULL,
430 p_dattribute5 IN DATE DEFAULT NULL,
431 p_owner_role IN VARCHAR2 DEFAULT NULL );
432
433
434
435 -- Name
436 -- FIND_COLLABORATION_STATUS
437 -- Purpose
438 -- This is the public procedure which may be called by the user to
439 -- know the status of any Collaboration.
440 -- Arguments
441 --
442 -- Notes
443 -- No specific notes.
444 /*#
445 * This procedure may be called by the user to know the status of any Collaboration.
446 * @param x_return_status value
447 * @param x_msg_data value
448 * @param p_coll_id value
449 * @param p_app_id value
450 * @param p_ref_id value
451 * @param p_rel_no value
452 * @param p_doc_no value
453 * @param p_doc_rev_no value
454 * @param p_xmlg_transaction_type value
455 * @param p_xmlg_transaction_subtype value
456 * @param p_xmlg_document_id value
457 * @param p_unique1 value
458 * @param p_unique2 value
459 * @param p_unique3 value
460 * @param p_unique4 value
461 * @param p_unique5 value
462 * @param p_doc_direction value
463 * @param p_xmlg_msg_id value
464 * @param p_xmlg_internal_control_number value
465 * @param x_coll_status value
466 * @rep:scope private
467 * @rep:lifecycle active
468 * @rep:displayname Finds Collaboration Status
469 */
470 PROCEDURE FIND_COLLABORATION_STATUS(
471 x_return_status OUT NOCOPY VARCHAR2,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_coll_id IN NUMBER,
474 p_app_id IN VARCHAR2,
475 p_ref_id IN VARCHAR2,
476 p_rel_no IN VARCHAR2,
477 p_doc_no IN VARCHAR2,
478 p_doc_rev_no IN VARCHAR2,
479 p_xmlg_transaction_type IN VARCHAR2,
480 p_xmlg_transaction_subtype IN VARCHAR2,
481 p_xmlg_document_id IN VARCHAR2,
482 x_coll_status OUT NOCOPY VARCHAR2,
483 p_unique1 IN VARCHAR2,
484 p_unique2 IN VARCHAR2,
485 p_unique3 IN VARCHAR2,
486 p_unique4 IN VARCHAR2,
487 p_unique5 IN VARCHAR2,
488 p_doc_direction IN VARCHAR2 DEFAULT NULL,
489 p_xmlg_msg_id IN VARCHAR2 DEFAULT NULL,
490 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL );
491
492
493
494 -- Name
495 -- RETRIEVE_COLLABORATION_DETAILS
496 -- Purpose
497 -- This is the public procedure which may be called to retrieve the details of any
498 -- collaboration.
499 -- Arguments
500 --
504 /*#
501 -- Notes
502 -- No specific notes.
503
505 * This procedure may be called to retrieve the details of any collaboration.
506 * @param x_return_status value
507 * @param x_msg_data value
508 * @param p_dtl_coll_id value
509 * @param p_coll_id value
510 * @param x_app_id value
511 * @param x_ref_id value
512 * @param x_rel_no value
513 * @param x_doc_no value
514 * @param x_doc_rev_no value
515 * @param p_xmlg_transaction_type value
516 * @param p_xmlg_transaction_subtype value
517 * @param p_xmlg_document_id value
518 * @param x_resend_flag value
519 * @param x_resend_count value
520 * @param x_disposition value
521 * @param x_coll_status value
522 * @param x_org_id value
523 * @param x_tr_partner_id value
524 * @param x_doc_owner value
525 * @param x_init_date value
526 * @param x_doc_creation_date value
527 * @param x_doc_revision_date value
528 * @param x_doc_type value
529 * @param x_doc_dir value
530 * @param x_coll_pt value
531 * @param x_org_ref value
532 * @param x_doc_status value
533 * @param x_notification_id value
534 * @param x_msg_text value
535 * @param x_bsr_verb value
536 * @param x_bsr_noun value
537 * @param x_bsr_rev value
538 * @param x_sdr_logical_id value
539 * @param x_sdr_component value
540 * @param x_sdr_task value
541 * @param x_sdr_refid value
542 * @param x_sdr_confirmation value
543 * @param x_sdr_language value
544 * @param x_sdr_codepage value
545 * @param x_sdr_authid value
546 * @param x_sdr_datetime_qualifier value
547 * @param x_sdr_datetime value
548 * @param x_sdr_timezone value
549 * @param x_attr1 value
550 * @param x_attr2 value
551 * @param x_attr3 value
552 * @param x_attr4 value
553 * @param x_attr5 value
554 * @param x_attr6 value
555 * @param x_attr7 value
556 * @param x_attr8 value
557 * @param x_attr9 value
558 * @param x_attr10 value
559 * @param x_attr11 value
560 * @param x_attr12 value
561 * @param x_attr13 value
562 * @param x_attr14 value
563 * @param x_attr15 value
564 * @param x_xmlg_msg_id value
565 * @param p_unique1 value
566 * @param p_unique2 value
567 * @param p_unique3 value
568 * @param p_unique4 value
569 * @param p_unique5 value
570 * @param p_xmlg_internal_control_number value
571 * @rep:scope private
572 * @rep:lifecycle active
573 * @rep:displayname Retrives Collaboration Details
574 */
575 PROCEDURE RETRIEVE_COLLABORATION_DETAILS(
576 x_return_status OUT NOCOPY VARCHAR2,
577 x_msg_data OUT NOCOPY VARCHAR2,
578 p_dtl_coll_id IN NUMBER,
579 p_coll_id IN NUMBER,
580 x_app_id IN OUT NOCOPY VARCHAR2,
581 x_ref_id IN OUT NOCOPY VARCHAR2,
582 x_rel_no IN OUT NOCOPY VARCHAR2,
583 x_doc_no IN OUT NOCOPY VARCHAR2,
584 x_doc_rev_no IN OUT NOCOPY VARCHAR2,
585 p_xmlg_transaction_type IN OUT NOCOPY VARCHAR2,
586 p_xmlg_transaction_subtype IN OUT NOCOPY VARCHAR2,
587 p_xmlg_document_id IN OUT NOCOPY VARCHAR2,
588 x_resend_flag OUT NOCOPY VARCHAR2,
589 x_resend_count OUT NOCOPY NUMBER,
590 x_disposition OUT NOCOPY VARCHAR2,
591 x_coll_status OUT NOCOPY VARCHAR2,
592 x_org_id OUT NOCOPY NUMBER,
593 x_tr_partner_id OUT NOCOPY VARCHAR2,
594 x_doc_owner OUT NOCOPY VARCHAR2,
595 x_init_date OUT NOCOPY DATE,
596 x_doc_creation_date OUT NOCOPY DATE,
597 x_doc_revision_date OUT NOCOPY DATE,
598 x_doc_type IN OUT NOCOPY VARCHAR2,
599 x_doc_dir IN OUT NOCOPY VARCHAR2,
600 x_coll_pt IN OUT NOCOPY VARCHAR2,
601 x_org_ref OUT NOCOPY VARCHAR2,
602 x_doc_status OUT NOCOPY VARCHAR2,
603 x_notification_id OUT NOCOPY VARCHAR2,
604 x_msg_text OUT NOCOPY VARCHAR2,
605 x_bsr_verb OUT NOCOPY VARCHAR2,
606 x_bsr_noun OUT NOCOPY VARCHAR2,
607 x_bsr_rev OUT NOCOPY VARCHAR2,
608 x_sdr_logical_id OUT NOCOPY VARCHAR2,
609 x_sdr_component OUT NOCOPY VARCHAR2,
610 x_sdr_task OUT NOCOPY VARCHAR2,
611 x_sdr_refid OUT NOCOPY VARCHAR2,
612 x_sdr_confirmation OUT NOCOPY VARCHAR2,
613 x_sdr_language OUT NOCOPY VARCHAR2,
614 x_sdr_codepage OUT NOCOPY VARCHAR2,
615 x_sdr_authid OUT NOCOPY VARCHAR2,
616 x_sdr_datetime_qualifier OUT NOCOPY VARCHAR2,
617 x_sdr_datetime OUT NOCOPY VARCHAR2,
618 x_sdr_timezone OUT NOCOPY VARCHAR2,
619 x_attr1 OUT NOCOPY VARCHAR2,
623 x_attr5 OUT NOCOPY VARCHAR2,
620 x_attr2 OUT NOCOPY VARCHAR2,
621 x_attr3 OUT NOCOPY VARCHAR2,
622 x_attr4 OUT NOCOPY VARCHAR2,
624 x_attr6 OUT NOCOPY VARCHAR2,
625 x_attr7 OUT NOCOPY VARCHAR2,
626 x_attr8 OUT NOCOPY VARCHAR2,
627 x_attr9 OUT NOCOPY VARCHAR2,
628 x_attr10 OUT NOCOPY VARCHAR2,
629 x_attr11 OUT NOCOPY VARCHAR2,
630 x_attr12 OUT NOCOPY VARCHAR2,
631 x_attr13 OUT NOCOPY VARCHAR2,
632 x_attr14 OUT NOCOPY VARCHAR2,
633 x_attr15 OUT NOCOPY VARCHAR2,
634 x_xmlg_msg_id IN OUT NOCOPY VARCHAR2,
635 p_unique1 IN VARCHAR2,
636 p_unique2 IN VARCHAR2,
637 p_unique3 IN VARCHAR2,
638 p_unique4 IN VARCHAR2,
639 p_unique5 IN VARCHAR2,
640 p_xmlg_internal_control_number IN OUT NOCOPY NUMBER );
641
642
643
644 -- Name
645 -- ADD_COLLABORATION_MESSAGES
646 -- Purpose
647 -- This is the public procedure which may be called by user for adding
648 -- detail messages related with any Collaboration.
649 -- Arguments
650 --
651 -- Notes
652 -- No specific notes.
653 /*#
654 * This procedure may be called by user for adding detailed messages related with any Collaboration.
655
656 * @param x_return_status value
657 * @param x_msg_data value
658 * @param p_dtl_coll_id value
659 * @param p_ref1 value
660 * @param p_ref2 value
661 * @param p_ref3 value
662 * @param p_ref4 value
663 * @param p_ref5 value
664 * @param p_dtl_msg value
665 * @param p_coll_id value
666 * @param p_xmlg_transaction_type value
667 * @param p_xmlg_transaction_subtype value
668 * @param p_xmlg_document_id value
669 * @param p_doc_type value
670 * @param p_doc_direction value
671 * @param p_coll_point value
672 * @param p_xmlg_internal_control_number value
673 * @param p_xmlg_int_transaction_type value
674 * @param p_xmlg_int_transaction_subtype value
675 * @param p_xmlg_msg_id value
676 * @param p_app_id value
677 * @param p_ref_id value
678 * @param p_unique1 value
679 * @param p_unique2 value
680 * @param p_unique3 value
681 * @param p_unique4 value
682 * @param p_unique5 value
683 * @param p_xml_event_key value
684 * @rep:scope private
685 * @rep:lifecycle active
686 * @rep:displayname Adds Collaboration Messages
687 */
688 PROCEDURE ADD_COLLABORATION_MESSAGES(
689 x_return_status OUT NOCOPY VARCHAR2,
690 x_msg_data OUT NOCOPY VARCHAR2,
691 p_dtl_coll_id IN NUMBER,
692 p_ref1 IN VARCHAR2 DEFAULT NULL,
693 p_ref2 IN VARCHAR2 DEFAULT NULL,
694 p_ref3 IN VARCHAR2 DEFAULT NULL,
695 p_ref4 IN VARCHAR2 DEFAULT NULL,
696 p_ref5 IN VARCHAR2 DEFAULT NULL,
697 p_dtl_msg IN VARCHAR2,
698 p_coll_id IN NUMBER DEFAULT NULL,
699 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
700 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
701 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
702 p_doc_type IN VARCHAR2 DEFAULT NULL,
703 p_doc_direction IN VARCHAR2 DEFAULT NULL,
704 p_coll_point IN VARCHAR2 DEFAULT NULL,
705 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
706 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,
707 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,
708 p_xmlg_msg_id IN VARCHAR2 DEFAULT NULL,
709 p_xml_event_key IN VARCHAR2 DEFAULT NULL,
710 p_app_id IN VARCHAR2 DEFAULT NULL,
711 p_ref_id IN VARCHAR2 DEFAULT NULL,
712 p_unique1 IN VARCHAR2 DEFAULT NULL,
713 p_unique2 IN VARCHAR2 DEFAULT NULL,
714 p_unique3 IN VARCHAR2 DEFAULT NULL,
715 p_unique4 IN VARCHAR2 DEFAULT NULL,
716 p_unique5 IN VARCHAR2 DEFAULT NULL );
717
718
719
720 -- Name
721 -- IS_UPDATE_REQUIRED
722 -- Purpose
723 -- This is the public procedure which checks for the protocol used
724 -- based on few parameters passed in and accordingly,collaboration is updated.
725 -- Arguments
726 --
727 -- Notes
728 -- No specific notes.
729 /*#
730 * This procedure checks for the protocol used based on few parameters passed in and accordingly, collaboration is updated.
731 * @param x_return_status value
732 * @param x_msg_data value
733 * @param p_doc_dir value
737 * @param p_tr_partner_id value
734 * @param p_xmlg_transaction_type value
735 * @param p_xmlg_transaction_subtype value
736 * @param p_tr_partner_type value
738 * @param p_tr_partner_site value
739 * @param p_sender_component value
740 * @param x_update_reqd value
741 * @rep:scope private
742 * @rep:lifecycle active
743 * @rep:displayname Checks if Update is required
744 */
745 PROCEDURE IS_UPDATE_REQUIRED(
746 x_return_status OUT NOCOPY VARCHAR2,
747 x_msg_data OUT NOCOPY VARCHAR2,
748 p_doc_dir IN VARCHAR2,
749 p_xmlg_transaction_type IN VARCHAR2,
750 p_xmlg_transaction_subtype IN VARCHAR2,
751 p_tr_partner_type IN VARCHAR2,
752 p_tr_partner_id IN VARCHAR2,
753 p_tr_partner_site IN VARCHAR2,
754 p_sender_component IN VARCHAR2,
755 x_update_reqd OUT NOCOPY BOOLEAN);
756
757
758
759
760 -- Name
761 -- FIND_COLLABORATION_DETAIL_ID
762 -- Purpose
763 -- This is the public procedure which may be called by the user to
764 -- query the detail collaboration id.
765 -- Arguments
766 --
767 -- Notes
768 -- No specific notes.
769 /*#
770 * This procedure may be used to get the latest collaboration detail id for a particular collaboration id or other parameters.
771 * @param x_return_status value
772 * @param x_msg_data value
773 * @param p_coll_id value
774 * @param p_app_id value
775 * @param p_ref_id value
776 * @param p_rel_no value
777 * @param p_doc_no value
778 * @param p_doc_rev_no value
779 * @param p_xmlg_transaction_type value
780 * @param p_xmlg_transaction_subtype value
781 * @param p_xmlg_document_id value
782 * @param p_unique1 value
783 * @param p_unique2 value
784 * @param p_unique3 value
785 * @param p_unique4 value
786 * @param p_unique5 value
787 * @param p_doc_type value
788 * @param p_doc_direction value
789 * @param p_coll_point value
790 * @param x_dtl_coll_id value
791 * @param p_xmlg_msg_id value
792 * @param p_xmlg_internal_control_number value
793 * @param p_xmlg_int_transaction_type value
794 * @param p_xmlg_int_transaction_subtype value
795 * @param p_xml_event_key value
796 * @rep:scope private
797 * @rep:lifecycle active
798 * @rep:displayname Finds Collaboration Detail Id
799 */
800 PROCEDURE FIND_COLLABORATION_DETAIL_ID(
801 x_return_status OUT NOCOPY VARCHAR2,
802 x_msg_data OUT NOCOPY VARCHAR2,
803 p_coll_id IN NUMBER,
804 p_app_id IN VARCHAR2 DEFAULT NULL,
805 p_ref_id IN VARCHAR2 DEFAULT NULL,
806 p_rel_no IN VARCHAR2 DEFAULT NULL,
807 p_doc_no IN VARCHAR2 DEFAULT NULL,
808 p_doc_rev_no IN VARCHAR2 DEFAULT NULL,
809 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
810 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
811 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
812 p_unique1 IN VARCHAR2 DEFAULT NULL,
813 p_unique2 IN VARCHAR2 DEFAULT NULL,
814 p_unique3 IN VARCHAR2 DEFAULT NULL,
815 p_unique4 IN VARCHAR2 DEFAULT NULL,
816 p_unique5 IN VARCHAR2 DEFAULT NULL,
817 p_doc_type IN VARCHAR2 DEFAULT NULL,
818 p_doc_direction IN VARCHAR2 DEFAULT NULL,
819 p_coll_point IN VARCHAR2 DEFAULT NULL,
820 x_dtl_coll_id OUT NOCOPY NUMBER,
821 p_xmlg_msg_id IN VARCHAR2 DEFAULT NULL,
822 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
823 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,
824 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,
825 p_xml_event_key IN VARCHAR2 DEFAULT NULL);
826
827
828
829
830 -- Name
831 -- GET_TRADING_PARTNER_DETAILS
832 -- Purpose
833 -- This is the public procedure which checks for the trading partner details from the
834 -- xmlg tables based on the parameters passed.
835 -- Arguments
836 --
837 -- Notes
838 -- No specific notes.
839 /*#
840 * This procedure checks for the trading partner details from the xmlg tables based on the parameters passed.
841 * @param x_return_status value
842 * @param x_msg_data value
843 * @param p_xmlg_internal_control_number value
844 * @param p_xmlg_msg_id value
845 * @param p_xmlg_transaction_type value
846 * @param p_xmlg_transaction_subtype value
847 * @param p_xmlg_int_transaction_type value
848 * @param p_xmlg_int_transaction_subtype value
849 * @param p_xmlg_document_id value
850 * @param p_doc_dir value
851 * @param p_tr_partner_type value
852 * @param p_tr_partner_id value
853 * @param p_tr_partner_site value
854 * @param p_sender_component value
855 * @param p_xml_event_key value
859 * @rep:displayname Gets Trading Patner Details
856 * @param p_collaboration_standard value
857 * @rep:scope private
858 * @rep:lifecycle active
860 */
861 PROCEDURE GET_TRADING_PARTNER_DETAILS(
862 x_return_status OUT NOCOPY VARCHAR2,
863 x_msg_data OUT NOCOPY VARCHAR2,
864 p_xmlg_internal_control_number IN OUT NOCOPY NUMBER,
865 p_xmlg_msg_id IN OUT NOCOPY VARCHAR2,
866 p_xmlg_transaction_type IN OUT NOCOPY VARCHAR2,
867 p_xmlg_transaction_subtype IN OUT NOCOPY VARCHAR2,
868 p_xmlg_int_transaction_type IN OUT NOCOPY VARCHAR2,
869 p_xmlg_int_transaction_subtype IN OUT NOCOPY VARCHAR2,
870 p_xmlg_document_id IN OUT NOCOPY VARCHAR2,
871 p_doc_dir IN OUT NOCOPY VARCHAR2,
872 p_tr_partner_type IN OUT NOCOPY VARCHAR2,
873 p_tr_partner_id IN OUT NOCOPY VARCHAR2,
874 p_tr_partner_site IN OUT NOCOPY VARCHAR2,
875 p_sender_component IN OUT NOCOPY VARCHAR2,
876 p_xml_event_key IN OUT NOCOPY VARCHAR2,
877 p_collaboration_standard IN OUT NOCOPY VARCHAR2);
878
879
880
881 -- Name
882 -- DEFAULT_XMLGTXN_MAPPING
883 -- Purpose
884 -- This is the public procedure which returns the application id for a given set of
885 -- parameters passed while refering to teh CLN_CH_XMLGTXN_MAPPING.
886 -- Arguments
887 --
888 -- Notes
889 -- No specific notes.
890 /*#
891 * This procedure returns the application id for a given set of parameters passed while referring to the CLN_CH_XMLGTXN_MAPPING.
892 * @param x_return_status value
893 * @param x_msg_data value
894 * @param p_xmlg_transaction_type value
895 * @param p_xmlg_transaction_subtype value
896 * @param p_doc_dir value
897 * @param p_app_id value
898 * @param p_coll_type value
899 * @param p_doc_type value
900 * @rep:scope private
901 * @rep:lifecycle active
902 * @rep:displayname Internal XMLG transaction mapping call.
903 */
904 PROCEDURE DEFAULT_XMLGTXN_MAPPING(
905 x_return_status OUT NOCOPY VARCHAR2,
906 x_msg_data OUT NOCOPY VARCHAR2,
907 p_xmlg_transaction_type IN VARCHAR2,
908 p_xmlg_transaction_subtype IN VARCHAR2,
909 p_doc_dir IN VARCHAR2,
910 p_app_id IN OUT NOCOPY VARCHAR2 ,
911 p_coll_type IN OUT NOCOPY VARCHAR2,
912 p_doc_type IN OUT NOCOPY VARCHAR2 );
913
914
915 -- Name
916 -- DEFAULT_COLLABORATION_STATUS
917 -- Purpose
918 -- This procedure defaults collaboration status based on the rules defined in
919 -- CLN_COLL_STATUS_MAPPING table.
920 -- Arguments
921 --
922 -- Notes
923 -- No specific notes.
924 /*#
925 * This procedure defaults collaboration status based on the rules defined in CLN_COLL_STATUS_MAPPING table.
926 * @param x_return_status value
927 * @param x_msg_data value
928 * @param x_coll_status value
929 * @param p_app_id value
930 * @param p_coll_type value
931 * @param p_doc_status value
932 * @param p_doc_type value
933 * @param p_doc_dir value
934 * @param p_coll_id value
935 * @param p_coll_standard value
936 * @rep:scope private
937 * @rep:lifecycle active
938 * @rep:displayname Defaults Collaboration Status
939 */
940 PROCEDURE DEFAULT_COLLABORATION_STATUS(
941 x_return_status OUT NOCOPY VARCHAR2,
942 x_msg_data OUT NOCOPY VARCHAR2,
943 x_coll_status IN OUT NOCOPY VARCHAR2,
944 p_app_id IN VARCHAR2,
945 p_coll_type IN VARCHAR2,
946 p_doc_status IN VARCHAR2,
947 p_doc_type IN VARCHAR2,
948 p_doc_dir IN VARCHAR2,
949 p_coll_id IN NUMBER,
950 p_coll_standard IN VARCHAR2 DEFAULT NULL);
951
952
953
954 -- Name
955 -- FIND_COLLABORATION_ID
956 -- Purpose
957 -- This is the public procedure which may be used to get the collaboration id
958 -- for a particular transaction.
959 -- Arguments
960 --
961 -- Notes
962 -- No specific notes.
963 /*#
964 * This procedure may be used to get the collaboration id for a particular transaction.
965 * @param x_return_status value
966 * @param x_msg_data value
967 * @param x_coll_id value
968 * @param p_app_id value
969 * @param p_coll_type value
970 * @param p_ref_id value
971 * @param p_xmlg_transaction_type value
972 * @param p_xmlg_transaction_subtype value
973 * @param p_xmlg_int_transaction_type value
974 * @param p_xmlg_int_transaction_subtype value
975 * @param p_tr_partner_id value
976 * @param p_tr_partner_site value
977 * @param p_tr_partner_type value
978 * @param p_xmlg_document_id value
982 * @param p_unique2 value
979 * @param p_doc_dir value
980 * @param p_xmlg_msg_id value
981 * @param p_unique1 value
983 * @param p_unique3 value
984 * @param p_unique4 value
985 * @param p_unique5 value
986 * @param p_xmlg_internal_control_number value
987 * @param p_xml_event_key value
988 * @param p_collaboration_standard value
989 * @rep:scope private
990 * @rep:lifecycle active
991 * @rep:displayname Finds Collaboration Id
992 */
993 PROCEDURE FIND_COLLABORATION_ID(
994 x_return_status OUT NOCOPY VARCHAR2,
995 x_msg_data OUT NOCOPY VARCHAR2,
996 x_coll_id OUT NOCOPY NUMBER,
997 p_app_id IN VARCHAR2 DEFAULT NULL,
998 p_coll_type IN VARCHAR2 DEFAULT NULL,
999 p_ref_id IN VARCHAR2 DEFAULT NULL,
1000 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
1001 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1002 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,--NOT USED FOR THIS RELEASE
1003 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,--NOT USED FOR THIS RELEASE
1004 p_tr_partner_id IN VARCHAR2 DEFAULT NULL,
1005 p_tr_partner_site IN VARCHAR2 DEFAULT NULL,
1006 p_tr_partner_type IN VARCHAR2 DEFAULT NULL,
1007 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
1008 p_doc_dir IN VARCHAR2 DEFAULT NULL,
1009 p_xmlg_msg_id IN VARCHAR2 DEFAULT NULL,
1010 p_unique1 IN VARCHAR2 DEFAULT NULL,
1011 p_unique2 IN VARCHAR2 DEFAULT NULL,
1012 p_unique3 IN VARCHAR2 DEFAULT NULL,
1013 p_unique4 IN VARCHAR2 DEFAULT NULL,
1014 p_unique5 IN VARCHAR2 DEFAULT NULL,
1015 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
1016 p_xml_event_key IN VARCHAR2 DEFAULT NULL,
1017 p_collaboration_standard IN VARCHAR2 DEFAULT NULL);
1018
1019
1020 -- Name
1021 -- ADD_COLLABORATION
1022 -- Purpose
1023 -- This is the public procedure which decides whether the collaboration nneds to be created
1024 -- or updated.
1025 -- Arguments
1026 --
1027 -- Notes
1028 -- No specific notes.
1029 /*#
1030 * This procedure which decides whether the collaboration needs to be created or updated
1031 * @param x_return_status value
1032 * @param x_msg_data value
1033 * @param p_coll_id value
1034 * @param p_app_id value
1035 * @param p_ref_id value
1036 * @param p_rel_no value
1037 * @param p_doc_no value
1038 * @param p_doc_rev_no value
1039 * @param p_xmlg_transaction_type value
1040 * @param p_xmlg_transaction_subtype value
1041 * @param p_xmlg_document_id value
1042 * @param p_resend_flag value
1043 * @param p_resend_count value
1044 * @param p_disposition value
1045 * @param p_coll_status value
1046 * @param p_coll_type value
1047 * @param p_coll_pt value
1048 * @param p_doc_type value
1049 * @param p_doc_dir value
1050 * @param p_org_ref value
1051 * @param p_doc_status value
1052 * @param p_notification_id value
1053 * @param p_msg_text value
1054 * @param p_attr1 value
1055 * @param p_attr2 value
1056 * @param p_attr3 value
1057 * @param p_attr4 value
1058 * @param p_attr5 value
1059 * @param p_attr6 value
1060 * @param p_attr7 value
1061 * @param p_attr8 value
1062 * @param p_attr9 value
1063 * @param p_attr10 value
1064 * @param p_attr11 value
1065 * @param p_attr12 value
1066 * @param p_attr13 value
1067 * @param p_attr14 value
1068 * @param p_attr15 value
1069 * @param p_unique1 value
1070 * @param p_unique2 value
1071 * @param p_unique3 value
1072 * @param p_unique4 value
1073 * @param p_unique5 value
1074 * @param p_tr_partner_type value
1075 * @param p_tr_partner_id value
1076 * @param p_tr_partner_site value
1077 * @param p_sender_component value
1078 * @param p_RosettaNet_check_required value
1079 * @param x_dtl_coll_id value
1080 * @param p_xmlg_internal_control_number value
1081 * @param p_partner_doc_no value
1082 * @param p_org_id value
1083 * @param p_init_date value
1084 * @param p_doc_creation_date value
1085 * @param p_doc_revision_date value
1086 * @param p_doc_owner value
1087 * @param p_xmlg_int_transaction_type value
1088 * @param p_xmlg_int_transaction_subtype value
1089 * @param p_xml_event_key value
1090 * @param p_collaboration_standard value
1091 * @param p_attribute1 value
1092 * @param p_attribute2 value
1093 * @param p_attribute3 value
1094 * @param p_attribute4 value
1095 * @param p_attribute5 value
1096 * @param p_attribute6 value
1097 * @param p_attribute7 value
1098 * @param p_attribute8 value
1099 * @param p_attribute9 value
1100 * @param p_attribute10 value
1101 * @param p_attribute11 value
1102 * @param p_attribute12 value
1103 * @param p_attribute13 value
1104 * @param p_attribute14 value
1105 * @param p_attribute15 value
1106 * @param p_dattribute1 value
1110 * @param p_dattribute5 value
1107 * @param p_dattribute2 value
1108 * @param p_dattribute3 value
1109 * @param p_dattribute4 value
1111 * @param p_xmlg_msg_id value
1112 * @param p_owner_role value
1113 * @rep:scope private
1114 * @rep:lifecycle active
1115 * @rep:displayname Adds Collaboration
1116 */
1117 PROCEDURE ADD_COLLABORATION(
1118 x_return_status OUT NOCOPY VARCHAR2,
1119 x_msg_data OUT NOCOPY VARCHAR2,
1120 p_coll_id IN NUMBER DEFAULT NULL,
1121 p_app_id IN VARCHAR2 DEFAULT NULL,
1122 p_ref_id IN VARCHAR2 DEFAULT NULL,
1123 p_rel_no IN VARCHAR2 DEFAULT NULL,
1124 p_doc_no IN VARCHAR2 DEFAULT NULL,
1125 p_doc_rev_no IN VARCHAR2 DEFAULT NULL,
1126 p_xmlg_transaction_type IN VARCHAR2 DEFAULT NULL,
1127 p_xmlg_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1128 p_xmlg_document_id IN VARCHAR2 DEFAULT NULL,
1129 p_resend_flag IN VARCHAR2 DEFAULT NULL,
1130 p_resend_count IN NUMBER DEFAULT NULL,
1131 p_disposition IN VARCHAR2 DEFAULT NULL,
1132 p_coll_status IN VARCHAR2 DEFAULT NULL,
1133 p_coll_type IN VARCHAR2 DEFAULT NULL,
1134 p_coll_pt IN VARCHAR2 DEFAULT 'APPS',
1135 p_doc_type IN VARCHAR2 DEFAULT NULL,
1136 p_doc_dir IN VARCHAR2 DEFAULT NULL,
1137 p_org_ref IN VARCHAR2 DEFAULT NULL,
1138 p_doc_status IN VARCHAR2 DEFAULT 'SUCCESS',
1139 p_notification_id IN VARCHAR2 DEFAULT NULL,
1140 p_msg_text IN VARCHAR2 ,
1141 p_attr1 IN VARCHAR2 DEFAULT NULL,
1142 p_attr2 IN VARCHAR2 DEFAULT NULL,
1143 p_attr3 IN VARCHAR2 DEFAULT NULL,
1144 p_attr4 IN VARCHAR2 DEFAULT NULL,
1145 p_attr5 IN VARCHAR2 DEFAULT NULL,
1146 p_attr6 IN VARCHAR2 DEFAULT NULL,
1147 p_attr7 IN VARCHAR2 DEFAULT NULL,
1148 p_attr8 IN VARCHAR2 DEFAULT NULL,
1149 p_attr9 IN VARCHAR2 DEFAULT NULL,
1150 p_attr10 IN VARCHAR2 DEFAULT NULL,
1151 p_attr11 IN VARCHAR2 DEFAULT NULL,
1152 p_attr12 IN VARCHAR2 DEFAULT NULL,
1153 p_attr13 IN VARCHAR2 DEFAULT NULL,
1154 p_attr14 IN VARCHAR2 DEFAULT NULL,
1155 p_attr15 IN VARCHAR2 DEFAULT NULL,
1156 p_xmlg_msg_id IN VARCHAR2,
1157 p_unique1 IN VARCHAR2 DEFAULT NULL,
1158 p_unique2 IN VARCHAR2 DEFAULT NULL,
1162 p_tr_partner_type IN VARCHAR2 DEFAULT NULL,
1159 p_unique3 IN VARCHAR2 DEFAULT NULL,
1160 p_unique4 IN VARCHAR2 DEFAULT NULL,
1161 p_unique5 IN VARCHAR2 DEFAULT NULL,
1163 p_tr_partner_id IN VARCHAR2 DEFAULT NULL,
1164 p_tr_partner_site IN VARCHAR2 DEFAULT NULL,
1165 p_sender_component IN VARCHAR2 DEFAULT NULL,
1166 p_rosettanet_check_required IN BOOLEAN DEFAULT NULL,
1167 x_dtl_coll_id OUT NOCOPY NUMBER,
1168 p_xmlg_internal_control_number IN NUMBER DEFAULT NULL,
1169 p_partner_doc_no IN VARCHAR2 DEFAULT NULL,
1170 p_org_id IN NUMBER DEFAULT NULL,
1171 p_init_date IN DATE DEFAULT SYSDATE,
1172 p_doc_creation_date IN DATE DEFAULT NULL,
1173 p_doc_revision_date IN DATE DEFAULT NULL,
1174 p_doc_owner IN VARCHAR2 DEFAULT NULL,
1175 p_xmlg_int_transaction_type IN VARCHAR2 DEFAULT NULL,
1176 p_xmlg_int_transaction_subtype IN VARCHAR2 DEFAULT NULL,
1177 p_xml_event_key IN VARCHAR2 DEFAULT NULL,
1178 p_collaboration_standard IN VARCHAR2 DEFAULT NULL,
1179 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1180 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1181 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1182 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1183 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1184 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1185 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1186 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1187 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1188 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1189 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1190 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1191 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1192 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1193 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1194 p_dattribute1 IN DATE DEFAULT NULL,
1195 p_dattribute2 IN DATE DEFAULT NULL,
1196 p_dattribute3 IN DATE DEFAULT NULL,
1197 p_dattribute4 IN DATE DEFAULT NULL,
1198 p_dattribute5 IN DATE DEFAULT NULL,
1199 p_owner_role IN VARCHAR2 DEFAULT NULL );
1200
1201 END CLN_CH_COLLABORATION_PKG;
[Home] [Help]