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_TENANCIES_PKG dependencies on PN_TENANCIES_PKG

Line 1: PACKAGE BODY pn_tenancies_pkg AS

1: PACKAGE BODY pn_tenancies_pkg AS
2: -- $Header: PNTTENTB.pls 120.9 2007/07/06 07:34:05 rdonthul ship $
3:
4: TYPE loc_info_rec IS
5: RECORD (active_start_date pn_locations.active_start_date%TYPE,

Line 39: -- pn_tenancies_pkg.check_unique_primary_location.

35: -- HISTORY :
36: -- 11-SEP-02 STripathi o If returnStatus = 'W', return parameter
37: -- x_tenancy_ovelap_wrn 'Y' for Multi-Tenancy-Lease changes.
38: -- 16-JAN-02 PSidhu o bug#2730279 - Removed call to
39: -- pn_tenancies_pkg.check_unique_primary_location.
40: -- 04-DEC-04 ftanudja o Added 8 parameters for lease rentable area. 3257508.
41: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_tenancies with _ALL table.
42: -- 28-NOV-05 pikhar o fetched org_id using cursor
43: -------------------------------------------------------------------------------

Line 118: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_ROW (+)');

114:
115:
116: BEGIN
117:
118: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_ROW (+)');
119:
120:
121: IF x_org_id IS NULL THEN
122: FOR rec IN org_cur LOOP

Line 135: PN_TENANCIES_PKG.CHECK_TENANCY_DATES

131: ---------------------------------------------------
132: -- Check tenancy dates
133: ---------------------------------------------------
134: l_returnStatus := NULL;
135: PN_TENANCIES_PKG.CHECK_TENANCY_DATES
136: (
137: l_returnStatus
138: ,X_ESTIMATED_OCCUPANCY_DATE
139: ,X_OCCUPANCY_DATE

Line 150: PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY

146: ---------------------------------------------------
147: -- Check IF the tenancy dates overlap
148: ---------------------------------------------------
149: l_returnStatus := NULL;
150: PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY
151: (
152: l_returnStatus
153: ,X_TENANCY_ID
154: ,X_LOCATION_ID

Line 294: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_ROW (-)');

290: RAISE NO_DATA_FOUND;
291: END IF;
292: CLOSE c;
293:
294: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_ROW (-)');
295:
296: END Insert_Row;
297:
298: -------------------------------------------------------------------------------

Line 360: pnp_debug_pkg.debug('PN_TENANCIES_PKG.LOCK_ROW (+)');

356:
357: tlinfo c1%ROWTYPE;
358:
359: BEGIN
360: pnp_debug_pkg.debug('PN_TENANCIES_PKG.LOCK_ROW (+)');
361:
362: OPEN c1;
363: FETCH c1 INTO tlinfo;
364: IF (c1%NOTFOUND) THEN

Line 554: pnp_debug_pkg.debug('PN_TENANCIES_PKG.LOCK_ROW (-)');

550: OR ((tlinfo.LEASE_LOAD_FACTOR IS NULL) AND (X_LEASE_LOAD_FACTOR IS NULL))) THEN
551: pn_var_rent_pkg.lock_row_exception('LEASE_LOAD_FACTOR',tlinfo.LEASE_LOAD_FACTOR);
552: END IF;
553:
554: pnp_debug_pkg.debug('PN_TENANCIES_PKG.LOCK_ROW (-)');
555:
556: END Lock_Row;
557:
558: -------------------------------------------------------------------------------

Line 566: -- pn_tenancies_pkg.check_unique_primary_location.

562: -- HISTORY :
563: -- 11-SEP-02 STripathi o If returnStatus = 'W', return parameter
564: -- x_tenancy_ovelap_wrn 'Y' for Multi-Tenancy-Lease changes.
565: -- 16-JAN-02 Pooja Sidhu o bug#2730279 - Removed call to
566: -- pn_tenancies_pkg.check_unique_primary_location.
567: -- 04-DEC-04 ftanudja o Added 8 parameters for lease rentable area. 3257508.
568: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_tenancies with _ALL table.
569: -------------------------------------------------------------------------------
570: PROCEDURE Update_Row

Line 634: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_ROW (+)');

630: l_leaseStatus VARCHAR2(30) := NULL;
631: l_returnStatus VARCHAR2(30) := NULL;
632: BEGIN
633:
634: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_ROW (+)');
635:
636: x_tenancy_ovelap_wrn := NULL;
637:
638: ---------------------------------------------------

Line 642: PN_TENANCIES_PKG.CHECK_TENANCY_DATES

638: ---------------------------------------------------
639: -- Check tenancy dates
640: ---------------------------------------------------
641: l_returnStatus := NULL;
642: PN_TENANCIES_PKG.CHECK_TENANCY_DATES
643: (
644: l_returnStatus
645: ,X_ESTIMATED_OCCUPANCY_DATE
646: ,X_OCCUPANCY_DATE

Line 657: PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY

653: ---------------------------------------------------
654: -- Check IF the tenancy dates overlap
655: ---------------------------------------------------
656: l_returnStatus := NULL;
657: PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY
658: (
659: l_returnStatus
660: ,X_TENANCY_ID
661: ,X_LOCATION_ID

Line 854: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_ROW (-)');

850: IF (SQL%NOTFOUND) THEN
851: RAISE NO_DATA_FOUND;
852: END IF;
853:
854: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_ROW (-)');
855: END Update_Row;
856:
857: -------------------------------------------------------------------------------
858: -- PROCDURE : Delete_Row

Line 869: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_ROW (+)');

865: X_TENANCY_ID IN NUMBER
866: )
867: IS
868: BEGIN
869: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_ROW (+)');
870:
871: DELETE FROM pn_tenancies_all
872: WHERE tenancy_id = x_tenancy_id;
873:

Line 878: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_ROW (-)');

874: IF (SQL%NOTFOUND) THEN
875: RAISE NO_DATA_FOUND;
876: END IF;
877:
878: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_ROW (-)');
879: END Delete_Row;
880:
881:
882: -------------------------------------------------------------------------------

Line 896: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_UNIQUE_PRIMARY_LOCATION (+)');

892: )
893: IS
894: l_dummy NUMBER;
895: BEGIN
896: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_UNIQUE_PRIMARY_LOCATION (+)');
897: BEGIN
898: SELECT 1
899: INTO l_dummy
900: FROM DUAL

Line 916: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_UNIQUE_PRIMARY_LOCATION (-)');

912: fnd_message.set_name ('PN', 'PN_DUPLEASE_PRIMARY_TENANCY');
913: x_return_status := 'E';
914: END;
915:
916: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_UNIQUE_PRIMARY_LOCATION (-)');
917: END CHECK_UNIQUE_PRIMARY_LOCATION;
918:
919: -------------------------------------------------------------------------------
920: -- PROCDURE : CHECK_FOR_OVELAP_OF_TENANCY

Line 959: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY (+)');

955:
956: l_org_id NUMBER;
957:
958: BEGIN
959: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY (+)');
960:
961: FOR rec IN org_cur LOOP
962: l_org_id := rec.org_id;
963: END LOOP;

Line 1214: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY (-) X_RETURN_STATUS: '||X_RETURN_STATUS);

1210: END IF;
1211:
1212: END IF;
1213:
1214: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_FOR_OVELAP_OF_TENANCY (-) X_RETURN_STATUS: '||X_RETURN_STATUS);
1215:
1216: END check_for_ovelap_of_tenancy;
1217:
1218: -------------------------------------------------------------------------------

Line 1233: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_TENANCY_DATES (+)');

1229: ,X_EXPIRATION_DATE IN DATE
1230: )
1231: IS
1232: BEGIN
1233: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_TENANCY_DATES (+)');
1234:
1235: IF (X_ESTIMATED_OCCUPANCY_DATE IS NULL) THEN
1236: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_EST_DT_NULL');
1237: x_return_status := 'E';

Line 1250: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_TENANCY_DATES (-)');

1246: x_return_status := 'E';
1247: END IF;
1248:
1249:
1250: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_TENANCY_DATES (-)');
1251: END check_tenancy_dates;
1252:
1253: -------------------------------------------------------------------------------
1254: -- FUNCTION : get_loc_type_code

Line 1278: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_TYPE_CODE (+)');

1274: l_location_code pn_locations_all.location_code%TYPE;
1275: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1276:
1277: BEGIN
1278: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_TYPE_CODE (+)');
1279:
1280: OPEN get_location_type_csr;
1281: FETCH get_location_type_csr INTO l_location_code, l_loc_type_code;
1282: CLOSE get_location_type_csr;

Line 1284: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_TYPE_CODE (-) Loc_Type_Code: '||l_loc_type_code);

1280: OPEN get_location_type_csr;
1281: FETCH get_location_type_csr INTO l_location_code, l_loc_type_code;
1282: CLOSE get_location_type_csr;
1283:
1284: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_TYPE_CODE (-) Loc_Type_Code: '||l_loc_type_code);
1285:
1286: RETURN l_loc_type_code;
1287:
1288: END get_loc_type_code;

Line 1410: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_INFO (+)');

1406: l_prior_assignable_area pn_locations_all.assignable_area%TYPE:=0;
1407: i NUMBER := 0;
1408:
1409: BEGIN
1410: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_INFO (+)');
1411:
1412: loc_info_tbl.delete;
1413:
1414: FOR rec_loc_info IN csr_loc_info

Line 1435: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_INFO (-)');

1431: END IF;
1432: l_prior_assignable_area := rec_loc_info.assignable_area;
1433:
1434: END LOOP;
1435: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_LOC_INFO (-)');
1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: pnp_debug_pkg.log('Get_loc_info - Errmsg: ' || sqlerrm);

Line 1460: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA_PCT (+)');

1456: IS
1457: i NUMBER := 0;
1458: l_min_area NUMBER := -1;
1459: BEGIN
1460: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA_PCT (+)');
1461:
1462: p_alloc_area_pct := -1;
1463: FOR i IN 0 .. loc_info_tbl.count-1
1464: LOOP

Line 1486: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA_PCT (-)');

1482: IF p_alloc_area_pct < 0 THEN
1483: p_alloc_area_pct := ROUND(((p_allocated_area * 100 )/l_min_area),2);
1484: END IF;
1485:
1486: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA_PCT (-)');
1487: END get_allocated_area_pct;
1488:
1489: -------------------------------------------------------------------
1490: -- PROCEDURE : POPULATE_SPACE_ASSIGN_INFO

Line 1542: pnp_debug_pkg.debug('PN_TENANCIES_PKG.POPULATE_SPACE_ASSIGN_INFO (+)');

1538: i NUMBER := 0;
1539: j NUMBER := 0;
1540:
1541: BEGIN
1542: pnp_debug_pkg.debug('PN_TENANCIES_PKG.POPULATE_SPACE_ASSIGN_INFO (+)');
1543:
1544: get_loc_info(p_location_id => p_location_id,
1545: p_from_date => p_from_date,
1546: p_to_date => p_to_date,

Line 1624: pnp_debug_pkg.debug('PN_TENANCIES_PKG.POPULATE_SPACE_ASSIGN_INFO (-)');

1620: space_assign_info_tbl(j).allocated_area_pct := NULL;
1621: END IF;
1622: p_loc_type_code := l_loc_type_code; -- 3242535
1623:
1624: pnp_debug_pkg.debug('PN_TENANCIES_PKG.POPULATE_SPACE_ASSIGN_INFO (-)');
1625: EXCEPTION
1626: WHEN OTHERS THEN
1627: pnp_debug_pkg.log('Populate_space_assign_info - Errmsg: ' || sqlerrm);
1628: RAISE;

Line 1666: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_SPACE_ASSIGN_ROW (+)');

1662: l_rowid ROWID := NULL;
1663: l_cust_space_assign_id NUMBER := NULL;
1664: i NUMBER := 0;
1665: BEGIN
1666: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_SPACE_ASSIGN_ROW (+)');
1667:
1668: i := 0;
1669: FOR i IN 0 .. p_space_assign_info_tbl.count-1
1670: LOOP

Line 1724: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_SPACE_ASSIGN_ROW (-)');

1720: l_rowid := NULL;
1721: l_cust_space_assign_id := NULL;
1722: END LOOP;
1723:
1724: pnp_debug_pkg.debug('PN_TENANCIES_PKG.INSERT_SPACE_ASSIGN_ROW (-)');
1725: END insert_space_assign_row;
1726:
1727: -------------------------------------------------------------------
1728: -- PROCEDURE : GET_ALLOCATED_AREA

Line 1743: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA (+)');

1739: IS
1740: i NUMBER := 0;
1741: l_min_area NUMBER := -1;
1742: BEGIN
1743: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA (+)');
1744:
1745: p_allocated_area := -1;
1746: FOR i IN 0 .. loc_info_tbl.count-1
1747: LOOP

Line 1763: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA (-)');

1759: END LOOP;
1760: IF p_allocated_area < 0 THEN
1761: p_allocated_area := ROUND(((p_allocated_area_pct * l_min_area)/100),2);
1762: END IF;
1763: pnp_debug_pkg.debug('PN_TENANCIES_PKG.GET_ALLOCATED_AREA (-)');
1764: END get_allocated_area;
1765:
1766: -------------------------------------------------------------------
1767: -- PROCEDURE : Manual_space_assign

Line 1792: pnp_debug_pkg.debug('PN_TENANCIES_PKG.MANUAL_SPACE_ASSIGN (+)');

1788: i NUMBER := 0;
1789: j NUMBER := 0;
1790:
1791: BEGIN
1792: pnp_debug_pkg.debug('PN_TENANCIES_PKG.MANUAL_SPACE_ASSIGN (+)');
1793:
1794: get_loc_info(p_location_id => p_location_id,
1795: p_from_date => p_from_date,
1796: p_to_date => p_to_date,

Line 1852: pnp_debug_pkg.debug('PN_TENANCIES_PKG.MANUAL_SPACE_ASSIGN (-)');

1848: space_assign_info_tbl(j).allocated_area_pct := NULL;
1849: END IF;
1850: p_loc_type_code := l_loc_type_code;
1851:
1852: pnp_debug_pkg.debug('PN_TENANCIES_PKG.MANUAL_SPACE_ASSIGN (-)');
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: pnp_debug_pkg.log('Manual_space_assign - Errmsg: ' || sqlerrm);
1856: RAISE;

Line 1943: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHK_MULTI_TENANCY_PROFILE (+)');

1939: l_org_id NUMBER;
1940:
1941:
1942: BEGIN
1943: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHK_MULTI_TENANCY_PROFILE (+)');
1944:
1945: FOR rec IN org_cur LOOP
1946: l_org_id := rec.org_id;
1947: END LOOP;

Line 2002: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHK_MULTI_TENANCY_PROFILE (-)');

1998:
1999: END IF;
2000: p_loc_type_code := l_loc_type_code; -- 3242535
2001:
2002: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHK_MULTI_TENANCY_PROFILE (-)');
2003: END chk_multi_tenancy_profile;
2004:
2005: -------------------------------------------------------------------------------
2006: -- PROCEDURE : CREATE_AUTO_SPACE_ASSIGN

Line 2061: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CREATE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '

2057: l_org_id := rec.org_id;
2058: END LOOP;
2059:
2060: l_auto_space_dist := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N');
2061: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CREATE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '
2062: ||l_auto_space_dist);
2063:
2064: IF p_customer_id IS NULL THEN
2065: RETURN;

Line 2143: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CREATE_AUTO_SPACE_ASSIGN (-)');

2139: p_end_date => p_cust_assign_end_dt);
2140:
2141: END IF;
2142:
2143: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CREATE_AUTO_SPACE_ASSIGN (-)');
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: p_msg := sqlerrm;
2147: pnp_debug_pkg.log('Create_auto_space_assign - Errmsg: ' || p_msg);

Line 2194: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '

2190: l_org_id := rec.org_id;
2191: END LOOP;
2192:
2193: l_auto_space_dist := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N');
2194: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '
2195: ||l_auto_space_dist||', TenancyId: '||p_tenancy_id);
2196:
2197: DELETE FROM pn_rec_expcl_dtlln_all
2198: WHERE cust_space_assign_id IN (SELECT cust_space_assign_id

Line 2229: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_AUTO_SPACE_ASSIGN (-) Deleted '||l_del_count||

2225: IF l_count > 0 THEN
2226: p_action := 'R';
2227: END IF;
2228:
2229: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_AUTO_SPACE_ASSIGN (-) Deleted '||l_del_count||
2230: ' Space Assgn Rows');
2231: EXCEPTION
2232: WHEN OTHERS THEN
2233: pnp_debug_pkg.log('Delete_auto_space_assign - Errmsg: ' || sqlerrm);

Line 2356: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '

2352: l_org_id := rec.org_id;
2353: END LOOP;
2354:
2355: l_auto_space_dist := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N');
2356: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '
2357: ||l_auto_space_dist);
2358: p_action := NULL;
2359:
2360: OPEN csr_spc_assign_exists;

Line 2939: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_AUTO_SPACE_ASSIGN (-)');

2935: p_end_date => p_cust_assign_end_dt);
2936:
2937: END IF;
2938:
2939: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_AUTO_SPACE_ASSIGN (-)');
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: pnp_debug_pkg.log('Update_auto_space_assign - Errmsg: ' || sqlerrm);
2943: RAISE;

Line 3011: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_DUP_SPACE_ASSIGN (+) Auto_Space_Dist: '

3007: l_org_id := rec.org_id;
3008: END LOOP;
3009:
3010: l_auto_space_dist := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N');
3011: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_DUP_SPACE_ASSIGN (+) Auto_Space_Dist: '
3012: ||l_auto_space_dist);
3013: p_action := NULL;
3014:
3015: OPEN get_cust_space_assign_id;

Line 3038: pn_tenancies_pkg.update_auto_space_assign

3034: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
3035: WHERE cust_space_assign_id = l_cust_space_assign_id;
3036:
3037:
3038: pn_tenancies_pkg.update_auto_space_assign
3039: (
3040: p_location_id => p_location_id
3041: ,p_lease_id => p_lease_id
3042: ,p_customer_id => p_customer_id

Line 3068: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_DUP_SPACE_ASSIGN (-)');

3064:
3065:
3066: END IF;
3067:
3068: pnp_debug_pkg.debug('PN_TENANCIES_PKG.UPDATE_DUP_SPACE_ASSIGN (-)');
3069:
3070: END Update_Dup_Space_Assign;
3071:
3072: -------------------------------------------------------------------------------

Line 3102: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area_Pct (+)');

3098: WHERE leases.lease_id = tenant.lease_id
3099: AND tenant.tenancy_id = p_tenancy_id;
3100:
3101: BEGIN
3102: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area_Pct (+)');
3103:
3104: --
3105: FOR rec_allocated_area_pct IN cur_allocated_area_pct LOOP
3106: l_allocated_area_pct := rec_allocated_area_pct.min_area_pct;

Line 3118: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area_Pct (-)');

3114: IF l_lease_class_code = 'DIRECT' THEN
3115: l_allocated_area_pct := NULL;
3116: END IF;
3117:
3118: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area_Pct (-)');
3119:
3120: RETURN l_allocated_area_pct;
3121:
3122: END Auto_Allocated_Area_Pct;

Line 3155: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area (+)');

3151: AND tenant.tenancy_id = p_tenancy_id;
3152:
3153:
3154: BEGIN
3155: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area (+)');
3156:
3157: --
3158: FOR rec_allocated_area IN cur_allocated_area LOOP
3159: l_allocated_area := rec_allocated_area.min_area;

Line 3171: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area (-)');

3167: IF l_lease_class_code = 'DIRECT' THEN
3168: l_allocated_area := NULL;
3169: END IF;
3170:
3171: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Auto_Allocated_Area (-)');
3172:
3173: RETURN l_allocated_area;
3174:
3175: END Auto_Allocated_Area;

Line 3217: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Availaible_Space (+)');

3213: i NUMBER := 0;
3214: j NUMBER := 0;
3215:
3216: BEGIN
3217: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Availaible_Space (+)');
3218:
3219: get_loc_info(p_location_id => p_location_id,
3220: p_from_date => p_from_date,
3221: p_to_date => p_to_date,

Line 3275: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Availaible_Space (-)');

3271: p_alloc_area_pct => p_min_pct);
3272:
3273: END IF;
3274:
3275: pnp_debug_pkg.debug('PN_TENANCIES_PKG.Availaible_Space (-)');
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: pnp_debug_pkg.log('Availaible_Space - Errmsg: ' || sqlerrm);
3279: RAISE;

Line 3283: END pn_tenancies_pkg;

3279: RAISE;
3280:
3281: END Availaible_Space;
3282:
3283: END pn_tenancies_pkg;