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

Line 11: -- 21-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.

7: -- INVOKED FROM :
8: -- PURPOSE :
9: -- HISTORY :
10: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_distributions with _ALL.
11: -- 21-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
12: -- 16-Jun-06 Kiran o Bug # 5334793 - removed stray ) from l_statement that
13: -- was causing the query to fail.
14: -------------------------------------------------------------------------------
15: PROCEDURE pn_milestones(

Line 124: l_cursor := dbms_sql.open_cursor;

120: retcode:=0;
121: errbuf:='';
122: fnd_profile.get('LOGIN_ID', l_login_id);
123:
124: l_cursor := dbms_sql.open_cursor;
125: l_statement :=
126: 'SELECT
127: distinct
128: ten.location_id LOCATION_ID,

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

349: l_statement || ' AND 6=6 ';
350:
351: END IF;
352:
353: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
354:
355: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
356: dbms_sql.bind_variable
357: (l_cursor, 'l_lease_number_low', l_lease_number_low );

Line 356: dbms_sql.bind_variable

352:
353: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
354:
355: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
356: dbms_sql.bind_variable
357: (l_cursor, 'l_lease_number_low', l_lease_number_low );
358: dbms_sql.bind_variable
359: (l_cursor, 'l_lease_number_high', l_lease_number_high );
360:

Line 358: dbms_sql.bind_variable

354:
355: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
356: dbms_sql.bind_variable
357: (l_cursor, 'l_lease_number_low', l_lease_number_low );
358: dbms_sql.bind_variable
359: (l_cursor, 'l_lease_number_high', l_lease_number_high );
360:
361: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
362: dbms_sql.bind_variable

Line 362: dbms_sql.bind_variable

358: dbms_sql.bind_variable
359: (l_cursor, 'l_lease_number_high', l_lease_number_high );
360:
361: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
362: dbms_sql.bind_variable
363: (l_cursor, 'l_lease_number_high', l_lease_number_high );
364:
365: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
366: dbms_sql.bind_variable

Line 366: dbms_sql.bind_variable

362: dbms_sql.bind_variable
363: (l_cursor, 'l_lease_number_high', l_lease_number_high );
364:
365: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
366: dbms_sql.bind_variable
367: (l_cursor, 'l_lease_number_low', l_lease_number_low );
368: END IF;
369:
370: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN

Line 371: dbms_sql.bind_variable

367: (l_cursor, 'l_lease_number_low', l_lease_number_low );
368: END IF;
369:
370: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
371: dbms_sql.bind_variable
372: (l_cursor, 'l_location_code_low', l_location_code_low );
373: dbms_sql.bind_variable
374: (l_cursor, 'l_location_code_high', l_location_code_high );
375:

Line 373: dbms_sql.bind_variable

369:
370: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
371: dbms_sql.bind_variable
372: (l_cursor, 'l_location_code_low', l_location_code_low );
373: dbms_sql.bind_variable
374: (l_cursor, 'l_location_code_high', l_location_code_high );
375:
376: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
377: dbms_sql.bind_variable

Line 377: dbms_sql.bind_variable

373: dbms_sql.bind_variable
374: (l_cursor, 'l_location_code_high', l_location_code_high );
375:
376: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
377: dbms_sql.bind_variable
378: (l_cursor, 'l_location_code_high', l_location_code_high );
379:
380: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
381: dbms_sql.bind_variable

Line 381: dbms_sql.bind_variable

377: dbms_sql.bind_variable
378: (l_cursor, 'l_location_code_high', l_location_code_high );
379:
380: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
381: dbms_sql.bind_variable
382: (l_cursor, 'l_location_code_low', l_location_code_low );
383: END IF;
384:
385: IF responsible_user IS NOT NULL THEN

Line 386: dbms_sql.bind_variable

382: (l_cursor, 'l_location_code_low', l_location_code_low );
383: END IF;
384:
385: IF responsible_user IS NOT NULL THEN
386: dbms_sql.bind_variable
387: (l_cursor, 'l_responsible_user', l_responsible_user );
388: END IF;
389:
390: IF action_due_date_from IS NOT NULL AND action_due_date_to IS NOT NULL THEN

Line 391: dbms_sql.bind_variable

387: (l_cursor, 'l_responsible_user', l_responsible_user );
388: END IF;
389:
390: IF action_due_date_from IS NOT NULL AND action_due_date_to IS NOT NULL THEN
391: dbms_sql.bind_variable
392: (l_cursor, 'l_action_due_date_from', l_action_due_date_from );
393: dbms_sql.bind_variable
394: (l_cursor, 'l_action_due_date_to', l_action_due_date_to );
395:

Line 393: dbms_sql.bind_variable

389:
390: IF action_due_date_from IS NOT NULL AND action_due_date_to IS NOT NULL THEN
391: dbms_sql.bind_variable
392: (l_cursor, 'l_action_due_date_from', l_action_due_date_from );
393: dbms_sql.bind_variable
394: (l_cursor, 'l_action_due_date_to', l_action_due_date_to );
395:
396: ELSIF action_due_date_from IS NULL AND action_due_date_to IS NOT NULL THEN
397: dbms_sql.bind_variable

Line 397: dbms_sql.bind_variable

393: dbms_sql.bind_variable
394: (l_cursor, 'l_action_due_date_to', l_action_due_date_to );
395:
396: ELSIF action_due_date_from IS NULL AND action_due_date_to IS NOT NULL THEN
397: dbms_sql.bind_variable
398: (l_cursor, 'l_action_due_date_to', l_action_due_date_to );
399: ELSIF action_due_date_from IS NOT NULL AND action_due_date_to IS NULL THEN
400: dbms_sql.bind_variable
401: (l_cursor, 'l_action_due_date_from', l_action_due_date_from );

Line 400: dbms_sql.bind_variable

396: ELSIF action_due_date_from IS NULL AND action_due_date_to IS NOT NULL THEN
397: dbms_sql.bind_variable
398: (l_cursor, 'l_action_due_date_to', l_action_due_date_to );
399: ELSIF action_due_date_from IS NOT NULL AND action_due_date_to IS NULL THEN
400: dbms_sql.bind_variable
401: (l_cursor, 'l_action_due_date_from', l_action_due_date_from );
402: END IF;
403:
404: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN

Line 405: dbms_sql.bind_variable

401: (l_cursor, 'l_action_due_date_from', l_action_due_date_from );
402: END IF;
403:
404: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
405: dbms_sql.bind_variable
406: (l_cursor, 'l_lease_termination_from', l_lease_termination_from );
407: dbms_sql.bind_variable
408: (l_cursor, 'l_lease_termination_to', l_lease_termination_to );
409:

Line 407: dbms_sql.bind_variable

403:
404: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
405: dbms_sql.bind_variable
406: (l_cursor, 'l_lease_termination_from', l_lease_termination_from );
407: dbms_sql.bind_variable
408: (l_cursor, 'l_lease_termination_to', l_lease_termination_to );
409:
410: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
411: dbms_sql.bind_variable

Line 411: dbms_sql.bind_variable

407: dbms_sql.bind_variable
408: (l_cursor, 'l_lease_termination_to', l_lease_termination_to );
409:
410: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
411: dbms_sql.bind_variable
412: (l_cursor, 'l_lease_termination_to', l_lease_termination_to );
413: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
414: dbms_sql.bind_variable
415: (l_cursor, 'l_lease_termination_from', l_lease_termination_from );

Line 414: dbms_sql.bind_variable

410: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
411: dbms_sql.bind_variable
412: (l_cursor, 'l_lease_termination_to', l_lease_termination_to );
413: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
414: dbms_sql.bind_variable
415: (l_cursor, 'l_lease_termination_from', l_lease_termination_from );
416: END IF;
417:
418: IF milestone_type IS NOT NULL THEN

Line 419: dbms_sql.bind_variable

415: (l_cursor, 'l_lease_termination_from', l_lease_termination_from );
416: END IF;
417:
418: IF milestone_type IS NOT NULL THEN
419: dbms_sql.bind_variable
420: (l_cursor, 'l_milestone_type', l_milestone_type );
421: END IF;
422:
423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);

Line 423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);

419: dbms_sql.bind_variable
420: (l_cursor, 'l_milestone_type', l_milestone_type );
421: END IF;
422:
423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);
424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);

Line 424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);

420: (l_cursor, 'l_milestone_type', l_milestone_type );
421: END IF;
422:
423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);
424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);

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

421: END IF;
422:
423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);
424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);

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

422:
423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);
424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);

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

423: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID);
424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);

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

424: dbms_sql.define_column (l_cursor, 2,V_OCCUPANCY_DATE);
425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);

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

425: dbms_sql.define_column (l_cursor, 3,V_LEASE_ID);
426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);

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

426: dbms_sql.define_column (l_cursor, 4,V_LEASE_NAME,50);
427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);

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

427: dbms_sql.define_column (l_cursor, 5,V_LEASE_NUMBER,30);
428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);

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

428: dbms_sql.define_column (l_cursor, 6,V_LEASE_COM_DATE);
429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);

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

429: dbms_sql.define_column (l_cursor, 7,V_LEASE_TERM_DATE);
430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);

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

430: dbms_sql.define_column (l_cursor, 8,V_LEASE_EXE_DATE);
431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);

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

431: dbms_sql.define_column (l_cursor, 9,V_LEASE_TERM);
432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);

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

432: dbms_sql.define_column (l_cursor, 10,V_LEASE_CLASS,80);
433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);

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

433: dbms_sql.define_column (l_cursor, 11,V_LEASE_RESP_USER,100);
434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);

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

434: dbms_sql.define_column (l_cursor, 12,V_LEASE_STATUS,80);
435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);

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

435: dbms_sql.define_column (l_cursor, 13,V_LEASE_TYPE,80);
436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);

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

436: dbms_sql.define_column (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);

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

437: dbms_sql.define_column (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);

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

438: dbms_sql.define_column (l_cursor, 16,V_ATTRIBUTE_CATEGORY,30);
439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);

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

439: dbms_sql.define_column (l_cursor, 17,V_ATTRIBUTE1,150);
440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);

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

440: dbms_sql.define_column (l_cursor, 18,V_ATTRIBUTE2,150);
441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);

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

441: dbms_sql.define_column (l_cursor, 19,V_ATTRIBUTE3,150);
442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);

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

442: dbms_sql.define_column (l_cursor, 20,V_ATTRIBUTE4,150);
443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);

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

443: dbms_sql.define_column (l_cursor, 21,V_ATTRIBUTE5,150);
444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);

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

444: dbms_sql.define_column (l_cursor, 22,V_ATTRIBUTE6,150);
445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);

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

445: dbms_sql.define_column (l_cursor, 23,V_ATTRIBUTE7,150);
446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);

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

446: dbms_sql.define_column (l_cursor, 24,V_ATTRIBUTE8,150);
447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);

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

447: dbms_sql.define_column (l_cursor, 25,V_ATTRIBUTE9,150);
448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);

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

448: dbms_sql.define_column (l_cursor, 26,V_ATTRIBUTE10,150);
449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);

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

449: dbms_sql.define_column (l_cursor, 27,V_ATTRIBUTE11,150);
450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);

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

450: dbms_sql.define_column (l_cursor, 28,V_ATTRIBUTE12,150);
451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);

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

451: dbms_sql.define_column (l_cursor, 29,V_ATTRIBUTE13,150);
452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);

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

452: dbms_sql.define_column (l_cursor, 30,V_ATTRIBUTE14,150);
453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);

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

453: dbms_sql.define_column (l_cursor, 31,V_ATTRIBUTE15,150);
454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);

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

454: dbms_sql.define_column (l_cursor, 32,V_LAST_UPDATE_DATE);
455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);

Line 459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);

455: dbms_sql.define_column (l_cursor, 33,V_LAST_UPDATED_BY);
456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);

Line 460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);

456: dbms_sql.define_column (l_cursor, 34,V_LAST_UPDATE_LOGIN);
457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);

Line 461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);

457: dbms_sql.define_column (l_cursor, 35,V_CREATION_DATE);
458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);

Line 462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);

458: dbms_sql.define_column (l_cursor, 36,V_CREATED_BY);
459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);

Line 463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);

459: dbms_sql.define_column (l_cursor, 37,V_LOCATION_TYPE,80);
460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);

Line 464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);

460: dbms_sql.define_column (l_cursor, 38,V_LOCATION_NAME,30);
461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);

Line 465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);

461: dbms_sql.define_column (l_cursor, 39,V_LOCATION_CODE,90);
462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);

Line 466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);

462: dbms_sql.define_column (l_cursor, 40,V_SPACE_TYPE,80);
463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);

Line 467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);

463: dbms_sql.define_column (l_cursor, 41,V_ADDRESS,1500);
464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);

Line 468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);

464: dbms_sql.define_column (l_cursor, 42,V_COUNTY,60);
465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);

Line 469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);

465: dbms_sql.define_column (l_cursor, 43,V_CITY,60);
466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);

Line 470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);

466: dbms_sql.define_column (l_cursor, 44,V_STATE,60);
467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);

Line 471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);

467: dbms_sql.define_column (l_cursor, 45,V_PROVINCE,60);
468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);

Line 472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);

468: dbms_sql.define_column (l_cursor, 46,V_ZIP_CODE,60);
469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);

Line 473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);

469: dbms_sql.define_column (l_cursor, 47,V_COUNTRY,60);
470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);

Line 474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);

470: dbms_sql.define_column (l_cursor, 48,V_RENTABLE_AREA);
471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);

Line 475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);

471: dbms_sql.define_column (l_cursor, 49,V_USABLE_AREA);
472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);

Line 476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);

472: dbms_sql.define_column (l_cursor, 50,V_GROSS_AREA);
473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);
480:

Line 477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);

473: dbms_sql.define_column (l_cursor, 51,V_TENURE,80);
474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);
480:
481: l_rows := dbms_sql.execute(l_cursor);

Line 478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);

474: dbms_sql.define_column (l_cursor, 52,V_LEASE_MILESTONE_ID);
475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);
480:
481: l_rows := dbms_sql.execute(l_cursor);
482:

Line 479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);

475: dbms_sql.define_column (l_cursor, 53,V_MILESTONE_TYPE,80);
476: dbms_sql.define_column (l_cursor, 54,V_RESPONSIBLE_USER,100);
477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);
480:
481: l_rows := dbms_sql.execute(l_cursor);
482:
483: LOOP

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

477: dbms_sql.define_column (l_cursor, 55,V_ACTION_DATE);
478: dbms_sql.define_column (l_cursor, 56,V_MILESTONE_DATE);
479: dbms_sql.define_column (l_cursor, 57,V_ACTION_TAKEN,50);
480:
481: l_rows := dbms_sql.execute(l_cursor);
482:
483: LOOP
484:
485: l_count := dbms_sql.fetch_rows( l_cursor );

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

481: l_rows := dbms_sql.execute(l_cursor);
482:
483: LOOP
484:
485: l_count := dbms_sql.fetch_rows( l_cursor );
486: EXIT WHEN l_count <> 1;
487:
488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);

Line 488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);

484:
485: l_count := dbms_sql.fetch_rows( l_cursor );
486: EXIT WHEN l_count <> 1;
487:
488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);

Line 489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);

485: l_count := dbms_sql.fetch_rows( l_cursor );
486: EXIT WHEN l_count <> 1;
487:
488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);

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

486: EXIT WHEN l_count <> 1;
487:
488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);

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

487:
488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);

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

488: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID);
489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);

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

489: dbms_sql.column_value (l_cursor, 2,V_OCCUPANCY_DATE);
490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);

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

490: dbms_sql.column_value (l_cursor, 3,V_LEASE_ID);
491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);

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

491: dbms_sql.column_value (l_cursor, 4,V_LEASE_NAME);
492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);

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

492: dbms_sql.column_value (l_cursor, 5,V_LEASE_NUMBER);
493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);

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

493: dbms_sql.column_value (l_cursor, 6,V_LEASE_COM_DATE);
494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);

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

494: dbms_sql.column_value (l_cursor, 7,V_LEASE_TERM_DATE);
495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);

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

495: dbms_sql.column_value (l_cursor, 8,V_LEASE_EXE_DATE);
496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);

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

496: dbms_sql.column_value (l_cursor, 9,V_LEASE_TERM);
497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);

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

497: dbms_sql.column_value (l_cursor, 10,V_LEASE_CLASS);
498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);

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

498: dbms_sql.column_value (l_cursor, 11,V_LEASE_RESP_USER);
499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);

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

499: dbms_sql.column_value (l_cursor, 12,V_LEASE_STATUS);
500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);

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

500: dbms_sql.column_value (l_cursor, 13,V_LEASE_TYPE);
501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);

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

501: dbms_sql.column_value (l_cursor, 14,V_ESTIMATED_OCCUPANCY_DATE);
502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);

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

502: dbms_sql.column_value (l_cursor, 15,V_ACTUAL_OCCUPANCY_DATE);
503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);

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

503: dbms_sql.column_value (l_cursor, 16,V_ATTRIBUTE_CATEGORY);
504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);

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

504: dbms_sql.column_value (l_cursor, 17,V_ATTRIBUTE1);
505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);

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

505: dbms_sql.column_value (l_cursor, 18,V_ATTRIBUTE2);
506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);

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

506: dbms_sql.column_value (l_cursor, 19,V_ATTRIBUTE3);
507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);

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

507: dbms_sql.column_value (l_cursor, 20,V_ATTRIBUTE4);
508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);

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

508: dbms_sql.column_value (l_cursor, 21,V_ATTRIBUTE5);
509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);

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

509: dbms_sql.column_value (l_cursor, 22,V_ATTRIBUTE6);
510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);

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

510: dbms_sql.column_value (l_cursor, 23,V_ATTRIBUTE7);
511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);

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

511: dbms_sql.column_value (l_cursor, 24,V_ATTRIBUTE8);
512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);

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

512: dbms_sql.column_value (l_cursor, 25,V_ATTRIBUTE9);
513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);

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

513: dbms_sql.column_value (l_cursor, 26,V_ATTRIBUTE10);
514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);

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

514: dbms_sql.column_value (l_cursor, 27,V_ATTRIBUTE11);
515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);

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

515: dbms_sql.column_value (l_cursor, 28,V_ATTRIBUTE12);
516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);

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

516: dbms_sql.column_value (l_cursor, 29,V_ATTRIBUTE13);
517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);

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

517: dbms_sql.column_value (l_cursor, 30,V_ATTRIBUTE14);
518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);

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

518: dbms_sql.column_value (l_cursor, 31,V_ATTRIBUTE15);
519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);

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

519: dbms_sql.column_value (l_cursor, 32,V_LAST_UPDATE_DATE);
520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);

Line 524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);

520: dbms_sql.column_value (l_cursor, 33,V_LAST_UPDATED_BY);
521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);

Line 525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);

521: dbms_sql.column_value (l_cursor, 34,V_LAST_UPDATE_LOGIN);
522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);

Line 526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);

522: dbms_sql.column_value (l_cursor, 35,V_CREATION_DATE);
523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);

Line 527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);

523: dbms_sql.column_value (l_cursor, 36,V_CREATED_BY);
524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);

Line 528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);

524: dbms_sql.column_value (l_cursor, 37,V_LOCATION_TYPE);
525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);

Line 529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);

525: dbms_sql.column_value (l_cursor, 38,V_LOCATION_NAME);
526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);

Line 530: dbms_sql.column_value (l_cursor, 43,V_CITY);

526: dbms_sql.column_value (l_cursor, 39,V_LOCATION_CODE);
527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);

Line 531: dbms_sql.column_value (l_cursor, 44,V_STATE);

527: dbms_sql.column_value (l_cursor, 40,V_SPACE_TYPE);
528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);

Line 532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);

528: dbms_sql.column_value (l_cursor, 41,V_ADDRESS);
529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);

Line 533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);

529: dbms_sql.column_value (l_cursor, 42,V_COUNTY);
530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);

Line 534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);

530: dbms_sql.column_value (l_cursor, 43,V_CITY);
531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);

Line 535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);

531: dbms_sql.column_value (l_cursor, 44,V_STATE);
532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);

Line 536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);

532: dbms_sql.column_value (l_cursor, 45,V_PROVINCE);
533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);

Line 537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);

533: dbms_sql.column_value (l_cursor, 46,V_ZIP_CODE);
534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);

Line 538: dbms_sql.column_value (l_cursor, 51,V_TENURE);

534: dbms_sql.column_value (l_cursor, 47,V_COUNTRY);
535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);

Line 539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);

535: dbms_sql.column_value (l_cursor, 48,V_RENTABLE_AREA);
536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);

Line 540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);

536: dbms_sql.column_value (l_cursor, 49,V_USABLE_AREA);
537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);

Line 541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);

537: dbms_sql.column_value (l_cursor, 50,V_GROSS_AREA);
538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);
545:

Line 542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);

538: dbms_sql.column_value (l_cursor, 51,V_TENURE);
539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);
545:
546: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OCCUPANCY_DATE);

Line 543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);

539: dbms_sql.column_value (l_cursor, 52,V_LEASE_MILESTONE_ID);
540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);
545:
546: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OCCUPANCY_DATE);
547:

Line 544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);

540: dbms_sql.column_value (l_cursor, 53,V_MILESTONE_TYPE);
541: dbms_sql.column_value (l_cursor, 54,V_RESPONSIBLE_USER);
542: dbms_sql.column_value (l_cursor, 55,V_ACTION_DATE);
543: dbms_sql.column_value (l_cursor, 56,V_MILESTONE_DATE);
544: dbms_sql.column_value (l_cursor, 57,V_ACTION_TAKEN);
545:
546: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, V_OCCUPANCY_DATE);
547:
548: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_les: insert(+)');

Line 681: IF dbms_sql.is_open (l_cursor) THEN

677: PNP_DEBUG_PKG.put_log_msg('pn_roll_rent_les: insert(-)');
678:
679: END LOOP;
680:
681: IF dbms_sql.is_open (l_cursor) THEN
682: dbms_sql.close_cursor (l_cursor);
683: END IF;
684:
685: PNP_DEBUG_PKG.put_log_msg('pn_lease_optionsLoop(-)');

Line 682: dbms_sql.close_cursor (l_cursor);

678:
679: END LOOP;
680:
681: IF dbms_sql.is_open (l_cursor) THEN
682: dbms_sql.close_cursor (l_cursor);
683: END IF;
684:
685: PNP_DEBUG_PKG.put_log_msg('pn_lease_optionsLoop(-)');
686: