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

Line 115: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

111: l_lease_termination_from DATE;
112: l_lease_termination_to DATE;
113: l_milestone_type VARCHAR2(30);
114: --declare the record type for the function here.........
115: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
116: -- declare cursors.....
117: BEGIN
118: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditiond(+)');
119: --Initialise status parameters...

Line 176: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),

172: pa.province PROVINCE,
173: pa.zip_code ZIP_CODE,
174: pa.country COUNTRY,
175: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.rentable_area,
176: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
177: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,

Line 177: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),

173: pa.zip_code ZIP_CODE,
174: pa.country COUNTRY,
175: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.rentable_area,
176: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
177: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,

Line 178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),

174: pa.country COUNTRY,
175: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.rentable_area,
176: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
177: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),

Line 179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),

175: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.rentable_area,
176: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
177: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_rentable_area(loc.location_id),
178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),

Line 182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),

178: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
184: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
185: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
186: usable_area) USABLE_AREA,

Line 183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),

179: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_rentable_area(loc.location_id),
180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
184: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
185: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
186: usable_area) USABLE_AREA,
187: loc.gross_area GROSS_AREA,

Line 184: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),

180: rentable_area) RENTABLE_AREA,
181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
184: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
185: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
186: usable_area) USABLE_AREA,
187: loc.gross_area GROSS_AREA,
188: fnd2.meaning TENURE,

Line 185: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),

181: DECODE (location_type_lookup_code,'||''''||'OFFICE'||''''||',loc.usable_area,
182: '||''''||'FLOOR'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
183: '||''''||'PARCEL'||''''||',PNP_UTIL_FUNC.get_floor_usable_area(loc.location_id),
184: '||''''||'BUILDING'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
185: '||''''||'LAND'||''''||',PNP_UTIL_FUNC.get_building_usable_area(loc.location_id),
186: usable_area) USABLE_AREA,
187: loc.gross_area GROSS_AREA,
188: fnd2.meaning TENURE,
189: mil.lease_milestone_id LEASE_MILESTONE_ID,

Line 546: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OCCUPANCY_DATE);

542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);
545:
546: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OCCUPANCY_DATE);
547:
548: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_les: insert(+)');
549:
550: INSERT INTO pn_milestones_itf