[Home] [Help]
672:
673: ----------------------------------------------------
674: -- get the lease status
675: ----------------------------------------------------
676: l_leaseStatus := PNP_UTIL_FUNC.GET_LEASE_STATUS (X_LEASE_ID);
677:
678: ---------------------------------------------------------------
679: -- We need to INsert the history row IF the lease IS finalised
680: ---------------------------------------------------------------
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.
1881: -- 14-JAN-04 STripathi o Fixed BUG# 3359371, Call pnp_util_func.Get_Location_Type_Lookup_Code
1882: -- with p_cust_assign_start_dt as as_of_date.
1883: -- 08-APR-04 STripathi o Fixed for BUG# 3533405, Modified CURSOR csr_assign_exists
1884: -- added ten.str_dt <= p_assgn_end_dt and ten.end_dt >= p_assgn_str_dt
1885: -- to check tenancy other exist betn assgn str and end dt.
1925: and pl.active_end_date >= p_cust_assign_start_dt);
1926:
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: