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_LOCATIONS_ALL

Line 968: FROM pn_locations_all

964:
965: -- we are selecting the location code for err condition
966: SELECT location_code
967: INTO l_locationCode
968: FROM pn_locations_all
969: WHERE location_id = x_location_id
970: AND ROWNUM < 2;
971:
972: -- we need to find IF the lease has a master lease defined

Line 998: FROM pn_locations_all b

994: WHERE pnt.status = 'A'
995: AND pnt.lease_id = x_lease_id
996: AND pnt.location_id IN
997: (SELECT b.parent_location_id
998: FROM pn_locations_all b
999: CONNECT BY b.location_id = PRIOR parent_location_id
1000: START WITH b.location_id = x_location_id
1001: )
1002: AND (TRUNC(NVL(pnt.occupancy_date, pnt.estimated_occupancy_date))

Line 1039: FROM pn_locations_all a

1035: FROM pn_tenancies_all pnt
1036: WHERE pnt.status = 'A'
1037: AND pnt.location_id IN
1038: (SELECT a.location_id
1039: FROM pn_locations_all a
1040: CONNECT BY PRIOR a.parent_location_id = a.location_id
1041: START WITH a.location_id = x_location_id
1042: UNION ALL
1043: SELECT b.location_id

Line 1044: FROM pn_locations_all b

1040: CONNECT BY PRIOR a.parent_location_id = a.location_id
1041: START WITH a.location_id = x_location_id
1042: UNION ALL
1043: SELECT b.location_id
1044: FROM pn_locations_all b
1045: CONNECT BY PRIOR b.location_id = b.parent_location_id
1046: START WITH b.location_id = x_location_id
1047: )
1048: AND (TRUNC(NVL(pnt.occupancy_date, pnt.estimated_occupancy_date))

Line 1090: FROM pn_locations_all b

1086: FROM pn_tenancies_all pnt
1087: WHERE pnt.status = 'A'
1088: AND pnt.location_id IN
1089: (SELECT b.location_id
1090: FROM pn_locations_all b
1091: CONNECT BY PRIOR b.location_id = b.parent_location_id
1092: START WITH b.location_id = x_location_id
1093: )
1094: AND (TRUNC(NVL(pnt.occupancy_date, pnt.estimated_occupancy_date))

Line 1128: FROM pn_locations_all

1124: -- parent lease AND the dates are within range
1125: BEGIN
1126: SELECT location_id
1127: INTO l_leaseNumber
1128: FROM pn_locations_all
1129: WHERE location_id = x_location_id
1130: AND location_id IN
1131: (SELECT b.location_id
1132: FROM pn_locations_all b

Line 1132: FROM pn_locations_all b

1128: FROM pn_locations_all
1129: WHERE location_id = x_location_id
1130: AND location_id IN
1131: (SELECT b.location_id
1132: FROM pn_locations_all b
1133: CONNECT BY PRIOR b.location_id = b.parent_location_id
1134: START WITH b.location_id IN
1135: (SELECT pnt.location_id
1136: FROM pn_tenancies_all pnt

Line 1175: FROM pn_locations_all a

1171: WHERE pnt.status = 'A'
1172: AND pnt.lease_id <> l_parentLeaseId
1173: AND pnt.location_id IN
1174: (SELECT a.location_id
1175: FROM pn_locations_all a
1176: CONNECT BY PRIOR a.parent_location_id = a.location_id
1177: START WITH a.location_id = x_location_id
1178: UNION ALL
1179: SELECT b.location_id

Line 1180: FROM pn_locations_all b

1176: CONNECT BY PRIOR a.parent_location_id = a.location_id
1177: START WITH a.location_id = x_location_id
1178: UNION ALL
1179: SELECT b.location_id
1180: FROM pn_locations_all b
1181: CONNECT BY PRIOR b.location_id = b.parent_location_id
1182: START WITH b.location_id = x_location_id
1183: )
1184: AND (TRUNC(NVL(pnt.occupancy_date, pnt.estimated_occupancy_date))

Line 1270: FROM pn_locations_all pnl

1266: IS
1267: CURSOR get_location_type_csr IS
1268: SELECT location_code,
1269: location_type_lookup_code
1270: FROM pn_locations_all pnl
1271: WHERE pnl.location_id = p_location_id
1272: AND p_start_date BETWEEN pnl.active_start_date AND pnl.active_end_date;
1273:
1274: l_location_code pn_locations_all.location_code%TYPE;

Line 1274: l_location_code pn_locations_all.location_code%TYPE;

1270: FROM pn_locations_all pnl
1271: WHERE pnl.location_id = p_location_id
1272: AND p_start_date BETWEEN pnl.active_start_date AND pnl.active_end_date;
1273:
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 (+)');

Line 1275: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

1271: WHERE pnl.location_id = p_location_id
1272: AND p_start_date BETWEEN pnl.active_start_date AND pnl.active_end_date;
1273:
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:

Line 1367: -- DESCRIPTION: o populate loc_info_tbl with rows from pn_locations_all for a given location

1363: END cust_assign_assoc_exp_area_dt;
1364:
1365: -------------------------------------------------------------------
1366: -- PROCEDURE : GET_LOC_INFO
1367: -- DESCRIPTION: o populate loc_info_tbl with rows from pn_locations_all for a given location
1368: -- o if the assignable area for a location has not changed but the location
1369: -- was split the location records would be treated as a single record.
1370: -- Example:
1371: -- Rows in pn_locations_all

Line 1371: -- Rows in pn_locations_all

1367: -- DESCRIPTION: o populate loc_info_tbl with rows from pn_locations_all for a given location
1368: -- o if the assignable area for a location has not changed but the location
1369: -- was split the location records would be treated as a single record.
1370: -- Example:
1371: -- Rows in pn_locations_all
1372: -- active_st_dt active_end_dt assignable_area
1373: -- 01-JAN-00 31-DEC-00 1000
1374: -- 01-JAN-01 30-JUN-01 1000
1375: -- 01-JUL-00 31-DEC-01 2000

Line 1400: FROM pn_locations_all

1396: SELECT active_start_date,
1397: NVL(active_end_date, p_to_date) active_end_date,
1398: assignable_area,
1399: location_type_lookup_code
1400: FROM pn_locations_all
1401: WHERE location_id = p_location_id
1402: AND active_start_date <= p_to_date
1403: AND NVL(active_end_date, p_to_date) >= p_from_date
1404: ORDER BY active_start_date;

Line 1406: l_prior_assignable_area pn_locations_all.assignable_area%TYPE:=0;

1402: AND active_start_date <= p_to_date
1403: AND NVL(active_end_date, p_to_date) >= p_from_date
1404: ORDER BY active_start_date;
1405:
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 (+)');

Line 1533: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

1529: WHERE location_id = p_location_id
1530: AND emp_assign_start_date <= p_to_date
1531: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
1532:
1533: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1534: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1535: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1536: l_start_date DATE := NULL;
1537: l_end_date DATE := NULL;

Line 1783: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

1779: ,p_loc_type_code OUT NOCOPY VARCHAR2
1780: )
1781: IS
1782:
1783: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1784: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1785: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1786: l_start_date DATE := NULL;
1787: l_end_date DATE := NULL;

Line 1876: -- in pn_locations_all is non-zero for a given assignment time period

1872: -- 07-NOV-03 DThota o Fix for bug # 3242535
1873: -- assigned l_loc_type_code to p_loc_type_code
1874: -- 10-NOV-03 DThota o Fix for bug # 3194380
1875: -- New cusrsor csr_space_exists checks to see if assignable area
1876: -- in pn_locations_all is non-zero for a given assignment time period
1877: -- Returning if there is no vacancy, overlap or assignable_area in locations is
1878: -- non-zero regardless of PN_AUTOMATIC_SPACE_DISTRIBUTION setting.
1879: -- 21-NOV-03 STripathi o Fixed BUG# 3263503, Removed return; CLOSE csr_space_exists; in
1880: -- csr_space_exists and EXIT; in space_assign_info_tbl for NOVACANT.

Line 1921: from pn_locations_all pl

1917: CURSOR csr_space_exists IS
1918: SELECT 'Y'
1919: FROM DUAl
1920: WHERE EXISTS (SELECT NULL
1921: from pn_locations_all pl
1922: where pl.location_id = p_location_id
1923: and pl.assignable_area = 0
1924: and pl.active_start_date <= nvl(p_cust_assign_end_dt,to_date('12/31/4712','MM/DD/YYYY'))
1925: and pl.active_end_date >= p_cust_assign_start_dt);

Line 1931: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

1927: l_multi_tenancy_profile VARCHAR2(100);
1928: l_exists VARCHAR2(1) := 'N';
1929: l_loc_type_lookup_code VARCHAR2(30) := pnp_util_func.Get_Location_Type_Lookup_Code(p_location_id, p_cust_assign_start_dt);
1930: i NUMBER := 0;
1931: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1932: l_auto_space_assign VARCHAR2(30);
1933:
1934: CURSOR org_cur IS
1935: SELECT org_id

Line 2043: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

2039: i NUMBER :=0;
2040: l_rowid ROWID := NULL;
2041: l_cust_space_assign_id NUMBER := NULL;
2042: space_assign_tbl space_assign_info_type;
2043: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
2044: l_return_status VARCHAR2(20) := NULL;
2045: l_auto_space_dist VARCHAR2(20) := NULL;
2046:
2047: CURSOR org_cur IS

Line 2172: ,p_location_id IN pn_locations_all.location_id%TYPE DEFAULT NULL

2168: p_tenancy_id IN NUMBER
2169: ,p_cust_assign_start_date IN DATE
2170: ,p_cust_assign_end_date IN DATE
2171: ,p_action OUT NOCOPY VARCHAR2
2172: ,p_location_id IN pn_locations_all.location_id%TYPE DEFAULT NULL
2173: ,p_loc_type_code IN pn_locations_all.location_type_lookup_code%TYPE DEFAULT NULL
2174: )
2175: IS
2176: l_count NUMBER := 0;

Line 2173: ,p_loc_type_code IN pn_locations_all.location_type_lookup_code%TYPE DEFAULT NULL

2169: ,p_cust_assign_start_date IN DATE
2170: ,p_cust_assign_end_date IN DATE
2171: ,p_action OUT NOCOPY VARCHAR2
2172: ,p_location_id IN pn_locations_all.location_id%TYPE DEFAULT NULL
2173: ,p_loc_type_code IN pn_locations_all.location_type_lookup_code%TYPE DEFAULT NULL
2174: )
2175: IS
2176: l_count NUMBER := 0;
2177: l_del_count NUMBER := 0;

Line 2328: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

2324: l_max_cust_end_date DATE := NULL;
2325: l_max_cust_assign_id NUMBER := NULL;
2326: space_assign_tbl space_assign_info_type;
2327: l_exists VARCHAR2(1) := 'N';
2328: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
2329: l_StartOfTime DATE := TO_DATE('01010001','MMDDYYYY');
2330: l_return_status VARCHAR2(20) := NULL;
2331: l_auto_space_dist VARCHAR2(20) := NULL;
2332: l_cust_assign_start_date DATE := NULL;

Line 2997: FROM pn_locations_all pnl

2993: l_auto_space_dist VARCHAR2(20) := NULL;
2994:
2995: CURSOR org_cur IS
2996: SELECT org_id
2997: FROM pn_locations_all pnl
2998: WHERE pnl.location_id = p_location_id
2999: AND ROWNUM < 2;
3000:
3001: l_org_id NUMBER;

Line 3210: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;

3206: WHERE location_id = p_location_id
3207: AND emp_assign_start_date <= p_to_date
3208: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
3209:
3210: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3211: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
3212: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
3213: i NUMBER := 0;
3214: j NUMBER := 0;