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

Line 205: pn_var_rent_pkg.lock_row_exception('COMPANY_ID',tlinfo.COMPANY_ID);

201: END IF;
202: CLOSE c;
203:
204: IF NOT (tlinfo.COMPANY_ID = X_COMPANY_ID) THEN
205: pn_var_rent_pkg.lock_row_exception('COMPANY_ID',tlinfo.COMPANY_ID);
206: END IF;
207:
208: IF NOT (tlinfo.COMPANY_SITE_ID = X_COMPANY_SITE_ID) THEN
209: pn_var_rent_pkg.lock_row_exception('COMPANY_SITE_ID',tlinfo.COMPANY_SITE_ID);

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

205: pn_var_rent_pkg.lock_row_exception('COMPANY_ID',tlinfo.COMPANY_ID);
206: END IF;
207:
208: IF NOT (tlinfo.COMPANY_SITE_ID = X_COMPANY_SITE_ID) THEN
209: pn_var_rent_pkg.lock_row_exception('COMPANY_SITE_ID',tlinfo.COMPANY_SITE_ID);
210: END IF;
211:
212: IF NOT ((tlinfo.LEASE_ID = X_LEASE_ID)
213: OR ((tlinfo.LEASE_ID IS NULL) AND (X_LEASE_ID IS NULL))) THEN

Line 214: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

210: END IF;
211:
212: IF NOT ((tlinfo.LEASE_ID = X_LEASE_ID)
213: OR ((tlinfo.LEASE_ID IS NULL) AND (X_LEASE_ID IS NULL))) THEN
214: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
215: END IF;
216:
217: IF NOT ((tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID)
218: OR ((tlinfo.LEASE_CHANGE_ID IS NULL) AND (X_LEASE_CHANGE_ID IS NULL))) THEN

Line 219: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);

215: END IF;
216:
217: IF NOT ((tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID)
218: OR ((tlinfo.LEASE_CHANGE_ID IS NULL) AND (X_LEASE_CHANGE_ID IS NULL))) THEN
219: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
220: END IF;
221:
222: IF NOT ((tlinfo.LOCATION_ID = X_LOCATION_ID)
223: OR ((tlinfo.LOCATION_ID IS NULL) AND (X_LOCATION_ID IS NULL))) THEN

Line 224: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);

220: END IF;
221:
222: IF NOT ((tlinfo.LOCATION_ID = X_LOCATION_ID)
223: OR ((tlinfo.LOCATION_ID IS NULL) AND (X_LOCATION_ID IS NULL))) THEN
224: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
225: END IF;
226:
227: IF NOT (tlinfo.STATUS = X_STATUS) THEN
228: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);

Line 228: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);

224: pn_var_rent_pkg.lock_row_exception('LOCATION_ID',tlinfo.LOCATION_ID);
225: END IF;
226:
227: IF NOT (tlinfo.STATUS = X_STATUS) THEN
228: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
229: END IF;
230:
231: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
232: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

229: END IF;
230:
231: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
232: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
233: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
234: END IF;
235:
236: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
237: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

234: END IF;
235:
236: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
237: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
238: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
239: END IF;
240:
241: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
242: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

239: END IF;
240:
241: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
242: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
243: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
244: END IF;
245:
246: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
247: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

244: END IF;
245:
246: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
247: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
248: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
249: END IF;
250:
251: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
252: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

249: END IF;
250:
251: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
252: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
253: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
254: END IF;
255:
256: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
257: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

254: END IF;
255:
256: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
257: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
258: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
259: END IF;
260:
261: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
262: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

259: END IF;
260:
261: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
262: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
263: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
264: END IF;
265:
266: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
267: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

264: END IF;
265:
266: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
267: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
268: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
269: END IF;
270:
271: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
272: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

269: END IF;
270:
271: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
272: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
273: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
274: END IF;
275:
276: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
277: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

274: END IF;
275:
276: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
277: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
278: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
279: END IF;
280:
281: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
282: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

279: END IF;
280:
281: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
282: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
283: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
284: END IF;
285:
286: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
287: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

284: END IF;
285:
286: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
287: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
288: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
289: END IF;
290:
291: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
292: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

289: END IF;
290:
291: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
292: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
293: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
294: END IF;
295:
296: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
297: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

294: END IF;
295:
296: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
297: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
298: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
299: END IF;
300:
301: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
302: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

299: END IF;
300:
301: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
302: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
303: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
304: END IF;
305:
306: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
307: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

304: END IF;
305:
306: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
307: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
308: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
309: END IF;
310:
311: RETURN;
312: