[Home] [Help]
PACKAGE: APPS.ZX_TRN_VALIDATION_PKG
Source
1 PACKAGE ZX_TRN_VALIDATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxctaxregns.pls 120.13 2005/08/02 13:37:59 amohiudd ship $ */
3
4 FUNCTION common_check_numeric (p_check_value IN VARCHAR2,
5 p_from IN NUMBER,
6 p_for IN NUMBER) RETURN VARCHAR2;
7
8 FUNCTION common_check_length (p_country_code IN VARCHAR2,
9 p_num_digits IN NUMBER,
10 p_trn IN VARCHAR2) RETURN VARCHAR2;
11
12
13 PROCEDURE validate_trn (p_country_code IN VARCHAR2,
14 p_tax_reg_num IN VARCHAR2,
15 p_tax_regime_code IN VARCHAR2,
16 p_tax IN VARCHAR2,
17 p_tax_jurisdiction_code IN VARCHAR2,
18 p_ptp_id IN NUMBER,
19 p_party_type_code IN VARCHAR2,
20 p_trn_type IN VARCHAR2,
21 p_error_buffer OUT NOCOPY VARCHAR2,
22 p_return_status OUT NOCOPY VARCHAR2,
23 x_party_type_token OUT NOCOPY VARCHAR2,
24 x_party_name_token OUT NOCOPY VARCHAR2,
25 x_party_site_name_token OUT NOCOPY VARCHAR2 );
26
27 procedure VALIDATE_TRN_AT (p_trn IN VARCHAR2,
28 p_trn_type IN VARCHAR2,
29 p_check_unique_flag IN VARCHAR2,
30 p_return_status OUT NOCOPY VARCHAR2,
31 p_error_buffer OUT NOCOPY VARCHAR2);
32
33 procedure VALIDATE_TRN_BE (p_trn IN VARCHAR2,
34 p_trn_type IN VARCHAR2,
35 p_check_unique_flag IN VARCHAR2,
36 p_return_status OUT NOCOPY VARCHAR2,
37 p_error_buffer OUT NOCOPY VARCHAR2);
38
39 procedure VALIDATE_TRN_DK (p_trn_value IN VARCHAR2,
40 p_trn_type IN VARCHAR2,
41 p_check_unique_flag IN VARCHAR2,
42 p_return_status OUT NOCOPY VARCHAR2,
43 p_error_buffer OUT NOCOPY VARCHAR2);
44
45 procedure VALIDATE_TRN_EE (p_trn_value IN VARCHAR2,
46 p_trn_type IN VARCHAR2,
47 p_check_unique_flag IN VARCHAR2,
48 p_return_status OUT NOCOPY VARCHAR2,
49 p_error_buffer OUT NOCOPY VARCHAR2);
50
51 procedure VALIDATE_TRN_FI (p_trn_value IN VARCHAR2,
52 p_trn_type IN VARCHAR2,
53 p_check_unique_flag IN VARCHAR2,
54 p_return_status OUT NOCOPY VARCHAR2,
55 p_error_buffer OUT NOCOPY VARCHAR2);
56
57 procedure VALIDATE_TRN_FR (p_trn_value IN VARCHAR2,
58 p_trn_type IN VARCHAR2,
59 p_check_unique_flag IN VARCHAR2,
60 p_return_status OUT NOCOPY VARCHAR2,
61 p_error_buffer OUT NOCOPY VARCHAR2);
62
63 procedure VALIDATE_TRN_DE (p_trn_value IN VARCHAR2,
64 p_trn_type IN VARCHAR2,
65 p_check_unique_flag IN VARCHAR2,
66 p_return_status OUT NOCOPY VARCHAR2,
67 p_error_buffer OUT NOCOPY VARCHAR2);
68
69 procedure VALIDATE_TRN_GR (p_trn_value IN VARCHAR2,
70 p_trn_type IN VARCHAR2,
71 p_check_unique_flag IN VARCHAR2,
72 p_return_status OUT NOCOPY VARCHAR2,
73 p_error_buffer OUT NOCOPY VARCHAR2);
74
75
76 procedure VALIDATE_TRN_IE (p_trn_value IN VARCHAR2,
77 p_trn_type IN VARCHAR2,
78 p_check_unique_flag IN VARCHAR2,
79 p_return_status OUT NOCOPY VARCHAR2,
80 p_error_buffer OUT NOCOPY VARCHAR2);
81
82 procedure VALIDATE_TRN_IT (p_trn_value IN VARCHAR2,
83 p_trn_type IN VARCHAR2,
84 p_check_unique_flag IN VARCHAR2,
85 p_return_status OUT NOCOPY VARCHAR2,
86 p_error_buffer OUT NOCOPY VARCHAR2);
87
88 procedure VALIDATE_TRN_LU (p_trn_value IN VARCHAR2,
89 p_trn_type IN VARCHAR2,
90 p_check_unique_flag IN VARCHAR2,
91 p_return_status OUT NOCOPY VARCHAR2,
92 p_error_buffer OUT NOCOPY VARCHAR2);
93
94 procedure VALIDATE_TRN_SK (p_trn_value IN VARCHAR2,
95 p_trn_type IN VARCHAR2,
96 p_check_unique_flag IN VARCHAR2,
97 p_return_status OUT NOCOPY VARCHAR2,
98 p_error_buffer OUT NOCOPY VARCHAR2);
99
100 procedure VALIDATE_TRN_NL(p_trn IN VARCHAR2,
101 p_trn_type IN VARCHAR2,
102 p_check_unique_flag IN VARCHAR2,
103 p_return_status OUT NOCOPY VARCHAR2,
104 p_error_buffer OUT NOCOPY VARCHAR2);
105
106 procedure VALIDATE_TRN_PL (p_trn_value IN VARCHAR2,
107 p_trn_type IN VARCHAR2,
108 p_check_unique_flag IN VARCHAR2,
109 p_return_status OUT NOCOPY VARCHAR2,
110 p_error_buffer OUT NOCOPY VARCHAR2);
111
112 procedure VALIDATE_TRN_PT (p_trn_value IN VARCHAR2,
113 p_trn_type IN VARCHAR2,
114 p_check_unique_flag IN VARCHAR2,
115 p_return_status OUT NOCOPY VARCHAR2,
116 p_error_buffer OUT NOCOPY VARCHAR2);
117
118 procedure VALIDATE_TRN_ES(p_trn IN VARCHAR2,
119 p_trn_type IN VARCHAR2,
120 p_check_unique_flag IN VARCHAR2,
121 p_return_status OUT NOCOPY VARCHAR2,
122 p_error_buffer OUT NOCOPY VARCHAR2);
123
124 procedure VALIDATE_TRN_SE (p_trn_value IN VARCHAR2,
125 p_trn_type IN VARCHAR2,
126 p_check_unique_flag IN VARCHAR2,
127 p_return_status OUT NOCOPY VARCHAR2,
128 p_error_buffer OUT NOCOPY VARCHAR2);
129
130 procedure VALIDATE_TRN_GB (p_trn_value IN VARCHAR2,
131 p_trn_type IN VARCHAR2,
132 p_check_unique_flag IN VARCHAR2,
133 p_return_status OUT NOCOPY VARCHAR2,
134 p_error_buffer OUT NOCOPY VARCHAR2);
135
136 procedure VALIDATE_TRN_CH (p_trn_value IN VARCHAR2,
137 p_trn_type IN VARCHAR2,
138 p_check_unique_flag IN VARCHAR2,
139 p_return_status OUT NOCOPY VARCHAR2,
140 p_error_buffer OUT NOCOPY VARCHAR2);
141
142 procedure VALIDATE_TRN_RU (p_trn_value IN VARCHAR2,
143 p_trn_type IN VARCHAR2,
144 p_check_unique_flag IN VARCHAR2,
145 p_return_status OUT NOCOPY VARCHAR2,
146 p_error_buffer OUT NOCOPY VARCHAR2);
147
148 procedure VALIDATE_TRN_HU (p_trn_value IN VARCHAR2,
149 p_trn_type IN VARCHAR2,
150 p_check_unique_flag IN VARCHAR2,
151 p_return_status OUT NOCOPY VARCHAR2,
152 p_error_buffer OUT NOCOPY VARCHAR2);
153
154 PROCEDURE VALIDATE_TRN_BR (p_trn IN VARCHAR2,
155 p_trn_type IN VARCHAR2,
156 p_return_status OUT NOCOPY VARCHAR2,
157 p_error_buffer OUT NOCOPY VARCHAR2);
158
159 PROCEDURE VALIDATE_TRN_AR ( p_trn IN VARCHAR2,
160 p_trn_type IN VARCHAR2,
161 p_return_status OUT NOCOPY VARCHAR2,
162 p_error_buffer OUT NOCOPY VARCHAR2);
163
164 PROCEDURE VALIDATE_TRN_CL ( p_trn IN VARCHAR2,
165 p_return_status OUT NOCOPY VARCHAR2,
166 p_error_buffer OUT NOCOPY VARCHAR2);
167
168 PROCEDURE VALIDATE_TRN_CO ( p_trn IN VARCHAR2,
169 p_return_status OUT NOCOPY VARCHAR2,
170 p_error_buffer OUT NOCOPY VARCHAR2);
171
172 PROCEDURE VALIDATE_TRN_TW ( p_trn IN VARCHAR2,
173 p_return_status OUT NOCOPY VARCHAR2,
174 p_error_buffer OUT NOCOPY VARCHAR2);
175
176 procedure VALIDATE_TRN_MT (p_trn_value IN VARCHAR2,
177 p_trn_type IN VARCHAR2,
178 p_check_unique_flag IN VARCHAR2,
179 p_return_status OUT NOCOPY VARCHAR2,
180 p_error_buffer OUT NOCOPY VARCHAR2);
181
182 procedure VALIDATE_TRN_CY (p_trn_value IN VARCHAR2,
183 p_trn_type IN VARCHAR2,
184 p_check_unique_flag IN VARCHAR2,
185 p_return_status OUT NOCOPY VARCHAR2,
186 p_error_buffer OUT NOCOPY VARCHAR2);
187
188 procedure VALIDATE_TRN_LV (p_trn_value IN VARCHAR2,
189 p_trn_type IN VARCHAR2,
190 p_check_unique_flag IN VARCHAR2,
191 p_return_status OUT NOCOPY VARCHAR2,
192 p_error_buffer OUT NOCOPY VARCHAR2);
193
194 procedure VALIDATE_TRN_LT (p_trn_value IN VARCHAR2,
195 p_trn_type IN VARCHAR2,
196 p_check_unique_flag IN VARCHAR2,
197 p_return_status OUT NOCOPY VARCHAR2,
198 p_error_buffer OUT NOCOPY VARCHAR2);
199
200 procedure VALIDATE_TRN_SI (p_trn_value IN VARCHAR2,
201 p_trn_type IN VARCHAR2,
202 p_check_unique_flag IN VARCHAR2,
203 p_return_status OUT NOCOPY VARCHAR2,
204 p_error_buffer OUT NOCOPY VARCHAR2);
205
206 END ZX_TRN_VALIDATION_PKG;