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

Line 141: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

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

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

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,

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

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,

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

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),

Line 483: 'LAND',PNP_UTIL_FUNC.get_building_rentable_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),

Line 486: 'FLOOR',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,

Line 487: 'PARCEL',PNP_UTIL_FUNC.get_floor_usable_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,
491: loc.gross_area GROSS_AREA,

Line 488: 'BUILDING',PNP_UTIL_FUNC.get_building_usable_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,
492: fnd.meaning TENURE

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

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,

Line 579: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OPTION_COMM_DATE);

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 ,