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

Line 162: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_HEADER_ID',tlinfo.NOTE_HEADER_ID);

158: close c1;
159: --3626177
160:
161: IF NOT (tlinfo.NOTE_HEADER_ID = X_NOTE_HEADER_ID) THEN
162: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_HEADER_ID',tlinfo.NOTE_HEADER_ID);
163: END IF;
164:
165: IF NOT ((tlinfo.NOTE_TYPE_LOOKUP_CODE = X_NOTE_TYPE_LOOKUP_CODE)
166: OR ((tlinfo.NOTE_TYPE_LOOKUP_CODE is null) AND (X_NOTE_TYPE_LOOKUP_CODE is null))) THEN

Line 167: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_TYPE_LOOKUP_CODE',tlinfo.NOTE_TYPE_LOOKUP_CODE);

163: END IF;
164:
165: IF NOT ((tlinfo.NOTE_TYPE_LOOKUP_CODE = X_NOTE_TYPE_LOOKUP_CODE)
166: OR ((tlinfo.NOTE_TYPE_LOOKUP_CODE is null) AND (X_NOTE_TYPE_LOOKUP_CODE is null))) THEN
167: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_TYPE_LOOKUP_CODE',tlinfo.NOTE_TYPE_LOOKUP_CODE);
168: END IF;
169:
170: IF NOT ((tlinfo.NOTE_DATE = X_NOTE_DATE)
171: OR ((tlinfo.NOTE_DATE is null) AND (X_NOTE_DATE is null))) THEN

Line 172: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_DATE',tlinfo.NOTE_DATE);

168: END IF;
169:
170: IF NOT ((tlinfo.NOTE_DATE = X_NOTE_DATE)
171: OR ((tlinfo.NOTE_DATE is null) AND (X_NOTE_DATE is null))) THEN
172: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('NOTE_DATE',tlinfo.NOTE_DATE);
173: END IF;
174:
175: IF NOT ((tlinfo.LEASE_ID = X_LEASE_ID)
176: OR ((tlinfo.LEASE_ID is null) AND (X_LEASE_ID is null))) THEN

Line 177: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LEASE_ID',tlinfo.LEASE_ID);

173: END IF;
174:
175: IF NOT ((tlinfo.LEASE_ID = X_LEASE_ID)
176: OR ((tlinfo.LEASE_ID is null) AND (X_LEASE_ID is null))) THEN
177: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('LEASE_ID',tlinfo.LEASE_ID);
178: END IF;
179:
180:
181: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)

Line 183: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);

179:
180:
181: IF NOT ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
182: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null))) THEN
183: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE_CATEGORY',tlinfo.ATTRIBUTE_CATEGORY);
184: END IF;
185:
186: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
187: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN

Line 188: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);

184: END IF;
185:
186: IF NOT ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
187: OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null))) THEN
188: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE1',tlinfo.ATTRIBUTE1);
189: END IF;
190:
191: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
192: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN

Line 193: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2',tlinfo.ATTRIBUTE2);

189: END IF;
190:
191: IF NOT ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
192: OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null))) THEN
193: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE2',tlinfo.ATTRIBUTE2);
194: END IF;
195:
196: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
197: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN

Line 198: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3',tlinfo.ATTRIBUTE3);

194: END IF;
195:
196: IF NOT ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
197: OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null))) THEN
198: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE3',tlinfo.ATTRIBUTE3);
199: END IF;
200:
201: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
202: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN

Line 203: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4',tlinfo.ATTRIBUTE4);

199: END IF;
200:
201: IF NOT ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
202: OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null))) THEN
203: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE4',tlinfo.ATTRIBUTE4);
204: END IF;
205:
206: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
207: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN

Line 208: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);

204: END IF;
205:
206: IF NOT ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
207: OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null))) THEN
208: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE5',tlinfo.ATTRIBUTE5);
209: END IF;
210:
211: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
212: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN

Line 213: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);

209: END IF;
210:
211: IF NOT ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
212: OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null))) THEN
213: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE6',tlinfo.ATTRIBUTE6);
214: END IF;
215:
216: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
217: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN

Line 218: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);

214: END IF;
215:
216: IF NOT ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
217: OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null))) THEN
218: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE7',tlinfo.ATTRIBUTE7);
219: END IF;
220:
221: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
222: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN

Line 223: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8',tlinfo.ATTRIBUTE8);

219: END IF;
220:
221: IF NOT ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
222: OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null))) THEN
223: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE8',tlinfo.ATTRIBUTE8);
224: END IF;
225:
226: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
227: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN

Line 228: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);

224: END IF;
225:
226: IF NOT ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
227: OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null))) THEN
228: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE9',tlinfo.ATTRIBUTE9);
229: END IF;
230:
231: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
232: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN

Line 233: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10',tlinfo.ATTRIBUTE10);

229: END IF;
230:
231: IF NOT ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
232: OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null))) THEN
233: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE10',tlinfo.ATTRIBUTE10);
234: END IF;
235:
236: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
237: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN

Line 238: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);

234: END IF;
235:
236: IF NOT ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
237: OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null))) THEN
238: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE11',tlinfo.ATTRIBUTE11);
239: END IF;
240:
241:
242: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)

Line 244: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);

240:
241:
242: IF NOT ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
243: OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null))) THEN
244: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE12',tlinfo.ATTRIBUTE12);
245: END IF;
246:
247: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
248: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN

Line 249: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);

245: END IF;
246:
247: IF NOT ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
248: OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null))) THEN
249: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE13',tlinfo.ATTRIBUTE13);
250: END IF;
251:
252: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
253: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN

Line 254: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);

250: END IF;
251:
252: IF NOT ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
253: OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null))) THEN
254: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE14',tlinfo.ATTRIBUTE14);
255: END IF;
256:
257:
258: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)

Line 260: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);

256:
257:
258: IF NOT ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
259: OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN
260: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
261: END IF;
262:
263: RETURN;
264: END LOCK_ROW;