1 PACKAGE hz_addr_ispeed_pkg as
2 /* $Header: ARHADISS.pls 120.2 2005/06/16 21:08:30 jhuang ship $*/
3 --
4 --
5 --
6 PROCEDURE insert_row (
7 Address_Id IN OUT NOCOPY NUMBER,
8 Last_Update_Date DATE,
9 Last_Updated_By NUMBER,
10 Creation_Date DATE,
11 Created_By NUMBER,
12 Status VARCHAR2,
13 Orig_System_Reference IN OUT NOCOPY VARCHAR2,
14 Country VARCHAR2,
15 Address1 VARCHAR2,
16 Address2 VARCHAR2,
17 Address3 VARCHAR2,
18 Address4 VARCHAR2,
19 City VARCHAR2,
20 Postal_Code VARCHAR2,
21 State VARCHAR2,
22 Province VARCHAR2,
23 County VARCHAR2,
24 Last_Update_Login NUMBER,
25 Address_Key VARCHAR2,
26 Language VARCHAR2,
27 Attribute_Category VARCHAR2,
28 Attribute1 VARCHAR2,
29 Attribute2 VARCHAR2,
30 Attribute3 VARCHAR2,
31 Attribute4 VARCHAR2,
32 Attribute5 VARCHAR2,
33 Attribute6 VARCHAR2,
34 Attribute7 VARCHAR2,
35 Attribute8 VARCHAR2,
36 Attribute9 VARCHAR2,
37 Attribute10 VARCHAR2,
38 Attribute11 VARCHAR2,
39 Attribute12 VARCHAR2,
40 Attribute13 VARCHAR2,
41 Attribute14 VARCHAR2,
42 Attribute15 VARCHAR2,
43 Attribute16 VARCHAR2,
44 Attribute17 VARCHAR2,
45 Attribute18 VARCHAR2,
46 Attribute19 VARCHAR2,
47 Attribute20 VARCHAR2,
48 Address_Lines_Phonetic VARCHAR2,
49 Global_Attribute_Category VARCHAR2,
50 Global_Attribute1 VARCHAR2,
51 Global_Attribute2 VARCHAR2,
52 Global_Attribute3 VARCHAR2,
53 Global_Attribute4 VARCHAR2,
54 Global_Attribute5 VARCHAR2,
55 Global_Attribute6 VARCHAR2,
56 Global_Attribute7 VARCHAR2,
57 Global_Attribute8 VARCHAR2,
58 Global_Attribute9 VARCHAR2,
59 Global_Attribute10 VARCHAR2,
60 Global_Attribute11 VARCHAR2,
61 Global_Attribute12 VARCHAR2,
62 Global_Attribute13 VARCHAR2,
63 Global_Attribute14 VARCHAR2,
64 Global_Attribute15 VARCHAR2,
65 Global_Attribute16 VARCHAR2,
66 Global_Attribute17 VARCHAR2,
67 Global_Attribute18 VARCHAR2,
68 Global_Attribute19 VARCHAR2,
69 Global_Attribute20 VARCHAR2,
70 Party_site_id IN OUT NOCOPY NUMBER,
71 Party_id NUMBER,
72 Location_id IN OUT NOCOPY NUMBER,
73 Party_Site_Number IN OUT NOCOPY VARCHAR2,
74 Identifying_address_flag VARCHAR2,
75 Cust_acct_site_id in out NOCOPY NUMBER,
76 Cust_account_id NUMBER,
77 su_Bill_To_Flag VARCHAR2,
78 su_Ship_To_Flag VARCHAR2,
79 su_Market_Flag VARCHAR2,
80 su_stmt_flag VARCHAR2,
81 su_dun_flag VARCHAR2,
82 su_legal_flag VARCHAR2,
83 Customer_Category VARCHAR2,
84 Key_Account_Flag VARCHAR2,
85 Territory_id NUMBER,
86 ece_tp_location_code VARCHAR2,
87 address_mode VARCHAR2,
88 territory VARCHAR2,
89 translated_customer_name VARCHAR2,
90 sales_tax_geo_code VARCHAR2,
91 sale_tax_inside_city_limits VARCHAR2,
92 shared_party_site IN VARCHAR2,
93 update_account_site IN VARCHAR2,
94 create_location_party_site IN VARCHAR2,
95 addressee VARCHAR2,
96 org_id IN NUMBER,
97 msg_count OUT NOCOPY NUMBER,
98 msg_data OUT NOCOPY VARCHAR2,
99 return_status OUT NOCOPY VARCHAR2);
100
101 /*
102
103 --
104 PROCEDURE update_row (
105 Address_Id NUMBER,
106 Last_Update_Date in out NOCOPY DATE,
107 party_site_Last_Update_Date in out NOCOPY DATE,
108 loc_Last_Update_Date in out NOCOPY DATE,
109 Last_Updated_By NUMBER,
110 Status VARCHAR2,
111 Orig_System_Reference VARCHAR2,
112 Country VARCHAR2,
113 Address1 VARCHAR2,
114 Address2 VARCHAR2,
115 Address3 VARCHAR2,
116 Address4 VARCHAR2,
117 City VARCHAR2,
118 Postal_Code VARCHAR2,
119 State VARCHAR2,
120 Province VARCHAR2,
121 County VARCHAR2,
122 Last_Update_Login NUMBER,
123 Address_Key VARCHAR2,
124 Language VARCHAR2,
125 Attribute_Category VARCHAR2,
126 Attribute1 VARCHAR2,
127 Attribute2 VARCHAR2,
128 Attribute3 VARCHAR2,
129 Attribute4 VARCHAR2,
130 Attribute5 VARCHAR2,
131 Attribute6 VARCHAR2,
132 Attribute7 VARCHAR2,
133 Attribute8 VARCHAR2,
134 Attribute9 VARCHAR2,
135 Attribute10 VARCHAR2,
136 Attribute11 VARCHAR2,
137 Attribute12 VARCHAR2,
138 Attribute13 VARCHAR2,
139 Attribute14 VARCHAR2,
140 Attribute15 VARCHAR2,
141 Attribute16 VARCHAR2,
142 Attribute17 VARCHAR2,
143 Attribute18 VARCHAR2,
144 Attribute19 VARCHAR2,
145 Attribute20 VARCHAR2,
146 Address_Lines_Phonetic VARCHAR2,
147 Global_Attribute_Category VARCHAR2,
148 Global_Attribute1 VARCHAR2,
149 Global_Attribute2 VARCHAR2,
150 Global_Attribute3 VARCHAR2,
151 Global_Attribute4 VARCHAR2,
152 Global_Attribute5 VARCHAR2,
153 Global_Attribute6 VARCHAR2,
154 Global_Attribute7 VARCHAR2,
155 Global_Attribute8 VARCHAR2,
156 Global_Attribute9 VARCHAR2,
157 Global_Attribute10 VARCHAR2,
158 Global_Attribute11 VARCHAR2,
159 Global_Attribute12 VARCHAR2,
160 Global_Attribute13 VARCHAR2,
161 Global_Attribute14 VARCHAR2,
162 Global_Attribute15 VARCHAR2,
163 Global_Attribute16 VARCHAR2,
164 Global_Attribute17 VARCHAR2,
165 Global_Attribute18 VARCHAR2,
166 Global_Attribute19 VARCHAR2,
167 Global_Attribute20 VARCHAR2,
168 Party_site_id NUMBER,
169 Party_id NUMBER,
170 Location_id NUMBER,
171 Party_Site_Number VARCHAR2,
172 Identifying_address_flag VARCHAR2,
173 Cust_acct_site_id NUMBER,
174 Cust_account_id NUMBER,
175 su_Bill_To_Flag VARCHAR2,
176 su_Ship_To_Flag VARCHAR2,
177 su_Market_Flag VARCHAR2,
178 su_stmt_flag VARCHAR2,
179 su_dun_flag VARCHAR2,
180 su_legal_flag VARCHAR2,
181 Customer_Category VARCHAR2,
182 Key_Account_Flag VARCHAR2,
183 Territory_id NUMBER,
184 ece_tp_location_code VARCHAR2,
185 address_mode VARCHAR2,
186 Territory VARCHAR2,
187 Translated_Customer_Name VARCHAR2,
188 Sales_Tax_Geocode VARCHAR2,
189 Sales_Tax_Inside_City_Limits VARCHAR2,
190 addressee VARCHAR2,
191 msg_count OUT NOCOPY NUMBER,
192 msg_data OUT NOCOPY VARCHAR2,
193 return_status OUT NOCOPY VARCHAR2);
194
195 */
196
197 END hz_addr_ispeed_pkg;
|
|
|