[Home] [Help]
PACKAGE: APPS.HZ_FORMAT_PUB_W
Source
1 package hz_format_pub_w AUTHID CURRENT_USER as
2 /* $Header: ARHFMTJS.pls 120.1 2005/07/29 19:45:15 jhuang noship $ */
3 procedure rosetta_table_copy_in_p0(t out nocopy hz_format_pub.string_tbl_type, a0 JTF_VARCHAR2_TABLE_300);
4 procedure rosetta_table_copy_out_p0(t hz_format_pub.string_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
5
6 procedure rosetta_table_copy_in_p2(t out nocopy hz_format_pub.layout_tbl_type, a0 JTF_NUMBER_TABLE
7 , a1 JTF_NUMBER_TABLE
8 , a2 JTF_VARCHAR2_TABLE_100
9 , a3 JTF_VARCHAR2_TABLE_100
10 , a4 JTF_VARCHAR2_TABLE_100
11 , a5 JTF_VARCHAR2_TABLE_100
12 , a6 JTF_VARCHAR2_TABLE_100
13 , a7 JTF_VARCHAR2_TABLE_100
14 , a8 JTF_NUMBER_TABLE
15 , a9 JTF_NUMBER_TABLE
16 , a10 JTF_VARCHAR2_TABLE_300
17 );
18 procedure rosetta_table_copy_out_p2(t hz_format_pub.layout_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19 , a1 out nocopy JTF_NUMBER_TABLE
20 , a2 out nocopy JTF_VARCHAR2_TABLE_100
21 , a3 out nocopy JTF_VARCHAR2_TABLE_100
22 , a4 out nocopy JTF_VARCHAR2_TABLE_100
23 , a5 out nocopy JTF_VARCHAR2_TABLE_100
24 , a6 out nocopy JTF_VARCHAR2_TABLE_100
25 , a7 out nocopy JTF_VARCHAR2_TABLE_100
26 , a8 out nocopy JTF_NUMBER_TABLE
27 , a9 out nocopy JTF_NUMBER_TABLE
28 , a10 out nocopy JTF_VARCHAR2_TABLE_300
29 );
30
31 procedure format_address_1(p_location_id NUMBER
32 , p_style_code VARCHAR2
33 , p_style_format_code VARCHAR2
34 , p_line_break VARCHAR2
35 , p_space_replace VARCHAR2
36 , p_to_language_code VARCHAR2
37 , p_country_name_lang VARCHAR2
38 , p_from_territory_code VARCHAR2
39 , x_return_status out nocopy VARCHAR2
40 , x_msg_count out nocopy NUMBER
41 , x_msg_data out nocopy VARCHAR2
42 , x_formatted_address out nocopy VARCHAR2
43 , x_formatted_lines_cnt out nocopy NUMBER
44 , x_formatted_address_tbl out nocopy JTF_VARCHAR2_TABLE_300
45 );
46 procedure format_address_2(p_style_code VARCHAR2
47 , p_style_format_code VARCHAR2
48 , p_line_break VARCHAR2
49 , p_space_replace VARCHAR2
50 , p_to_language_code VARCHAR2
51 , p_country_name_lang VARCHAR2
52 , p_from_territory_code VARCHAR2
53 , p_address_line_1 VARCHAR2
54 , p_address_line_2 VARCHAR2
55 , p_address_line_3 VARCHAR2
56 , p_address_line_4 VARCHAR2
57 , p_city VARCHAR2
58 , p_postal_code VARCHAR2
59 , p_state VARCHAR2
60 , p_province VARCHAR2
61 , p_county VARCHAR2
62 , p_country VARCHAR2
63 , p_address_lines_phonetic VARCHAR2
64 , x_return_status out nocopy VARCHAR2
65 , x_msg_count out nocopy NUMBER
66 , x_msg_data out nocopy VARCHAR2
67 , x_formatted_address out nocopy VARCHAR2
68 , x_formatted_lines_cnt out nocopy NUMBER
69 , x_formatted_address_tbl out nocopy JTF_VARCHAR2_TABLE_300
70 );
71 procedure format_address_layout_3(p_location_id NUMBER
72 , p_style_code VARCHAR2
73 , p_style_format_code VARCHAR2
74 , p_line_break VARCHAR2
75 , p_space_replace VARCHAR2
76 , p_to_language_code VARCHAR2
77 , p_country_name_lang VARCHAR2
78 , p_from_territory_code VARCHAR2
79 , x_return_status out nocopy VARCHAR2
80 , x_msg_count out nocopy NUMBER
81 , x_msg_data out nocopy VARCHAR2
82 , x_layout_tbl_cnt out nocopy NUMBER
83 , p12_a0 out nocopy JTF_NUMBER_TABLE
84 , p12_a1 out nocopy JTF_NUMBER_TABLE
85 , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
86 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
87 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
88 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
89 , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
90 , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
91 , p12_a8 out nocopy JTF_NUMBER_TABLE
92 , p12_a9 out nocopy JTF_NUMBER_TABLE
93 , p12_a10 out nocopy JTF_VARCHAR2_TABLE_300
94 );
95 procedure format_address_layout_4(p_style_code VARCHAR2
96 , p_style_format_code VARCHAR2
97 , p_line_break VARCHAR2
98 , p_space_replace VARCHAR2
99 , p_to_language_code VARCHAR2
100 , p_country_name_lang VARCHAR2
101 , p_from_territory_code VARCHAR2
102 , p_address_line_1 VARCHAR2
103 , p_address_line_2 VARCHAR2
104 , p_address_line_3 VARCHAR2
105 , p_address_line_4 VARCHAR2
106 , p_city VARCHAR2
107 , p_postal_code VARCHAR2
108 , p_state VARCHAR2
109 , p_province VARCHAR2
110 , p_county VARCHAR2
111 , p_country VARCHAR2
112 , p_address_lines_phonetic VARCHAR2
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , x_layout_tbl_cnt out nocopy NUMBER
117 , p22_a0 out nocopy JTF_NUMBER_TABLE
118 , p22_a1 out nocopy JTF_NUMBER_TABLE
119 , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
120 , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
121 , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
122 , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
123 , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
124 , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100
125 , p22_a8 out nocopy JTF_NUMBER_TABLE
126 , p22_a9 out nocopy JTF_NUMBER_TABLE
127 , p22_a10 out nocopy JTF_VARCHAR2_TABLE_300
128 );
129 procedure format_name_5(p_party_id NUMBER
130 , p_style_code VARCHAR2
131 , p_style_format_code VARCHAR2
132 , p_line_break VARCHAR2
133 , p_space_replace VARCHAR2
134 , p_ref_language_code VARCHAR2
135 , p_ref_territory_code VARCHAR2
136 , x_return_status out nocopy VARCHAR2
137 , x_msg_count out nocopy NUMBER
138 , x_msg_data out nocopy VARCHAR2
139 , x_formatted_name out nocopy VARCHAR2
140 , x_formatted_lines_cnt out nocopy NUMBER
141 , x_formatted_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
142 );
143 procedure format_name_6(p_style_code VARCHAR2
144 , p_style_format_code VARCHAR2
145 , p_line_break VARCHAR2
146 , p_space_replace VARCHAR2
147 , p_ref_language_code VARCHAR2
148 , p_ref_territory_code VARCHAR2
149 , p_person_title VARCHAR2
150 , p_person_first_name VARCHAR2
151 , p_person_middle_name VARCHAR2
152 , p_person_last_name VARCHAR2
153 , p_person_name_suffix VARCHAR2
154 , p_person_known_as VARCHAR2
155 , p_first_name_phonetic VARCHAR2
156 , p_middle_name_phonetic VARCHAR2
157 , p_last_name_phonetic VARCHAR2
158 , x_return_status out nocopy VARCHAR2
159 , x_msg_count out nocopy NUMBER
160 , x_msg_data out nocopy VARCHAR2
161 , x_formatted_name out nocopy VARCHAR2
162 , x_formatted_lines_cnt out nocopy NUMBER
163 , x_formatted_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
164 );
165 procedure format_data_7(p_object_code VARCHAR2
166 , p_object_key_1 VARCHAR2
167 , p_object_key_2 VARCHAR2
168 , p_object_key_3 VARCHAR2
169 , p_object_key_4 VARCHAR2
170 , p_style_code VARCHAR2
171 , p_style_format_code VARCHAR2
172 , p_line_break VARCHAR2
173 , p_space_replace VARCHAR2
174 , p_ref_language_code VARCHAR2
175 , p_ref_territory_code VARCHAR2
176 , x_return_status out nocopy VARCHAR2
177 , x_msg_count out nocopy NUMBER
178 , x_msg_data out nocopy VARCHAR2
179 , x_formatted_data out nocopy VARCHAR2
180 , x_formatted_lines_cnt out nocopy NUMBER
181 , x_formatted_data_tbl out nocopy JTF_VARCHAR2_TABLE_300
182 );
183 procedure get_context_8(p0_a0 out nocopy VARCHAR2
184 , p0_a1 out nocopy VARCHAR2
185 , p0_a2 out nocopy VARCHAR2
186 , p0_a3 out nocopy VARCHAR2
187 , p0_a4 out nocopy VARCHAR2
188 , p0_a5 out nocopy VARCHAR2
189 , p0_a6 out nocopy VARCHAR2
190 );
191 end hz_format_pub_w;