APPS.PNT_LOCATIONS_PKG dependencies on PN_VAR_RENT_PKG

Line 2054: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',G_LOC_RECINFO.ATTRIBUTE_CATEGORY);

2050: CLOSE C;
2051:
2052: IF NOT ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
2053: OR ((G_LOC_RECINFO.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) THEN
2054: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',G_LOC_RECINFO.ATTRIBUTE_CATEGORY);
2055: END IF;
2056:
2057: IF NOT ((G_LOC_RECINFO.ATTRIBUTE1 = X_ATTRIBUTE1)
2058: OR ((G_LOC_RECINFO.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN

Line 2059: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1', G_LOC_RECINFO.attribute1);

2055: END IF;
2056:
2057: IF NOT ((G_LOC_RECINFO.ATTRIBUTE1 = X_ATTRIBUTE1)
2058: OR ((G_LOC_RECINFO.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN
2059: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1', G_LOC_RECINFO.attribute1);
2060: END IF;
2061:
2062: IF NOT ((G_LOC_RECINFO.ATTRIBUTE2 = X_ATTRIBUTE2)
2063: OR ((G_LOC_RECINFO.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN

Line 2064: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2', G_LOC_RECINFO.attribute2);

2060: END IF;
2061:
2062: IF NOT ((G_LOC_RECINFO.ATTRIBUTE2 = X_ATTRIBUTE2)
2063: OR ((G_LOC_RECINFO.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN
2064: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2', G_LOC_RECINFO.attribute2);
2065: END IF;
2066:
2067: IF NOT ((G_LOC_RECINFO.ATTRIBUTE3 = X_ATTRIBUTE3)
2068: OR ((G_LOC_RECINFO.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN

Line 2069: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3', G_LOC_RECINFO.attribute3);

2065: END IF;
2066:
2067: IF NOT ((G_LOC_RECINFO.ATTRIBUTE3 = X_ATTRIBUTE3)
2068: OR ((G_LOC_RECINFO.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN
2069: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3', G_LOC_RECINFO.attribute3);
2070: END IF;
2071:
2072: IF NOT ((G_LOC_RECINFO.ATTRIBUTE4 = X_ATTRIBUTE4)
2073: OR ((G_LOC_RECINFO.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN

Line 2074: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4', G_LOC_RECINFO.attribute4);

2070: END IF;
2071:
2072: IF NOT ((G_LOC_RECINFO.ATTRIBUTE4 = X_ATTRIBUTE4)
2073: OR ((G_LOC_RECINFO.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN
2074: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4', G_LOC_RECINFO.attribute4);
2075: END IF;
2076:
2077: IF NOT ((G_LOC_RECINFO.ATTRIBUTE5 = X_ATTRIBUTE5)
2078: OR ((G_LOC_RECINFO.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN

Line 2079: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5', G_LOC_RECINFO.attribute5);

2075: END IF;
2076:
2077: IF NOT ((G_LOC_RECINFO.ATTRIBUTE5 = X_ATTRIBUTE5)
2078: OR ((G_LOC_RECINFO.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN
2079: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5', G_LOC_RECINFO.attribute5);
2080: END IF;
2081:
2082: IF NOT ((G_LOC_RECINFO.ATTRIBUTE6 = X_ATTRIBUTE6)
2083: OR ((G_LOC_RECINFO.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN

Line 2084: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6', G_LOC_RECINFO.attribute6);

2080: END IF;
2081:
2082: IF NOT ((G_LOC_RECINFO.ATTRIBUTE6 = X_ATTRIBUTE6)
2083: OR ((G_LOC_RECINFO.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN
2084: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6', G_LOC_RECINFO.attribute6);
2085: END IF;
2086:
2087: IF NOT ((G_LOC_RECINFO.ATTRIBUTE7 = X_ATTRIBUTE7)
2088: OR ((G_LOC_RECINFO.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN

Line 2089: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7', G_LOC_RECINFO.attribute7);

2085: END IF;
2086:
2087: IF NOT ((G_LOC_RECINFO.ATTRIBUTE7 = X_ATTRIBUTE7)
2088: OR ((G_LOC_RECINFO.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN
2089: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7', G_LOC_RECINFO.attribute7);
2090: END IF;
2091:
2092: IF NOT ((G_LOC_RECINFO.ATTRIBUTE8 = X_ATTRIBUTE8)
2093: OR ((G_LOC_RECINFO.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN

Line 2094: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8', G_LOC_RECINFO.attribute8);

2090: END IF;
2091:
2092: IF NOT ((G_LOC_RECINFO.ATTRIBUTE8 = X_ATTRIBUTE8)
2093: OR ((G_LOC_RECINFO.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN
2094: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8', G_LOC_RECINFO.attribute8);
2095: END IF;
2096:
2097: IF NOT ((G_LOC_RECINFO.ATTRIBUTE9 = X_ATTRIBUTE9)
2098: OR ((G_LOC_RECINFO.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN

Line 2099: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9', G_LOC_RECINFO.attribute9);

2095: END IF;
2096:
2097: IF NOT ((G_LOC_RECINFO.ATTRIBUTE9 = X_ATTRIBUTE9)
2098: OR ((G_LOC_RECINFO.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN
2099: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9', G_LOC_RECINFO.attribute9);
2100: END IF;
2101:
2102: IF NOT ((G_LOC_RECINFO.ATTRIBUTE10 = X_ATTRIBUTE10)
2103: OR ((G_LOC_RECINFO.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN

Line 2104: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10', G_LOC_RECINFO.attribute10);

2100: END IF;
2101:
2102: IF NOT ((G_LOC_RECINFO.ATTRIBUTE10 = X_ATTRIBUTE10)
2103: OR ((G_LOC_RECINFO.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN
2104: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10', G_LOC_RECINFO.attribute10);
2105: END IF;
2106:
2107: IF NOT ((G_LOC_RECINFO.ATTRIBUTE11 = X_ATTRIBUTE11)
2108: OR ((G_LOC_RECINFO.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN

Line 2109: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11', G_LOC_RECINFO.attribute11);

2105: END IF;
2106:
2107: IF NOT ((G_LOC_RECINFO.ATTRIBUTE11 = X_ATTRIBUTE11)
2108: OR ((G_LOC_RECINFO.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN
2109: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11', G_LOC_RECINFO.attribute11);
2110: END IF;
2111:
2112: IF NOT ((G_LOC_RECINFO.ATTRIBUTE12 = X_ATTRIBUTE12)
2113: OR ((G_LOC_RECINFO.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN

Line 2114: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12', G_LOC_RECINFO.attribute12);

2110: END IF;
2111:
2112: IF NOT ((G_LOC_RECINFO.ATTRIBUTE12 = X_ATTRIBUTE12)
2113: OR ((G_LOC_RECINFO.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN
2114: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12', G_LOC_RECINFO.attribute12);
2115: END IF;
2116:
2117: IF NOT ((G_LOC_RECINFO.ATTRIBUTE13 = X_ATTRIBUTE13)
2118: OR ((G_LOC_RECINFO.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN

Line 2119: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13', G_LOC_RECINFO.attribute13);

2115: END IF;
2116:
2117: IF NOT ((G_LOC_RECINFO.ATTRIBUTE13 = X_ATTRIBUTE13)
2118: OR ((G_LOC_RECINFO.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN
2119: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13', G_LOC_RECINFO.attribute13);
2120: END IF;
2121:
2122: IF NOT ((G_LOC_RECINFO.ATTRIBUTE14 = X_ATTRIBUTE14)
2123: OR ((G_LOC_RECINFO.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN

Line 2124: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14', G_LOC_RECINFO.attribute14);

2120: END IF;
2121:
2122: IF NOT ((G_LOC_RECINFO.ATTRIBUTE14 = X_ATTRIBUTE14)
2123: OR ((G_LOC_RECINFO.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN
2124: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14', G_LOC_RECINFO.attribute14);
2125: END IF;
2126:
2127: IF NOT ((G_LOC_RECINFO.ATTRIBUTE15 = X_ATTRIBUTE15)
2128: OR ((G_LOC_RECINFO.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN

Line 2129: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', G_LOC_RECINFO.attribute15);

2125: END IF;
2126:
2127: IF NOT ((G_LOC_RECINFO.ATTRIBUTE15 = X_ATTRIBUTE15)
2128: OR ((G_LOC_RECINFO.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN
2129: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', G_LOC_RECINFO.attribute15);
2130: END IF;
2131:
2132: IF NOT ((G_LOC_RECINFO.COMMON_AREA_FLAG = X_COMMON_AREA_FLAG)
2133: OR ((G_LOC_RECINFO.COMMON_AREA_FLAG is null) AND (X_COMMON_AREA_FLAG is null))) THEN

Line 2134: pn_var_rent_pkg.lock_row_exception('COMMON_AREA_FLAG',G_LOC_RECINFO.COMMON_AREA_FLAG);

2130: END IF;
2131:
2132: IF NOT ((G_LOC_RECINFO.COMMON_AREA_FLAG = X_COMMON_AREA_FLAG)
2133: OR ((G_LOC_RECINFO.COMMON_AREA_FLAG is null) AND (X_COMMON_AREA_FLAG is null))) THEN
2134: pn_var_rent_pkg.lock_row_exception('COMMON_AREA_FLAG',G_LOC_RECINFO.COMMON_AREA_FLAG);
2135: END IF;
2136:
2137: IF NOT (G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE = X_LOCATION_TYPE_LOOKUP_CODE) THEN
2138: pn_var_rent_pkg.lock_row_exception('LOCATION_TYPE_LOOKUP_CODE',G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE);

Line 2138: pn_var_rent_pkg.lock_row_exception('LOCATION_TYPE_LOOKUP_CODE',G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE);

2134: pn_var_rent_pkg.lock_row_exception('COMMON_AREA_FLAG',G_LOC_RECINFO.COMMON_AREA_FLAG);
2135: END IF;
2136:
2137: IF NOT (G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE = X_LOCATION_TYPE_LOOKUP_CODE) THEN
2138: pn_var_rent_pkg.lock_row_exception('LOCATION_TYPE_LOOKUP_CODE',G_LOC_RECINFO.LOCATION_TYPE_LOOKUP_CODE);
2139: END IF;
2140:
2141: IF NOT ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE = X_FUNCTION_TYPE_LOOKUP_CODE)
2142: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is null) AND (X_FUNCTION_TYPE_LOOKUP_CODE is null))) THEN

Line 2143: pn_var_rent_pkg.lock_row_exception('FUNCTION_TYPE_LOOKUP_CODE',G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE);

2139: END IF;
2140:
2141: IF NOT ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE = X_FUNCTION_TYPE_LOOKUP_CODE)
2142: OR ((G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE is null) AND (X_FUNCTION_TYPE_LOOKUP_CODE is null))) THEN
2143: pn_var_rent_pkg.lock_row_exception('FUNCTION_TYPE_LOOKUP_CODE',G_LOC_RECINFO.FUNCTION_TYPE_LOOKUP_CODE);
2144: END IF;
2145:
2146:
2147: IF NOT ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE = X_SPACE_TYPE_LOOKUP_CODE)

Line 2149: pn_var_rent_pkg.lock_row_exception('SPACE_TYPE_LOOKUP_CODE',G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE);

2145:
2146:
2147: IF NOT ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE = X_SPACE_TYPE_LOOKUP_CODE)
2148: OR ((G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE is null) AND (X_SPACE_TYPE_LOOKUP_CODE is null))) THEN
2149: pn_var_rent_pkg.lock_row_exception('SPACE_TYPE_LOOKUP_CODE',G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE);
2150: END IF;
2151:
2152:
2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)

Line 2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);

2151:
2152:
2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)
2154: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is null) AND (X_STANDARD_TYPE_LOOKUP_CODE is null))) THEN
2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);
2156: END IF;
2157:
2158: IF NOT (G_LOC_RECINFO.LOCATION_CODE = X_LOCATION_CODE) THEN
2159: pn_var_rent_pkg.lock_row_exception('LOCATION_CODE',G_LOC_RECINFO.LOCATION_CODE);

Line 2159: pn_var_rent_pkg.lock_row_exception('LOCATION_CODE',G_LOC_RECINFO.LOCATION_CODE);

2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);
2156: END IF;
2157:
2158: IF NOT (G_LOC_RECINFO.LOCATION_CODE = X_LOCATION_CODE) THEN
2159: pn_var_rent_pkg.lock_row_exception('LOCATION_CODE',G_LOC_RECINFO.LOCATION_CODE);
2160: END IF;
2161:
2162: IF NOT ((G_LOC_RECINFO.BUILDING = X_BUILDING)
2163: OR ((G_LOC_RECINFO.BUILDING is null) AND (X_BUILDING is null))) THEN

Line 2164: pn_var_rent_pkg.lock_row_exception('BUILDING',G_LOC_RECINFO.BUILDING);

2160: END IF;
2161:
2162: IF NOT ((G_LOC_RECINFO.BUILDING = X_BUILDING)
2163: OR ((G_LOC_RECINFO.BUILDING is null) AND (X_BUILDING is null))) THEN
2164: pn_var_rent_pkg.lock_row_exception('BUILDING',G_LOC_RECINFO.BUILDING);
2165: END IF;
2166:
2167: IF NOT ((G_LOC_RECINFO.FLOOR = X_FLOOR)
2168: OR ((G_LOC_RECINFO.FLOOR is null) AND (X_FLOOR is null))) THEN

Line 2169: pn_var_rent_pkg.lock_row_exception('FLOOR',G_LOC_RECINFO.FLOOR);

2165: END IF;
2166:
2167: IF NOT ((G_LOC_RECINFO.FLOOR = X_FLOOR)
2168: OR ((G_LOC_RECINFO.FLOOR is null) AND (X_FLOOR is null))) THEN
2169: pn_var_rent_pkg.lock_row_exception('FLOOR',G_LOC_RECINFO.FLOOR);
2170: END IF;
2171:
2172: IF NOT ((G_LOC_RECINFO.LOCATION_ALIAS = X_LOCATION_ALIAS)
2173: OR ((G_LOC_RECINFO.LOCATION_ALIAS is null) AND (X_LOCATION_ALIAS is null))) THEN

Line 2174: pn_var_rent_pkg.lock_row_exception('LOCATION_ALIAS',G_LOC_RECINFO.LOCATION_ALIAS);

2170: END IF;
2171:
2172: IF NOT ((G_LOC_RECINFO.LOCATION_ALIAS = X_LOCATION_ALIAS)
2173: OR ((G_LOC_RECINFO.LOCATION_ALIAS is null) AND (X_LOCATION_ALIAS is null))) THEN
2174: pn_var_rent_pkg.lock_row_exception('LOCATION_ALIAS',G_LOC_RECINFO.LOCATION_ALIAS);
2175: END IF;
2176:
2177: IF NOT ((G_LOC_RECINFO.PROPERTY_ID = X_PROPERTY_ID)
2178: OR ((G_LOC_RECINFO.PROPERTY_ID is null) AND (X_PROPERTY_ID is null))) THEN

Line 2179: pn_var_rent_pkg.lock_row_exception('PROPERTY_ID',G_LOC_RECINFO.PROPERTY_ID);

2175: END IF;
2176:
2177: IF NOT ((G_LOC_RECINFO.PROPERTY_ID = X_PROPERTY_ID)
2178: OR ((G_LOC_RECINFO.PROPERTY_ID is null) AND (X_PROPERTY_ID is null))) THEN
2179: pn_var_rent_pkg.lock_row_exception('PROPERTY_ID',G_LOC_RECINFO.PROPERTY_ID);
2180: END IF;
2181:
2182: IF NOT ((G_LOC_RECINFO.PARENT_LOCATION_ID = X_PARENT_LOCATION_ID)
2183: OR ((G_LOC_RECINFO.PARENT_LOCATION_ID is null) AND (X_PARENT_LOCATION_ID is null))) THEN

Line 2184: pn_var_rent_pkg.lock_row_exception('PARENT_LOCATION_ID',G_LOC_RECINFO.PARENT_LOCATION_ID);

2180: END IF;
2181:
2182: IF NOT ((G_LOC_RECINFO.PARENT_LOCATION_ID = X_PARENT_LOCATION_ID)
2183: OR ((G_LOC_RECINFO.PARENT_LOCATION_ID is null) AND (X_PARENT_LOCATION_ID is null))) THEN
2184: pn_var_rent_pkg.lock_row_exception('PARENT_LOCATION_ID',G_LOC_RECINFO.PARENT_LOCATION_ID);
2185: END IF;
2186:
2187: IF NOT ((G_LOC_RECINFO.INTERFACE_FLAG = X_INTERFACE_FLAG)
2188: OR ((G_LOC_RECINFO.INTERFACE_FLAG is null) AND (X_INTERFACE_FLAG is null))) THEN

Line 2189: pn_var_rent_pkg.lock_row_exception('INTERFACE_FLAG',G_LOC_RECINFO.INTERFACE_FLAG);

2185: END IF;
2186:
2187: IF NOT ((G_LOC_RECINFO.INTERFACE_FLAG = X_INTERFACE_FLAG)
2188: OR ((G_LOC_RECINFO.INTERFACE_FLAG is null) AND (X_INTERFACE_FLAG is null))) THEN
2189: pn_var_rent_pkg.lock_row_exception('INTERFACE_FLAG',G_LOC_RECINFO.INTERFACE_FLAG);
2190: END IF;
2191:
2192: IF NOT ((G_LOC_RECINFO.STATUS = X_STATUS)
2193: OR ((G_LOC_RECINFO.STATUS is null) AND (X_STATUS is null))) THEN

Line 2194: pn_var_rent_pkg.lock_row_exception('STATUS',G_LOC_RECINFO.STATUS);

2190: END IF;
2191:
2192: IF NOT ((G_LOC_RECINFO.STATUS = X_STATUS)
2193: OR ((G_LOC_RECINFO.STATUS is null) AND (X_STATUS is null))) THEN
2194: pn_var_rent_pkg.lock_row_exception('STATUS',G_LOC_RECINFO.STATUS);
2195: END IF;
2196:
2197:
2198: IF NOT ((G_LOC_RECINFO.ACTIVE_START_DATE = x_ACTIVE_START_DATE)

Line 2200: pn_var_rent_pkg.lock_row_exception('ACTIVE_START_DATE',G_LOC_RECINFO.ACTIVE_START_DATE);

2196:
2197:
2198: IF NOT ((G_LOC_RECINFO.ACTIVE_START_DATE = x_ACTIVE_START_DATE)
2199: OR ((G_LOC_RECINFO.ACTIVE_START_DATE is null) AND (x_ACTIVE_START_DATE is null))) THEN
2200: pn_var_rent_pkg.lock_row_exception('ACTIVE_START_DATE',G_LOC_RECINFO.ACTIVE_START_DATE);
2201: END IF;
2202:
2203: IF NOT ((G_LOC_RECINFO.ACTIVE_END_DATE = x_ACTIVE_END_DATE)
2204: OR ((G_LOC_RECINFO.ACTIVE_END_DATE is null) AND (x_ACTIVE_END_DATE is null))) THEN

Line 2205: pn_var_rent_pkg.lock_row_exception('ACTIVE_END_DATE',G_LOC_RECINFO.ACTIVE_END_DATE);

2201: END IF;
2202:
2203: IF NOT ((G_LOC_RECINFO.ACTIVE_END_DATE = x_ACTIVE_END_DATE)
2204: OR ((G_LOC_RECINFO.ACTIVE_END_DATE is null) AND (x_ACTIVE_END_DATE is null))) THEN
2205: pn_var_rent_pkg.lock_row_exception('ACTIVE_END_DATE',G_LOC_RECINFO.ACTIVE_END_DATE);
2206: END IF;
2207:
2208: -- DO SPECIAL CHECKS FOR PARTICULAR KINDS
2209:

Line 2213: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_ID',G_LOC_RECINFO.LOCATION_PARK_ID);

2209:
2210: IF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND')) THEN
2211: IF NOT ((G_LOC_RECINFO.LOCATION_PARK_ID = X_LOCATION_PARK_ID)
2212: OR ((G_LOC_RECINFO.LOCATION_PARK_ID is null) AND (X_LOCATION_PARK_ID is null))) THEN
2213: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_ID',G_LOC_RECINFO.LOCATION_PARK_ID);
2214: END IF;
2215:
2216: IF NOT ((G_LOC_RECINFO.LEASE_OR_OWNED = X_LEASE_OR_OWNED)
2217: OR ((G_LOC_RECINFO.LEASE_OR_OWNED is null) AND (X_LEASE_OR_OWNED is null))) THEN

Line 2218: pn_var_rent_pkg.lock_row_exception('LEASE_OR_OWNED',G_LOC_RECINFO.LEASE_OR_OWNED);

2214: END IF;
2215:
2216: IF NOT ((G_LOC_RECINFO.LEASE_OR_OWNED = X_LEASE_OR_OWNED)
2217: OR ((G_LOC_RECINFO.LEASE_OR_OWNED is null) AND (X_LEASE_OR_OWNED is null))) THEN
2218: pn_var_rent_pkg.lock_row_exception('LEASE_OR_OWNED',G_LOC_RECINFO.LEASE_OR_OWNED);
2219: END IF;
2220:
2221: IF NOT ((G_LOC_RECINFO.CLASS = X_CLASS)
2222: OR ((G_LOC_RECINFO.CLASS is null) AND (X_CLASS is null))) THEN

Line 2223: pn_var_rent_pkg.lock_row_exception('CLASS',G_LOC_RECINFO.CLASS);

2219: END IF;
2220:
2221: IF NOT ((G_LOC_RECINFO.CLASS = X_CLASS)
2222: OR ((G_LOC_RECINFO.CLASS is null) AND (X_CLASS is null))) THEN
2223: pn_var_rent_pkg.lock_row_exception('CLASS',G_LOC_RECINFO.CLASS);
2224: END IF;
2225:
2226: IF NOT ((G_LOC_RECINFO.STATUS_TYPE = X_STATUS_TYPE)
2227: OR ((G_LOC_RECINFO.STATUS_TYPE is null) AND (X_STATUS_TYPE is null))) THEN

Line 2228: pn_var_rent_pkg.lock_row_exception('STATUS_TYPE',G_LOC_RECINFO.STATUS_TYPE);

2224: END IF;
2225:
2226: IF NOT ((G_LOC_RECINFO.STATUS_TYPE = X_STATUS_TYPE)
2227: OR ((G_LOC_RECINFO.STATUS_TYPE is null) AND (X_STATUS_TYPE is null))) THEN
2228: pn_var_rent_pkg.lock_row_exception('STATUS_TYPE',G_LOC_RECINFO.STATUS_TYPE);
2229: END IF;
2230:
2231: IF NOT ((G_LOC_RECINFO.OFFICE = X_OFFICE)
2232: OR ((G_LOC_RECINFO.OFFICE is null) AND (X_OFFICE is null))) THEN

Line 2233: pn_var_rent_pkg.lock_row_exception('OFFICE',G_LOC_RECINFO.OFFICE);

2229: END IF;
2230:
2231: IF NOT ((G_LOC_RECINFO.OFFICE = X_OFFICE)
2232: OR ((G_LOC_RECINFO.OFFICE is null) AND (X_OFFICE is null))) THEN
2233: pn_var_rent_pkg.lock_row_exception('OFFICE',G_LOC_RECINFO.OFFICE);
2234: END IF;
2235:
2236: IF NOT ((G_LOC_RECINFO.ADDRESS_ID = X_ADDRESS_ID)
2237: OR ((G_LOC_RECINFO.ADDRESS_ID is null) AND (X_ADDRESS_ID is null))) THEN

Line 2238: pn_var_rent_pkg.lock_row_exception('ADDRESS_ID',G_LOC_RECINFO.ADDRESS_ID);

2234: END IF;
2235:
2236: IF NOT ((G_LOC_RECINFO.ADDRESS_ID = X_ADDRESS_ID)
2237: OR ((G_LOC_RECINFO.ADDRESS_ID is null) AND (X_ADDRESS_ID is null))) THEN
2238: pn_var_rent_pkg.lock_row_exception('ADDRESS_ID',G_LOC_RECINFO.ADDRESS_ID);
2239: END IF;
2240:
2241: IF NOT ((G_LOC_RECINFO.GROSS_AREA = X_GROSS_AREA)
2242: OR ((G_LOC_RECINFO.GROSS_AREA is null) AND (X_GROSS_AREA is null))) THEN

Line 2243: pn_var_rent_pkg.lock_row_exception('GROSS_AREA',G_LOC_RECINFO.GROSS_AREA);

2239: END IF;
2240:
2241: IF NOT ((G_LOC_RECINFO.GROSS_AREA = X_GROSS_AREA)
2242: OR ((G_LOC_RECINFO.GROSS_AREA is null) AND (X_GROSS_AREA is null))) THEN
2243: pn_var_rent_pkg.lock_row_exception('GROSS_AREA',G_LOC_RECINFO.GROSS_AREA);
2244: END IF;
2245:
2246: IF NOT ((G_LOC_RECINFO.SUITE = X_SUITE)
2247: OR ((G_LOC_RECINFO.SUITE is null) AND (X_SUITE is null))) THEN

Line 2248: pn_var_rent_pkg.lock_row_exception('SUITE',G_LOC_RECINFO.SUITE);

2244: END IF;
2245:
2246: IF NOT ((G_LOC_RECINFO.SUITE = X_SUITE)
2247: OR ((G_LOC_RECINFO.SUITE is null) AND (X_SUITE is null))) THEN
2248: pn_var_rent_pkg.lock_row_exception('SUITE',G_LOC_RECINFO.SUITE);
2249: END IF;
2250:
2251: IF NOT ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE = X_ALLOCATE_COST_CENTER_CODE)
2252: OR ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE is null) AND (X_ALLOCATE_COST_CENTER_CODE is null))) THEN

Line 2253: pn_var_rent_pkg.lock_row_exception('ALLOCATE_COST_CENTER_CODE',G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE);

2249: END IF;
2250:
2251: IF NOT ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE = X_ALLOCATE_COST_CENTER_CODE)
2252: OR ((G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE is null) AND (X_ALLOCATE_COST_CENTER_CODE is null))) THEN
2253: pn_var_rent_pkg.lock_row_exception('ALLOCATE_COST_CENTER_CODE',G_LOC_RECINFO.ALLOCATE_COST_CENTER_CODE);
2254: END IF;
2255:
2256: IF NOT ((G_LOC_RECINFO.UOM_CODE = X_UOM_CODE)
2257: OR ((G_LOC_RECINFO.UOM_CODE is null) AND (X_UOM_CODE is null))) THEN

Line 2258: pn_var_rent_pkg.lock_row_exception('UOM_CODE',G_LOC_RECINFO.UOM_CODE);

2254: END IF;
2255:
2256: IF NOT ((G_LOC_RECINFO.UOM_CODE = X_UOM_CODE)
2257: OR ((G_LOC_RECINFO.UOM_CODE is null) AND (X_UOM_CODE is null))) THEN
2258: pn_var_rent_pkg.lock_row_exception('UOM_CODE',G_LOC_RECINFO.UOM_CODE);
2259: END IF;
2260:
2261: IF NOT ((G_LOC_RECINFO.DESCRIPTION = X_DESCRIPTION)
2262: OR ((G_LOC_RECINFO.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN

Line 2263: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',G_LOC_RECINFO.DESCRIPTION);

2259: END IF;
2260:
2261: IF NOT ((G_LOC_RECINFO.DESCRIPTION = X_DESCRIPTION)
2262: OR ((G_LOC_RECINFO.DESCRIPTION is null) AND (X_DESCRIPTION is null))) THEN
2263: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',G_LOC_RECINFO.DESCRIPTION);
2264: END IF;
2265:
2266: ELSIF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('OFFICE','SECTION')) THEN
2267:

Line 2270: pn_var_rent_pkg.lock_row_exception('OFFICE',G_LOC_RECINFO.OFFICE);

2266: ELSIF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('OFFICE','SECTION')) THEN
2267:
2268: IF NOT ((G_LOC_RECINFO.OFFICE = X_OFFICE)
2269: OR ((G_LOC_RECINFO.OFFICE is null) AND (X_OFFICE is null))) THEN
2270: pn_var_rent_pkg.lock_row_exception('OFFICE',G_LOC_RECINFO.OFFICE);
2271: END IF;
2272:
2273: IF NOT ((G_LOC_RECINFO.MAX_CAPACITY = X_MAX_CAPACITY)
2274: OR ((G_LOC_RECINFO.MAX_CAPACITY is null) AND (X_MAX_CAPACITY is null))) THEN

Line 2275: pn_var_rent_pkg.lock_row_exception('MAX_CAPACITY',G_LOC_RECINFO.MAX_CAPACITY);

2271: END IF;
2272:
2273: IF NOT ((G_LOC_RECINFO.MAX_CAPACITY = X_MAX_CAPACITY)
2274: OR ((G_LOC_RECINFO.MAX_CAPACITY is null) AND (X_MAX_CAPACITY is null))) THEN
2275: pn_var_rent_pkg.lock_row_exception('MAX_CAPACITY',G_LOC_RECINFO.MAX_CAPACITY);
2276: END IF;
2277:
2278: IF NOT ((G_LOC_RECINFO.OPTIMUM_CAPACITY = X_OPTIMUM_CAPACITY)
2279: OR ((G_LOC_RECINFO.OPTIMUM_CAPACITY is null) AND (X_OPTIMUM_CAPACITY is null))) THEN

Line 2280: pn_var_rent_pkg.lock_row_exception('OPTIMUM_CAPACITY',G_LOC_RECINFO.OPTIMUM_CAPACITY);

2276: END IF;
2277:
2278: IF NOT ((G_LOC_RECINFO.OPTIMUM_CAPACITY = X_OPTIMUM_CAPACITY)
2279: OR ((G_LOC_RECINFO.OPTIMUM_CAPACITY is null) AND (X_OPTIMUM_CAPACITY is null))) THEN
2280: pn_var_rent_pkg.lock_row_exception('OPTIMUM_CAPACITY',G_LOC_RECINFO.OPTIMUM_CAPACITY);
2281: END IF;
2282:
2283: IF NOT ((G_LOC_RECINFO.RENTABLE_AREA = X_RENTABLE_AREA)
2284: OR ((G_LOC_RECINFO.RENTABLE_AREA is null) AND (X_RENTABLE_AREA is null))) THEN

Line 2285: pn_var_rent_pkg.lock_row_exception('RENTABLE_AREA',G_LOC_RECINFO.RENTABLE_AREA);

2281: END IF;
2282:
2283: IF NOT ((G_LOC_RECINFO.RENTABLE_AREA = X_RENTABLE_AREA)
2284: OR ((G_LOC_RECINFO.RENTABLE_AREA is null) AND (X_RENTABLE_AREA is null))) THEN
2285: pn_var_rent_pkg.lock_row_exception('RENTABLE_AREA',G_LOC_RECINFO.RENTABLE_AREA);
2286: END IF;
2287:
2288: IF NOT ((G_LOC_RECINFO.USABLE_AREA = X_USABLE_AREA)
2289: OR ((G_LOC_RECINFO.USABLE_AREA is null) AND (X_USABLE_AREA is null))) THEN

Line 2290: pn_var_rent_pkg.lock_row_exception('USABLE_AREA',G_LOC_RECINFO.USABLE_AREA);

2286: END IF;
2287:
2288: IF NOT ((G_LOC_RECINFO.USABLE_AREA = X_USABLE_AREA)
2289: OR ((G_LOC_RECINFO.USABLE_AREA is null) AND (X_USABLE_AREA is null))) THEN
2290: pn_var_rent_pkg.lock_row_exception('USABLE_AREA',G_LOC_RECINFO.USABLE_AREA);
2291: END IF;
2292:
2293: IF NOT ((G_LOC_RECINFO.ASSIGNABLE_AREA = X_ASSIGNABLE_AREA)
2294: OR ((G_LOC_RECINFO.ASSIGNABLE_AREA is null) AND (X_ASSIGNABLE_AREA is null))) THEN

Line 2295: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_AREA',G_LOC_RECINFO.ASSIGNABLE_AREA);

2291: END IF;
2292:
2293: IF NOT ((G_LOC_RECINFO.ASSIGNABLE_AREA = X_ASSIGNABLE_AREA)
2294: OR ((G_LOC_RECINFO.ASSIGNABLE_AREA is null) AND (X_ASSIGNABLE_AREA is null))) THEN
2295: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_AREA',G_LOC_RECINFO.ASSIGNABLE_AREA);
2296: END IF;
2297:
2298: IF NOT ((G_LOC_RECINFO.COMMON_AREA = X_COMMON_AREA)
2299: OR ((G_LOC_RECINFO.COMMON_AREA is null) AND (X_COMMON_AREA is null))) THEN

Line 2300: pn_var_rent_pkg.lock_row_exception('COMMON_AREA',G_LOC_RECINFO.COMMON_AREA);

2296: END IF;
2297:
2298: IF NOT ((G_LOC_RECINFO.COMMON_AREA = X_COMMON_AREA)
2299: OR ((G_LOC_RECINFO.COMMON_AREA is null) AND (X_COMMON_AREA is null))) THEN
2300: pn_var_rent_pkg.lock_row_exception('COMMON_AREA',G_LOC_RECINFO.COMMON_AREA);
2301: END IF;
2302:
2303: IF NOT ((G_LOC_RECINFO.SUITE = X_SUITE)
2304: OR ((G_LOC_RECINFO.SUITE is null) AND (X_SUITE is null))) THEN

Line 2305: pn_var_rent_pkg.lock_row_exception('SUITE',G_LOC_RECINFO.SUITE);

2301: END IF;
2302:
2303: IF NOT ((G_LOC_RECINFO.SUITE = X_SUITE)
2304: OR ((G_LOC_RECINFO.SUITE is null) AND (X_SUITE is null))) THEN
2305: pn_var_rent_pkg.lock_row_exception('SUITE',G_LOC_RECINFO.SUITE);
2306: END IF;
2307:
2308: IF NOT ((G_LOC_RECINFO.BOOKABLE_FLAG = X_BOOKABLE_FLAG)
2309: OR ((G_LOC_RECINFO.BOOKABLE_FLAG is null) AND (X_BOOKABLE_FLAG is null))) THEN

Line 2310: pn_var_rent_pkg.lock_row_exception('BOOKABLE_FLAG', G_LOC_RECINFO.BOOKABLE_FLAG);

2306: END IF;
2307:
2308: IF NOT ((G_LOC_RECINFO.BOOKABLE_FLAG = X_BOOKABLE_FLAG)
2309: OR ((G_LOC_RECINFO.BOOKABLE_FLAG is null) AND (X_BOOKABLE_FLAG is null))) THEN
2310: pn_var_rent_pkg.lock_row_exception('BOOKABLE_FLAG', G_LOC_RECINFO.BOOKABLE_FLAG);
2311: END IF;
2312:
2313: IF NOT ((g_loc_recinfo.occupancy_status_code = x_occupancy_status_code)
2314: OR ((g_loc_recinfo.occupancy_status_code IS NULL) AND (x_occupancy_status_code IS NULL))) THEN

Line 2315: pn_var_rent_pkg.lock_row_exception('OCCUPANCY_STATUS_CODE', g_loc_recinfo.occupancy_status_code);

2311: END IF;
2312:
2313: IF NOT ((g_loc_recinfo.occupancy_status_code = x_occupancy_status_code)
2314: OR ((g_loc_recinfo.occupancy_status_code IS NULL) AND (x_occupancy_status_code IS NULL))) THEN
2315: pn_var_rent_pkg.lock_row_exception('OCCUPANCY_STATUS_CODE', g_loc_recinfo.occupancy_status_code);
2316: END IF;
2317:
2318: IF NOT ((g_loc_recinfo.assignable_emp = x_assignable_emp)
2319: OR ((g_loc_recinfo.assignable_emp IS NULL) AND (x_assignable_emp IS NULL))) THEN

Line 2320: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_EMP', g_loc_recinfo.assignable_emp);

2316: END IF;
2317:
2318: IF NOT ((g_loc_recinfo.assignable_emp = x_assignable_emp)
2319: OR ((g_loc_recinfo.assignable_emp IS NULL) AND (x_assignable_emp IS NULL))) THEN
2320: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_EMP', g_loc_recinfo.assignable_emp);
2321: END IF;
2322:
2323: IF NOT ((g_loc_recinfo.assignable_cc = x_assignable_cc)
2324: OR ((g_loc_recinfo.assignable_cc IS NULL) AND (x_assignable_cc IS NULL))) THEN

Line 2325: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_CC', g_loc_recinfo.assignable_cc);

2321: END IF;
2322:
2323: IF NOT ((g_loc_recinfo.assignable_cc = x_assignable_cc)
2324: OR ((g_loc_recinfo.assignable_cc IS NULL) AND (x_assignable_cc IS NULL))) THEN
2325: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_CC', g_loc_recinfo.assignable_cc);
2326: END IF;
2327:
2328: IF NOT ((g_loc_recinfo.assignable_cust = x_assignable_cust)
2329: OR ((g_loc_recinfo.assignable_cust IS NULL) AND (x_assignable_cust IS NULL))) THEN

Line 2330: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_CUST', g_loc_recinfo.assignable_cust);

2326: END IF;
2327:
2328: IF NOT ((g_loc_recinfo.assignable_cust = x_assignable_cust)
2329: OR ((g_loc_recinfo.assignable_cust IS NULL) AND (x_assignable_cust IS NULL))) THEN
2330: pn_var_rent_pkg.lock_row_exception('ASSIGNABLE_CUST', g_loc_recinfo.assignable_cust);
2331: END IF;
2332:
2333: IF NOT ((g_loc_recinfo.disposition_code = x_disposition_code)
2334: OR ((g_loc_recinfo.disposition_code IS NULL) AND (x_disposition_code IS NULL))) THEN

Line 2335: pn_var_rent_pkg.lock_row_exception('DISPOSITION_CODE', g_loc_recinfo.disposition_code);

2331: END IF;
2332:
2333: IF NOT ((g_loc_recinfo.disposition_code = x_disposition_code)
2334: OR ((g_loc_recinfo.disposition_code IS NULL) AND (x_disposition_code IS NULL))) THEN
2335: pn_var_rent_pkg.lock_row_exception('DISPOSITION_CODE', g_loc_recinfo.disposition_code);
2336: END IF;
2337:
2338: IF NOT ((g_loc_recinfo.acc_treatment_code = x_acc_treatment_code)
2339: OR ((g_loc_recinfo.acc_treatment_code IS NULL) AND (x_acc_treatment_code IS NULL))) THEN

Line 2340: pn_var_rent_pkg.lock_row_exception('ACC_TREATMENT_CODE', g_loc_recinfo.acc_treatment_code);

2336: END IF;
2337:
2338: IF NOT ((g_loc_recinfo.acc_treatment_code = x_acc_treatment_code)
2339: OR ((g_loc_recinfo.acc_treatment_code IS NULL) AND (x_acc_treatment_code IS NULL))) THEN
2340: pn_var_rent_pkg.lock_row_exception('ACC_TREATMENT_CODE', g_loc_recinfo.acc_treatment_code);
2341: END IF;
2342:
2343: END IF;
2344: