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,
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,
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: /**
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,
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,
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.
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'
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.
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'
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.
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: (
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'
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.