APPS.PN_INDEX_LEASE_CONSTRAINTS_PKG dependencies on PN_VAR_RENT_PKG

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

340: END IF;
341: CLOSE c1;
342:
343: IF NOT (tlinfo.index_constraint_id = x_index_constraint_id) THEN
344: pn_var_rent_pkg.lock_row_exception('INDEX_CONSTRAINT_ID',tlinfo.index_constraint_id);
345: END IF;
346:
347: IF NOT (tlinfo.index_lease_id = x_index_lease_id) THEN
348: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);

Line 348: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);

344: pn_var_rent_pkg.lock_row_exception('INDEX_CONSTRAINT_ID',tlinfo.index_constraint_id);
345: END IF;
346:
347: IF NOT (tlinfo.index_lease_id = x_index_lease_id) THEN
348: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
349: END IF;
350:
351: IF NOT (tlinfo.scope = x_scope) THEN
352: pn_var_rent_pkg.lock_row_exception('SCOPE',tlinfo.scope);

Line 352: pn_var_rent_pkg.lock_row_exception('SCOPE',tlinfo.scope);

348: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
349: END IF;
350:
351: IF NOT (tlinfo.scope = x_scope) THEN
352: pn_var_rent_pkg.lock_row_exception('SCOPE',tlinfo.scope);
353: END IF;
354:
355: IF NOT ((tlinfo.minimum_amount = x_minimum_amount)
356: OR ((tlinfo.minimum_amount IS NULL) AND x_minimum_amount IS NULL)) THEN

Line 357: pn_var_rent_pkg.lock_row_exception('MINIMUM_AMOUNT',tlinfo.minimum_amount);

353: END IF;
354:
355: IF NOT ((tlinfo.minimum_amount = x_minimum_amount)
356: OR ((tlinfo.minimum_amount IS NULL) AND x_minimum_amount IS NULL)) THEN
357: pn_var_rent_pkg.lock_row_exception('MINIMUM_AMOUNT',tlinfo.minimum_amount);
358: END IF;
359:
360: IF NOT ((tlinfo.maximum_amount = x_maximum_amount)
361: OR ((tlinfo.maximum_amount IS NULL) AND x_maximum_amount IS NULL)) THEN

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

358: END IF;
359:
360: IF NOT ((tlinfo.maximum_amount = x_maximum_amount)
361: OR ((tlinfo.maximum_amount IS NULL) AND x_maximum_amount IS NULL)) THEN
362: pn_var_rent_pkg.lock_row_exception('MAXIMUM_AMOUNT',tlinfo.maximum_amount);
363: END IF;
364:
365: IF NOT ((tlinfo.minimum_percent = x_minimum_percent)
366: OR ((tlinfo.minimum_percent IS NULL) AND x_minimum_percent IS NULL)) THEN

Line 367: pn_var_rent_pkg.lock_row_exception('MINIMUM_PERCENT',tlinfo.minimum_percent);

363: END IF;
364:
365: IF NOT ((tlinfo.minimum_percent = x_minimum_percent)
366: OR ((tlinfo.minimum_percent IS NULL) AND x_minimum_percent IS NULL)) THEN
367: pn_var_rent_pkg.lock_row_exception('MINIMUM_PERCENT',tlinfo.minimum_percent);
368: END IF;
369:
370: IF NOT ((tlinfo.maximum_percent = x_maximum_percent)
371: OR ((tlinfo.maximum_percent IS NULL) AND x_maximum_percent IS NULL)) THEN

Line 372: pn_var_rent_pkg.lock_row_exception('MAXIMUM_PERCENT',tlinfo.maximum_percent);

368: END IF;
369:
370: IF NOT ((tlinfo.maximum_percent = x_maximum_percent)
371: OR ((tlinfo.maximum_percent IS NULL) AND x_maximum_percent IS NULL)) THEN
372: pn_var_rent_pkg.lock_row_exception('MAXIMUM_PERCENT',tlinfo.maximum_percent);
373: END IF;
374:
375: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_CONSTRAINTS_PKG.lock_row (-)');
376: END lock_row;