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_LOCATION_PARKS_PKG dependencies on PN_VAR_RENT_PKG

Line 168: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);

164: CLOSE c1;
165:
166: IF NOT (tlinfo.name = x_name)
167: THEN
168: pn_var_rent_pkg.lock_row_exception('NAME',tlinfo.name);
169: END IF;
170:
171: IF NOT ((tlinfo.description = x_description)
172: OR ((tlinfo.description IS NULL) AND (x_description IS NULL)))

Line 174: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',tlinfo.description);

170:
171: IF NOT ((tlinfo.description = x_description)
172: OR ((tlinfo.description IS NULL) AND (x_description IS NULL)))
173: THEN
174: pn_var_rent_pkg.lock_row_exception('DESCRIPTION',tlinfo.description);
175: END IF;
176:
177: IF NOT (tlinfo.location_park_type = x_location_park_type)
178: THEN

Line 179: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_TYPE',tlinfo.location_park_type);

175: END IF;
176:
177: IF NOT (tlinfo.location_park_type = x_location_park_type)
178: THEN
179: pn_var_rent_pkg.lock_row_exception('LOCATION_PARK_TYPE',tlinfo.location_park_type);
180: END IF;
181:
182: IF NOT ((tlinfo.parent_location_park_id = x_parent_location_park_id)
183: OR ((tlinfo.parent_location_park_id IS NULL) AND (x_parent_location_park_id IS NULL)))

Line 185: pn_var_rent_pkg.lock_row_exception('PARENT_LOCATION_PARK_ID',tlinfo.parent_location_park_id);

181:
182: IF NOT ((tlinfo.parent_location_park_id = x_parent_location_park_id)
183: OR ((tlinfo.parent_location_park_id IS NULL) AND (x_parent_location_park_id IS NULL)))
184: THEN
185: pn_var_rent_pkg.lock_row_exception('PARENT_LOCATION_PARK_ID',tlinfo.parent_location_park_id);
186: END IF;
187:
188: IF NOT ((tlinfo.attribute_category = x_attribute_category)
189: OR ((tlinfo.attribute_category IS NULL) AND (x_attribute_category IS NULL)))

Line 191: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.attribute_category);

187:
188: IF NOT ((tlinfo.attribute_category = x_attribute_category)
189: OR ((tlinfo.attribute_category IS NULL) AND (x_attribute_category IS NULL)))
190: THEN
191: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.attribute_category);
192: END IF;
193:
194: IF NOT ((tlinfo.attribute1 = x_attribute1)
195: OR ((tlinfo.attribute1 IS NULL) AND (x_attribute1 IS NULL)))

Line 197: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.attribute1);

193:
194: IF NOT ((tlinfo.attribute1 = x_attribute1)
195: OR ((tlinfo.attribute1 IS NULL) AND (x_attribute1 IS NULL)))
196: THEN
197: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.attribute1);
198: END IF;
199:
200: IF NOT ((tlinfo.attribute2 = x_attribute2)
201: OR ((tlinfo.attribute2 IS NULL) AND (x_attribute2 IS NULL)))

Line 203: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.attribute2);

199:
200: IF NOT ((tlinfo.attribute2 = x_attribute2)
201: OR ((tlinfo.attribute2 IS NULL) AND (x_attribute2 IS NULL)))
202: THEN
203: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.attribute2);
204: END IF;
205:
206: IF NOT ((tlinfo.attribute3 = x_attribute3)
207: OR ((tlinfo.attribute3 IS NULL) AND (x_attribute3 IS NULL)))

Line 209: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.attribute3);

205:
206: IF NOT ((tlinfo.attribute3 = x_attribute3)
207: OR ((tlinfo.attribute3 IS NULL) AND (x_attribute3 IS NULL)))
208: THEN
209: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.attribute3);
210: END IF;
211:
212: IF NOT ((tlinfo.attribute4 = x_attribute4)
213: OR ((tlinfo.attribute4 IS NULL) AND (x_attribute4 IS NULL)))

Line 215: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.attribute4);

211:
212: IF NOT ((tlinfo.attribute4 = x_attribute4)
213: OR ((tlinfo.attribute4 IS NULL) AND (x_attribute4 IS NULL)))
214: THEN
215: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.attribute4);
216: END IF;
217:
218: IF NOT ((tlinfo.attribute5 = x_attribute5)
219: OR ((tlinfo.attribute5 IS NULL) AND (x_attribute5 IS NULL)))

Line 221: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.attribute5);

217:
218: IF NOT ((tlinfo.attribute5 = x_attribute5)
219: OR ((tlinfo.attribute5 IS NULL) AND (x_attribute5 IS NULL)))
220: THEN
221: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.attribute5);
222: END IF;
223:
224: IF NOT ((tlinfo.attribute6 = x_attribute6)
225: OR ((tlinfo.attribute6 IS NULL) AND (x_attribute6 IS NULL)))

Line 227: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.attribute6);

223:
224: IF NOT ((tlinfo.attribute6 = x_attribute6)
225: OR ((tlinfo.attribute6 IS NULL) AND (x_attribute6 IS NULL)))
226: THEN
227: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.attribute6);
228: END IF;
229:
230: IF NOT ((tlinfo.attribute7 = x_attribute7)
231: OR ((tlinfo.attribute7 IS NULL) AND (x_attribute7 IS NULL)))

Line 233: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.attribute7);

229:
230: IF NOT ((tlinfo.attribute7 = x_attribute7)
231: OR ((tlinfo.attribute7 IS NULL) AND (x_attribute7 IS NULL)))
232: THEN
233: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.attribute7);
234: END IF;
235:
236: IF NOT ((tlinfo.attribute8 = x_attribute8)
237: OR ((tlinfo.attribute8 IS NULL) AND (x_attribute8 IS NULL)))

Line 239: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.attribute8);

235:
236: IF NOT ((tlinfo.attribute8 = x_attribute8)
237: OR ((tlinfo.attribute8 IS NULL) AND (x_attribute8 IS NULL)))
238: THEN
239: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.attribute8);
240: END IF;
241:
242: IF NOT ((tlinfo.attribute9 = x_attribute9)
243: OR ((tlinfo.attribute9 IS NULL) AND (x_attribute9 IS NULL)))

Line 245: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.attribute9);

241:
242: IF NOT ((tlinfo.attribute9 = x_attribute9)
243: OR ((tlinfo.attribute9 IS NULL) AND (x_attribute9 IS NULL)))
244: THEN
245: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.attribute9);
246: END IF;
247:
248: IF NOT ((tlinfo.attribute10 = x_attribute10)
249: OR ((tlinfo.attribute10 IS NULL) AND (x_attribute10 IS NULL)))

Line 251: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.attribute10);

247:
248: IF NOT ((tlinfo.attribute10 = x_attribute10)
249: OR ((tlinfo.attribute10 IS NULL) AND (x_attribute10 IS NULL)))
250: THEN
251: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.attribute10);
252: END IF;
253:
254: IF NOT ((tlinfo.attribute11 = x_attribute11)
255: OR ((tlinfo.attribute11 IS NULL) AND (x_attribute11 IS NULL)))

Line 257: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.attribute11);

253:
254: IF NOT ((tlinfo.attribute11 = x_attribute11)
255: OR ((tlinfo.attribute11 IS NULL) AND (x_attribute11 IS NULL)))
256: THEN
257: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.attribute11);
258: END IF;
259:
260: IF NOT ((tlinfo.attribute12 = x_attribute12)
261: OR ((tlinfo.attribute12 IS NULL) AND (x_attribute12 IS NULL)))

Line 263: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.attribute12);

259:
260: IF NOT ((tlinfo.attribute12 = x_attribute12)
261: OR ((tlinfo.attribute12 IS NULL) AND (x_attribute12 IS NULL)))
262: THEN
263: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.attribute12);
264: END IF;
265:
266: IF NOT ((tlinfo.attribute13 = x_attribute13)
267: OR ((tlinfo.attribute13 IS NULL) AND (x_attribute13 IS NULL)))

Line 269: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.attribute13);

265:
266: IF NOT ((tlinfo.attribute13 = x_attribute13)
267: OR ((tlinfo.attribute13 IS NULL) AND (x_attribute13 IS NULL)))
268: THEN
269: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.attribute13);
270: END IF;
271:
272: IF NOT ((tlinfo.attribute14 = x_attribute14)
273: OR ((tlinfo.attribute14 IS NULL) AND (x_attribute14 IS NULL)))

Line 275: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.attribute14);

271:
272: IF NOT ((tlinfo.attribute14 = x_attribute14)
273: OR ((tlinfo.attribute14 IS NULL) AND (x_attribute14 IS NULL)))
274: THEN
275: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.attribute14);
276: END IF;
277:
278: IF NOT ((tlinfo.attribute15 = x_attribute15)
279: OR ((tlinfo.attribute15 IS NULL) AND (x_attribute15 IS NULL)))

Line 281: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);

277:
278: IF NOT ((tlinfo.attribute15 = x_attribute15)
279: OR ((tlinfo.attribute15 IS NULL) AND (x_attribute15 IS NULL)))
280: THEN
281: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);
282: END IF;
283:
284: RETURN;
285: