DBA Data[Home] [Help]

APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_RENT_PKG

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

217: end if;
218:
219: */
220: IF NOT (tlinfo.BKDT_START_DATE = X_BKDT_START_DATE) THEN
221: pn_var_rent_pkg.lock_row_exception('BKDT_START_DATE',tlinfo.BKDT_START_DATE);
222: END IF;
223: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
224: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
225: END IF;

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

220: IF NOT (tlinfo.BKDT_START_DATE = X_BKDT_START_DATE) THEN
221: pn_var_rent_pkg.lock_row_exception('BKDT_START_DATE',tlinfo.BKDT_START_DATE);
222: END IF;
223: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
224: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
225: END IF;
226: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
227: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
228: END IF;

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

223: IF NOT (tlinfo.BKDT_END_DATE = X_BKDT_END_DATE) THEN
224: pn_var_rent_pkg.lock_row_exception('BKDT_END_DATE',tlinfo.BKDT_END_DATE);
225: END IF;
226: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
227: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
228: END IF;
229: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
230: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
231: END IF;

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

226: IF NOT (tlinfo.PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START) THEN
227: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_START',tlinfo.PERIOD_BKPT_VOL_START);
228: END IF;
229: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
230: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
231: END IF;
232: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
233: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
234: END IF;

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

229: IF NOT (tlinfo.PERIOD_BKPT_VOL_END = X_PERIOD_BKPT_VOL_END) THEN
230: pn_var_rent_pkg.lock_row_exception('PERIOD_BKPT_VOL_END',tlinfo.PERIOD_BKPT_VOL_END);
231: END IF;
232: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
233: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
234: END IF;
235: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
236: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
237: END IF;

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

232: IF NOT (tlinfo.GROUP_BKPT_VOL_START = X_GROUP_BKPT_VOL_START) THEN
233: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_START',tlinfo.GROUP_BKPT_VOL_START);
234: END IF;
235: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
236: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
237: END IF;
238: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
239: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
240: END IF;

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

235: IF NOT (tlinfo.GROUP_BKPT_VOL_END = X_GROUP_BKPT_VOL_END) THEN
236: pn_var_rent_pkg.lock_row_exception('GROUP_BKPT_VOL_END',tlinfo.GROUP_BKPT_VOL_END);
237: END IF;
238: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
239: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
240: END IF;
241: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
242: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
243: END IF;

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

238: IF NOT (tlinfo.BKPT_RATE = X_BKPT_RATE) THEN
239: pn_var_rent_pkg.lock_row_exception('BKPT_RATE',tlinfo.BKPT_RATE);
240: END IF;
241: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
242: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
243: END IF;
244: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
245: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
246: END IF;

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

241: IF NOT (tlinfo.ANNUAL_BASIS_AMOUNT = X_ANNUAL_BASIS_AMOUNT) THEN
242: pn_var_rent_pkg.lock_row_exception('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
243: END IF;
244: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
245: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
246: END IF;
247: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
248: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
249: END IF;

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

244: IF NOT (tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY) THEN
245: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
246: END IF;
247: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
248: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
249: END IF;
250: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
251: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
252: END IF;

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

247: IF NOT (tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1) THEN
248: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
249: END IF;
250: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
251: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
252: END IF;
253: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
254: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
255: END IF;

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

250: IF NOT (tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2) THEN
251: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
252: END IF;
253: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
254: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
255: END IF;
256: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
257: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
258: END IF;

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

253: IF NOT (tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3) THEN
254: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
255: END IF;
256: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
257: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
258: END IF;
259: IF NOT (tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5) THEN
260: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
261: END IF;

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

256: IF NOT (tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4) THEN
257: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
258: END IF;
259: IF NOT (tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5) THEN
260: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
261: END IF;
262: IF NOT (tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6) THEN
263: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
264: END IF;

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

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

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

262: IF NOT (tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6) THEN
263: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
264: END IF;
265: IF NOT (tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7) THEN
266: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
267: END IF;
268: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
269: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
270: END IF;

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

265: IF NOT (tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7) THEN
266: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
267: END IF;
268: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
269: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
270: END IF;
271: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
272: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
273: END IF;

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

268: IF NOT (tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8) THEN
269: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
270: END IF;
271: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
272: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
273: END IF;
274: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
275: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
276: END IF;

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

271: IF NOT (tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9) THEN
272: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
273: END IF;
274: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
275: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
276: END IF;
277: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
278: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
279: END IF;

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

274: IF NOT (tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10) THEN
275: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
276: END IF;
277: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
278: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
279: END IF;
280: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
281: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
282: END IF;

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

277: IF NOT (tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11) THEN
278: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
279: END IF;
280: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
281: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
282: END IF;
283: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
284: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
285: END IF;

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

280: IF NOT (tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12) THEN
281: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
282: END IF;
283: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
284: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
285: END IF;
286: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
287: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
288: END IF;

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

283: IF NOT (tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13) THEN
284: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
285: END IF;
286: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
287: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
288: END IF;
289: IF NOT (tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15) THEN
290: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
291: END IF;

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

286: IF NOT (tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14) THEN
287: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
288: END IF;
289: IF NOT (tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15) THEN
290: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
291: END IF;
292:
293: end loop;
294: return;