[Home] [Help]
PACKAGE: APPS.ECX_DOCUMENT
Source
1 PACKAGE ecx_document AUTHID CURRENT_USER AS
2 -- $Header: ECXSENDS.pls 120.3 2005/10/30 23:57:31 susaha ship $
3 /** Exceptions raised from the ecx_document **/
4 ecx_transaction_not_defined exception;
5 ecx_no_party_setup exception;
6 ecx_delivery_setup_error exception;
7 ecx_no_delivery_required exception;
8
9 /** (A-Synchronous) Send api **/
10 procedure send(
11 transaction_type IN VARCHAR2,
12 transaction_subtype IN VARCHAR2,
13 party_id IN VARCHAR2,
14 party_site_id IN VARCHAR2,
15 party_type IN VARCHAR2 default null,--bug #2183619
16 document_id IN VARCHAR2,
17 parameter1 IN VARCHAR2 default null,
18 parameter2 IN VARCHAR2 default null,
19 parameter3 IN VARCHAR2 default null,
20 parameter4 IN VARCHAR2 default null,
21 parameter5 IN VARCHAR2 default null,
22 debug_mode IN PLS_INTEGER DEFAULT 0,
23 trigger_id OUT NOCOPY PLS_INTEGER,
24 retcode OUT NOCOPY PLS_INTEGER,
25 errmsg OUT NOCOPY VARCHAR2
26 );
27
28 /** (Synchronous) Send Direct api to avoid racing condition **/
29 procedure sendDirect(
30 transaction_type IN VARCHAR2,
31 transaction_subtype IN VARCHAR2,
32 party_id IN VARCHAR2,
33 party_site_id IN VARCHAR2,
34 party_type IN VARCHAR2 default null, --bug #2183619
35 document_id IN VARCHAR2,
36 debug_mode IN PLS_INTEGER DEFAULT 0,
37 i_msgid OUT NOCOPY RAW,
38 retcode OUT NOCOPY PLS_INTEGER,
39 errmsg OUT NOCOPY VARCHAR2
40 );
41
42 /* This is used by the CM */
43 /*procedure send_cm(
44 retcode OUT NOCOPY number,
45 errmsg OUT NOCOPY VARCHAR2 ,
46 transaction_type IN VARCHAR2,
47 transaction_subtype IN VARCHAR2,
48 party_id IN VARCHAR2,
49 party_site_id IN VARCHAR2,
50 document_id IN VARCHAR2,
51 parameter1 IN VARCHAR2,
52 parameter2 IN VARCHAR2,
53 parameter3 IN VARCHAR2,
54 parameter4 IN VARCHAR2,
55 parameter5 IN VARCHAR2,
56 call_type IN varchar2,
57 debug_mode IN number DEFAULT 0
58 );
59 */
60 procedure isDeliveryRequired
61 (
62 transaction_type IN VARCHAR2,
63 transaction_subtype IN VARCHAR2,
64 party_id IN varchar2,
65 party_site_id IN varchar2,
66 party_type IN VARCHAR2 default null,--bug #2183619
67 resultout OUT NOCOPY boolean,
68 retcode OUT NOCOPY PLS_INTEGER,
69 errmsg OUT NOCOPY VARCHAR2
70 );
71
72 procedure getExtPartyInfo
73 (
74 transaction_type IN VARCHAR2,
75 transaction_subtype IN VARCHAR2,
76 party_id IN varchar2,
77 party_site_id IN varchar2,
78 party_type IN VARCHAR2 default null,--bug #2183619
79 ext_type OUT NOCOPY varchar2,
80 ext_subtype OUT NOCOPY varchar2,
81 source_code OUT NOCOPY varchar2,
82 destination_code OUT NOCOPY varchar2,
83 retcode OUT NOCOPY PLS_INTEGER,
84 errmsg OUT NOCOPY VARCHAR2
85 );
86 PROCEDURE get_delivery_attribs
87 (
88 i_transaction_type IN varchar2,
89 i_transaction_subtype IN varchar2,
90 i_party_id IN varchar2,
91 i_party_site_id IN varchar2,
92 i_party_type IN OUT NOCOPY varchar2, --bug #2183619
93 i_standard_type OUT NOCOPY varchar2,
94 i_standard_code OUT NOCOPY varchar2,
95 i_ext_type OUT NOCOPY varchar2,
96 i_ext_subtype OUT NOCOPY varchar2,
97 i_source_code OUT NOCOPY varchar2,
98 i_destination_code OUT NOCOPY varchar2,
99 i_destination_type OUT NOCOPY varchar2,
100 i_destination_address OUT NOCOPY varchar2,
101 i_username OUT NOCOPY varchar2,
102 i_password OUT NOCOPY varchar2,
103 i_map_code OUT NOCOPY varchar2,
104 i_queue_name OUT NOCOPY varchar2,
105 i_tp_header_id OUT NOCOPY pls_integer
106 );
107
108 PROCEDURE get_delivery_attribs
109 (
110 transaction_type IN varchar2,
111 transaction_subtype IN varchar2,
112 party_id IN varchar2,
113 party_site_id IN varchar2,
114 party_type IN OUT NOCOPY varchar2, --Bug #2183619
115 standard_type OUT NOCOPY varchar2,
116 standard_code OUT NOCOPY varchar2,
117 ext_type OUT NOCOPY varchar2,
118 ext_subtype OUT NOCOPY varchar2,
119 source_code OUT NOCOPY varchar2,
120 destination_code OUT NOCOPY varchar2,
121 destination_type OUT NOCOPY varchar2,
122 destination_address OUT NOCOPY varchar2,
123 username OUT NOCOPY varchar2,
124 password OUT NOCOPY varchar2,
125 map_code OUT NOCOPY varchar2,
126 queue_name OUT NOCOPY varchar2,
127 tp_header_id OUT NOCOPY pls_integer,
128 retcode OUT NOCOPY pls_integer,
129 retmsg OUT NOCOPY varchar2
130 );
131
132 PROCEDURE resend
133 (
134 i_msgid IN RAW,
135 retcode OUT NOCOPY PLS_INTEGER,
136 errmsg OUT NOCOPY VARCHAR2,
137 i_flag IN varchar2 default null
138 );
139 /* Added new procedure for bug #2215677*/
140 procedure getConfirmationStatus
141 (
142 i_transaction_type IN VARCHAR2,
143 i_transaction_subtype IN VARCHAR2,
144 i_party_id IN varchar2,
145 i_party_site_id IN varchar2,
146 i_party_type IN varchar2 default null,
147 o_confirmation OUT NOCOPY number
148 );
149
150
151 /**
152 Helper method. This procedure will call getConfirmation, outbound_trigger and
153 get_delivery_attribs
154 **/
155 procedure trigger_outbound (transaction_type IN varchar2,
156 transaction_subtype IN varchar2,
157 party_id IN varchar2,
158 party_site_id IN varchar2,
159 document_id IN varchar2,
160 status IN varchar2,
161 errmsg IN varchar2,
162 trigger_id IN varchar2,
163 p_party_type IN OUT NOCOPY varchar2,
164 p_party_id OUT NOCOPY varchar2,
165 p_party_site_id OUT NOCOPY varchar2,
166 p_message_type OUT NOCOPY varchar2,
167 p_message_standard OUT NOCOPY varchar2,
168 p_ext_type OUT NOCOPY varchar2,
169 p_ext_subtype OUT NOCOPY varchar2,
170 p_source_code OUT NOCOPY varchar2,
171 p_destination_code OUT NOCOPY varchar2,
172 p_destination_type OUT NOCOPY varchar2,
173 p_destination_address OUT NOCOPY varchar2,
174 p_username OUT NOCOPY varchar2,
175 p_password OUT NOCOPY varchar2,
176 p_map_code OUT NOCOPY varchar2,
177 p_queue_name OUT NOCOPY varchar2,
178 p_tp_header_id OUT NOCOPY varchar2
179 );
180
181 end ecx_document;