[Home] [Help]
PACKAGE: APPS.XLE_UTILITIES_GRP
Source
1 PACKAGE XLE_UTILITIES_GRP AUTHID CURRENT_USER AS
2 /* $Header: xlegfpts.pls 120.42 2006/01/27 19:55:36 shnaraya ship $*/
3
4
5 --G_PKG_NAME CONSTANT VARCHAR2(30):=' XLE_UTILITIES_GRP';
6 -- TYPE RegNum_tbl_type IS TABLE OF XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7
8 TYPE RegNum_Rec IS RECORD (
9 registration_number XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
10 legislative_cat_code XLE_JURISDICTIONS_VL.LEGISLATIVE_CAT_CODE%TYPE
11 );
12 TYPE RegNum_tbl_type IS TABLE OF RegNum_Rec INDEX BY BINARY_INTEGER;
13
14 TYPE PartyClass_Rec IS RECORD (
15 class_category XLE_LOOKUPS.LOOKUP_TYPE%TYPE,
16 class_code XLE_LOOKUPS.LOOKUP_CODE%TYPE,
17 meaning XLE_LOOKUPS.meaning%TYPE
18 );
19
20 TYPE PartyClass_tbl_type IS TABLE OF PartyClass_Rec INDEX BY BINARY_INTEGER;
21
22 TYPE PartyID_tbl_type IS TABLE OF HR_ALL_ORGANIZATION_UNITS.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
23
24 TYPE CountryCode_Rec IS RECORD (
25 country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE
26 );
27
28 TYPE CountryCode_tbl_type IS TABLE OF CountryCode_Rec INDEX BY BINARY_INTEGER;
29
30 TYPE LegalEntity_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
31
32 TYPE History_Rec IS RECORD (
33 SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34 SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35 SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36 SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37 EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38 EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39 COMMENTS XLE_HISTORIES.COMMENTS%TYPE
40 );
41
42 TYPE History_Tbl_Type IS TABLE OF History_Rec INDEX BY BINARY_INTEGER;
43
44
45
46 -- Start of comments
47 -- API name : Get_LegalEntityID_OU (Stamping API)
48 -- Type : Group
49 -- Function : Used for Stamping Transactions with Legal Entity ID
50 -- Pre-reqs : None.
51 -- Parameters :
52 -- IN : p_api_version IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2 Optional
54 -- Default = FND_API.G_FALSE
55 -- p_commit IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 --
58 -- p_operating_unit IN NUMBER ,
59 --
60 --
61 -- OUT : x_return_status OUT VARCHAR2(1)
62 -- x_msg_count OUT NUMBER
63 -- x_msg_data OUT VARCHAR2(2000)
64 -- x_LegalEntity_tbl OUT LegalEntity_tbl_type
65 --
66 -- Version : Current version 1.0
67 -- Changed....
68 -- previous version 1.0
69 -- Changed....
70 --
71 -- Initial version 1.0
72 --
73 -- Notes : Requesting Team : Legal Entity
74 --
75 -- End of comments
76
77
78
79
80 TYPE Registration_Rec IS RECORD (
81 PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
82 ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
83 ENTITY_NAME XLE_ENTITY_PROFILES.NAME%TYPE,
84 ENTITY_TYPE VARCHAR2(100),
85 REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
86 REGISTERED_NAME XLE_REGISTRATIONS.registered_name%TYPE,
87 ALTERNATE_REGISTERED_NAME XLE_REGISTRATIONS.alternate_registered_name%TYPE,
88 identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
89 LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
90 LEGALAUTH_NAME HZ_PARTIES.PARTY_NAME%TYPE,
91 LEGALAUTH_ADDRESS VARCHAR2(1000),
92 EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
93 EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
94 LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
95 ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96 ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97 ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98 TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99 REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100 REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101 REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102 POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103 COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
104 );
105
106 TYPE Registration_Tbl_Type IS TABLE OF Registration_Rec INDEX BY BINARY_INTEGER;
107
108
109 TYPE Establishment_Rec IS RECORD (
110 ESTABLISHMENT_ID XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,
111 ESTABLISHMENT_NAME XLE_ETB_PROFILES.NAME%TYPE,
112 PARTY_ID XLE_ETB_PROFILES.PARTY_ID%TYPE,
113 LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
114 MAIN_ESTABLISHMENT_FLAG XLE_ETB_PROFILES.MAIN_ESTABLISHMENT_FLAG%TYPE,
115 ACTIVITY_CODE XLE_ETB_PROFILES.ACTIVITY_CODE%TYPE,
116 sub_activity_code XLE_ETB_PROFILES.SUB_ACTIVITY_CODE%TYPE,
117 type_of_company XLE_ETB_PROFILES.type_of_company%TYPE,
118 ETB_EFFECTIVE_FROM XLE_ETB_PROFILES.EFFECTIVE_FROM%TYPE,
119 ETB_EFFECTIVE_TO XLE_ETB_PROFILES.EFFECTIVE_TO%TYPE,
120 REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
121 identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
122 LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
123 EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
124 EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
125 LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126 ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127 ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128 ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129 TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130 REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131 REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132 REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133 POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134 COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
135 );
136
137 TYPE Establishment_Tbl_Type IS TABLE OF Establishment_Rec INDEX BY BINARY_INTEGER;
138
139 TYPE LegalEntity_Rec IS RECORD (
140 LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
141 NAME XLE_ENTITY_PROFILES.NAME%TYPE,
142 PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
143 LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
144 TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
145 ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
146 sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
147 type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
148 LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
149 LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
150 REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
151 identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
152 LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
153 EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
154 EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
155 LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156 ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157 ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158 ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159 TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160 REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161 REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162 REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163 POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164 COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
165 );
166
167 TYPE Legal_Entity_Tbl_Type IS TABLE OF LegalEntity_Rec INDEX BY BINARY_INTEGER;
168
169 PROCEDURE Get_Registration_Info(
170 x_return_status OUT NOCOPY VARCHAR2 ,
171 x_msg_count OUT NOCOPY NUMBER ,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
174 P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
175 P_ENTITY_TYPE IN VARCHAR2,
176 P_identifying_flag IN VARCHAR2,
177 P_LEGISLATIVE_CATEGORY IN VARCHAR2,
178 X_REGISTRATION_INFO OUT NOCOPY Registration_Tbl_Type);
179
180
181 PROCEDURE Get_Establishment_Info(
182 x_return_status OUT NOCOPY VARCHAR2 ,
183 x_msg_count OUT NOCOPY NUMBER ,
184 x_msg_data OUT NOCOPY VARCHAR2 ,
185 P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
186 P_ESTABLISHMENT_ID IN XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,
187 p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
188 p_etb_reg IN VARCHAR2 default 'Y',
189 X_ESTABLISHMENT_INFO OUT NOCOPY Establishment_Tbl_Type);
190
191 PROCEDURE Get_LegalEntity_Info(
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
196 P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
197 X_LEGALENTITY_INFO OUT NOCOPY LegalEntity_Rec);
198
199
200 PROCEDURE Get_History_Info(
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
205 P_ENTITY_TYPE IN VARCHAR2,
206 P_EFFECTIVE_DATE IN VARCHAR2,
207 X_HISTORY_INFO OUT NOCOPY History_Tbl_Type);
208
209
210
211 PROCEDURE Get_LegalEntityID_OU(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2,
214 p_commit IN VARCHAR2,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_operating_unit IN NUMBER,
219 x_LegalEntity_tbl OUT NOCOPY LegalEntity_tbl_type);
220 -- Start of comments
221 -- API name : Get_LegalEntityName_PID
222 -- Type : Group
223 -- Function :
224 -- Pre-reqs : None.
225 -- Parameters :
226 -- IN : p_api_version IN i NUMBER Required
227 -- p_init_msg_list IN VARCHAR2 Optional
228 -- Default = FND_API.G_FALSE
229 -- p_commit IN VARCHAR2 Optional
230 -- Default = FND_API.G_FALSE
231 --
232 -- p_party_id IN NUMBER ,
233 --
234 --
235 -- OUT : x_return_status OUT VARCHAR2(1)
236 -- x_msg_count OUT NUMBER
237 -- x_msg_data OUT VARCHAR2(2000)
238 -- x_Legal_entity_name OUT NOCOPY VARCHAR2
239 -- Version : Current version 1.0
240 -- Changed....
241 -- previous version 1.0
242 -- Changed....
243 --
244 -- Initial version 1.0
245 --
246 -- Notes : Requesting Team : Legal Entity
247 --
248 -- End of comments
249 PROCEDURE Get_LegalEntityName_PID(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2,
252 p_commit IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_party_id IN NUMBER,
257 x_legal_entity_name OUT NOCOPY VARCHAR2) ;
258
259 -- Start of comments
260 -- API name : Get_CountryCode_LID
261 -- Type : Group
262 -- Function :
263 -- Pre-reqs : None.
264 -- Parameters :
265 -- IN : p_api_version IN NUMBER Required
266 -- p_init_msg_list IN VARCHAR2 Optional
267 -- Default = FND_API.G_FALSE
268 -- p_commit IN VARCHAR2 Optional
269 -- Default = FND_API.G_FALSE
270 --
271 -- p_ledger_id IN NUMBER,
272 --
273 --
274 -- OUT : x_return_status OUT VARCHAR2(1)
275 -- x_msg_count OUT NUMBER
276 -- x_msg_data OUT VARCHAR2(2000)
277 -- x_register_country_tbl OUT NOCOPY CountryCode_tbl_type
278 -- Version : Current version 1.0
279 -- Changed....
280 -- previous version 1.0
281 -- Changed....
282 --
283 -- Initial version 1.0
284 --
285 -- Notes : Requesting Team :
286 --
287 -- End of comments
288
289 PROCEDURE Get_FP_CountryCode_LID(
290 p_api_version IN NUMBER ,
291 p_init_msg_list IN VARCHAR2,
292 p_commit IN VARCHAR2,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER ,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_ledger_id IN NUMBER,
297 x_register_country_tbl OUT NOCOPY CountryCode_tbl_type) ;
298
299
300
301
302 -- Start of comments
303 -- API name : Get_CountryCode_OU
304 -- Type : Group
305 -- Function :
306 -- Pre-reqs : None.
307 -- Parameters :
308 -- IN : p_api_version IN NUMBER Required
309 -- p_init_msg_list IN VARCHAR2 Optional
310 -- Default = FND_API.G_FALSE
311 -- p_commit IN VARCHAR2 Optional
312 -- Default = FND_API.G_FALSE
313 --
314 -- p_operating_unit IN NUMBER
315 --
316 --
317 -- OUT : x_return_status OUT VARCHAR2(1)
318 -- x_msg_count OUT NUMBER
319 -- x_msg_data OUT VARCHAR2(2000)
320 -- x_register_country_tbl OUT NOCOPY CountryCode_tbl_type
321 -- Version : Current version 1.0
322 -- Changed....
323 -- previous version 1.0
324 -- Changed....
325 --
326 -- Initial version 1.0
327 --
328 -- Notes : Requesting Team :
329 --
330 -- End of comments
331
332 PROCEDURE Get_FP_CountryCode_OU(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2,
335 p_commit IN VARCHAR2,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER ,
338 x_msg_data OUT NOCOPY VARCHAR2 ,
339 p_operating_unit IN NUMBER,
340 x_country_code OUT NOCOPY VARCHAR2) ;
341
342 -- Start of comments
343 -- API name : IsEstablishment_PID
344 -- Type : Group
345 -- Function :
346 -- Pre-reqs : None.
347 -- Parameters :
348 -- IN : p_api_version IN NUMBER Required
349 -- p_init_msg_list IN VARCHAR2 Optional
350 -- Default = FND_API.G_FALSE
351 -- p_commit IN VARCHAR2 Optional
352 -- Default = FND_API.G_FALSE
353 --
354 -- p_party_id IN NUMBER
355 --
356 --
357 -- OUT : x_return_status OUT VARCHAR2(1)
361 -- Version : Current version 1.0
358 -- x_msg_count OUT NUMBER
359 -- x_msg_data OUT VARCHAR2(2000)
360 -- x_establishment OUT NOCOPY VARCHAR2
362 -- Changed....
363 -- previous version 1.0
364 -- Changed....
365 --
366 -- Initial version 1.0
367 --
368 -- Notes : Requesting Team :
369 --
370 -- End of comments
371
372 PROCEDURE IsEstablishment_PID(
373 p_api_version IN NUMBER,
374 p_init_msg_list IN VARCHAR2,
375 p_commit IN VARCHAR2,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_party_id IN NUMBER ,
380 x_establishment OUT NOCOPY VARCHAR2 ) ;
381
382 -- Start of comments
383 -- API name : IsTransEntity_PID
384 -- Type : Group
385 -- Function :
386 -- Pre-reqs : None.
387 -- Parameters :
388 -- IN : p_api_version IN NUMBER Required
389 -- p_init_msg_list IN VARCHAR2 Optional
390 -- Default = FND_API.G_FALSE
391 -- p_commit IN VARCHAR2 Optional
392 -- Default = FND_API.G_FALSE
393 --
394 -- p_party_id IN NUMBER
395 --
396 --
397 -- OUT : x_return_status OUT VARCHAR2(1)
398 -- x_msg_count OUT NUMBER
399 -- x_msg_data OUT VARCHAR2(2000)
400 -- x_TransEntity OUT NOCOPY VARCHAR2
401 -- Version : Current version 1.0
402 -- Changed....
403 -- previous version 1.0
404 -- Changed....
405 --
406 -- Initial version 1.0
407 --
408 -- Notes : Requesting Team :
409 --
410 -- End of comments
411 PROCEDURE IsTransEntity_PID (
412 p_api_version IN NUMBER,
413 p_init_msg_list IN VARCHAR2,
414 p_commit IN VARCHAR2,
415 x_return_status OUT NOCOPY VARCHAR2 ,
416 x_msg_count OUT NOCOPY NUMBER,
417 x_msg_data OUT NOCOPY VARCHAR2,
418 p_party_id IN NUMBER ,
419 x_TransEntity OUT NOCOPY VARCHAR2) ;
420
421 -- Start of comments
422 -- API name : Get_PartyID_OU
423 -- Type : Group
424 -- Function :
425 -- Pre-reqs : None.
426 -- Parameters :
427 -- IN : p_api_version IN NUMBER Required
428 -- p_init_msg_list IN VARCHAR2 Optional
429 -- Default = FND_API.G_FALSE
430 -- p_commit IN VARCHAR2 Optional
431 -- Default = FND_API.G_FALSE
432 --
433 -- p_operating_unit IN NUMBER
434 --
435 --
436 -- OUT : x_return_status OUT VARCHAR2(1)
437 -- x_msg_count OUT NUMBER
438 -- x_msg_data OUT VARCHAR2(2000)
439 -- x_party_tbl OUT NOCOPY PartyID_tbl_type
440 -- Version : Current version 1.0
441 -- Changed....
442 -- previous version 1.0
443 -- Changed....
444 --
445 -- Initial version 1.0
446 --
447 -- Notes : Requesting Team :
448 --
449 -- End of comments
450 PROCEDURE Get_PartyID_OU(
451 p_api_version IN NUMBER ,
452 p_init_msg_list IN VARCHAR2,
453 p_commit IN VARCHAR2,
454 x_return_status OUT NOCOPY VARCHAR2 ,
455 x_msg_count OUT NOCOPY NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2 ,
457 p_operating_unit IN NUMBER,
458 x_party_tbl OUT NOCOPY PartyID_tbl_type) ;
459
460 -- Start of comments
461 -- API name : Is_Intercompany_LEID
462 -- Type : Group
463 -- Function :
464 -- Pre-reqs : None.
465 -- Parameters :
466 -- IN : p_api_version IN NUMBER Required
467 -- p_init_msg_list IN VARCHAR2 Optional
468 -- Default = FND_API.G_FALSE
472 -- p_legal_entity_id2 IN VARCHAR2
469 -- p_commit IN VARCHAR2 Optional
470 -- Default = FND_API.G_FALSE
471 -- p_legal_entity_id1 IN VARCHAR2 ,
473 --
474 --
475 --
476 -- OUT : x_return_status OUT VARCHAR2(1)
477 -- x_msg_count OUT NUMBER
478 -- x_msg_data OUT VARCHAR2(2000)
479 -- x_Intercompany OUT NOCOPY VARCHAR2
480 -- Version : Current version 1.0
481 -- Changed....
482 -- previous version 1.0
483 -- Changed....
484 --
485 -- Initial version 1.0
486 --
487 -- Notes : Requesting Team :
488 --
489 -- End of comments
490
491
492 PROCEDURE Is_Intercompany_LEID(
493 p_api_version IN NUMBER,
494 p_init_msg_list IN VARCHAR2,
495 p_commit IN VARCHAR2,
496 x_return_status OUT NOCOPY VARCHAR2,
497 x_msg_count OUT NOCOPY NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2 ,
499 p_legal_entity_id1 IN VARCHAR2 ,
500 p_legal_entity_id2 IN VARCHAR2,
501 x_Intercompany OUT NOCOPY VARCHAR2) ;
502
503
504 -- Start of comments
505 -- API name : Get_ME_PARTYID_LEID
506 -- Type : Group
507 -- Function :
508 -- Pre-reqs : None.
509 -- Parameters :
510 -- IN : p_api_version IN NUMBER Required
511 -- p_init_msg_list IN VARCHAR2 Optional
512 -- Default = FND_API.G_FALSE
513 -- p_commit IN VARCHAR2 Optional
514 -- Default = FND_API.G_FALSE
515 -- p_legal_entity_id IN VARCHAR2,
516 -- p_legal_entity_id2 IN VARCHAR2
517 --
518 --
519 --
520 --
521 -- OUT : x_return_status OUT VARCHAR2(1)
522 -- x_msg_count OUT NUMBER
523 -- x_msg_data OUT VARCHAR2(2000)
524 -- x_me_party_id OUT NOCOPY VARCHAR2
525 -- Version : Current version 1.0
526 -- Changed....
527 -- previous version 1.0
528 -- Changed....
529 --
530 -- Initial version 1.0
531 --
532 -- Notes : Requesting Team : ETax
533 --
534 -- End of comments
535
536 PROCEDURE Get_ME_PARTYID_LEID(
537 p_api_version IN NUMBER,
538 p_init_msg_list IN VARCHAR2,
539 p_commit IN VARCHAR2,
540 x_return_status OUT NOCOPY VARCHAR2,
541 x_msg_count OUT NOCOPY NUMBER,
542 x_msg_data OUT NOCOPY VARCHAR2,
543 p_legal_entity_id IN VARCHAR2,
544 x_me_party_id OUT NOCOPY VARCHAR2);
545
546
547 -- Start of comments
548 -- API name : Get_RegisterNumber_PID
549 -- Type : Group
550 -- Function :
551 -- Pre-reqs : None.
552 -- Parameters :
553 -- IN : p_api_version IN NUMBER Required
554 -- p_init_msg_list IN VARCHAR2 Optional
555 -- Default = FND_API.G_FALSE
556 -- p_commit IN VARCHAR2 Optional
557 -- Default = FND_API.G_FALSE
558 -- p_party_id IN NUMBER
559 --
560 --
561 --
562 --
563 -- OUT : x_return_status OUT VARCHAR2(1)
564 -- x_msg_count OUT NUMBER
565 -- x_msg_data OUT VARCHAR2(2000)
566 -- x_regnum_tbl OUT NOCOPY RegNum_tbl_type
567 -- Version : Current version 1.0
568 -- Changed....
569 -- previous version 1.0
570 -- Changed....
571 --
572 -- Initial version 1.0
573 --
574 -- Notes : Requesting Team :
575 --
576 -- End of comments
577
578 PROCEDURE Get_RegisterNumber_PID(
579 p_api_version IN NUMBER,
580 p_init_msg_list IN VARCHAR2,
581 p_commit IN VARCHAR2,
582 x_return_status OUT NOCOPY VARCHAR2,
583 x_msg_count OUT NOCOPY NUMBER,
584 x_msg_data OUT NOCOPY VARCHAR2 ,
585 p_party_id IN NUMBER,
586 x_regnum_tbl OUT NOCOPY RegNum_tbl_type );
587
588
589 -- Start of comments
590 -- API name : Get_LegalEntity_LGER_BSV
591 -- Type : Group
592 -- Function :
593 -- Pre-reqs : None.
594 -- Parameters :
595 -- IN : p_api_version IN NUMBER Required
596 -- p_init_msg_list IN VARCHAR2 Optional
597 -- Default = FND_API.G_FALSE
598 -- p_commit IN VARCHAR2 Optional
599 -- Default = FND_API.G_FALSE
600 --
601 -- p_ledger_id IN NUMBER Required ,
602 -- p_bsv IN VARCHAR2 Required ,
603 --
604 --
605 -- OUT : x_return_status OUT VARCHAR2(1)
606 -- x_msg_count OUT NUMBER
607 -- x_msg_data OUT VARCHAR2(2000)
608 -- x_legal_entity_id OUT NUMBER,
609 -- x_legal_entity_name OUT VARCHAR2
610 --
611 -- Version : Current version 1.0
612 -- Changed....
613 -- previous version 1.0
614 -- Changed....
615 --
616 -- Initial version 1.0
617 --
618 -- Notes : Requesting Team : Legal Entity
619 --
620 -- End of comments
621 PROCEDURE Get_LegalEntity_LGER_BSV(
622 p_api_version IN NUMBER ,
623 p_init_msg_list IN VARCHAR2,
624 p_commit IN VARCHAR2,
625 x_return_status OUT NOCOPY VARCHAR2,
626 x_msg_count OUT NOCOPY NUMBER,
627 x_msg_data OUT NOCOPY VARCHAR2,
628 p_ledger_id IN NUMBER ,
629 p_bsv IN VARCHAR2,
630 x_legal_entity_id OUT NOCOPY NUMBER,
631 x_legal_entity_name OUT NOCOPY VARCHAR2);
632
633 Procedure Get_FP_VATRegistration_LEID(
634 p_api_version IN NUMBER,
635 p_init_msg_list IN VARCHAR2,
636 p_commit IN VARCHAR2,
637 p_effective_date IN zx_registrations.effective_from%Type,
638 x_return_status OUT NOCOPY VARCHAR2,
639 x_msg_count OUT NOCOPY NUMBER,
640 x_msg_data OUT NOCOPY VARCHAR2,
641 p_legal_entity_id IN NUMBER,
642 x_registration_number OUT NOCOPY VARCHAR2);
643
644 PROCEDURE Get_LE_Interface(
645 x_return_status OUT NOCOPY VARCHAR2,
646 x_msg_count OUT NOCOPY NUMBER,
647 x_msg_data OUT NOCOPY VARCHAR2,
648 P_INTERFACE_ATTRIBUTE IN VARCHAR2,
649 P_INTERFACE_VALUE IN VARCHAR2,
650 X_LEGAL_ENTITY_ID OUT NOCOPY XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE
651 );
652
653 function GET_DefaultLegalContext_OU(
654 p_operating_unit IN NUMBER )
655 RETURN NUMBER;
656
657 function Get_DLC_LE_OU RETURN VARCHAR2;
658
659 PROCEDURE IsLegalEntity_LEID(
660 x_return_status OUT NOCOPY VARCHAR2,
661 x_msg_data OUT NOCOPY VARCHAR2,
662 p_legal_entity_id IN NUMBER,
663 x_legal_entity OUT NOCOPY VARCHAR2
664 );
665
666 PROCEDURE Check_IC_Invoice_required(
667 x_return_status OUT NOCOPY VARCHAR2,
668 x_msg_data OUT NOCOPY VARCHAR2,
669 p_legal_entity_id IN NUMBER,
670 p_party_id IN NUMBER,
671 x_intercompany_inv OUT NOCOPY VARCHAR2);
672
673 END;