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.PNRX_SP_ASSIGN_BY_LEASE dependencies on DBMS_SQL

Line 232: l_cursor := dbms_sql.open_cursor;

228: pn_tenancies_all ten
229: WHERE ten.lease_id = les.lease_id
230: AND ten.lease_id = lda.lease_id '
231: ||lease_number_WHERE_clause;
232: l_cursor := dbms_sql.open_cursor;
233: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
234:
235:
236: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN

Line 233: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

229: WHERE ten.lease_id = les.lease_id
230: AND ten.lease_id = lda.lease_id '
231: ||lease_number_WHERE_clause;
232: l_cursor := dbms_sql.open_cursor;
233: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
234:
235:
236: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
237: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

Line 237: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

233: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
234:
235:
236: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
237: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
238: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
239: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
240: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
241: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN

Line 238: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);

234:
235:
236: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
237: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
238: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
239: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
240: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
241: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

Line 240: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);

236: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
237: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
238: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
239: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
240: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
241: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
243: END IF;
244:

Line 242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

238: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
239: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
240: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
241: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
243: END IF;
244:
245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);

Line 245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);

241: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
243: END IF;
244:
245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);

Line 246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);

242: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
243: END IF;
244:
245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);

Line 247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);

243: END IF;
244:
245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);

Line 248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);

244:
245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);

Line 249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);

245: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);

Line 250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);

246: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);

Line 251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);

247: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);

Line 252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);

248: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);

Line 253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);

249: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);

Line 254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);

250: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);

Line 255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);

251: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);

Line 256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);

252: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);

Line 257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);

253: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);

Line 258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);

254: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);

Line 259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);

255: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);

Line 260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);

256: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);

Line 261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);

257: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);

Line 262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);

258: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);

Line 263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);

259: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:

Line 264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);

260: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:
268: l_rows := dbms_sql.execute(l_cursor);

Line 265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);

261: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:
268: l_rows := dbms_sql.execute(l_cursor);
269:

Line 266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);

262: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
263: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:
268: l_rows := dbms_sql.execute(l_cursor);
269:
270: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(+)');

Line 268: l_rows := dbms_sql.execute(l_cursor);

264: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
265: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:
268: l_rows := dbms_sql.execute(l_cursor);
269:
270: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(+)');
271: l_count_1 := 0;
272: LOOP

Line 274: l_count := dbms_sql.fetch_rows( l_cursor );

270: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(+)');
271: l_count_1 := 0;
272: LOOP
273: l_count_1 := l_count_1 + 1;
274: l_count := dbms_sql.fetch_rows( l_cursor );
275: EXIT WHEN l_count <> 1;
276:
277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);

Line 277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);

273: l_count_1 := l_count_1 + 1;
274: l_count := dbms_sql.fetch_rows( l_cursor );
275: EXIT WHEN l_count <> 1;
276:
277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);

Line 278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);

274: l_count := dbms_sql.fetch_rows( l_cursor );
275: EXIT WHEN l_count <> 1;
276:
277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);

Line 279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);

275: EXIT WHEN l_count <> 1;
276:
277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);

Line 280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);

276:
277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);

Line 281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);

277: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);

Line 282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);

278: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);

Line 283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);

279: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);

Line 284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);

280: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);

Line 285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);

281: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);

Line 286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);

282: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);

Line 287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);

283: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);

Line 288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);

284: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);

Line 289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);

285: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);

Line 290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);

286: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);

Line 291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);

287: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);

Line 292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);

288: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);

Line 293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);

289: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);

Line 294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);

290: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);

Line 295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);

291: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
299:

Line 296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);

292: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
299:
300: OPEN c_e_assign_pn FOR

Line 297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);

293: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
299:
300: OPEN c_e_assign_pn FOR
301: SELECT

Line 298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);

294: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
295: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
296: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
297: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
298: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
299:
300: OPEN c_e_assign_pn FOR
301: SELECT
302: distinct

Line 553: IF dbms_sql.is_open (l_cursor) THEN

549: END LOOP;
550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');
551: END LOOP;
552: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(-)');
553: IF dbms_sql.is_open (l_cursor) THEN
554: dbms_sql.close_cursor (l_cursor);
555: END IF;
556:
557: COMMIT;

Line 554: dbms_sql.close_cursor (l_cursor);

550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');
551: END LOOP;
552: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(-)');
553: IF dbms_sql.is_open (l_cursor) THEN
554: dbms_sql.close_cursor (l_cursor);
555: END IF;
556:
557: COMMIT;
558: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(-)');

Line 602: IF NOT dbms_sql.is_open (l_cursor) THEN

598: WHERE ten.lease_id = les.lease_id
599: AND ten.lease_id = lda.lease_id '
600: ||lease_number_WHERE_clause;
601:
602: IF NOT dbms_sql.is_open (l_cursor) THEN
603: l_cursor := dbms_sql.open_cursor;
604: END IF;
605:
606:

Line 603: l_cursor := dbms_sql.open_cursor;

599: AND ten.lease_id = lda.lease_id '
600: ||lease_number_WHERE_clause;
601:
602: IF NOT dbms_sql.is_open (l_cursor) THEN
603: l_cursor := dbms_sql.open_cursor;
604: END IF;
605:
606:
607: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

Line 607: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

603: l_cursor := dbms_sql.open_cursor;
604: END IF;
605:
606:
607: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
608: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
609: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
611: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN

Line 609: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

605:
606:
607: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
608: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
609: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
611: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
612: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
613: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN

Line 610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);

606:
607: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
608: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
609: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
611: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
612: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
613: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

Line 612: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);

608: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
609: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
611: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
612: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
613: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
615: END IF;
616:

Line 614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

610: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
611: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
612: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
613: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
615: END IF;
616:
617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);

Line 617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);

613: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
615: END IF;
616:
617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);

Line 618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);

614: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
615: END IF;
616:
617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);

Line 619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);

615: END IF;
616:
617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);

Line 620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);

616:
617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);

Line 621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);

617: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);

Line 622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);

618: dbms_sql.define_column (l_cursor,2,V_LEASE_ID);
619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);

Line 623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);

619: dbms_sql.define_column (l_cursor,3,V_LEASE_NAME,50);
620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);

Line 624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);

620: dbms_sql.define_column (l_cursor,4,V_LEASE_NUMBER,30);
621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);

Line 625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);

621: dbms_sql.define_column (l_cursor,5,V_LEASE_COM_DATE);
622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);

Line 626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);

622: dbms_sql.define_column (l_cursor,6,V_LEASE_TERM_DATE);
623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);

Line 627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);

623: dbms_sql.define_column (l_cursor,7,V_ATTRIBUTE_CATEGORY,30);
624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);

Line 628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);

624: dbms_sql.define_column (l_cursor,8,V_ATTRIBUTE1,150);
625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);

Line 629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);

625: dbms_sql.define_column (l_cursor,9,V_ATTRIBUTE2,150);
626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);

Line 630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);

626: dbms_sql.define_column (l_cursor,10,V_ATTRIBUTE3,150);
627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);

Line 631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);

627: dbms_sql.define_column (l_cursor,11,V_ATTRIBUTE4,150);
628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);

Line 632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);

628: dbms_sql.define_column (l_cursor,12,V_ATTRIBUTE5,150);
629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);

Line 633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);

629: dbms_sql.define_column (l_cursor,13,V_ATTRIBUTE6,150);
630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);

Line 634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);

630: dbms_sql.define_column (l_cursor,14,V_ATTRIBUTE7,150);
631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);

Line 635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);

631: dbms_sql.define_column (l_cursor,15,V_ATTRIBUTE8,150);
632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
639:

Line 636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);

632: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE9,150);
633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
639:
640:

Line 637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);

633: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE10,150);
634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
639:
640:
641:

Line 638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);

634: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE11,150);
635: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE12,150);
636: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE13,150);
637: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE14,150);
638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
639:
640:
641:
642: l_rows := dbms_sql.execute(l_cursor);

Line 642: l_rows := dbms_sql.execute(l_cursor);

638: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
639:
640:
641:
642: l_rows := dbms_sql.execute(l_cursor);
643:
644: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(+)');
645: l_count_1 := 0;
646: LOOP

Line 648: l_count := dbms_sql.fetch_rows( l_cursor );

644: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(+)');
645: l_count_1 := 0;
646: LOOP
647: l_count_1 := l_count_1 + 1;
648: l_count := dbms_sql.fetch_rows( l_cursor );
649: EXIT WHEN l_count <> 1;
650:
651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);

Line 651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);

647: l_count_1 := l_count_1 + 1;
648: l_count := dbms_sql.fetch_rows( l_cursor );
649: EXIT WHEN l_count <> 1;
650:
651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);

Line 652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);

648: l_count := dbms_sql.fetch_rows( l_cursor );
649: EXIT WHEN l_count <> 1;
650:
651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);

Line 653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);

649: EXIT WHEN l_count <> 1;
650:
651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);

Line 654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);

650:
651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);

Line 655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);

651: dbms_sql.column_value(l_cursor,1,V_LOCATION_ID_1);
652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);

Line 656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);

652: dbms_sql.column_value(l_cursor,2,V_LEASE_ID);
653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);

Line 657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);

653: dbms_sql.column_value(l_cursor,3,V_LEASE_NAME);
654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);

Line 658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);

654: dbms_sql.column_value(l_cursor,4,V_LEASE_NUMBER);
655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);

Line 659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);

655: dbms_sql.column_value(l_cursor,5,V_LEASE_COM_DATE);
656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);

Line 660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);

656: dbms_sql.column_value(l_cursor,6,V_LEASE_TERM_DATE);
657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);

Line 661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);

657: dbms_sql.column_value(l_cursor,7,V_ATTRIBUTE_CATEGORY);
658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);

Line 662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);

658: dbms_sql.column_value(l_cursor,8,V_ATTRIBUTE1);
659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);

Line 663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);

659: dbms_sql.column_value(l_cursor,9,V_ATTRIBUTE2);
660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);

Line 664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);

660: dbms_sql.column_value(l_cursor,10,V_ATTRIBUTE3);
661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);

Line 665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);

661: dbms_sql.column_value(l_cursor,11,V_ATTRIBUTE4);
662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);

Line 666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);

662: dbms_sql.column_value(l_cursor,12,V_ATTRIBUTE5);
663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);

Line 667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);

663: dbms_sql.column_value(l_cursor,13,V_ATTRIBUTE6);
664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);

Line 668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);

664: dbms_sql.column_value(l_cursor,14,V_ATTRIBUTE7);
665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);

Line 669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);

665: dbms_sql.column_value(l_cursor,15,V_ATTRIBUTE8);
666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
673:

Line 670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);

666: dbms_sql.column_value(l_cursor,16,V_ATTRIBUTE9);
667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
673:
674: OPEN c_c_assign_pn FOR

Line 671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);

667: dbms_sql.column_value(l_cursor,17,V_ATTRIBUTE10);
668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
673:
674: OPEN c_c_assign_pn FOR
675: SELECT

Line 672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);

668: dbms_sql.column_value(l_cursor,18,V_ATTRIBUTE11);
669: dbms_sql.column_value(l_cursor,19,V_ATTRIBUTE12);
670: dbms_sql.column_value(l_cursor,20,V_ATTRIBUTE13);
671: dbms_sql.column_value(l_cursor,21,V_ATTRIBUTE14);
672: dbms_sql.column_value(l_cursor,22,V_ATTRIBUTE15);
673:
674: OPEN c_c_assign_pn FOR
675: SELECT
676: distinct

Line 941: IF dbms_sql.is_open (l_cursor) THEN

937: END LOOP;
938: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(-)');
939: END LOOP;
940:
941: IF dbms_sql.is_open (l_cursor) THEN
942: dbms_sql.close_cursor (l_cursor);
943: END IF;
944:
945: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(-)');

Line 942: dbms_sql.close_cursor (l_cursor);

938: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(-)');
939: END LOOP;
940:
941: IF dbms_sql.is_open (l_cursor) THEN
942: dbms_sql.close_cursor (l_cursor);
943: END IF;
944:
945: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(-)');
946: COMMIT;