DBA Data[Home] [Help]

APPS.ECX_TRANSACTIONS_API dependencies on STANDARD

Line 76: p_standard In Varchar2,

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,

Line 81: x_standard_id Out NOCOPY pls_integer,

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,

Line 89: p_standard_type IN varchar2 default 'XML'

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: /**

Line 108: p_standard In Varchar2,

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,

Line 113: x_standard_id Out NOCOPY pls_integer,

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,

Line 121: p_standard_type IN varchar2 default 'XML'

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.

Line 136: p_standard In 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'

Line 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.

Line 159: p_standard 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'

Line 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.

Line 168: This API allows users to update the ext_type, ext_subtype, standard, queue_name and direction by

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: (

Line 178: p_standard In Varchar2,

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'

Line 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.