eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLE_UTILITIES_GRP dependencies on XLE_ENTITY_PROFILES

Line 30: TYPE LegalEntity_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.legal_entity_id%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,

Line 81: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

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,

Line 82: ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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,

Line 83: ENTITY_NAME XLE_ENTITY_PROFILES.NAME%TYPE,

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,

Line 113: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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,

Line 140: LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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,

Line 141: NAME XLE_ENTITY_PROFILES.NAME%TYPE,

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,

Line 142: PARTY_ID XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

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,

Line 143: LEGAL_ENTITY_IDENTIFIER XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER%TYPE,

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,

Line 144: TRANSACTING_ENTITY_FLAG XLE_ENTITY_PROFILES.TRANSACTING_ENTITY_FLAG%TYPE,

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,

Line 145: ACTIVITY_CODE XLE_ENTITY_PROFILES.ACTIVITY_CODE%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,

Line 146: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%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,

Line 147: type_of_company XLE_ENTITY_PROFILES.type_of_company%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,

Line 148: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%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,

Line 149: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%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,

Line 173: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

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,

Line 174: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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);

Line 185: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

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);

Line 187: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

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(

Line 195: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

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:

Line 196: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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(

Line 204: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

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:

Line 650: X_LEGAL_ENTITY_ID OUT NOCOPY XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE

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 )