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_LOC dependencies on PNP_UTIL_FUNC

Line 78: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

74: V_CREATION_DATE DATE;
75: V_CREATED_BY NUMBER(15);
76: V_REQUEST_ID NUMBER;
77: l_found VARCHAR2(1);
78: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
79: v_compare BOOLEAN;
80: l_cursor INTEGER;
81: l_statement VARCHAR2(10000);
82: l_rows INTEGER;

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

240: fl1.meaning LOCATION_TYPE,
241: NVL(NVL(loc.building, loc.floor), loc.office) LOCATION_NAME,
242: loc.location_code LOCATION_CODE,
243: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
244: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
245: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
246: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,

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

241: NVL(NVL(loc.building, loc.floor), loc.office) LOCATION_NAME,
242: loc.location_code LOCATION_CODE,
243: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
244: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
245: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
246: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,

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

242: loc.location_code LOCATION_CODE,
243: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
244: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
245: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
246: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

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

243: DECODE (location_type_lookup_code,''OFFICE'',loc.rentable_area,
244: ''FLOOR'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
245: ''PARCEL'',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id,:l_as_of_date),
246: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
251: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),

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

246: ''BUILDING'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
251: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
252: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,

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

247: ''LAND'',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id,:l_as_of_date),
248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
251: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
252: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,

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

248: rentable_area) RENTABLE_AREA,
249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
251: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
252: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

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

249: DECODE (location_type_lookup_code,''OFFICE'',loc.usable_area,
250: ''FLOOR'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
251: ''PARCEL'',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id,:l_as_of_date),
252: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
257: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),

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

252: ''BUILDING'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
257: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
258: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,

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

253: ''LAND'',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id,:l_as_of_date),
254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
257: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
258: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,

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

254: usable_area) USABLE_AREA,
255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
257: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
258: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

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

255: DECODE (location_type_lookup_code,''OFFICE'',loc.assignable_area,
256: ''FLOOR'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
257: ''PARCEL'',PNP_UTIL_FUNC.get_floor_assignable_area(loc.location_id,:l_as_of_date),
258: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
263: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),

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

258: ''BUILDING'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
263: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
264: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,

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

259: ''LAND'',PNP_UTIL_FUNC.get_building_assignable_area(loc.location_id,:l_as_of_date),
260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
263: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
264: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,

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

260: assignable_area) ASSIGNABLE_AREA,
261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
263: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
264: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

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

261: DECODE (location_type_lookup_code,''OFFICE'',loc.common_area,
262: ''FLOOR'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
263: ''PARCEL'',PNP_UTIL_FUNC.get_floor_common_area(loc.location_id,:l_as_of_date),
264: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
269: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),

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

264: ''BUILDING'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
269: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
270: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,

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

265: ''LAND'',PNP_UTIL_FUNC.get_building_common_area(loc.location_id,:l_as_of_date),
266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
269: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
270: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,

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

266: common_area) COMMON_AREA,
267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
269: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
270: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

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

267: DECODE (location_type_lookup_code,''OFFICE'',loc.max_capacity,
268: ''FLOOR'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
269: ''PARCEL'',PNP_UTIL_FUNC.get_floor_max_capacity(loc.location_id,:l_as_of_date),
270: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
275: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),

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

270: ''BUILDING'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
275: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
276: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
277: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
278: optimum_capacity) OPTIMUM_OCCUPANCY,

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

271: ''LAND'',PNP_UTIL_FUNC.get_building_max_capacity(loc.location_id,:l_as_of_date),
272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
275: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
276: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
277: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
278: optimum_capacity) OPTIMUM_OCCUPANCY,
279: fl.meaning USAGE_TYPE,

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

272: max_capacity) MAXIMUM_OCCUPANCY,
273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
275: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
276: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
277: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
278: optimum_capacity) OPTIMUM_OCCUPANCY,
279: fl.meaning USAGE_TYPE,
280: loc.attribute_category ATTRIBUTE_CATEGORY,

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

273: DECODE (location_type_lookup_code,''OFFICE'',loc.optimum_capacity,
274: ''FLOOR'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
275: ''PARCEL'',PNP_UTIL_FUNC.get_floor_optimum_capacity(loc.location_id,:l_as_of_date),
276: ''BUILDING'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
277: ''LAND'',PNP_UTIL_FUNC.get_building_optimum_capacity(loc.location_id,:l_as_of_date),
278: optimum_capacity) OPTIMUM_OCCUPANCY,
279: fl.meaning USAGE_TYPE,
280: loc.attribute_category ATTRIBUTE_CATEGORY,
281: loc.attribute1 ATTRIBUTE1,

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

395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:
398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');
399: v_code_data := pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
400:
401: /* Before inserting, check to see whether the record already exists in the table */
402:
403: l_found := 'N';

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

465: V_COMMON_AREA ,
466: V_MAXIMUM_OCCUPANCY ,
467: V_OPTIMUM_OCCUPANCY ,
468: V_USAGE_TYPE ,
469: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
470: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
471: pnp_util_func.get_utilized_capacity(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)),

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

466: V_MAXIMUM_OCCUPANCY ,
467: V_OPTIMUM_OCCUPANCY ,
468: V_USAGE_TYPE ,
469: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
470: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
471: pnp_util_func.get_utilized_capacity(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_code_data.PROPERTY_CODE ,

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

467: V_OPTIMUM_OCCUPANCY ,
468: V_USAGE_TYPE ,
469: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
470: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
471: pnp_util_func.get_utilized_capacity(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_code_data.PROPERTY_CODE ,
475: v_code_data.PROPERTY_NAME ,

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_USAGE_TYPE ,
469: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
470: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
471: pnp_util_func.get_utilized_capacity(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_code_data.PROPERTY_CODE ,
475: v_code_data.PROPERTY_NAME ,
476: v_code_data.BUILDING_LOCATION_CODE ,

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: pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
470: V_ASSIGNABLE_AREA-pnp_util_func.get_vacant_area(V_LOCATION_ID, as_of_date),
471: pnp_util_func.get_utilized_capacity(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_code_data.PROPERTY_CODE ,
475: v_code_data.PROPERTY_NAME ,
476: v_code_data.BUILDING_LOCATION_CODE ,
477: v_code_data.BUILDING ,