APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_ENTITY_PROFILES

Line 7: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

3:
4:
5: TYPE BG_LE_Rec IS RECORD (
6: Business_group_id HR_OPERATING_UNITS.business_group_id%TYPE,
7: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
8: PARTY_ID XLE_ENTITY_PROFILES.party_id%TYPE
9: );
10:
11:

Line 8: PARTY_ID XLE_ENTITY_PROFILES.party_id%TYPE

4:
5: TYPE BG_LE_Rec IS RECORD (
6: Business_group_id HR_OPERATING_UNITS.business_group_id%TYPE,
7: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
8: PARTY_ID XLE_ENTITY_PROFILES.party_id%TYPE
9: );
10:
11:
12: TYPE BG_LE_Tbl_Type IS TABLE OF BG_LE_Rec INDEX BY BINARY_INTEGER;

Line 19: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

15: PROCEDURE Get_BusinessGroup_Info(
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
20: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,
21: p_businessgroup_id IN hr_operating_units.business_group_id%type,
22: x_businessgroup_info OUT NOCOPY BG_LE_Tbl_Type
23: );

Line 20: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,

16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
20: P_party_id IN XLE_ENTITY_PROFILES.party_id%TYPE,
21: p_businessgroup_id IN hr_operating_units.business_group_id%type,
22: x_businessgroup_info OUT NOCOPY BG_LE_Tbl_Type
23: );
24:

Line 30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

26:
27: TYPE LE_Ledger_Rec IS RECORD (
28: Ledger_ID gl_ledgers.ledger_id%TYPE,
29: bal_seg_value gl_ledger_norm_seg_vals.segment_value%type,
30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

27: TYPE LE_Ledger_Rec IS RECORD (
28: Ledger_ID gl_ledgers.ledger_id%TYPE,
29: bal_seg_value gl_ledger_norm_seg_vals.segment_value%type,
30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

28: Ledger_ID gl_ledgers.ledger_id%TYPE,
29: bal_seg_value gl_ledger_norm_seg_vals.segment_value%type,
30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

29: bal_seg_value gl_ledger_norm_seg_vals.segment_value%type,
30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

30: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

31: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

32: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

33: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

34: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

35: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

56: TYPE LE_Ledger_Rec_Type IS TABLE OF LE_Ledger_Rec INDEX BY BINARY_INTEGER;
57:
58: TYPE inv_org_Rec IS RECORD (
59: Inv_org_id org_organization_definitions.organization_id%type,
60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

57:
58: TYPE inv_org_Rec IS RECORD (
59: Inv_org_id org_organization_definitions.organization_id%type,
60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

58: TYPE inv_org_Rec IS RECORD (
59: Inv_org_id org_organization_definitions.organization_id%type,
60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

59: Inv_org_id org_organization_definitions.organization_id%type,
60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

60: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

61: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

62: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

63: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

64: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

65: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

87:
88:
89: TYPE OU_LE_Rec IS RECORD (
90: Operating_Unit_ID NUMBER,
91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

88:
89: TYPE OU_LE_Rec IS RECORD (
90: Operating_Unit_ID NUMBER,
91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

89: TYPE OU_LE_Rec IS RECORD (
90: Operating_Unit_ID NUMBER,
91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

90: Operating_Unit_ID NUMBER,
91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

91: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

92: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

93: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

94: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

95: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

96: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

168:
169: TYPE ccid_le_Rec IS RECORD (
170: Ledger_ID gl_ledgers.ledger_id%TYPE,
171: ccid gl_code_combinations.code_combination_id%type,
172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

169: TYPE ccid_le_Rec IS RECORD (
170: Ledger_ID gl_ledgers.ledger_id%TYPE,
171: ccid gl_code_combinations.code_combination_id%type,
172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

170: Ledger_ID gl_ledgers.ledger_id%TYPE,
171: ccid gl_code_combinations.code_combination_id%type,
172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

171: ccid gl_code_combinations.code_combination_id%type,
172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

172: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

173: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

174: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

175: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

176: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

177: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

225: x_ccid_le_info OUT NOCOPY XLE_BUSINESSINFO_GRP.ccid_le_Rec_Type
226: ) ;
227:
228: TYPE ptop_le_Rec IS RECORD (
229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

226: ) ;
227:
228: TYPE ptop_le_Rec IS RECORD (
229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

227:
228: TYPE ptop_le_Rec IS RECORD (
229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

228: TYPE ptop_le_Rec IS RECORD (
229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

229: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

230: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

231: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

232: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

233: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

234: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

261: P_operating_unit_id IN NUMBER,
262: x_ptop_Le_info OUT NOCOPY XLE_BUSINESSINFO_GRP.ptop_le_rec);
263:
264: TYPE otoc_le_rec IS RECORD (
265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

Line 266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

262: x_ptop_Le_info OUT NOCOPY XLE_BUSINESSINFO_GRP.ptop_le_rec);
263:
264: TYPE otoc_le_rec IS RECORD (
265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

Line 267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

263:
264: TYPE otoc_le_rec IS RECORD (
265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

Line 268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

264: TYPE otoc_le_rec IS RECORD (
265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

Line 269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

265: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

Line 270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,

266: NAME XLE_ENTITY_PROFILES.NAME%TYPE,
267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

Line 271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,

267: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

Line 272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,

268: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,
269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

Line 273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,

269: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,
270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

Line 274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,

270: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%TYPE,
271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,