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

Line 210: pn_var_rent_pkg.lock_row_exception('loc_acc_map_hdr_id',tlinfo.loc_acc_map_hdr_id);

206: END IF;
207: CLOSE c1;
208:
209: IF NOT (tlinfo.loc_acc_map_hdr_id = x_loc_acc_map_hdr_id) THEN
210: pn_var_rent_pkg.lock_row_exception('loc_acc_map_hdr_id',tlinfo.loc_acc_map_hdr_id);
211: END IF;
212: IF NOT (tlinfo.mapping_name = x_mapping_name) THEN
213: pn_var_rent_pkg.lock_row_exception('mapping_name',tlinfo.mapping_name);
214: END IF;

Line 213: pn_var_rent_pkg.lock_row_exception('mapping_name',tlinfo.mapping_name);

209: IF NOT (tlinfo.loc_acc_map_hdr_id = x_loc_acc_map_hdr_id) THEN
210: pn_var_rent_pkg.lock_row_exception('loc_acc_map_hdr_id',tlinfo.loc_acc_map_hdr_id);
211: END IF;
212: IF NOT (tlinfo.mapping_name = x_mapping_name) THEN
213: pn_var_rent_pkg.lock_row_exception('mapping_name',tlinfo.mapping_name);
214: END IF;
215: IF NOT ( (tlinfo.attribute_category = x_Attribute_Category)
216: or ((tlinfo.attribute_category IS null) and (x_Attribute_Category IS null))) THEN
217: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);

Line 217: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);

213: pn_var_rent_pkg.lock_row_exception('mapping_name',tlinfo.mapping_name);
214: END IF;
215: IF NOT ( (tlinfo.attribute_category = x_Attribute_Category)
216: or ((tlinfo.attribute_category IS null) and (x_Attribute_Category IS null))) THEN
217: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);
218: END IF;
219: IF NOT ( (tlinfo.attribute1 = x_Attribute1)
220: or ((tlinfo.attribute1 IS null) and (x_Attribute1 IS null))) THEN
221: pn_var_rent_pkg.lock_row_exception('attribute1',tlinfo.attribute1);

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

217: pn_var_rent_pkg.lock_row_exception('attribute_category',tlinfo.attribute_category);
218: END IF;
219: IF NOT ( (tlinfo.attribute1 = x_Attribute1)
220: or ((tlinfo.attribute1 IS null) and (x_Attribute1 IS null))) THEN
221: pn_var_rent_pkg.lock_row_exception('attribute1',tlinfo.attribute1);
222: END IF;
223: IF NOT ( (tlinfo.attribute2 = x_Attribute2)
224: or ((tlinfo.attribute2 IS null) and (x_Attribute2 IS null))) THEN
225: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);

Line 225: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);

221: pn_var_rent_pkg.lock_row_exception('attribute1',tlinfo.attribute1);
222: END IF;
223: IF NOT ( (tlinfo.attribute2 = x_Attribute2)
224: or ((tlinfo.attribute2 IS null) and (x_Attribute2 IS null))) THEN
225: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);
226: END IF;
227: IF NOT ( (tlinfo.attribute3 = x_Attribute3)
228: or ((tlinfo.attribute3 IS null) and (x_Attribute3 IS null))) THEN
229: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);

Line 229: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);

225: pn_var_rent_pkg.lock_row_exception('attribute2',tlinfo.attribute2);
226: END IF;
227: IF NOT ( (tlinfo.attribute3 = x_Attribute3)
228: or ((tlinfo.attribute3 IS null) and (x_Attribute3 IS null))) THEN
229: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);
230: END IF;
231: IF NOT ( (tlinfo.attribute4 = x_Attribute4)
232: or ((tlinfo.attribute4 IS null) and (x_Attribute4 IS null))) THEN
233: pn_var_rent_pkg.lock_row_exception('attribute4',tlinfo.attribute4);

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

229: pn_var_rent_pkg.lock_row_exception('attribute3',tlinfo.attribute3);
230: END IF;
231: IF NOT ( (tlinfo.attribute4 = x_Attribute4)
232: or ((tlinfo.attribute4 IS null) and (x_Attribute4 IS null))) THEN
233: pn_var_rent_pkg.lock_row_exception('attribute4',tlinfo.attribute4);
234: END IF;
235: IF NOT ( (tlinfo.attribute5 = x_Attribute5)
236: or ((tlinfo.attribute5 IS null) and (x_Attribute5 IS null))) THEN
237: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);

Line 237: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);

233: pn_var_rent_pkg.lock_row_exception('attribute4',tlinfo.attribute4);
234: END IF;
235: IF NOT ( (tlinfo.attribute5 = x_Attribute5)
236: or ((tlinfo.attribute5 IS null) and (x_Attribute5 IS null))) THEN
237: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);
238: END IF;
239: IF NOT ( (tlinfo.attribute6 = x_Attribute6)
240: or ((tlinfo.attribute6 IS null) and (x_Attribute6 IS null))) THEN
241: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);

Line 241: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);

237: pn_var_rent_pkg.lock_row_exception('attribute5',tlinfo.attribute5);
238: END IF;
239: IF NOT ( (tlinfo.attribute6 = x_Attribute6)
240: or ((tlinfo.attribute6 IS null) and (x_Attribute6 IS null))) THEN
241: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);
242: END IF;
243: IF NOT ( (tlinfo.attribute7 = x_Attribute7)
244: or ((tlinfo.attribute7 IS null) and (x_Attribute7 IS null))) THEN
245: pn_var_rent_pkg.lock_row_exception('attribute7',tlinfo.attribute7);

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

241: pn_var_rent_pkg.lock_row_exception('attribute6',tlinfo.attribute6);
242: END IF;
243: IF NOT ( (tlinfo.attribute7 = x_Attribute7)
244: or ((tlinfo.attribute7 IS null) and (x_Attribute7 IS null))) THEN
245: pn_var_rent_pkg.lock_row_exception('attribute7',tlinfo.attribute7);
246: END IF;
247: IF NOT ( (tlinfo.attribute8 = x_Attribute8)
248: or ((tlinfo.attribute8 IS null) and (x_Attribute8 IS null))) THEN
249: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);

Line 249: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);

245: pn_var_rent_pkg.lock_row_exception('attribute7',tlinfo.attribute7);
246: END IF;
247: IF NOT ( (tlinfo.attribute8 = x_Attribute8)
248: or ((tlinfo.attribute8 IS null) and (x_Attribute8 IS null))) THEN
249: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);
250: END IF;
251: IF NOT ( (tlinfo.attribute9 = x_Attribute9)
252: or ((tlinfo.attribute9 IS null) and (x_Attribute9 IS null))) THEN
253: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);

Line 253: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);

249: pn_var_rent_pkg.lock_row_exception('attribute8',tlinfo.attribute8);
250: END IF;
251: IF NOT ( (tlinfo.attribute9 = x_Attribute9)
252: or ((tlinfo.attribute9 IS null) and (x_Attribute9 IS null))) THEN
253: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);
254: END IF;
255: IF NOT ( (tlinfo.attribute10 = x_Attribute10)
256: or ((tlinfo.attribute10 IS null) and (x_Attribute10 IS null))) THEN
257: pn_var_rent_pkg.lock_row_exception('attribute10',tlinfo.attribute10);

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

253: pn_var_rent_pkg.lock_row_exception('attribute9',tlinfo.attribute9);
254: END IF;
255: IF NOT ( (tlinfo.attribute10 = x_Attribute10)
256: or ((tlinfo.attribute10 IS null) and (x_Attribute10 IS null))) THEN
257: pn_var_rent_pkg.lock_row_exception('attribute10',tlinfo.attribute10);
258: END IF;
259: IF NOT ( (tlinfo.attribute11 = x_Attribute11)
260: or ((tlinfo.attribute11 IS null) and (x_Attribute11 IS null))) THEN
261: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);

Line 261: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);

257: pn_var_rent_pkg.lock_row_exception('attribute10',tlinfo.attribute10);
258: END IF;
259: IF NOT ( (tlinfo.attribute11 = x_Attribute11)
260: or ((tlinfo.attribute11 IS null) and (x_Attribute11 IS null))) THEN
261: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);
262: END IF;
263: IF NOT ( (tlinfo.attribute12 = x_Attribute12)
264: or ((tlinfo.attribute12 IS null) and (x_Attribute12 IS null))) THEN
265: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);

Line 265: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);

261: pn_var_rent_pkg.lock_row_exception('attribute11',tlinfo.attribute11);
262: END IF;
263: IF NOT ( (tlinfo.attribute12 = x_Attribute12)
264: or ((tlinfo.attribute12 IS null) and (x_Attribute12 IS null))) THEN
265: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);
266: END IF;
267: IF NOT ( (tlinfo.attribute13 = x_Attribute13)
268: or ((tlinfo.attribute13 IS null) and (x_Attribute13 IS null))) THEN
269: pn_var_rent_pkg.lock_row_exception('attribute13',tlinfo.attribute13);

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

265: pn_var_rent_pkg.lock_row_exception('attribute12',tlinfo.attribute12);
266: END IF;
267: IF NOT ( (tlinfo.attribute13 = x_Attribute13)
268: or ((tlinfo.attribute13 IS null) and (x_Attribute13 IS null))) THEN
269: pn_var_rent_pkg.lock_row_exception('attribute13',tlinfo.attribute13);
270: END IF;
271: IF NOT ( (tlinfo.attribute14 = x_Attribute14)
272: or ((tlinfo.attribute14 IS null) and (x_Attribute14 IS null))) THEN
273: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);

Line 273: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);

269: pn_var_rent_pkg.lock_row_exception('attribute13',tlinfo.attribute13);
270: END IF;
271: IF NOT ( (tlinfo.attribute14 = x_Attribute14)
272: or ((tlinfo.attribute14 IS null) and (x_Attribute14 IS null))) THEN
273: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);
274: END IF;
275: IF NOT ( (tlinfo.attribute15 = x_Attribute15)
276: or ((tlinfo.attribute15 IS null) and (x_Attribute15 IS null))) THEN
277: pn_var_rent_pkg.lock_row_exception('attribute15',tlinfo.attribute15);

Line 277: pn_var_rent_pkg.lock_row_exception('attribute15',tlinfo.attribute15);

273: pn_var_rent_pkg.lock_row_exception('attribute14',tlinfo.attribute14);
274: END IF;
275: IF NOT ( (tlinfo.attribute15 = x_Attribute15)
276: or ((tlinfo.attribute15 IS null) and (x_Attribute15 IS null))) THEN
277: pn_var_rent_pkg.lock_row_exception('attribute15',tlinfo.attribute15);
278: END IF;
279:
280: END lock_row;
281: