137:
138:
139:
140: --declare the record type for the function here.........
141: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
142: -- declare cursors.....
143: CURSOR pterm (V_LEASE_ID IN NUMBER) IS
144: SELECT payment_term_id,start_date,end_date,payment_term_type_code,vendor_id,
145: vendor_site_id, customer_id, customer_site_use_id
476: pa.province PROVINCE,
477: pa.zip_code ZIP_CODE,
478: pa.country COUNTRY,
479: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
480: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
481: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
482: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
477: pa.zip_code ZIP_CODE,
478: pa.country COUNTRY,
479: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
480: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
481: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
482: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
478: pa.country COUNTRY,
479: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
480: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
481: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
482: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
479: DECODE (location_type_lookup_code,'OFFICE',loc.rentable_area,
480: 'FLOOR',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
481: 'PARCEL',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id, loc.active_start_date),
482: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
482: 'BUILDING',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
488: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
489: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
490: usable_area) USABLE_AREA,
483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id, loc.active_start_date),
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
488: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
489: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
490: usable_area) USABLE_AREA,
491: loc.gross_area GROSS_AREA,
484: rentable_area) RENTABLE_AREA,
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
488: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
489: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
490: usable_area) USABLE_AREA,
491: loc.gross_area GROSS_AREA,
492: fnd.meaning TENURE
485: DECODE (location_type_lookup_code,'OFFICE',loc.usable_area,
486: 'FLOOR',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id, loc.active_start_date),
488: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
489: 'LAND',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id, loc.active_start_date),
490: usable_area) USABLE_AREA,
491: loc.gross_area GROSS_AREA,
492: fnd.meaning TENURE
493: FROM pn_locations_all loc,
575: FETCH c_currency_pn into V_OPTION_CURRENCY;
576: EXIT WHEN c_currency_pn%notfound;
577: END LOOP;
578:
579: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OPTION_COMM_DATE);
580:
581: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_inserting(+)');
582: INSERT INTO pn_lease_options_itf
583: (LEASE_ID ,