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_ETB_PROFILES

Line 110: ESTABLISHMENT_ID XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,

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,

Line 111: ESTABLISHMENT_NAME XLE_ETB_PROFILES.NAME%TYPE,

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,

Line 112: PARTY_ID XLE_ETB_PROFILES.PARTY_ID%TYPE,

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,

Line 114: MAIN_ESTABLISHMENT_FLAG XLE_ETB_PROFILES.MAIN_ESTABLISHMENT_FLAG%TYPE,

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,

Line 115: ACTIVITY_CODE XLE_ETB_PROFILES.ACTIVITY_CODE%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,

Line 116: sub_activity_code XLE_ETB_PROFILES.SUB_ACTIVITY_CODE%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,

Line 117: type_of_company XLE_ETB_PROFILES.type_of_company%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,

Line 118: ETB_EFFECTIVE_FROM XLE_ETB_PROFILES.EFFECTIVE_FROM%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,

Line 119: ETB_EFFECTIVE_TO XLE_ETB_PROFILES.EFFECTIVE_TO%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,

Line 186: P_ESTABLISHMENT_ID IN XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,

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: