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.PNRX_SP_UTIL_BY_LEASE dependencies on PNP_UTIL_FUNC

Line 95: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

91: l_statement_3 VARCHAR2(10000);
92: l_rows_3 INTEGER;
93: l_count_3 INTEGER;
94:
95: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
96:
97: v_compare BOOLEAN;
98:
99:

Line 186: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),

182: fl1.meaning LOCATION_TYPE,
183: NVL(NVL(loc.building, loc.floor), loc.office) LOCATION_NAME,
184: loc.location_code LOCATION_CODE,
185: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
186: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
187: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,

Line 187: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),

183: NVL(NVL(loc.building, loc.floor), loc.office) LOCATION_NAME,
184: loc.location_code LOCATION_CODE,
185: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
186: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
187: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,

Line 188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),

184: loc.location_code LOCATION_CODE,
185: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
186: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
187: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

Line 189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),

185: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
186: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
187: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

Line 192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

188: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,

Line 193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

189: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,

Line 194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),

190: rentable_area) RENTABLE_AREA,
191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

Line 195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),

191: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
192: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
193: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

Line 198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

194: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,

Line 199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

195: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,

Line 200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),

196: usable_area) USABLE_AREA,
197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

Line 201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),

197: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
198: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
199: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

Line 204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

200: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,

Line 205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

201: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,

Line 206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),

202: assignable_area) ASSIGNABLE_AREA,
203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

Line 207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),

203: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
204: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
205: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

Line 210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

206: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,

Line 211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

207: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,

Line 212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),

208: common_area) COMMON_AREA,
209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

Line 213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),

209: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
210: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
211: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

Line 216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

212: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
218: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
219: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
220: optimum_capacity) OPTIMUM_OCCUPANCY,

Line 217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

213: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
218: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
219: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
220: optimum_capacity) OPTIMUM_OCCUPANCY,
221: fl.meaning USAGE_TYPE,

Line 218: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),

214: max_capacity) MAXIMUM_OCCUPANCY,
215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
218: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
219: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
220: optimum_capacity) OPTIMUM_OCCUPANCY,
221: fl.meaning USAGE_TYPE,
222: loc.attribute_category ATTRIBUTE_CATEGORY,

Line 219: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),

215: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
216: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
217: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
218: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
219: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
220: optimum_capacity) OPTIMUM_OCCUPANCY,
221: fl.meaning USAGE_TYPE,
222: loc.attribute_category ATTRIBUTE_CATEGORY,
223: loc.attribute1 ATTRIBUTE1,

Line 403: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);

399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);
402:
403: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
404: INSERT INTO pn_space_util_lease_itf
405: (LEASE_ID ,
406: LEASE_NAME ,
407: LEASE_NUMBER ,

Line 472: decode(SIGN(V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),

468: V_ASSIGNABLE_AREA ,
469: V_COMMON_AREA ,
470: V_MAXIMUM_OCCUPANCY ,
471: V_OPTIMUM_OCCUPANCY ,
472: decode(SIGN(V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
474: V_USAGE_TYPE ,
475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),

Line 473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),

469: V_COMMON_AREA ,
470: V_MAXIMUM_OCCUPANCY ,
471: V_OPTIMUM_OCCUPANCY ,
472: decode(SIGN(V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
474: V_USAGE_TYPE ,
475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
477: pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date),

Line 475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),

471: V_OPTIMUM_OCCUPANCY ,
472: decode(SIGN(V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
474: V_USAGE_TYPE ,
475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
477: pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date),
478: v_code_data.PROPERTY_CODE ,
479: v_code_data.PROPERTY_NAME ,

Line 476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),

472: decode(SIGN(V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_MAXIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
474: V_USAGE_TYPE ,
475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
477: pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date),
478: v_code_data.PROPERTY_CODE ,
479: v_code_data.PROPERTY_NAME ,
480: v_code_data.BUILDING_LOCATION_CODE ,

Line 477: pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date),

473: decode(SIGN(V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),-1,0,V_OPTIMUM_OCCUPANCY-pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date)),
474: V_USAGE_TYPE ,
475: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
476: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
477: pnp_util_func.get_utilized_capacity(V_LOCATION_ID, as_of_date),
478: v_code_data.PROPERTY_CODE ,
479: v_code_data.PROPERTY_NAME ,
480: v_code_data.BUILDING_LOCATION_CODE ,
481: v_code_data.BUILDING ,