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.PNT_PHONE_PKG dependencies on PN_VAR_RENT_PKG

Line 242: pn_var_rent_pkg.lock_row_exception('phone_number',Recinfo.phone_number);

238: end if;
239: CLOSE C;
240:
241: IF NOT (Recinfo.phone_number = X_Phone_Number) THEN
242: pn_var_rent_pkg.lock_row_exception('phone_number',Recinfo.phone_number);
243: END IF;
244: IF NOT (Recinfo.status = X_Status) THEN
245: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
246: END IF;

Line 245: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);

241: IF NOT (Recinfo.phone_number = X_Phone_Number) THEN
242: pn_var_rent_pkg.lock_row_exception('phone_number',Recinfo.phone_number);
243: END IF;
244: IF NOT (Recinfo.status = X_Status) THEN
245: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
246: END IF;
247: IF NOT (Recinfo.phone_type = X_Phone_Type) THEN
248: pn_var_rent_pkg.lock_row_exception('phone_type',Recinfo.phone_type);
249: END IF;

Line 248: pn_var_rent_pkg.lock_row_exception('phone_type',Recinfo.phone_type);

244: IF NOT (Recinfo.status = X_Status) THEN
245: pn_var_rent_pkg.lock_row_exception('status',Recinfo.status);
246: END IF;
247: IF NOT (Recinfo.phone_type = X_Phone_Type) THEN
248: pn_var_rent_pkg.lock_row_exception('phone_type',Recinfo.phone_type);
249: END IF;
250: IF NOT ( (Recinfo.area_code = X_Area_Code)
251: OR ((Recinfo.area_code IS NULL) AND (X_Area_Code IS NULL))) THEN
252: pn_var_rent_pkg.lock_row_exception('area_code',Recinfo.area_code);

Line 252: pn_var_rent_pkg.lock_row_exception('area_code',Recinfo.area_code);

248: pn_var_rent_pkg.lock_row_exception('phone_type',Recinfo.phone_type);
249: END IF;
250: IF NOT ( (Recinfo.area_code = X_Area_Code)
251: OR ((Recinfo.area_code IS NULL) AND (X_Area_Code IS NULL))) THEN
252: pn_var_rent_pkg.lock_row_exception('area_code',Recinfo.area_code);
253: END IF;
254: IF NOT ( (Recinfo.extension = X_Extension)
255: OR ((Recinfo.extension IS NULL) AND (X_Extension IS NULL))) THEN
256: pn_var_rent_pkg.lock_row_exception('extension',Recinfo.extension);

Line 256: pn_var_rent_pkg.lock_row_exception('extension',Recinfo.extension);

252: pn_var_rent_pkg.lock_row_exception('area_code',Recinfo.area_code);
253: END IF;
254: IF NOT ( (Recinfo.extension = X_Extension)
255: OR ((Recinfo.extension IS NULL) AND (X_Extension IS NULL))) THEN
256: pn_var_rent_pkg.lock_row_exception('extension',Recinfo.extension);
257: END IF;
258: IF NOT ( (Recinfo.primary_flag = X_Primary_Flag)
259: OR ((Recinfo.primary_flag IS NULL) AND (X_Primary_Flag IS NULL))) THEN
260: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);

Line 260: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);

256: pn_var_rent_pkg.lock_row_exception('extension',Recinfo.extension);
257: END IF;
258: IF NOT ( (Recinfo.primary_flag = X_Primary_Flag)
259: OR ((Recinfo.primary_flag IS NULL) AND (X_Primary_Flag IS NULL))) THEN
260: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);
261: END IF;
262: IF NOT ( (Recinfo.attribute_category = X_Attribute_Category)
263: OR ((Recinfo.attribute_category IS NULL) AND (X_Attribute_Category IS NULL))) THEN
264: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

Line 264: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);

260: pn_var_rent_pkg.lock_row_exception('primary_flag',Recinfo.primary_flag);
261: END IF;
262: IF NOT ( (Recinfo.attribute_category = X_Attribute_Category)
263: OR ((Recinfo.attribute_category IS NULL) AND (X_Attribute_Category IS NULL))) THEN
264: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
265: END IF;
266: IF NOT ( (Recinfo.attribute1 = X_Attribute1)
267: OR ((Recinfo.attribute1 IS NULL) AND (X_Attribute1 IS NULL))) THEN
268: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

Line 268: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);

264: pn_var_rent_pkg.lock_row_exception('attribute_category',Recinfo.attribute_category);
265: END IF;
266: IF NOT ( (Recinfo.attribute1 = X_Attribute1)
267: OR ((Recinfo.attribute1 IS NULL) AND (X_Attribute1 IS NULL))) THEN
268: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
269: END IF;
270: IF NOT ( (Recinfo.attribute2 = X_Attribute2)
271: OR ((Recinfo.attribute2 IS NULL) AND (X_Attribute2 IS NULL))) THEN
272: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

Line 272: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);

268: pn_var_rent_pkg.lock_row_exception('attribute1',Recinfo.attribute1);
269: END IF;
270: IF NOT ( (Recinfo.attribute2 = X_Attribute2)
271: OR ((Recinfo.attribute2 IS NULL) AND (X_Attribute2 IS NULL))) THEN
272: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
273: END IF;
274: IF NOT ( (Recinfo.attribute3 = X_Attribute3)
275: OR ((Recinfo.attribute3 IS NULL) AND (X_Attribute3 IS NULL))) THEN
276: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

Line 276: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);

272: pn_var_rent_pkg.lock_row_exception('attribute2',Recinfo.attribute2);
273: END IF;
274: IF NOT ( (Recinfo.attribute3 = X_Attribute3)
275: OR ((Recinfo.attribute3 IS NULL) AND (X_Attribute3 IS NULL))) THEN
276: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
277: END IF;
278: IF NOT ( (Recinfo.attribute4 = X_Attribute4)
279: OR ((Recinfo.attribute4 IS NULL) AND (X_Attribute4 IS NULL))) THEN
280: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

Line 280: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);

276: pn_var_rent_pkg.lock_row_exception('attribute3',Recinfo.attribute3);
277: END IF;
278: IF NOT ( (Recinfo.attribute4 = X_Attribute4)
279: OR ((Recinfo.attribute4 IS NULL) AND (X_Attribute4 IS NULL))) THEN
280: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
281: END IF;
282: IF NOT ( (Recinfo.attribute5 = X_Attribute5)
283: OR ((Recinfo.attribute5 IS NULL) AND (X_Attribute5 IS NULL))) THEN
284: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

Line 284: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);

280: pn_var_rent_pkg.lock_row_exception('attribute4',Recinfo.attribute4);
281: END IF;
282: IF NOT ( (Recinfo.attribute5 = X_Attribute5)
283: OR ((Recinfo.attribute5 IS NULL) AND (X_Attribute5 IS NULL))) THEN
284: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
285: END IF;
286: IF NOT ( (Recinfo.attribute6 = X_Attribute6)
287: OR ((Recinfo.attribute6 IS NULL) AND (X_Attribute6 IS NULL))) THEN
288: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

Line 288: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);

284: pn_var_rent_pkg.lock_row_exception('attribute5',Recinfo.attribute5);
285: END IF;
286: IF NOT ( (Recinfo.attribute6 = X_Attribute6)
287: OR ((Recinfo.attribute6 IS NULL) AND (X_Attribute6 IS NULL))) THEN
288: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
289: END IF;
290: IF NOT ( (Recinfo.attribute7 = X_Attribute7)
291: OR ((Recinfo.attribute7 IS NULL) AND (X_Attribute7 IS NULL))) THEN
292: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

Line 292: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);

288: pn_var_rent_pkg.lock_row_exception('attribute6',Recinfo.attribute6);
289: END IF;
290: IF NOT ( (Recinfo.attribute7 = X_Attribute7)
291: OR ((Recinfo.attribute7 IS NULL) AND (X_Attribute7 IS NULL))) THEN
292: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
293: END IF;
294: IF NOT ( (Recinfo.attribute8 = X_Attribute8)
295: OR ((Recinfo.attribute8 IS NULL) AND (X_Attribute8 IS NULL))) THEN
296: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

Line 296: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);

292: pn_var_rent_pkg.lock_row_exception('attribute7',Recinfo.attribute7);
293: END IF;
294: IF NOT ( (Recinfo.attribute8 = X_Attribute8)
295: OR ((Recinfo.attribute8 IS NULL) AND (X_Attribute8 IS NULL))) THEN
296: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
297: END IF;
298: IF NOT ( (Recinfo.attribute9 = X_Attribute9)
299: OR ((Recinfo.attribute9 IS NULL) AND (X_Attribute9 IS NULL))) THEN
300: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

Line 300: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);

296: pn_var_rent_pkg.lock_row_exception('attribute8',Recinfo.attribute8);
297: END IF;
298: IF NOT ( (Recinfo.attribute9 = X_Attribute9)
299: OR ((Recinfo.attribute9 IS NULL) AND (X_Attribute9 IS NULL))) THEN
300: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
301: END IF;
302: IF NOT ( (Recinfo.attribute10 = X_Attribute10)
303: OR ((Recinfo.attribute10 IS NULL) AND (X_Attribute10 IS NULL))) THEN
304: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

Line 304: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);

300: pn_var_rent_pkg.lock_row_exception('attribute9',Recinfo.attribute9);
301: END IF;
302: IF NOT ( (Recinfo.attribute10 = X_Attribute10)
303: OR ((Recinfo.attribute10 IS NULL) AND (X_Attribute10 IS NULL))) THEN
304: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
305: END IF;
306: IF NOT ( (Recinfo.attribute11 = X_Attribute11)
307: OR ((Recinfo.attribute11 IS NULL) AND (X_Attribute11 IS NULL))) THEN
308: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

Line 308: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);

304: pn_var_rent_pkg.lock_row_exception('attribute10',Recinfo.attribute10);
305: END IF;
306: IF NOT ( (Recinfo.attribute11 = X_Attribute11)
307: OR ((Recinfo.attribute11 IS NULL) AND (X_Attribute11 IS NULL))) THEN
308: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
309: END IF;
310: IF NOT ( (Recinfo.attribute12 = X_Attribute12)
311: OR ((Recinfo.attribute12 IS NULL) AND (X_Attribute12 IS NULL))) THEN
312: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

Line 312: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);

308: pn_var_rent_pkg.lock_row_exception('attribute11',Recinfo.attribute11);
309: END IF;
310: IF NOT ( (Recinfo.attribute12 = X_Attribute12)
311: OR ((Recinfo.attribute12 IS NULL) AND (X_Attribute12 IS NULL))) THEN
312: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
313: END IF;
314: IF NOT ( (Recinfo.attribute13 = X_Attribute13)
315: OR ((Recinfo.attribute13 IS NULL) AND (X_Attribute13 IS NULL))) THEN
316: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

Line 316: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);

312: pn_var_rent_pkg.lock_row_exception('attribute12',Recinfo.attribute12);
313: END IF;
314: IF NOT ( (Recinfo.attribute13 = X_Attribute13)
315: OR ((Recinfo.attribute13 IS NULL) AND (X_Attribute13 IS NULL))) THEN
316: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
317: END IF;
318: IF NOT ( (Recinfo.attribute14 = X_Attribute14)
319: OR ((Recinfo.attribute14 IS NULL) AND (X_Attribute14 IS NULL))) THEN
320: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

Line 320: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);

316: pn_var_rent_pkg.lock_row_exception('attribute13',Recinfo.attribute13);
317: END IF;
318: IF NOT ( (Recinfo.attribute14 = X_Attribute14)
319: OR ((Recinfo.attribute14 IS NULL) AND (X_Attribute14 IS NULL))) THEN
320: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
321: END IF;
322: IF NOT ( (Recinfo.attribute15 = X_Attribute15)
323: OR ((Recinfo.attribute15 IS NULL) AND (X_Attribute15 IS NULL))) THEN
324: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

Line 324: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);

320: pn_var_rent_pkg.lock_row_exception('attribute14',Recinfo.attribute14);
321: END IF;
322: IF NOT ( (Recinfo.attribute15 = X_Attribute15)
323: OR ((Recinfo.attribute15 IS NULL) AND (X_Attribute15 IS NULL))) THEN
324: pn_var_rent_pkg.lock_row_exception('attribute15',Recinfo.attribute15);
325: END IF;
326:
327: END Lock_Row;
328: