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.PN_LEASE_PVT dependencies on PN_TENANCIES_PKG

Line 289: pn_tenancies_pkg.create_auto_space_assign

285:
286: IF l_create_space_assign = 'Y' THEN
287:
288: pvt_debug(g_pkg_name||'-Calling create_auto_space_assign Begin',3);
289: pn_tenancies_pkg.create_auto_space_assign
290: (
291: p_location_id => p_lease_tenancies_rec.location_id
292: ,p_lease_id => p_lease_tenancies_rec.lease_id
293: ,p_customer_id => p_lease_tenancies_rec.customer_id

Line 387: pn_tenancies_pkg.update_auto_space_assign

383: END IF;
384:
385: pvt_debug(g_pkg_name||'-Calling Update_auto_space_assign Begin',3);
386:
387: pn_tenancies_pkg.update_auto_space_assign
388: (
389: p_location_id => p_lease_tenancies_rec.location_id
390: ,p_lease_id => p_lease_tenancies_rec.lease_id
391: ,p_customer_id => p_lease_tenancies_rec.customer_id

Line 1319: pn_tenancies_pkg.get_loc_info(p_lease_tenancies_rec.location_id,

1315: ,'N');
1316:
1317: IF l_automatic_distrubution = 'N' AND (l_mutiple_lease <> 'N' OR l_overlap_tenancy <>'N') THEN
1318:
1319: pn_tenancies_pkg.get_loc_info(p_lease_tenancies_rec.location_id,
1320: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
1321: p_lease_tenancies_rec.expiration_date,
1322: l_loc_code);
1323:

Line 1324: pn_tenancies_pkg.get_allocated_area(NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),

1320: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
1321: p_lease_tenancies_rec.expiration_date,
1322: l_loc_code);
1323:
1324: pn_tenancies_pkg.get_allocated_area(NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
1325: p_lease_tenancies_rec.expiration_date,
1326: p_lease_tenancies_rec.allocated_area_pct,
1327: l_loc_area
1328: );

Line 1330: pn_tenancies_pkg.Availaible_Space (p_lease_tenancies_rec.location_id,

1326: p_lease_tenancies_rec.allocated_area_pct,
1327: l_loc_area
1328: );
1329:
1330: pn_tenancies_pkg.Availaible_Space (p_lease_tenancies_rec.location_id,
1331: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
1332: p_lease_tenancies_rec.expiration_date,
1333: l_min_pct);
1334:

Line 1362: pn_tenancies_pkg.update_row

1358: OPEN c_loc(p_lease_tenancies_rec.tenancy_id);
1359: FETCH c_loc into c_loc_rec;
1360: CLOSE c_loc;
1361:
1362: pn_tenancies_pkg.update_row
1363: (x_tenancy_id => p_lease_tenancies_rec.tenancy_id
1364: , x_location_id => p_lease_tenancies_rec.location_id
1365: , x_lease_id => p_lease_id
1366: , x_lease_change_id => p_lease_tenancies_rec.lease_change_id

Line 2993: pn_tenancies_pkg.get_loc_info(

2989: p_lease_tenancies_rec.allocated_area_pct:=100;
2990: END IF;
2991:
2992: IF l_automatic_distrubution = 'N' AND (l_mutiple_lease <> 'N' OR l_overlap_tenancy <>'N') THEN
2993: pn_tenancies_pkg.get_loc_info(
2994: p_lease_tenancies_rec.location_id,
2995: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
2996: p_lease_tenancies_rec.expiration_date,
2997: l_loc_code);

Line 2999: pn_tenancies_pkg.get_allocated_area(

2995: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
2996: p_lease_tenancies_rec.expiration_date,
2997: l_loc_code);
2998:
2999: pn_tenancies_pkg.get_allocated_area(
3000: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
3001: p_lease_tenancies_rec.expiration_date,
3002: p_lease_tenancies_rec.allocated_area_pct,
3003: l_loc_area

Line 3006: pn_tenancies_pkg.Availaible_Space

3002: p_lease_tenancies_rec.allocated_area_pct,
3003: l_loc_area
3004: );
3005:
3006: pn_tenancies_pkg.Availaible_Space
3007: (
3008: p_lease_tenancies_rec.location_id,
3009: NVL(p_lease_tenancies_rec.occupancy_date,p_lease_tenancies_rec.estimated_occupancy_date),
3010: p_lease_tenancies_rec.expiration_date,

Line 3053: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );

3049: );
3050: p_lease_tenancies_rec.lease_id := p_lease_rec.lease_id;
3051: p_lease_tenancies_rec.lease_change_id := p_lease_rec.lease_id;
3052:
3053: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );
3054: ------------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );
3055: pn_tenancies_pkg.insert_row
3056: (x_rowid => l_rowid
3057: , x_tenancy_id => p_lease_tenancies_rec.tenancy_id

Line 3054: ------------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );

3050: p_lease_tenancies_rec.lease_id := p_lease_rec.lease_id;
3051: p_lease_tenancies_rec.lease_change_id := p_lease_rec.lease_id;
3052:
3053: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );
3054: ------------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );
3055: pn_tenancies_pkg.insert_row
3056: (x_rowid => l_rowid
3057: , x_tenancy_id => p_lease_tenancies_rec.tenancy_id
3058: , x_location_id => p_lease_tenancies_rec.location_id

Line 3055: pn_tenancies_pkg.insert_row

3051: p_lease_tenancies_rec.lease_change_id := p_lease_rec.lease_id;
3052:
3053: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );
3054: ------------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id BEFORE CALLING pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );
3055: pn_tenancies_pkg.insert_row
3056: (x_rowid => l_rowid
3057: , x_tenancy_id => p_lease_tenancies_rec.tenancy_id
3058: , x_location_id => p_lease_tenancies_rec.location_id
3059: , x_lease_id => p_lease_tenancies_rec.lease_id

Line 3111: -- --------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );--Rupak

3107: , x_location_load_factor => p_lease_tenancies_rec.location_load_factor
3108: );
3109: pvt_debug(g_pkg_name||'- INSERT_TENANCIES_ROW:Insertion into tenancies table successful',3);
3110:
3111: -- --------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );--Rupak
3112: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );--Rupak
3113: EXCEPTION
3114: WHEN OTHERS
3115: THEN

Line 3112: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );--Rupak

3108: );
3109: pvt_debug(g_pkg_name||'- INSERT_TENANCIES_ROW:Insertion into tenancies table successful',3);
3110:
3111: -- --------------------dbms_output.put_line('p_lease_tenancies_rec.lease_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_id );--Rupak
3112: ----------------------dbms_output.put_line('p_lease_tenancies_rec.lease_change_id after pn_tenancies_pkg.insert_row: '||p_lease_tenancies_rec.lease_change_id );--Rupak
3113: EXCEPTION
3114: WHEN OTHERS
3115: THEN
3116: NULL;