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

Line 158: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

154:
155:
156:
157: --declare the record type for the function here.........
158: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
159: -- declare cursors.....
160: CURSOR pterm (V_LEASE_ID IN NUMBER) IS
161: SELECT payment_term_id,start_date,END_date,payment_term_type_code,vENDor_id,vENDor_site_id,
162: customer_id, customer_site_use_id

Line 546: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),

542: pa.province PROVINCE,
543: pa.zip_code ZIP_CODE,
544: pa.country COUNTRY,
545: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
546: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
547: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,

Line 547: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),

543: pa.zip_code ZIP_CODE,
544: pa.country COUNTRY,
545: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
546: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
547: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,

Line 548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),

544: pa.country COUNTRY,
545: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
546: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
547: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),

Line 549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),

545: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
546: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
547: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),

Line 552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),

548: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
554: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
555: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
556: usable_area) USABLE_AREA,

Line 553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),

549: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
554: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
555: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
556: usable_area) USABLE_AREA,
557: loc.gross_area GROSS_AREA,

Line 554: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),

550: rentable_area) RENTABLE_AREA,
551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
554: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
555: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
556: usable_area) USABLE_AREA,
557: loc.gross_area GROSS_AREA,
558: fnd.meaning TENURE

Line 555: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),

551: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
552: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
553: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
554: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
555: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
556: usable_area) USABLE_AREA,
557: loc.gross_area GROSS_AREA,
558: fnd.meaning TENURE
559: FROM pn_locations_all loc,

Line 726: v_code_data :=pnp_util_func.get_location_name(V_LOCATION_ID, V_ACTIVE_START_DATE);

722: ELSE
723: V_ANNUAL_RENT_PER_RENT_AREA := NULL;
724: END IF;
725:
726: v_code_data :=pnp_util_func.get_location_name(V_LOCATION_ID, V_ACTIVE_START_DATE);
727: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(-)');
728: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(+)');
729:
730: