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_REGISTRATIONS

Line 6: -- TYPE RegNum_tbl_type IS TABLE OF XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

Line 9: registration_number XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

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:

Line 85: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

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,

Line 86: REGISTERED_NAME XLE_REGISTRATIONS.registered_name%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,

Line 87: ALTERNATE_REGISTERED_NAME XLE_REGISTRATIONS.alternate_registered_name%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),

Line 88: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%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,

Line 92: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%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,

Line 93: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%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,

Line 94: LOCATION_ID XLE_REGISTRATIONS.location_id%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,

Line 120: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%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,

Line 121: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%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,

Line 123: EFFECTIVE_FROM XLE_REGISTRATIONS.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,

Line 124: EFFECTIVE_TO XLE_REGISTRATIONS.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,

Line 125: LOCATION_ID XLE_REGISTRATIONS.location_id%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,

Line 150: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%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,

Line 151: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%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,

Line 153: EFFECTIVE_FROM XLE_REGISTRATIONS.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,

Line 154: EFFECTIVE_TO XLE_REGISTRATIONS.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,

Line 155: LOCATION_ID XLE_REGISTRATIONS.location_id%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,