APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_ENTITY_PROFILES

Line 10: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

6: PROCEDURE Get_BusinessGroup_Info(
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
11: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,
12: p_businessgroup_id IN hr_operating_units.business_group_id%type,
13: x_businessgroup_info OUT NOCOPY BG_LE_Tbl_Type
14: )

Line 11: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,

7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
11: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,
12: p_businessgroup_id IN hr_operating_units.business_group_id%type,
13: x_businessgroup_info OUT NOCOPY BG_LE_Tbl_Type
14: )
15: IS

Line 32: xle_entity_profiles xlep

28: cursor business_c is
29: select xlep.legal_entity_id,
30: xlep.party_id
31: from hr_legal_entities hrle,
32: xle_entity_profiles xlep
33: where business_group_id = l_business_group_id
34: and xlep.legal_entity_id = hrle.organization_id;
35:
36: BEGIN

Line 70: from xle_entity_profiles

66: Legal Entity ID match. Else return with error message; */
67: BEGIN
68: select legal_entity_id
69: into l_legal_entity_id
70: from xle_entity_profiles
71: where party_id = p_party_id;
72:
73: EXCEPTION
74: when no_data_found then

Line 93: from xle_entity_profiles

89:
90: BEGIN
91: select party_id
92: into l_party_id
93: from xle_entity_profiles
94: where legal_entity_id = l_legal_entity_id;
95:
96: EXCEPTION
97: when no_data_found then

Line 478: from xle_entity_profiles

474:
475: begin
476: select party_id
477: into l_party_id
478: from xle_entity_profiles
479: where legal_entity_id = p_LegalEntity_ID;
480: exception
481: when no_data_found then
482: x_msg_data := 'Legal Entity ID is invalid';

Line 497: from xle_entity_profiles

493:
494: BEGIN
495: select legal_entity_id
496: into l_legal_entity_id
497: from xle_entity_profiles
498: where party_id = p_party_id;
499:
500: exception
501: when no_data_found then

Line 766: from xle_entity_profiles

762:
763: BEGIN
764: select legal_entity_id
765: into l_legal_entity_id
766: from xle_entity_profiles
767: where party_id = p_party_id;
768:
769: EXCEPTION
770: when no_data_found then

Line 787: from xle_entity_profiles

783:
784: if p_legal_entity_id is null then
785: select legal_entity_id
786: into l_legal_entity_id
787: from xle_entity_profiles
788: where party_id = p_party_id;
789: else
790: l_legal_entity_id := p_legal_entity_id;
791: end if;

Line 939: from xle_entity_profiles

935: Else return with error message; */
936: BEGIN
937: select legal_entity_id
938: into l_le_id
939: from xle_entity_profiles
940: where party_id = p_party_id;
941:
942: EXCEPTION
943: when no_data_found then

Line 963: from xle_entity_profiles

959:
960: BEGIN
961: select party_id
962: into l_party_id
963: from xle_entity_profiles
964: where legal_entity_id = l_le_id;
965:
966:
967: EXCEPTION

Line 1322: TYPE l_le_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE INDEX BY BINARY_INTEGER;

1318: x_le_flag BOOLEAN :=FALSE;
1319: l_le_id NUMBER(15);
1320: l_registration_code VARCHAR2(10);
1321: l_le_info XLE_UTILITIES_GRP.LegalEntity_Rec;
1322: TYPE l_le_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE INDEX BY BINARY_INTEGER;
1323: l_le_tbl l_le_tbl_type;
1324:
1325: l_ccid_le_info XLE_BUSINESSINFO_GRP.ccid_le_Rec_Type;
1326:

Line 1388: from XLE_ENTITY_PROFILES ent,

1384: BEGIN
1385:
1386: select ent.legal_entity_id
1387: into l_le_id
1388: from XLE_ENTITY_PROFILES ent,
1389: XLE_REGISTRATIONS reg,
1390: XLE_JURISDICTIONS_B jur
1391: where reg.REGISTRATION_NUMBER = P_REGISTRATION_NUMBER
1392: and REG.jurisdiction_id = jur.jurisdiction_id