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_LEASE_OPTIONS dependencies on DBMS_SQL

Line 174: l_cursor := dbms_sql.open_cursor;

170: retcode:=0;
171: errbuf:='';
172: fnd_profile.get('LOGIN_ID', l_login_id);
173:
174: l_cursor := dbms_sql.open_cursor;
175:
176: --lease number conditions.....
177: l_lease_number_low := lease_number_low;
178: l_lease_number_high := lease_number_high;

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

318: ||exer_date_where_clause||lease_date_where_clause;
319:
320:
321:
322: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
323:
324:
325: --lease number conditions.....
326: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN

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

323:
324:
325: --lease number conditions.....
326: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
327: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
328: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
329: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
330: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
331: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN

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

324:
325: --lease number conditions.....
326: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
327: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
328: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
329: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
330: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
331: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
332: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

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

326: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
327: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
328: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
329: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
330: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
331: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
332: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
333: END IF;
334:

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

328: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
329: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
330: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
331: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
332: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
333: END IF;
334:
335: --location code conditions.....
336: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN

Line 337: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

333: END IF;
334:
335: --location code conditions.....
336: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
337: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
338: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
339: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
340: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
341: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN

Line 338: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

334:
335: --location code conditions.....
336: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
337: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
338: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
339: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
340: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
341: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
342: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

Line 340: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);

336: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
337: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
338: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
339: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
340: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
341: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
342: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
343: END IF;
344:

Line 342: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

338: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
339: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
340: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
341: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
342: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
343: END IF;
344:
345: --lease responsible user conditions....
346: IF lease_responsible_user IS NOT NULL THEN

Line 347: dbms_sql.bind_variable(l_cursor,'l_lease_responsible_user',l_lease_responsible_user);

343: END IF;
344:
345: --lease responsible user conditions....
346: IF lease_responsible_user IS NOT NULL THEN
347: dbms_sql.bind_variable(l_cursor,'l_lease_responsible_user',l_lease_responsible_user);
348: END IF;
349:
350: --option type conditions....
351: IF option_type IS NOT NULL THEN

Line 352: dbms_sql.bind_variable(l_cursor,'l_option_type',l_option_type);

348: END IF;
349:
350: --option type conditions....
351: IF option_type IS NOT NULL THEN
352: dbms_sql.bind_variable(l_cursor,'l_option_type',l_option_type);
353: END IF;
354:
355:
356: --exer window termination date conditions.....

Line 358: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);

354:
355:
356: --exer window termination date conditions.....
357: IF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NOT NULL THEN
358: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);
359: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
360: ELSIF exer_window_termination_from IS NULL AND exer_window_termination_to IS NOT NULL THEN
361: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
362: ELSIF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NULL THEN

Line 359: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);

355:
356: --exer window termination date conditions.....
357: IF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NOT NULL THEN
358: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);
359: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
360: ELSIF exer_window_termination_from IS NULL AND exer_window_termination_to IS NOT NULL THEN
361: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
362: ELSIF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NULL THEN
363: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);

Line 361: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);

357: IF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NOT NULL THEN
358: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);
359: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
360: ELSIF exer_window_termination_from IS NULL AND exer_window_termination_to IS NOT NULL THEN
361: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
362: ELSIF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NULL THEN
363: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);
364: END IF;
365:

Line 363: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);

359: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
360: ELSIF exer_window_termination_from IS NULL AND exer_window_termination_to IS NOT NULL THEN
361: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_to',l_exer_window_termination_to);
362: ELSIF exer_window_termination_from IS NOT NULL AND exer_window_termination_to IS NULL THEN
363: dbms_sql.bind_variable(l_cursor,'l_exer_window_termination_from',l_exer_window_termination_from);
364: END IF;
365:
366:
367: --lease date conditions.....

Line 369: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);

365:
366:
367: --lease date conditions.....
368: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
369: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
370: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
371: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
372: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
373: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN

Line 370: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);

366:
367: --lease date conditions.....
368: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
369: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
370: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
371: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
372: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
373: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
374: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);

Line 372: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);

368: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
369: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
370: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
371: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
372: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
373: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
374: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
375: END IF;
376:

Line 374: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);

370: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
371: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
372: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
373: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
374: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
375: END IF;
376:
377:
378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);

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

374: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
375: END IF;
376:
377:
378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);

Line 379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);

375: END IF;
376:
377:
378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);

Line 380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);

376:
377:
378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);

Line 381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);

377:
378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);

Line 382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);

378: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);

Line 383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);

379: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,30);
380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);

Line 384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);

380: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);

Line 385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);

381: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);

Line 386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);

382: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);

Line 387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);

383: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);

Line 388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);

384: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);

Line 389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);

385: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);

Line 390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);

386: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);

Line 391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);

387: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);

Line 392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);

388: dbms_sql.define_column (l_cursor,11,V_LEASE_RESP_USER,100);
389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);

Line 393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);

389: dbms_sql.define_column (l_cursor,12,V_LEASE_STATUS,80);
390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);

Line 394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);

390: dbms_sql.define_column (l_cursor,13,V_LEASE_TYPE,80);
391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);

Line 395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);

391: dbms_sql.define_column (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);

Line 396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);

392: dbms_sql.define_column (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);

Line 397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);

393: dbms_sql.define_column (l_cursor,16,V_ATTRIBUTE_CATEGORY,30);
394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);

Line 398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);

394: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE1,150);
395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);

Line 399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);

395: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE2,150);
396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);

Line 400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);

396: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE3,150);
397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);

Line 401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);

397: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE4,150);
398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);

Line 402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);

398: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE5,150);
399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);

Line 403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);

399: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE6,150);
400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);

Line 404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);

400: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE7,150);
401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);

Line 405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);

401: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE8,150);
402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);

Line 406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);

402: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE9,150);
403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);

Line 407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);

403: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE10,150);
404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);

Line 408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);

404: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE11,150);
405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);

Line 409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);

405: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE12,150);
406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);
413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);

Line 410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);

406: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE13,150);
407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);
413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);
414:

Line 411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);

407: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE14,150);
408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);
413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);
414:
415:

Line 412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);

408: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE15,150);
409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);
413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);
414:
415:
416:

Line 413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);

409: dbms_sql.define_column (l_cursor,32,V_LAST_UPDATE_DATE);
410: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATED_BY);
411: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATE_LOGIN);
412: dbms_sql.define_column (l_cursor,35,V_CREATION_DATE);
413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);
414:
415:
416:
417: l_rows := dbms_sql.execute(l_cursor);

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

413: dbms_sql.define_column (l_cursor,36,V_CREATED_BY);
414:
415:
416:
417: l_rows := dbms_sql.execute(l_cursor);
418:
419: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_lesLoop(+)');
420: LOOP --start lease loop....
421:

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

418:
419: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_lesLoop(+)');
420: LOOP --start lease loop....
421:
422: l_count := dbms_sql.fetch_rows( l_cursor );
423:
424: EXIT WHEN l_count <> 1;
425:
426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);

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

422: l_count := dbms_sql.fetch_rows( l_cursor );
423:
424: EXIT WHEN l_count <> 1;
425:
426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);

Line 427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);

423:
424: EXIT WHEN l_count <> 1;
425:
426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);

Line 428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);

424: EXIT WHEN l_count <> 1;
425:
426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);

Line 429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);

425:
426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);

Line 430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);

426: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);

Line 431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);

427: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);

Line 432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);

428: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);

Line 433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);

429: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);

Line 434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);

430: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);

Line 435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);

431: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);

Line 436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);

432: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);

Line 437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);

433: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);
434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);

Line 438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);

434: dbms_sql.column_value (l_cursor,9,V_LEASE_TERM);
435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);

Line 439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);

435: dbms_sql.column_value (l_cursor,10,V_LEASE_CLASS);
436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);

Line 440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);

436: dbms_sql.column_value (l_cursor,11,V_LEASE_RESP_USER);
437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);

Line 441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);

437: dbms_sql.column_value (l_cursor,12,V_LEASE_STATUS);
438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);

Line 442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);

438: dbms_sql.column_value (l_cursor,13,V_LEASE_TYPE);
439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);

Line 443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);

439: dbms_sql.column_value (l_cursor,14,V_ESTIMATED_OCCUPANCY_DATE);
440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);

Line 444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);

440: dbms_sql.column_value (l_cursor,15,V_ACTUAL_OCCUPANCY_DATE);
441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);

Line 445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);

441: dbms_sql.column_value (l_cursor,16,V_ATTRIBUTE_CATEGORY);
442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);

Line 446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);

442: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE1);
443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);

Line 447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);

443: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE2);
444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);

Line 448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);

444: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE3);
445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);

Line 449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);

445: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE4);
446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);

Line 450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);

446: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE5);
447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);

Line 451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);

447: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE6);
448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);

Line 452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);

448: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE7);
449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);

Line 453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);

449: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE8);
450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);

Line 454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);

450: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE9);
451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);

Line 455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);

451: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE10);
452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);

Line 456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);

452: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE11);
453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);

Line 457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);

453: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE12);
454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);
461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);

Line 458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);

454: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE13);
455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);
461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);
462:

Line 459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);

455: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE14);
456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);
461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);
462:
463:

Line 460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);

456: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE15);
457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);
461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);
462:
463:
464: OPEN c_loc_pn FOR

Line 461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);

457: dbms_sql.column_value (l_cursor,32,V_LAST_UPDATE_DATE);
458: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATED_BY);
459: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATE_LOGIN);
460: dbms_sql.column_value (l_cursor,35,V_CREATION_DATE);
461: dbms_sql.column_value (l_cursor,36,V_CREATED_BY);
462:
463:
464: OPEN c_loc_pn FOR
465: SELECT

Line 734: IF dbms_sql.is_open (l_cursor) THEN

730: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_inserting(-)');
731: END LOOP; --end option loop
732: END LOOP; --end location loop...
733: END LOOP; --end lease loop...
734: IF dbms_sql.is_open (l_cursor) THEN
735: dbms_sql.close_cursor (l_cursor);
736: END IF;
737:
738: PNP_DEBUG_PKG.put_log_msg('pn_lease_optionsLoop(-)');

Line 735: dbms_sql.close_cursor (l_cursor);

731: END LOOP; --end option loop
732: END LOOP; --end location loop...
733: END LOOP; --end lease loop...
734: IF dbms_sql.is_open (l_cursor) THEN
735: dbms_sql.close_cursor (l_cursor);
736: END IF;
737:
738: PNP_DEBUG_PKG.put_log_msg('pn_lease_optionsLoop(-)');
739: --If there is something amiss...