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

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

227: END IF;
228: CLOSE c1;
229:
230: IF NOT (tlinfo.LEASE_MILESTONE_ID = X_LEASE_MILESTONE_ID) THEN
231: pn_var_rent_pkg.lock_row_exception('LEASE_MILESTONE_ID',tlinfo.LEASE_MILESTONE_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_MILESTONE_ID',tlinfo.LEASE_MILESTONE_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.MILESTONE_TYPE_CODE = X_MILESTONE_TYPE_CODE) THEN
239: pn_var_rent_pkg.lock_row_exception('MILESTONE_TYPE_CODE',tlinfo.MILESTONE_TYPE_CODE);

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

235: pn_var_rent_pkg.lock_row_exception('LEASE_CHANGE_ID',tlinfo.LEASE_CHANGE_ID);
236: END IF;
237:
238: IF NOT (tlinfo.MILESTONE_TYPE_CODE = X_MILESTONE_TYPE_CODE) THEN
239: pn_var_rent_pkg.lock_row_exception('MILESTONE_TYPE_CODE',tlinfo.MILESTONE_TYPE_CODE);
240: END IF;
241:
242: IF NOT ((tlinfo.OPTION_ID = X_OPTION_ID)
243: OR ((tlinfo.OPTION_ID IS NULL) AND (X_OPTION_ID IS NULL))) THEN

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

240: END IF;
241:
242: IF NOT ((tlinfo.OPTION_ID = X_OPTION_ID)
243: OR ((tlinfo.OPTION_ID IS NULL) AND (X_OPTION_ID IS NULL))) THEN
244: pn_var_rent_pkg.lock_row_exception('OPTION_ID',tlinfo.OPTION_ID);
245: END IF;
246:
247: IF NOT ((tlinfo.INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID)
248: OR ((tlinfo.INSURANCE_REQUIREMENT_ID IS NULL) AND (X_INSURANCE_REQUIREMENT_ID IS NULL))) THEN

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

245: END IF;
246:
247: IF NOT ((tlinfo.INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID)
248: OR ((tlinfo.INSURANCE_REQUIREMENT_ID IS NULL) AND (X_INSURANCE_REQUIREMENT_ID IS NULL))) THEN
249: pn_var_rent_pkg.lock_row_exception('INSURANCE_REQUIREMENT_ID',tlinfo.INSURANCE_REQUIREMENT_ID);
250: END IF;
251:
252: IF NOT ((tlinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID)
253: OR ((tlinfo.PAYMENT_TERM_ID IS NULL) AND (X_PAYMENT_TERM_ID IS NULL))) THEN

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

250: END IF;
251:
252: IF NOT ((tlinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID)
253: OR ((tlinfo.PAYMENT_TERM_ID IS NULL) AND (X_PAYMENT_TERM_ID IS NULL))) THEN
254: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.PAYMENT_TERM_ID);
255: END IF;
256:
257: IF NOT ((tlinfo.LEAD_DAYS = X_LEAD_DAYS)
258: OR ((tlinfo.LEAD_DAYS IS NULL) AND (X_LEAD_DAYS IS NULL))) THEN

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

255: END IF;
256:
257: IF NOT ((tlinfo.LEAD_DAYS = X_LEAD_DAYS)
258: OR ((tlinfo.LEAD_DAYS IS NULL) AND (X_LEAD_DAYS IS NULL))) THEN
259: pn_var_rent_pkg.lock_row_exception('LEAD_DAYS',tlinfo.LEAD_DAYS);
260: END IF;
261:
262: IF NOT ((tlinfo.EVERY_DAYS = X_EVERY_DAYS)
263: OR ((tlinfo.EVERY_DAYS IS NULL) AND (X_EVERY_DAYS IS NULL))) THEN

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

260: END IF;
261:
262: IF NOT ((tlinfo.EVERY_DAYS = X_EVERY_DAYS)
263: OR ((tlinfo.EVERY_DAYS IS NULL) AND (X_EVERY_DAYS IS NULL))) THEN
264: pn_var_rent_pkg.lock_row_exception('EVERY_DAYS',tlinfo.EVERY_DAYS);
265: END IF;
266:
267: IF NOT ((tlinfo.ACTION_TAKEN = X_ACTION_TAKEN)
268: OR ((tlinfo.ACTION_TAKEN IS NULL) AND (X_ACTION_TAKEN IS NULL))) THEN

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

265: END IF;
266:
267: IF NOT ((tlinfo.ACTION_TAKEN = X_ACTION_TAKEN)
268: OR ((tlinfo.ACTION_TAKEN IS NULL) AND (X_ACTION_TAKEN IS NULL))) THEN
269: pn_var_rent_pkg.lock_row_exception('ACTION_TAKEN',tlinfo.ACTION_TAKEN);
270: END IF;
271:
272: IF NOT ((tlinfo.ACTION_DATE = X_ACTION_DATE)
273: OR ((tlinfo.ACTION_DATE IS NULL) AND (X_ACTION_DATE IS NULL))) THEN

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

270: END IF;
271:
272: IF NOT ((tlinfo.ACTION_DATE = X_ACTION_DATE)
273: OR ((tlinfo.ACTION_DATE IS NULL) AND (X_ACTION_DATE IS NULL))) THEN
274: pn_var_rent_pkg.lock_row_exception('ACTION_DATE',tlinfo.ACTION_DATE);
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: IF NOT (tlinfo.MILESTONE_DATE = X_MILESTONE_DATE) THEN
358: pn_var_rent_pkg.lock_row_exception('MILESTONE_DATE',tlinfo.MILESTONE_DATE);

Line 358: pn_var_rent_pkg.lock_row_exception('MILESTONE_DATE',tlinfo.MILESTONE_DATE);

354: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
355: END IF;
356:
357: IF NOT (tlinfo.MILESTONE_DATE = X_MILESTONE_DATE) THEN
358: pn_var_rent_pkg.lock_row_exception('MILESTONE_DATE',tlinfo.MILESTONE_DATE);
359: END IF;
360:
361: IF NOT (tlinfo.USER_ID = X_USER_ID) THEN
362: pn_var_rent_pkg.lock_row_exception('USER_ID',tlinfo.USER_ID);

Line 362: pn_var_rent_pkg.lock_row_exception('USER_ID',tlinfo.USER_ID);

358: pn_var_rent_pkg.lock_row_exception('MILESTONE_DATE',tlinfo.MILESTONE_DATE);
359: END IF;
360:
361: IF NOT (tlinfo.USER_ID = X_USER_ID) THEN
362: pn_var_rent_pkg.lock_row_exception('USER_ID',tlinfo.USER_ID);
363: END IF;
364:
365: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
366: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);

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

362: pn_var_rent_pkg.lock_row_exception('USER_ID',tlinfo.USER_ID);
363: END IF;
364:
365: IF NOT (tlinfo.LEASE_ID = X_LEASE_ID) THEN
366: pn_var_rent_pkg.lock_row_exception('LEASE_ID',tlinfo.LEASE_ID);
367: END IF;
368:
369: RETURN;
370: