[Home] [Help]
PACKAGE BODY: APPS.HZ_ADDR_ISPEED_PKG
Source
1 PACKAGE BODY hz_addr_ispeed_pkg as
2 /* $Header: ARHADISB.pls 120.4 2005/10/30 03:50:39 appldev ship $*/
3
4 --
5 --
6 --
7 PROCEDURE insert_row (
8 Address_Id IN OUT NOCOPY NUMBER,
9 Last_Update_Date DATE,
10 Last_Updated_By NUMBER,
11 Creation_Date DATE,
12 Created_By NUMBER,
13 Status VARCHAR2,
14 Orig_System_Reference IN OUT NOCOPY VARCHAR2,
15 Country VARCHAR2,
16 Address1 VARCHAR2,
17 Address2 VARCHAR2,
18 Address3 VARCHAR2,
19 Address4 VARCHAR2,
20 City VARCHAR2,
21 Postal_Code VARCHAR2,
22 State VARCHAR2,
23 Province VARCHAR2,
24 County VARCHAR2,
25 Last_Update_Login NUMBER,
26 Address_Key VARCHAR2,
27 Language VARCHAR2,
28 Attribute_Category VARCHAR2,
29 Attribute1 VARCHAR2,
30 Attribute2 VARCHAR2,
31 Attribute3 VARCHAR2,
32 Attribute4 VARCHAR2,
33 Attribute5 VARCHAR2,
34 Attribute6 VARCHAR2,
35 Attribute7 VARCHAR2,
36 Attribute8 VARCHAR2,
37 Attribute9 VARCHAR2,
38 Attribute10 VARCHAR2,
39 Attribute11 VARCHAR2,
40 Attribute12 VARCHAR2,
41 Attribute13 VARCHAR2,
42 Attribute14 VARCHAR2,
43 Attribute15 VARCHAR2,
44 Attribute16 VARCHAR2,
45 Attribute17 VARCHAR2,
46 Attribute18 VARCHAR2,
47 Attribute19 VARCHAR2,
48 Attribute20 VARCHAR2,
49 Address_Lines_Phonetic VARCHAR2,
50 Global_Attribute_Category VARCHAR2,
51 Global_Attribute1 VARCHAR2,
52 Global_Attribute2 VARCHAR2,
53 Global_Attribute3 VARCHAR2,
54 Global_Attribute4 VARCHAR2,
55 Global_Attribute5 VARCHAR2,
56 Global_Attribute6 VARCHAR2,
57 Global_Attribute7 VARCHAR2,
58 Global_Attribute8 VARCHAR2,
59 Global_Attribute9 VARCHAR2,
60 Global_Attribute10 VARCHAR2,
61 Global_Attribute11 VARCHAR2,
62 Global_Attribute12 VARCHAR2,
63 Global_Attribute13 VARCHAR2,
64 Global_Attribute14 VARCHAR2,
65 Global_Attribute15 VARCHAR2,
66 Global_Attribute16 VARCHAR2,
67 Global_Attribute17 VARCHAR2,
68 Global_Attribute18 VARCHAR2,
69 Global_Attribute19 VARCHAR2,
70 Global_Attribute20 VARCHAR2,
71 Party_site_id IN OUT NOCOPY NUMBER,
72 Party_id NUMBER,
73 Location_id IN OUT NOCOPY NUMBER,
74 Party_Site_Number IN OUT NOCOPY VARCHAR2,
75 Identifying_address_flag VARCHAR2,
76 Cust_acct_site_id in out NOCOPY NUMBER,
77 Cust_account_id NUMBER,
78 su_Bill_To_Flag VARCHAR2,
79 su_Ship_To_Flag VARCHAR2,
80 su_Market_Flag VARCHAR2,
81 su_stmt_flag VARCHAR2,
82 su_dun_flag VARCHAR2,
83 su_legal_flag VARCHAR2,
84 Customer_Category VARCHAR2,
85 Key_Account_Flag VARCHAR2,
86 Territory_id NUMBER,
87 ece_tp_location_code VARCHAR2,
88 address_mode VARCHAR2,
89 territory VARCHAR2,
90 translated_customer_name VARCHAR2,
91 sales_tax_geo_code VARCHAR2,
92 sale_tax_inside_city_limits VARCHAR2,
93 shared_party_site IN VARCHAR2,
94 update_account_site IN VARCHAR2,
95 create_location_party_site IN VARCHAR2,
96 addressee VARCHAR2,
97 org_id IN NUMBER,
98 msg_count OUT NOCOPY NUMBER,
99 msg_data OUT NOCOPY VARCHAR2,
100 return_status OUT NOCOPY VARCHAR2)
101
102 IS
103
104 X_Address_warning boolean;
105
106
107
108 BEGIN
109
110 fnd_client_info.set_org_context(org_id);
111
112 arh_addr_pkg.insert_row (
113 X_Address_Id => Address_Id,
114 X_Last_Update_Date => Last_Update_Date,
115 X_Last_Updated_By => Last_Updated_By,
116 X_Creation_Date => Creation_Date,
117 X_Created_By => Created_By,
118 X_Status => Status,
119 X_Orig_System_Reference => Orig_System_Reference,
120 X_Country => Country,
121 X_Address1 => Address1,
122 X_Address2 => Address2,
123 X_Address3 => Address3,
124 X_Address4 => Address4,
125 X_City => City,
126 X_Postal_Code => Postal_Code,
127 X_State => State,
128 X_Province => Province,
129 X_County => County,
130 X_Last_Update_Login => Last_Update_Login,
131 X_Address_Key => Address_Key,
132 X_Language => Language,
133 X_Attribute_Category => Attribute_Category,
134 X_Attribute1 => Attribute1,
135 X_Attribute2 => Attribute2,
136 X_Attribute3 => Attribute3,
137 X_Attribute4 => Attribute4,
138 X_Attribute5 => Attribute5,
139 X_Attribute6 => Attribute6,
140 X_Attribute7 => Attribute7,
141 X_Attribute8 => Attribute8,
142 X_Attribute9 => Attribute9,
143 X_Attribute10 => Attribute10,
144 X_Attribute11 => Attribute11,
145 X_Attribute12 => Attribute12,
146 X_Attribute13 => Attribute13,
147 X_Attribute14 => Attribute14,
148 X_Attribute15 => Attribute15,
149 X_Attribute16 => Attribute16,
150 X_Attribute17 => Attribute17,
151 X_Attribute18 => Attribute18,
152 X_Attribute19 => Attribute19,
153 X_Attribute20 => Attribute20,
154 X_Address_warning => X_Address_warning,
155 X_Address_Lines_Phonetic => Address_Lines_Phonetic,
156 X_Global_Attribute_Category => Global_Attribute_Category,
157 X_Global_Attribute1 => Global_Attribute1,
158 X_Global_Attribute2 => Global_Attribute2,
159 X_Global_Attribute3 => Global_Attribute3,
160 X_Global_Attribute4 => Global_Attribute4,
161 X_Global_Attribute5 => Global_Attribute5,
162 X_Global_Attribute6 => Global_Attribute6,
163 X_Global_Attribute7 => Global_Attribute7,
164 X_Global_Attribute8 => Global_Attribute8,
165 X_Global_Attribute9 => Global_Attribute9,
166 X_Global_Attribute10 => Global_Attribute10,
167 X_Global_Attribute11 => Global_Attribute11,
168 X_Global_Attribute12 => Global_Attribute12,
169 X_Global_Attribute13 => Global_Attribute13,
170 X_Global_Attribute14 => Global_Attribute14,
171 X_Global_Attribute15 => Global_Attribute15,
172 X_Global_Attribute16 => Global_Attribute16,
173 X_Global_Attribute17 => Global_Attribute17,
174 X_Global_Attribute18 => Global_Attribute18,
175 X_Global_Attribute19 => Global_Attribute19,
176 X_Global_Attribute20 => Global_Attribute20,
177 X_Party_site_id => Party_site_id,
178 X_Party_id => Party_id,
179 X_Location_id => Location_id,
180 X_Party_Site_Number => Party_Site_Number,
181 X_Identifying_address_flag => Identifying_address_flag,
182 X_Cust_acct_site_id => Cust_acct_site_id,
183 X_Cust_account_id => Cust_account_id,
184 X_su_Bill_To_Flag => su_Bill_To_Flag,
185 X_su_Ship_To_Flag => su_Ship_To_Flag,
186 X_su_Market_Flag => su_Market_Flag,
187 X_su_stmt_flag => su_stmt_flag,
188 X_su_dun_flag => su_dun_flag,
189 X_su_legal_flag => su_legal_flag,
190 X_Customer_Category => Customer_Category,
191 X_Key_Account_Flag => Key_Account_Flag,
192 X_Territory_id => Territory_id,
193 X_ece_tp_location_code => ece_tp_location_code,
194 x_address_mode => address_mode,
195 x_territory => territory,
196 x_translated_customer_name => translated_customer_name,
197 x_sales_tax_geo_code => sales_tax_geo_code,
198 x_sale_tax_inside_city_limits => sale_tax_inside_city_limits,
199 x_ADDRESSEE => addressee,
200 x_shared_party_site => shared_party_site,
201 x_update_account_site => update_account_site,
202 x_create_location_party_site => create_location_party_site,
203 x_msg_count => msg_count,
204 x_msg_data => msg_data,
205 x_return_status => return_status);
206
207 exception
208 when others then
209 NULL;
210
211 END Insert_Row;
212
213 --
214 END hz_addr_ispeed_pkg;