[Home] [Help]
PACKAGE: APPS.ECX_TP_API
Source
1 package ecx_tp_api AUTHID CURRENT_USER as
2 -- $Header: ECXTPXAS.pls 115.9 2003/01/14 20:18:04 rdiwan ship $
3
4 tp_event_not_raised exception;
5
6 Procedure retrieve_trading_partner(
7 x_return_status OUT NOCOPY Pls_integer,
8 x_msg OUT NOCOPY Varchar2,
9 x_tp_header_id OUT NOCOPY Pls_integer,
10 p_party_type IN Varchar2,
11 p_party_id IN Varchar2,
12 p_party_site_id IN Varchar2,
13 x_company_admin_email OUT NOCOPY Varchar2,
14 x_created_by OUT NOCOPY Varchar2,
15 x_creation_date OUT NOCOPY Varchar2,
16 x_last_updated_by OUT NOCOPY Varchar2,
17 x_last_update_date OUT NOCOPY Varchar2);
18
19 Procedure create_trading_partner(
20 x_return_status OUT NOCOPY Pls_integer,
21 x_msg OUT NOCOPY Varchar2,
22 x_tp_header_id OUT NOCOPY Pls_integer,
23 p_party_type IN Varchar2,
24 p_party_id IN Varchar2,
25 p_party_site_id IN Varchar2,
26 p_company_admin_email IN Varchar2);
27
28 Procedure update_trading_partner(
29 x_return_status OUT NOCOPY Pls_integer,
30 x_msg OUT NOCOPY Varchar2,
31 p_tp_header_id IN Pls_integer,
32 p_company_admin_email IN Varchar2);
33
34 Procedure delete_trading_partner(
35 x_return_status OUT NOCOPY Pls_integer,
36 x_msg OUT NOCOPY Varchar2,
37 p_tp_header_id IN Pls_integer);
38
39 /*Bug #2183619, added one additional input parameter for
40 source_tp_location_code */
41
42 Procedure retrieve_tp_detail(
43 x_return_status OUT NOCOPY Pls_integer,
44 x_msg OUT NOCOPY Varchar2,
45 x_tp_detail_id OUT NOCOPY Pls_integer,
46 p_tp_header_id IN Pls_integer,
47 p_ext_process_id IN Pls_integer,
48 x_map_code OUT NOCOPY Varchar2,
49 x_connection_type OUT NOCOPY Varchar2,
50 x_hub_user_id OUT NOCOPY Pls_integer,
51 x_protocol_type OUT NOCOPY Varchar2,
52 x_protocol_address OUT NOCOPY Varchar2,
53 x_username OUT NOCOPY Varchar2,
54 x_password OUT NOCOPY Varchar2,
55 x_routing_id OUT NOCOPY Pls_integer,
56 x_source_tp_location_code OUT NOCOPY Varchar2,
57 x_external_tp_location_code OUT NOCOPY Varchar2,
58 x_confirmation OUT NOCOPY Varchar2,
59 x_created_by OUT NOCOPY Varchar2,
60 x_creation_date OUT NOCOPY Varchar2,
61 x_last_updated_by OUT NOCOPY Varchar2,
62 x_last_update_date OUT NOCOPY Varchar2,
63 p_source_tp_location_code IN Varchar2 default null);
64 --Overloaded procedure
65
66 /* Bug #2183619, Added three additional input parameters
67 for External Type and Subtype and source_tp_location_code */
68
69 Procedure retrieve_tp_detail(
70 x_return_status OUT NOCOPY Pls_integer,
71 x_msg OUT NOCOPY Varchar2,
72 x_tp_detail_id OUT NOCOPY Pls_integer,
73 x_tp_header_id OUT NOCOPY Pls_integer,
74 p_party_type IN Varchar2,
75 p_party_id IN Varchar2,
76 p_party_site_id IN Varchar2,
77 p_transaction_type IN Varchar2,
78 p_transaction_subtype IN Varchar2,
79 p_standard_code IN Varchar2,
80 p_direction IN Varchar2,
81 x_ext_type OUT NOCOPY Varchar2,
82 x_ext_subtype OUT NOCOPY Varchar2,
83 x_map_code OUT NOCOPY Varchar2,
84 x_connection_type OUT NOCOPY Varchar2,
85 x_hub_user_id OUT NOCOPY Pls_integer,
86 x_protocol_type OUT NOCOPY Varchar2,
87 x_protocol_address OUT NOCOPY Varchar2,
88 x_username OUT NOCOPY Varchar2,
89 x_password OUT NOCOPY Varchar2,
90 x_routing_id OUT NOCOPY Pls_integer,
91 x_source_tp_location_code OUT NOCOPY Varchar2,
92 x_external_tp_location_code OUT NOCOPY Varchar2,
93 x_confirmation OUT NOCOPY Varchar2,
94 x_created_by OUT NOCOPY Varchar2,
95 x_creation_date OUT NOCOPY Varchar2,
96 x_last_updated_by OUT NOCOPY Varchar2,
97 x_last_update_date OUT NOCOPY Varchar2,
98 p_ext_type IN Varchar2 default null,
99 p_ext_subtype IN Varchar2 default null,
100 p_source_tp_location_code IN Varchar2 default null);
101
102
103 procedure create_tp_detail(
104 x_return_status OUT NOCOPY pls_integer,
105 x_msg OUT NOCOPY Varchar2,
106 x_tp_detail_id OUT NOCOPY Pls_integer,
107 p_tp_header_id IN pls_integer,
108 p_ext_process_id IN pls_integer,
109 p_map_code IN Varchar2,
110 p_connection_type IN Varchar2,
111 p_hub_user_id IN pls_integer,
112 p_protocol_type IN Varchar2,
113 p_protocol_address IN Varchar2,
114 p_username IN Varchar2,
115 p_password IN Varchar2,
116 p_routing_id IN pls_integer,
117 p_source_tp_location_code IN Varchar2 default null,
118 p_external_tp_location_code IN Varchar2,
119 p_confirmation IN pls_integer);
120
121 ---Overloaded
122 /* Bug 2122579 */
123
124 /* Bug #2183619, Added two additional input parameters
125 for External Type and Subtype */
126
127 Procedure create_tp_detail(
128 x_return_status OUT NOCOPY pls_integer,
129 x_msg OUT NOCOPY Varchar2,
130 x_tp_detail_id OUT NOCOPY Pls_integer,
131 x_tp_header_id OUT NOCOPY Pls_integer,
132 p_party_type IN Varchar2,
133 p_party_id IN number,
134 p_party_site_id IN number,
135 p_transaction_type IN Varchar2,
136 p_transaction_subtype IN Varchar2,
137 p_standard_code IN Varchar2,
138 p_direction IN Varchar2,
139 p_map_code IN Varchar2,
140 p_connection_type IN Varchar2,
141 p_hub_user_id IN pls_integer,
142 p_protocol_type IN Varchar2,
143 p_protocol_address IN Varchar2,
144 p_username IN Varchar2,
145 p_password IN Varchar2,
146 p_routing_id IN pls_integer,
147 p_source_tp_location_code IN Varchar2 default null,
148 p_external_tp_location_code IN Varchar2,
149 p_confirmation IN pls_integer,
150 p_ext_type IN Varchar2 default null,
151 p_ext_subtype IN Varchar2 default null);
152
153 Procedure update_tp_detail(
154 x_return_status OUT NOCOPY pls_integer,
155 x_msg OUT NOCOPY Varchar2,
156 p_tp_detail_id IN pls_integer,
157 p_map_code IN Varchar2,
158 p_ext_process_id IN pls_integer,
159 p_connection_type IN Varchar2,
160 p_hub_user_id IN pls_integer,
161 p_protocol_type IN Varchar2,
162 p_protocol_address IN Varchar2,
163 p_username IN Varchar2,
164 p_password IN Varchar2,
165 p_routing_id IN pls_integer,
166 p_source_tp_location_code IN Varchar2 default null,
167 p_external_tp_location_code IN Varchar2,
168 p_confirmation IN pls_integer ,
169 p_passupd_flag IN varchar2 default 'Y'
170 );
171
172 Procedure delete_tp_detail( x_return_status OUT NOCOPY pls_integer,
173 x_msg OUT NOCOPY Varchar2,
174 p_tp_detail_id IN pls_integer );
175
176 Procedure raise_tp_event(
177 x_return_status out NOCOPY pls_integer,
178 x_msg out NOCOPY varchar2,
179 x_event_name out NOCOPY varchar2,
180 x_event_key out NOCOPY number,
181 p_mod_type in varchar2,
182 p_tp_header_id in number,
183 p_party_type in varchar2,
184 p_party_id in varchar2,
185 p_party_site_id in varchar2,
186 p_company_email_addr in varchar2 );
187 End;