[Home] [Help]
PACKAGE: APPS.ARP_CSU_PKG
Source
1 PACKAGE arp_csu_pkg as
2 /* $Header: AROCSUS.pls 120.3 2005/08/11 01:03:26 hyu ship $ */
3
4 /*Bug 44509019 Removed GSCC warning file.sql.39 used NOCOPY hint for OUT and IN OUT parameter type*/
5 PROCEDURE site_use_exists( p_address_id in number,
6 p_site_use_code in varchar2,
7 p_site_use_id out NOCOPY number,
8 p_site_use_status out NOCOPY varchar2);
9
10
11 procedure check_unique_site_use_code( p_site_use_id in number,
12 p_customer_id in number,
13 p_address_id in number,
14 p_site_use_code in varchar2);
15
16 procedure check_unique_location ( p_site_use_id in number,
17 p_customer_id in number,
18 p_site_use_code in varchar2,
19 p_location in varchar2 );
20
21 PROCEDURE check_primary ( p_site_use_id in number,
22 p_customer_id in number,
23 p_site_use_code in varchar2);
24
25 PROCEDURE update_su_status ( p_customer_id in number,
26 p_address_id in number,
27 p_site_use_id in number,
28 p_site_use_code in varchar2,
29 p_status in varchar2 );
30
31 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
32 X_Site_Use_Id IN OUT NOCOPY NUMBER,
33 X_Last_Update_Date DATE,
34 X_Last_Updated_By NUMBER,
35 X_Creation_Date DATE,
36 X_Created_By NUMBER,
37 X_Site_Use_Code VARCHAR2,
38 X_customer_id NUMBER,
39 X_Address_Id NUMBER,
40 X_Primary_Flag VARCHAR2,
41 X_Status VARCHAR2,
42 X_Location IN OUT NOCOPY VARCHAR2,
43 X_Last_Update_Login NUMBER,
44 X_Contact_Id NUMBER,
45 X_Bill_To_Site_Use_Id NUMBER,
46 X_Sic_Code VARCHAR2,
47 X_Payment_Term_Id NUMBER,
48 X_Gsa_Indicator VARCHAR2,
49 X_Ship_Partial VARCHAR2,
50 X_Ship_Via VARCHAR2,
51 X_Fob_Point VARCHAR2,
52 X_Order_Type_Id NUMBER,
53 X_Price_List_Id NUMBER,
54 X_Freight_Term VARCHAR2,
55 X_Warehouse_Id NUMBER,
56 X_Territory_Id NUMBER,
57 X_Tax_Code VARCHAR2,
58 X_Tax_Reference VARCHAR2,
59 X_Demand_Class_Code VARCHAR2,
60 x_inventory_location_id NUMBER,
61 x_inventory_organization_id NUMBER,
62 X_Attribute_Category VARCHAR2,
63 X_Attribute1 VARCHAR2,
64 X_Attribute2 VARCHAR2,
65 X_Attribute3 VARCHAR2,
66 X_Attribute4 VARCHAR2,
67 X_Attribute5 VARCHAR2,
68 X_Attribute6 VARCHAR2,
69 X_Attribute7 VARCHAR2,
70 X_Attribute8 VARCHAR2,
71 X_Attribute9 VARCHAR2,
72 X_Attribute10 VARCHAR2,
73 X_Attribute11 VARCHAR2,
74 X_Attribute12 VARCHAR2,
75 X_Attribute13 VARCHAR2,
76 X_Attribute14 VARCHAR2,
77 X_Attribute15 VARCHAR2,
78 X_Attribute16 VARCHAR2,
79 X_Attribute17 VARCHAR2,
80 X_Attribute18 VARCHAR2,
81 X_Attribute19 VARCHAR2,
82 X_Attribute20 VARCHAR2,
83 X_Attribute21 VARCHAR2,
84 X_Attribute22 VARCHAR2,
85 X_Attribute23 VARCHAR2,
86 X_Attribute24 VARCHAR2,
87 X_Attribute25 VARCHAR2,
88 X_Tax_Classification VARCHAR2,
89 X_Tax_Header_Level_Flag VARCHAR2,
90 X_Tax_Rounding_Rule VARCHAR2,
91 X_Global_Attribute_Category VARCHAR2,
92 X_Global_Attribute1 VARCHAR2,
93 X_Global_Attribute2 VARCHAR2,
94 X_Global_Attribute3 VARCHAR2,
95 X_Global_Attribute4 VARCHAR2,
96 X_Global_Attribute5 VARCHAR2,
97 X_Global_Attribute6 VARCHAR2,
98 X_Global_Attribute7 VARCHAR2,
99 X_Global_Attribute8 VARCHAR2,
100 X_Global_Attribute9 VARCHAR2,
101 X_Global_Attribute10 VARCHAR2,
102 X_Global_Attribute11 VARCHAR2,
103 X_Global_Attribute12 VARCHAR2,
104 X_Global_Attribute13 VARCHAR2,
105 X_Global_Attribute14 VARCHAR2,
106 X_Global_Attribute15 VARCHAR2,
107 X_Global_Attribute16 VARCHAR2,
108 X_Global_Attribute17 VARCHAR2,
109 X_Global_Attribute18 VARCHAR2,
110 X_Global_Attribute19 VARCHAR2,
111 X_Global_Attribute20 VARCHAR2,
112 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
113 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
114 X_GL_ID_Rec NUMBER,
115 X_GL_ID_Rev NUMBER,
116 X_GL_ID_Tax NUMBER,
117 X_GL_ID_Freight NUMBER,
118 X_GL_ID_Clearing NUMBER,
119 X_GL_ID_Unbilled NUMBER,
120 X_GL_ID_Unearned NUMBER
121 );
122 --
123 --
124 --
125 --
126
127 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2 ,
128 X_Site_Use_Id IN OUT NOCOPY NUMBER,
129 X_Last_Update_Date DATE,
130 X_Last_Updated_By NUMBER,
131 X_Site_Use_Code VARCHAR2,
132 X_customer_id number,
133 X_Address_Id NUMBER,
134 X_Primary_Flag VARCHAR2,
135 X_Status VARCHAR2,
136 X_Location VARCHAR2,
137 X_Last_Update_Login NUMBER,
138 X_Contact_Id NUMBER,
139 X_Bill_To_Site_Use_Id NUMBER,
140 X_Sic_Code VARCHAR2,
141 X_Payment_Term_Id NUMBER,
142 X_Gsa_Indicator VARCHAR2,
143 X_Ship_Partial VARCHAR2,
144 X_Ship_Via VARCHAR2,
145 X_Fob_Point VARCHAR2,
146 X_Order_Type_Id NUMBER,
147 X_Price_List_Id NUMBER,
148 X_Freight_Term VARCHAR2,
149 X_Warehouse_Id NUMBER,
150 X_Territory_Id NUMBER,
151 X_Tax_Code VARCHAR2,
152 X_Tax_Reference VARCHAR2,
153 X_Demand_Class_Code VARCHAR2,
154 x_inventory_location_id NUMBER,
155 x_inventory_organization_id NUMBER,
156 X_Attribute_Category VARCHAR2,
157 X_Attribute1 VARCHAR2,
158 X_Attribute2 VARCHAR2,
159 X_Attribute3 VARCHAR2,
160 X_Attribute4 VARCHAR2,
161 X_Attribute5 VARCHAR2,
162 X_Attribute6 VARCHAR2,
163 X_Attribute7 VARCHAR2,
164 X_Attribute8 VARCHAR2,
165 X_Attribute9 VARCHAR2,
166 X_Attribute10 VARCHAR2,
167 X_Attribute11 VARCHAR2,
168 X_Attribute12 VARCHAR2,
169 X_Attribute13 VARCHAR2,
170 X_Attribute14 VARCHAR2,
171 X_Attribute15 VARCHAR2,
172 X_Attribute16 VARCHAR2,
173 X_Attribute17 VARCHAR2,
174 X_Attribute18 VARCHAR2,
175 X_Attribute19 VARCHAR2,
176 X_Attribute20 VARCHAR2,
177 X_Attribute21 VARCHAR2,
178 X_Attribute22 VARCHAR2,
179 X_Attribute23 VARCHAR2,
180 X_Attribute24 VARCHAR2,
181 X_Attribute25 VARCHAR2,
182 X_Tax_Classification VARCHAR2,
183 X_Tax_Header_Level_Flag VARCHAR2,
184 X_Tax_Rounding_Rule VARCHAR2,
185 X_Global_Attribute_Category VARCHAR2,
186 X_Global_Attribute1 VARCHAR2,
187 X_Global_Attribute2 VARCHAR2,
188 X_Global_Attribute3 VARCHAR2,
189 X_Global_Attribute4 VARCHAR2,
190 X_Global_Attribute5 VARCHAR2,
191 X_Global_Attribute6 VARCHAR2,
192 X_Global_Attribute7 VARCHAR2,
193 X_Global_Attribute8 VARCHAR2,
194 X_Global_Attribute9 VARCHAR2,
195 X_Global_Attribute10 VARCHAR2,
196 X_Global_Attribute11 VARCHAR2,
197 X_Global_Attribute12 VARCHAR2,
198 X_Global_Attribute13 VARCHAR2,
199 X_Global_Attribute14 VARCHAR2,
200 X_Global_Attribute15 VARCHAR2,
201 X_Global_Attribute16 VARCHAR2,
202 X_Global_Attribute17 VARCHAR2,
203 X_Global_Attribute18 VARCHAR2,
204 X_Global_Attribute19 VARCHAR2,
205 X_Global_Attribute20 VARCHAR2,
206 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
207 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
208 X_GL_ID_Rec NUMBER,
209 X_GL_ID_Rev NUMBER,
210 X_GL_ID_Tax NUMBER,
211 X_GL_ID_Freight NUMBER,
212 X_GL_ID_Clearing NUMBER,
213 X_GL_ID_Unbilled NUMBER,
214 X_GL_ID_Unearned NUMBER
215 );
216
217 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
218 X_Site_Use_Id NUMBER,
219 X_Site_Use_Code VARCHAR2,
220 X_Address_Id NUMBER,
221 X_Primary_Flag VARCHAR2,
222 X_Status VARCHAR2,
223 X_Location VARCHAR2,
224 X_Contact_Id NUMBER,
225 X_Bill_To_Site_Use_Id NUMBER,
226 X_Sic_Code VARCHAR2,
227 X_Payment_Term_Id NUMBER,
228 X_Gsa_Indicator VARCHAR2,
229 X_Ship_Partial VARCHAR2,
230 X_Ship_Via VARCHAR2,
231 X_Fob_Point VARCHAR2,
232 X_Order_Type_Id NUMBER,
233 X_Price_List_Id NUMBER,
234 X_Freight_Term VARCHAR2,
235 X_Warehouse_Id NUMBER,
236 X_Territory_Id NUMBER,
237 X_Tax_Code VARCHAR2,
238 X_Tax_Reference VARCHAR2,
239 X_Demand_Class_Code VARCHAR2,
240 X_Attribute_Category VARCHAR2,
241 X_Attribute1 VARCHAR2,
242 X_Attribute2 VARCHAR2,
243 X_Attribute3 VARCHAR2,
244 X_Attribute4 VARCHAR2,
245 X_Attribute5 VARCHAR2,
246 X_Attribute6 VARCHAR2,
247 X_Attribute7 VARCHAR2,
248 X_Attribute8 VARCHAR2,
249 X_Attribute9 VARCHAR2,
250 X_Attribute10 VARCHAR2,
251 X_Attribute11 VARCHAR2,
252 X_Attribute12 VARCHAR2,
253 X_Attribute13 VARCHAR2,
254 X_Attribute14 VARCHAR2,
255 X_Attribute15 VARCHAR2,
256 X_Attribute16 VARCHAR2,
257 X_Attribute17 VARCHAR2,
258 X_Attribute18 VARCHAR2,
259 X_Attribute19 VARCHAR2,
260 X_Attribute20 VARCHAR2,
261 X_Attribute21 VARCHAR2,
262 X_Attribute22 VARCHAR2,
263 X_Attribute23 VARCHAR2,
264 X_Attribute24 VARCHAR2,
265 X_Attribute25 VARCHAR2,
266 X_Tax_Classification VARCHAR2,
267 X_Tax_Header_Level_Flag VARCHAR2,
268 X_Tax_Rounding_Rule VARCHAR2,
269 X_Global_Attribute_Category VARCHAR2,
273 X_Global_Attribute4 VARCHAR2,
270 X_Global_Attribute1 VARCHAR2,
271 X_Global_Attribute2 VARCHAR2,
272 X_Global_Attribute3 VARCHAR2,
274 X_Global_Attribute5 VARCHAR2,
275 X_Global_Attribute6 VARCHAR2,
276 X_Global_Attribute7 VARCHAR2,
277 X_Global_Attribute8 VARCHAR2,
278 X_Global_Attribute9 VARCHAR2,
279 X_Global_Attribute10 VARCHAR2,
280 X_Global_Attribute11 VARCHAR2,
281 X_Global_Attribute12 VARCHAR2,
282 X_Global_Attribute13 VARCHAR2,
283 X_Global_Attribute14 VARCHAR2,
284 X_Global_Attribute15 VARCHAR2,
285 X_Global_Attribute16 VARCHAR2,
286 X_Global_Attribute17 VARCHAR2,
287 X_Global_Attribute18 VARCHAR2,
288 X_Global_Attribute19 VARCHAR2,
289 X_Global_Attribute20 VARCHAR2,
290 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
291 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
292 X_GL_ID_Rec NUMBER,
293 X_GL_ID_Rev NUMBER,
294 X_GL_ID_Tax NUMBER,
295 X_GL_ID_Freight NUMBER,
296 X_GL_ID_Clearing NUMBER,
297 X_GL_ID_Unbilled NUMBER,
298 X_GL_ID_Unearned NUMBER
299
300 );
301
302 END arp_csu_pkg;