192: END IF;
193: CLOSE c1;
194:
195: IF NOT (tlinfo.INDEX_EXCLUDE_TERM_ID = X_INDEX_EXCLUDE_TERM_ID) THEN
196: pn_var_rent_pkg.lock_row_exception('INDEX_EXCLUDE_TERM_ID',tlinfo.index_exclude_term_id);
197: END IF;
198:
199: IF NOT (tlinfo.INDEX_LEASE_ID = X_INDEX_LEASE_ID) THEN
200: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
196: pn_var_rent_pkg.lock_row_exception('INDEX_EXCLUDE_TERM_ID',tlinfo.index_exclude_term_id);
197: END IF;
198:
199: IF NOT (tlinfo.INDEX_LEASE_ID = X_INDEX_LEASE_ID) THEN
200: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
201: END IF;
202:
203: IF NOT (tlinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID) THEN
204: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.payment_term_id);
200: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
201: END IF;
202:
203: IF NOT (tlinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID) THEN
204: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.payment_term_id);
205: END IF;
206:
207: IF NOT (tlinfo.INCLUDE_EXCLUDE_FLAG = X_INCLUDE_EXCLUDE_FLAG) THEN
208: pn_var_rent_pkg.lock_row_exception('INCLUDE_EXCLUDE_FLAG',tlinfo.include_exclude_flag);
204: pn_var_rent_pkg.lock_row_exception('PAYMENT_TERM_ID',tlinfo.payment_term_id);
205: END IF;
206:
207: IF NOT (tlinfo.INCLUDE_EXCLUDE_FLAG = X_INCLUDE_EXCLUDE_FLAG) THEN
208: pn_var_rent_pkg.lock_row_exception('INCLUDE_EXCLUDE_FLAG',tlinfo.include_exclude_flag);
209: END IF;
210:
211: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.lock_row (-)');
212: END LOCK_ROW;