[Home] [Help]
PACKAGE: APPS.HZ_ORG_INFO_PUB
Source
1 package HZ_ORG_INFO_PUB AUTHID CURRENT_USER as
2 /* $Header: ARHORISS.pls 120.3 2005/06/24 16:00:57 sponnamb ship $ */
3
4 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5
6 ----------------------------------------------------------------
7 ------------------ #1 stock_markets_rec_type -------------------
8 ----------------------------------------------------------------
9
10 TYPE stock_markets_rec_type IS RECORD(
11 stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
12 country_of_residence VARCHAR2(60) := FND_API.G_MISS_CHAR,
13 stock_exchange_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14 stock_exchange_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
15 wh_update_date DATE := FND_API.G_MISS_DATE);
16
17
18 ----------------------------------------------------------------
19 ------------------ #2 security_issued_rec_type ----------------
20 ----------------------------------------------------------------
21
22
23 TYPE security_issued_rec_type IS RECORD(
24 security_issued_id NUMBER := FND_API.G_MISS_NUM,
25 estimated_total_amount NUMBER := FND_API.G_MISS_NUM,
26 stock_exchange_id NUMBER := FND_API.G_MISS_NUM,
27 security_issued_class VARCHAR2(30) := FND_API.G_MISS_CHAR,
28 security_issued_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
29 total_amount_in_a_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
30 stock_ticker_symbol VARCHAR2(60) := FND_API.G_MISS_CHAR,
31 security_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
32 begin_date DATE := FND_API.G_MISS_DATE,
33 party_id NUMBER := FND_API.G_MISS_NUM,
34 end_date DATE := FND_API.G_MISS_DATE,
35 wh_update_date DATE := FND_API.G_MISS_DATE,
36 status VARCHAR2(1) := FND_API.G_MISS_CHAR);
37
38 ----------------------------------------------------------------
39 ------------------ #3 financial_reports_rec_type ---------------
40 ----------------------------------------------------------------
41
42 TYPE financial_reports_rec_type IS RECORD(
43 financial_report_id NUMBER := FND_API.G_MISS_NUM,
44 date_report_issued DATE := FND_API.G_MISS_DATE,
45 party_id NUMBER := FND_API.G_MISS_NUM,
46 document_reference VARCHAR2(120) := FND_API.G_MISS_CHAR,
47 issued_period VARCHAR2(60) := FND_API.G_MISS_CHAR,
48 requiring_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
49 type_of_financial_report VARCHAR2(60) := FND_API.G_MISS_CHAR,
50 wh_udpate_id DATE := FND_API.G_MISS_DATE,
51 report_start_date DATE := FND_API.G_MISS_DATE,
52 report_end_date DATE := FND_API.G_MISS_DATE,
53 audit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
54 consolidated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
55 estimated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
56 fiscal_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
57 final_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
58 forecast_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
59 opening_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
60 proforma_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
61 qualified_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
62 restated_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
63 signed_by_principals_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
64 trial_balance_ind VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 unbalanced_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
66 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
67 status VARCHAR2(1) := FND_API.G_MISS_CHAR,
68 actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
69 );
70
71
72
73
74 ----------------------------------------------------------------
75 ------------------ #4 financial_numbers_rec_type ---------------
76 ----------------------------------------------------------------
77
78
79 TYPE financial_numbers_rec_type IS RECORD(
80 financial_number_id NUMBER := FND_API.G_MISS_NUM,
81 financial_report_id NUMBER := FND_API.G_MISS_NUM,
82 financial_number NUMBER := FND_API.G_MISS_NUM,
83 financial_number_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
84 financial_units_applied NUMBER := FND_API.G_MISS_NUM,
85 financial_number_currency VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 projected_actual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
87 wh_update_date DATE := FND_API.G_MISS_DATE,
88 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
89 status VARCHAR2(1) := FND_API.G_MISS_CHAR
90 );
91
92
93 ----------------------------------------------------------------
94 ------------------ #5 certifications_rec_type ---------------
95 ----------------------------------------------------------------
96
97
98 TYPE certifications_rec_type IS RECORD(
99 certification_id NUMBER := FND_API.G_MISS_NUM,
100 certification_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 party_id NUMBER := FND_API.G_MISS_NUM,
102 current_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
103 expires_on_date DATE := FND_API.G_MISS_DATE,
104 grade VARCHAR2(30) := FND_API.G_MISS_CHAR,
105 issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
106 issued_on_date DATE := FND_API.G_MISS_DATE,
107 wh_update_date DATE := FND_API.G_MISS_DATE,
108 status VARCHAR2(1) := FND_API.G_MISS_CHAR);
109
110 ----------------------------------------------------------------
111 ------------------ #6 industrial_reference_rec_type ---------
112 ----------------------------------------------------------------
113
114 TYPE industrial_reference_rec_type IS RECORD(
115 industry_reference_id NUMBER := FND_API.G_MISS_NUM,
116 industry_reference VARCHAR2(60) := FND_API.G_MISS_CHAR,
117 party_id NUMBER := FND_API.G_MISS_NUM,
118 issued_by_authority VARCHAR2(60) := FND_API.G_MISS_CHAR,
119 name_of_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
120 recognized_as_of_date DATE := FND_API.G_MISS_DATE,
121 wh_update_date DATE := FND_API.G_MISS_DATE,
122 status VARCHAR2(1) := FND_API.G_MISS_CHAR);
123
124 ----------------------------------------------------------------
125 ------------------ #7 industrial_classes_rec_typ ------------
126 ----------------------------------------------------------------
127
128
129 TYPE industrial_classes_rec_type IS RECORD(
130 industrial_class_id NUMBER := FND_API.G_MISS_NUM,
131 industrial_code_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
132 code_primary_segment VARCHAR2(60) := FND_API.G_MISS_CHAR,
133 industrial_class_source VARCHAR2(60) := FND_API.G_MISS_CHAR,
134 code_description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
135 wh_update_date DATE := FND_API.G_MISS_DATE);
136
137 ----------------------------------------------------------------
138 ------------------ #8 industrial_class_app_rec_type ---------
139 ----------------------------------------------------------------
140
141 TYPE industrial_class_app_rec_type IS RECORD(
142 code_applied_id NUMBER := FND_API.G_MISS_NUM,
143 begin_date DATE := FND_API.G_MISS_DATE,
144 party_id NUMBER := FND_API.G_MISS_NUM,
145 end_date DATE := FND_API.G_MISS_DATE,
146 industrial_class_id NUMBER := FND_API.G_MISS_NUM,
147 wh_update_date DATE := FND_API.G_MISS_DATE,
148 content_source_type VARCHAR2(60) := FND_API.G_MISS_CHAR,
149 importance_ranking VARCHAR2(240) := FND_API.G_MISS_CHAR);
150
151
152 --------------------- #1 -----------------------------
153
154 procedure create_stock_markets(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
157 p_commit IN VARCHAR2:= FND_API.G_FALSE,
158 p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 x_stock_exchange_id OUT NOCOPY NUMBER,
163 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
164 );
165
166 procedure update_stock_markets(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
169 p_commit IN VARCHAR2:= FND_API.G_FALSE,
170 p_stock_markets_rec IN STOCK_MARKETS_REC_TYPE,
171 p_last_update_date IN OUT NOCOPY DATE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
176 );
177
178 --------------------- #2 -----------------------------
179 procedure create_security_issued(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
182 p_commit IN VARCHAR2:= FND_API.G_FALSE,
183 p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 x_security_issued_id OUT NOCOPY NUMBER,
188 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
189 );
190
191
192 procedure update_security_issued(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
195 p_commit IN VARCHAR2:= FND_API.G_FALSE,
196 p_security_issued_rec IN SECURITY_ISSUED_REC_TYPE,
197 p_last_update_date IN OUT NOCOPY DATE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
202 );
203
204 --------------------- #3 -----------------------------
205 /* Obsolete V1 API
206 procedure create_financial_reports(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
209 p_commit IN VARCHAR2:= FND_API.G_FALSE,
210 p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 x_financial_report_id OUT NOCOPY NUMBER,
215 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
216 );
217
218
219 procedure update_financial_reports(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
222 p_commit IN VARCHAR2:= FND_API.G_FALSE,
223 p_financial_reports_rec IN FINANCIAL_REPORTS_REC_TYPE,
224 p_last_update_date IN OUT NOCOPY DATE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229 );
230
231 --------------------- #4 -----------------------------
232
233 procedure create_financial_numbers(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
236 p_commit IN VARCHAR2:= FND_API.G_FALSE,
237 p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 x_financial_number_id OUT NOCOPY NUMBER,
242 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
243 );
244
245
246 procedure update_financial_numbers(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
249 p_commit IN VARCHAR2:= FND_API.G_FALSE,
250 p_financial_numbers_rec IN FINANCIAL_NUMBERS_REC_TYPE,
251 p_last_update_date IN OUT NOCOPY DATE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
256 );
257 */
258
259 --------------------- #5 -----------------------------
260
261 procedure create_certifications(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
264 p_commit IN VARCHAR2:= FND_API.G_FALSE,
268 x_msg_data OUT NOCOPY VARCHAR2,
265 p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
269 x_certification_id OUT NOCOPY NUMBER,
270 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271 );
272
273
274 procedure update_certifications(
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
277 p_commit IN VARCHAR2:= FND_API.G_FALSE,
278 p_certifications_rec IN CERTIFICATIONS_REC_TYPE,
279 p_last_update_date IN OUT NOCOPY DATE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284 );
285
286 --------------------- #6 -----------------------------
287
288 procedure create_industrial_reference(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
291 p_commit IN VARCHAR2:= FND_API.G_FALSE,
292 p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 x_industry_reference_id OUT NOCOPY NUMBER,
297 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298 );
299
300
301 procedure update_industrial_reference(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
304 p_commit IN VARCHAR2:= FND_API.G_FALSE,
305 p_industrial_reference_rec IN INDUSTRIAL_REFERENCE_REC_TYPE,
306 p_last_update_date IN OUT NOCOPY DATE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
311 );
312
313 --------------------- #7 -----------------------------
314
315 procedure create_industrial_classes(
316 p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
318 p_commit IN VARCHAR2:= FND_API.G_FALSE,
319 p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 x_industrial_class_id OUT NOCOPY NUMBER,
324 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
325 );
326
327
328 procedure update_industrial_classes(
329 p_api_version IN NUMBER,
330 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
331 p_commit IN VARCHAR2:= FND_API.G_FALSE,
332 p_industrial_classes_rec IN INDUSTRIAL_CLASSES_REC_TYPE,
333 p_last_update_date IN OUT NOCOPY DATE,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
338 );
339
340 --------------------- #8 -----------------------------
341
342 procedure create_industrial_class_app(
343 p_api_version IN NUMBER,
344 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
345 p_commit IN VARCHAR2:= FND_API.G_FALSE,
346 p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_count OUT NOCOPY NUMBER,
349 x_msg_data OUT NOCOPY VARCHAR2,
350 x_code_applied_id OUT NOCOPY NUMBER,
351 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
352 );
353
354 procedure update_industrial_class_app(
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
357 p_commit IN VARCHAR2:= FND_API.G_FALSE,
358 p_industrial_class_app_rec IN INDUSTRIAL_CLASS_APP_REC_TYPE,
359 p_last_update_date IN OUT NOCOPY DATE,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
364 );
365
366
367 procedure get_current_financial_report(
368 p_api_version IN NUMBER,
369 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
370 p_financial_report_id IN NUMBER,
371 x_financial_reports_rec OUT NOCOPY FINANCIAL_REPORTS_REC_TYPE,
372 x_return_status IN OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
377 procedure get_current_financial_number(
374 x_msg_data OUT NOCOPY VARCHAR2
375 );
376
378 p_api_version IN NUMBER,
379 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
380 p_financial_number_id IN NUMBER,
381 x_financial_numbers_rec OUT NOCOPY FINANCIAL_NUMBERS_REC_TYPE,
382 x_return_status IN OUT NOCOPY VARCHAR2,
383 x_msg_count OUT NOCOPY NUMBER,
384 x_msg_data OUT NOCOPY VARCHAR2
385 );
386
387
388 end HZ_ORG_INFO_PUB;