1 PACKAGE ECX_TRANSACTIONS_API AUTHID CURRENT_USER AS
2 -- $Header: ECXTXNAS.pls 120.1.12000000.3 2007/07/20 07:38:44 susaha ship $
3
4 /**
5 This retrieves Transaction from the transaction definition in the ECX_TRANSACTIONS table.
6 **/
7 procedure retrieve_transaction
8 (
9 x_return_status Out NOCOPY pls_integer,
10 x_msg Out NOCOPY varchar2,
11 X_transaction_id Out NOCOPY Pls_integer,
12 p_transaction_type In Varchar2,
13 p_transaction_subtype In Varchar2,
14 p_party_type In Varchar2,
15 x_transaction_description OUT NOCOPY Varchar2,
16 x_created_by Out NOCOPY pls_integer,
17 x_creation_date Out NOCOPY date,
18 x_last_updated_by Out NOCOPY pls_integer,
19 x_last_update_date Out NOCOPY date
20 );
21
22 /**
23 This Create_Transaction API is used to create a new transaction definition in the ECX_TRANSACTIONS table.
24 **/
25 procedure create_transaction
26 (
27 x_return_status Out NOCOPY pls_integer,
28 x_msg Out NOCOPY varchar2,
29 X_transaction_id Out NOCOPY Pls_integer,
30 p_transaction_type In Varchar2,
31 p_transaction_subtype In Varchar2,
32 p_transaction_description In Varchar2,
33 p_admin_user in varchar2 default null,
34 p_party_type In Varchar2,
35 p_owner IN varchar2 default 'CUSTOM'
36 );
37
38 /**
39 This Update_Transaction API is used to update an existing transaction description in the ECX_TRANSACTIONS table.
40 **/
41 procedure update_transaction
42 (
43 x_return_status Out NOCOPY pls_integer,
44 x_msg Out NOCOPY varchar2,
45 p_transaction_id In Pls_integer,
46 p_transaction_type In Varchar2,
47 p_transaction_subtype In Varchar2,
48 p_party_type In Varchar2,
49 p_transaction_description In Varchar2,
50 p_owner IN varchar2 default 'CUSTOM'
51 );
52
53 /**
54 This Delete_Transaction API is used to delete an existing transaction definition in the ECX_TRANSACTIONS
55 table and also the external processes that are associate to it. This API allows users to delete a
56 transaction definition by specifying the transaction id.
57 **/
58 procedure delete_transaction
59 (
60 x_return_status Out NOCOPY pls_integer,
61 x_msg Out NOCOPY varchar2,
62 p_transaction_id In Pls_integer
63 );
64 /**
65 This Retrieve_Ext_Process API is used to retrieve an existing external
66 process definition from the ECX_EXT_PROCESSES table.
67 **/
68 /* Bug #2183619, Added two additional input parameters for
69 External Type and Subtype */
70 procedure retrieve_external_transaction
71 (
72 x_return_status Out NOCOPY pls_integer,
73 x_msg Out NOCOPY varchar2,
74 X_ext_process_id Out NOCOPY pls_integer,
75 p_transaction_id in pls_integer,
76 p_standard In Varchar2,
77 p_direction In Varchar2,
78 x_transaction_description Out NOCOPY Varchar2,
79 x_ext_type Out NOCOPY Varchar2,
80 x_ext_subtype Out NOCOPY Varchar2,
81 x_standard_id Out NOCOPY pls_integer,
82 x_queue_name Out NOCOPY Varchar2,
83 x_created_by Out NOCOPY pls_integer,
84 x_creation_date Out NOCOPY date,
85 x_last_updated_by Out NOCOPY pls_integer,
86 x_last_update_date Out NOCOPY date,
87 p_ext_type In Varchar2 default null,
88 p_ext_subtype In Varchar2 default null,
89 p_standard_type IN varchar2 default 'XML'
90 );
91
92
93 /**
94 Overloaded Procedure.This Retrieve_Ext_Process API is used to retrieve an existing external
95 process definition from the ECX_EXT_PROCESSES table.
96 **/
97 /* Bug #2183619, Added two additional input parameters for
98 External Type and Subtype */
99 procedure retrieve_external_transaction
100 (
101 x_return_status Out NOCOPY pls_integer,
102 x_msg Out NOCOPY varchar2,
103 X_ext_process_id Out NOCOPY pls_integer,
104 x_transaction_id OUT NOCOPY pls_integer,
105 p_transaction_type IN varchar2,
106 p_transaction_subtype IN varchar2,
107 p_party_type IN varchar2,
108 p_standard In Varchar2,
109 p_direction In Varchar2,
110 x_transaction_description Out NOCOPY Varchar2,
111 x_ext_type Out NOCOPY Varchar2,
112 x_ext_subtype Out NOCOPY Varchar2,
113 x_standard_id Out NOCOPY pls_integer,
114 x_queue_name Out NOCOPY Varchar2,
115 x_created_by Out NOCOPY pls_integer,
116 x_creation_date Out NOCOPY date,
117 x_last_updated_by Out NOCOPY pls_integer,
118 x_last_update_date Out NOCOPY date,
119 p_ext_type In Varchar2 default null,
120 p_ext_subtype In Varchar2 default null,
121 p_standard_type IN varchar2 default 'XML'
122 );
123 /**
124 This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.
125 If the transaction doesnt exists, then create one.
126 **/
127
128 procedure create_external_transaction
129 (
130 x_return_status Out NOCOPY pls_integer,
131 x_msg Out NOCOPY varchar2,
132 X_ext_process_id Out NOCOPY Pls_integer,
133 p_transaction_id in Pls_integer,
134 p_ext_type In Varchar2,
135 p_ext_subtype In Varchar2,
136 p_standard In Varchar2,
137 p_queue_name In Varchar2,
138 p_direction In Varchar2,
139 p_owner IN varchar2 default 'CUSTOM',
140 p_standard_type IN varchar2 default 'XML'
141 );
142
143 /**
144 Overloaded.This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.
145 If the transaction doesnt exists, then create one.
146 **/
147
148 procedure create_external_transaction
149 (
150 x_return_status Out NOCOPY pls_integer,
151 x_msg Out NOCOPY varchar2,
152 X_ext_process_id Out NOCOPY Pls_integer,
153 X_transaction_id Out NOCOPY Pls_integer,
154 p_transaction_type in varchar2,
155 p_transaction_subtype in varchar2,
156 p_party_type in varchar2,
157 p_ext_type In Varchar2,
158 p_ext_subtype In Varchar2,
159 p_standard In Varchar2,
160 p_queue_name In Varchar2,
161 p_direction In Varchar2,
162 p_owner in varchar2 default 'CUSTOM',
163 p_standard_type IN varchar2 default 'XML'
164 );
165
166 /**
167 Update_Ext_Process API is used to update an existing external process definition in the ECX_EXT_PROCESSES table.
168 This API allows users to update the ext_type, ext_subtype, standard, queue_name and direction by
169 specifying the ext_process_id.
170 **/
171 procedure update_external_transaction
172 (
173 x_return_status Out NOCOPY pls_integer,
174 x_msg Out NOCOPY varchar2,
175 p_ext_process_id In pls_integer,
176 p_ext_type In Varchar2,
177 p_ext_subtype In Varchar2,
178 p_standard In Varchar2,
179 p_queue_name In Varchar2,
180 p_direction In Varchar2,
181 p_owner IN varchar2 default 'CUSTOM',
182 p_standard_type IN varchar2 default 'XML'
183 );
184
185 /**
186 This Delete_Ext_Process API is used to delete an existing external process definition in the ECX_EXT_PROCESSES table.
187 This API allows users to delete a process definition by specifying the ext_process_id.
188 **/
189 procedure delete_external_transaction
190 (
191 x_return_status Out NOCOPY pls_integer,
192 x_msg Out NOCOPY varchar2,
193 p_ext_process_id In pls_integer
194 );
195
196 END ECX_TRANSACTIONS_API;