DBA Data[Home] [Help]

APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_RENT_PKG

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

249: end if;
250:
251: */
252: IF NOT (tlinfo.BKDT_START_DATE = X_BKDT_START_DATE) THEN
253: pn_var_rent_pkg.lock_row_exception('BKDT_START_DATE',tlinfo.BKDT_START_DATE);
254: END IF;
255: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
256: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
257: END IF;

Line 256: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);

252: IF NOT (tlinfo.BKDT_START_DATE = X_BKDT_START_DATE) THEN
253: pn_var_rent_pkg.lock_row_exception('BKDT_START_DATE',tlinfo.BKDT_START_DATE);
254: END IF;
255: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
256: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
257: END IF;
258: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
259: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
260: END IF;

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

255: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
256: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
257: END IF;
258: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
259: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
260: END IF;
261: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
262: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
263: END IF;

Line 262: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);

258: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
259: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
260: END IF;
261: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
262: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
263: END IF;
264: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
265: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
266: END IF;

Line 265: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);

261: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
262: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
263: END IF;
264: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
265: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
266: END IF;
267: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
268: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
269: END IF;

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

264: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
265: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
266: END IF;
267: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
268: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
269: END IF;
270: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
271: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
272: END IF;

Line 271: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);

267: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
268: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
269: END IF;
270: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
271: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
272: END IF;
273: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
274: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
275: END IF;

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

270: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
271: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
272: END IF;
273: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
274: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
275: END IF;
276: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
277: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
278: END IF;

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

273: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
274: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
275: END IF;
276: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
277: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
278: END IF;
279: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
280: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
281: END IF;

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

276: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
277: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
278: END IF;
279: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
280: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
281: END IF;
282: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
283: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
284: END IF;

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

279: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
280: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
281: END IF;
282: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
283: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
284: END IF;
285: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
286: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
287: END IF;

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

282: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
283: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
284: END IF;
285: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
286: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
287: END IF;
288: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
289: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
290: END IF;

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

285: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
286: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
287: END IF;
288: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
289: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
290: END IF;
291: IF NOT (tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5) THEN
292: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
293: END IF;

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

288: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
289: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
290: END IF;
291: IF NOT (tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5) THEN
292: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
293: END IF;
294: IF NOT (tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6) THEN
295: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
296: END IF;

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

291: IF NOT (tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5) THEN
292: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
293: END IF;
294: IF NOT (tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6) THEN
295: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
296: END IF;
297: IF NOT (tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7) THEN
298: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
299: END IF;

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

294: IF NOT (tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6) THEN
295: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
296: END IF;
297: IF NOT (tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7) THEN
298: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
299: END IF;
300: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
301: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
302: END IF;

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

297: IF NOT (tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7) THEN
298: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
299: END IF;
300: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
301: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
302: END IF;
303: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
304: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
305: END IF;

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

300: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
301: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
302: END IF;
303: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
304: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
305: END IF;
306: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
307: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
308: END IF;

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

303: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
304: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
305: END IF;
306: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
307: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
308: END IF;
309: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
310: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
311: END IF;

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

306: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
307: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
308: END IF;
309: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
310: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
311: END IF;
312: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
313: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
314: END IF;

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

309: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
310: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
311: END IF;
312: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
313: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
314: END IF;
315: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
316: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
317: END IF;

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

312: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
313: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
314: END IF;
315: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
316: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
317: END IF;
318: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
319: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
320: END IF;

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

315: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
316: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
317: END IF;
318: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
319: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
320: END IF;
321: IF NOT (tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15) THEN
322: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
323: END IF;

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

318: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
319: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
320: END IF;
321: IF NOT (tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15) THEN
322: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
323: END IF;
324:
325: end loop;
326: return;