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

Line 223: pn_var_rent_pkg.lock_row_exception('INSURANCE_REQUIREMENT_ID',tlinfo.INSURANCE_REQUIREMENT_ID);

219: END IF;
220: CLOSE c1;
221:
222: IF NOT (tlinfo.INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID) THEN
223: pn_var_rent_pkg.lock_row_exception('INSURANCE_REQUIREMENT_ID',tlinfo.INSURANCE_REQUIREMENT_ID);
224: END IF;
225:
226: IF NOT (tlinfo.INSURANCE_TYPE_LOOKUP_CODE = X_INSURANCE_TYPE_LOOKUP_CODE) THEN
227: pn_var_rent_pkg.lock_row_exception('INSURANCE_TYPE_LOOKUP_CODE',tlinfo.INSURANCE_TYPE_LOOKUP_CODE);

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

223: pn_var_rent_pkg.lock_row_exception('INSURANCE_REQUIREMENT_ID',tlinfo.INSURANCE_REQUIREMENT_ID);
224: END IF;
225:
226: IF NOT (tlinfo.INSURANCE_TYPE_LOOKUP_CODE = X_INSURANCE_TYPE_LOOKUP_CODE) THEN
227: pn_var_rent_pkg.lock_row_exception('INSURANCE_TYPE_LOOKUP_CODE',tlinfo.INSURANCE_TYPE_LOOKUP_CODE);
228: END IF;
229:
230: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
231: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

227: pn_var_rent_pkg.lock_row_exception('INSURANCE_TYPE_LOOKUP_CODE',tlinfo.INSURANCE_TYPE_LOOKUP_CODE);
228: END IF;
229:
230: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
231: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
232: END IF;
233:
234: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
235: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);

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

231: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
232: END IF;
233:
234: IF NOT (tlinfo.LEASE_CHANGE_ID = X_LEASE_CHANGE_ID) THEN
235: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
236: END IF;
237:
238: IF NOT (tlinfo.STATUS = X_STATUS) THEN
239: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);

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

235: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
236: END IF;
237:
238: IF NOT (tlinfo.STATUS = X_STATUS) THEN
239: pn_var_rent_pkg.lock_row_exception('STATUS',tlinfo.STATUS);
240: END IF;
241:
242: IF NOT ((tlinfo.INSURANCE_COMMENTS = X_INSURANCE_COMMENTS)
243: OR ((tlinfo.INSURANCE_COMMENTS IS NULL) AND (X_INSURANCE_COMMENTS IS NULL))) THEN

Line 244: pn_var_rent_pkg.lock_row_exception('INSURANCE_COMMENTS',tlinfo.INSURANCE_COMMENTS);

240: END IF;
241:
242: IF NOT ((tlinfo.INSURANCE_COMMENTS = X_INSURANCE_COMMENTS)
243: OR ((tlinfo.INSURANCE_COMMENTS IS NULL) AND (X_INSURANCE_COMMENTS IS NULL))) THEN
244: pn_var_rent_pkg.lock_row_exception('INSURANCE_COMMENTS',tlinfo.INSURANCE_COMMENTS);
245: END IF;
246:
247: IF NOT ((tlinfo.POLICY_START_DATE = X_POLICY_START_DATE)
248: OR ((tlinfo.POLICY_START_DATE IS NULL) AND (X_POLICY_START_DATE IS NULL))) THEN

Line 249: pn_var_rent_pkg.lock_row_exception('POLICY_START_DATE',tlinfo.POLICY_START_DATE);

245: END IF;
246:
247: IF NOT ((tlinfo.POLICY_START_DATE = X_POLICY_START_DATE)
248: OR ((tlinfo.POLICY_START_DATE IS NULL) AND (X_POLICY_START_DATE IS NULL))) THEN
249: pn_var_rent_pkg.lock_row_exception('POLICY_START_DATE',tlinfo.POLICY_START_DATE);
250: END IF;
251:
252: IF NOT ((tlinfo.POLICY_EXPIRATION_DATE = X_POLICY_EXPIRATION_DATE)
253: OR ((tlinfo.POLICY_EXPIRATION_DATE IS NULL) AND (X_POLICY_EXPIRATION_DATE IS NULL))) THEN

Line 254: pn_var_rent_pkg.lock_row_exception('POLICY_EXPIRATION_DATE',tlinfo.POLICY_EXPIRATION_DATE);

250: END IF;
251:
252: IF NOT ((tlinfo.POLICY_EXPIRATION_DATE = X_POLICY_EXPIRATION_DATE)
253: OR ((tlinfo.POLICY_EXPIRATION_DATE IS NULL) AND (X_POLICY_EXPIRATION_DATE IS NULL))) THEN
254: pn_var_rent_pkg.lock_row_exception('POLICY_EXPIRATION_DATE',tlinfo.POLICY_EXPIRATION_DATE);
255: END IF;
256:
257: IF NOT ((tlinfo.INSURER_NAME = X_INSURER_NAME)
258: OR ((tlinfo.INSURER_NAME IS NULL) AND (X_INSURER_NAME IS NULL))) THEN

Line 259: pn_var_rent_pkg.lock_row_exception('INSURER_NAME',tlinfo.INSURER_NAME);

255: END IF;
256:
257: IF NOT ((tlinfo.INSURER_NAME = X_INSURER_NAME)
258: OR ((tlinfo.INSURER_NAME IS NULL) AND (X_INSURER_NAME IS NULL))) THEN
259: pn_var_rent_pkg.lock_row_exception('INSURER_NAME',tlinfo.INSURER_NAME);
260: END IF;
261:
262: IF NOT ((tlinfo.POLICY_NUMBER = X_POLICY_NUMBER)
263: OR ((tlinfo.POLICY_NUMBER IS NULL) AND (X_POLICY_NUMBER IS NULL))) THEN

Line 264: pn_var_rent_pkg.lock_row_exception('POLICY_NUMBER',tlinfo.POLICY_NUMBER);

260: END IF;
261:
262: IF NOT ((tlinfo.POLICY_NUMBER = X_POLICY_NUMBER)
263: OR ((tlinfo.POLICY_NUMBER IS NULL) AND (X_POLICY_NUMBER IS NULL))) THEN
264: pn_var_rent_pkg.lock_row_exception('POLICY_NUMBER',tlinfo.POLICY_NUMBER);
265: END IF;
266:
267: IF NOT ((tlinfo.INSURED_AMOUNT = X_INSURED_AMOUNT)
268: OR ((tlinfo.INSURED_AMOUNT IS NULL) AND (X_INSURED_AMOUNT IS NULL))) THEN

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

265: END IF;
266:
267: IF NOT ((tlinfo.INSURED_AMOUNT = X_INSURED_AMOUNT)
268: OR ((tlinfo.INSURED_AMOUNT IS NULL) AND (X_INSURED_AMOUNT IS NULL))) THEN
269: pn_var_rent_pkg.lock_row_exception('INSURED_AMOUNT',tlinfo.INSURED_AMOUNT);
270: END IF;
271:
272: IF NOT ((tlinfo.REQUIRED_AMOUNT = X_REQUIRED_AMOUNT)
273: OR ((tlinfo.REQUIRED_AMOUNT IS NULL) AND (X_REQUIRED_AMOUNT IS NULL))) THEN

Line 274: pn_var_rent_pkg.lock_row_exception('REQUIRED_AMOUNT',tlinfo.REQUIRED_AMOUNT);

270: END IF;
271:
272: IF NOT ((tlinfo.REQUIRED_AMOUNT = X_REQUIRED_AMOUNT)
273: OR ((tlinfo.REQUIRED_AMOUNT IS NULL) AND (X_REQUIRED_AMOUNT IS NULL))) THEN
274: pn_var_rent_pkg.lock_row_exception('REQUIRED_AMOUNT',tlinfo.REQUIRED_AMOUNT);
275: END IF;
276:
277: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
278: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN

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

275: END IF;
276:
277: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
278: OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL))) THEN
279: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
280: END IF;
281:
282: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
283: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN

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

280: END IF;
281:
282: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
283: OR ((tlinfo.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL))) THEN
284: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
285: END IF;
286:
287: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
288: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN

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

285: END IF;
286:
287: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
288: OR ((tlinfo.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL))) THEN
289: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
290: END IF;
291:
292: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
293: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN

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

290: END IF;
291:
292: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
293: OR ((tlinfo.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL))) THEN
294: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
295: END IF;
296:
297: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
298: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN

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

295: END IF;
296:
297: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
298: OR ((tlinfo.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL))) THEN
299: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
300: END IF;
301:
302: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
303: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN

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

300: END IF;
301:
302: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
303: OR ((tlinfo.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL))) THEN
304: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
305: END IF;
306:
307: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
308: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN

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

305: END IF;
306:
307: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
308: OR ((tlinfo.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL))) THEN
309: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
310: END IF;
311:
312: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
313: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN

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

310: END IF;
311:
312: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
313: OR ((tlinfo.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL))) THEN
314: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
315: END IF;
316:
317: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
318: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN

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

315: END IF;
316:
317: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
318: OR ((tlinfo.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL))) THEN
319: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
320: END IF;
321:
322: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
323: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN

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

320: END IF;
321:
322: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
323: OR ((tlinfo.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL))) THEN
324: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
325: END IF;
326:
327: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
328: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN

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

325: END IF;
326:
327: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
328: OR ((tlinfo.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL))) THEN
329: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
330: END IF;
331:
332: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
333: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN

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

330: END IF;
331:
332: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
333: OR ((tlinfo.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL))) THEN
334: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
338: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN

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

335: END IF;
336:
337: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
338: OR ((tlinfo.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL))) THEN
339: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
343: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN

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

340: END IF;
341:
342: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
343: OR ((tlinfo.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL))) THEN
344: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
348: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN

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

345: END IF;
346:
347: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
348: OR ((tlinfo.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL))) THEN
349: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
353: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN

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

350: END IF;
351:
352: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
353: OR ((tlinfo.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL))) THEN
354: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
355: END IF;
356:
357: RETURN;
358: