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

Line 221: l_cursor := dbms_sql.open_cursor;

217: retcode:=0;
218: errbuf:='';
219: fnd_profile.get('LOGIN_ID', l_login_id);
220:
221: l_cursor := dbms_sql.open_cursor;
222: --lease responsible user conditions....
223: l_lease_resp_user := lease_resp_user;
224: IF lease_resp_user IS NOT NULL THEN
225: les_resp_user_where_clause := ' AND fnd4.user_name = :l_lease_resp_user';

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

381:
382:
383: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(-)');
384:
385: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
386:
387: --lease responsible user conditions....
388:
389: IF lease_resp_user IS NOT NULL THEN

Line 390: dbms_sql.bind_variable(l_cursor,'l_lease_resp_user',l_lease_resp_user);

386:
387: --lease responsible user conditions....
388:
389: IF lease_resp_user IS NOT NULL THEN
390: dbms_sql.bind_variable(l_cursor,'l_lease_resp_user',l_lease_resp_user);
391: END IF;
392:
393:
394: --location code conditions.....

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

392:
393:
394: --location code conditions.....
395: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
396: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
397: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
398: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
399: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
400: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN

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

393:
394: --location code conditions.....
395: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
396: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
397: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
398: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
399: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
400: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
401: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);

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

395: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
396: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
397: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
398: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
399: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
400: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
401: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
402: END IF;
403:

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

397: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
398: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
399: dbms_sql.bind_variable(l_cursor,'l_location_code_high',l_location_code_high);
400: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
401: dbms_sql.bind_variable(l_cursor,'l_location_code_low',l_location_code_low);
402: END IF;
403:
404: --lease type conditions....
405: IF lease_type IS NOT NULL THEN

Line 406: dbms_sql.bind_variable(l_cursor,'l_lease_type',l_lease_type);

402: END IF;
403:
404: --lease type conditions....
405: IF lease_type IS NOT NULL THEN
406: dbms_sql.bind_variable(l_cursor,'l_lease_type',l_lease_type);
407: END IF;
408:
409: --lease number conditions.....
410: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN

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

407: END IF;
408:
409: --lease number conditions.....
410: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
411: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
412: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
413: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
414: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
415: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN

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

408:
409: --lease number conditions.....
410: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
411: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
412: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
413: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
414: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
415: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
416: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);

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

410: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
411: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
412: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
413: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
414: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
415: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
416: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
417: END IF;
418:

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

412: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
413: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
414: dbms_sql.bind_variable(l_cursor,'l_lease_number_high',l_lease_number_high);
415: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
416: dbms_sql.bind_variable(l_cursor,'l_lease_number_low',l_lease_number_low);
417: END IF;
418:
419: --lease date conditions.....
420: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN

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

417: END IF;
418:
419: --lease date conditions.....
420: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
421: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
422: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
423: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
424: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
425: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN

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

418:
419: --lease date conditions.....
420: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
421: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
422: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
423: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
424: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
425: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
426: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);

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

420: IF lease_termination_from IS NOT NULL AND lease_termination_to IS NOT NULL THEN
421: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
422: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
423: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
424: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
425: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
426: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
427: END IF;
428:

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

422: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
423: ELSIF lease_termination_from IS NULL AND lease_termination_to IS NOT NULL THEN
424: dbms_sql.bind_variable(l_cursor,'l_lease_termination_to',l_lease_termination_to);
425: ELSIF lease_termination_from IS NOT NULL AND lease_termination_to IS NULL THEN
426: dbms_sql.bind_variable(l_cursor,'l_lease_termination_from',l_lease_termination_from);
427: END IF;
428:
429:
430: --lease status conditions.....

Line 432: dbms_sql.bind_variable(l_cursor,'l_lease_status',l_lease_status);

428:
429:
430: --lease status conditions.....
431: IF lease_status IS NOT NULL THEN
432: dbms_sql.bind_variable(l_cursor,'l_lease_status',l_lease_status);
433: END IF;
434:
435: --lease class conditions..... bug#2099864
436: IF lease_class IS NOT NULL THEN

Line 437: dbms_sql.bind_variable(l_cursor,'l_lease_class',l_lease_class);

433: END IF;
434:
435: --lease class conditions..... bug#2099864
436: IF lease_class IS NOT NULL THEN
437: dbms_sql.bind_variable(l_cursor,'l_lease_class',l_lease_class);
438: END IF;
439:
440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);

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

436: IF lease_class IS NOT NULL THEN
437: dbms_sql.bind_variable(l_cursor,'l_lease_class',l_lease_class);
438: END IF;
439:
440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);

Line 441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);

437: dbms_sql.bind_variable(l_cursor,'l_lease_class',l_lease_class);
438: END IF;
439:
440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);

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

438: END IF;
439:
440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);

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

439:
440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);

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

440: dbms_sql.define_column (l_cursor,1,V_LOCATION_ID_1);
441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);

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

441: dbms_sql.define_column (l_cursor,2,V_SPACE_TYPE,80);
442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);

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

442: dbms_sql.define_column (l_cursor,3,V_LEASE_ID);
443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);

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

443: dbms_sql.define_column (l_cursor,4,V_LEASE_NAME,50);
444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);

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

444: dbms_sql.define_column (l_cursor,5,V_LEASE_NUMBER,30);
445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);

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

445: dbms_sql.define_column (l_cursor,6,V_LEASE_COM_DATE);
446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);

Line 450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);

446: dbms_sql.define_column (l_cursor,7,V_LEASE_TERM_DATE);
447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);

Line 451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);

447: dbms_sql.define_column (l_cursor,8,V_LEASE_EXE_DATE);
448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);

Line 452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);

448: dbms_sql.define_column (l_cursor,9,V_LEASE_TERM);
449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);

Line 453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);

449: dbms_sql.define_column (l_cursor,10,V_LEASE_CLASS,80);
450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);

Line 454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);

450: dbms_sql.define_column (l_cursor,11,V_LEASE_CLASS_CODE,30);
451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);

Line 455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);

451: dbms_sql.define_column (l_cursor,12,V_LEASE_RESP_USER,100);
452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);

Line 456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);

452: dbms_sql.define_column (l_cursor,13,V_LEASE_STATUS,80);
453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);

Line 457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);

453: dbms_sql.define_column (l_cursor,14,V_LEASE_TYPE,80);
454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);

Line 458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);

454: dbms_sql.define_column (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);
455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);

Line 459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);

455: dbms_sql.define_column (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);
456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);

Line 460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);

456: dbms_sql.define_column (l_cursor,17,V_ATTRIBUTE_CATEGORY,30);
457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);

Line 461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);

457: dbms_sql.define_column (l_cursor,18,V_ATTRIBUTE1,150);
458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);

Line 462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);

458: dbms_sql.define_column (l_cursor,19,V_ATTRIBUTE2,150);
459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);

Line 463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);

459: dbms_sql.define_column (l_cursor,20,V_ATTRIBUTE3,150);
460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);

Line 464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);

460: dbms_sql.define_column (l_cursor,21,V_ATTRIBUTE4,150);
461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);

Line 465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);

461: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE5,150);
462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);

Line 466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);

462: dbms_sql.define_column (l_cursor,23,V_ATTRIBUTE6,150);
463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);

Line 467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);

463: dbms_sql.define_column (l_cursor,24,V_ATTRIBUTE7,150);
464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);

Line 468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);

464: dbms_sql.define_column (l_cursor,25,V_ATTRIBUTE8,150);
465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);

Line 469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);

465: dbms_sql.define_column (l_cursor,26,V_ATTRIBUTE9,150);
466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);

Line 470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);

466: dbms_sql.define_column (l_cursor,27,V_ATTRIBUTE10,150);
467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);

Line 471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);

467: dbms_sql.define_column (l_cursor,28,V_ATTRIBUTE11,150);
468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);

Line 472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);

468: dbms_sql.define_column (l_cursor,29,V_ATTRIBUTE12,150);
469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);

Line 473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);

469: dbms_sql.define_column (l_cursor,30,V_ATTRIBUTE13,150);
470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);

Line 474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);

470: dbms_sql.define_column (l_cursor,31,V_ATTRIBUTE14,150);
471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);
478:

Line 475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);

471: dbms_sql.define_column (l_cursor,32,V_ATTRIBUTE15,150);
472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);
478:
479: l_rows := dbms_sql.execute(l_cursor);

Line 476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);

472: dbms_sql.define_column (l_cursor,33,V_LAST_UPDATE_DATE);
473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);
478:
479: l_rows := dbms_sql.execute(l_cursor);
480:

Line 477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);

473: dbms_sql.define_column (l_cursor,34,V_LAST_UPDATED_BY);
474: dbms_sql.define_column (l_cursor,35,V_LAST_UPDATE_LOGIN);
475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);
478:
479: l_rows := dbms_sql.execute(l_cursor);
480:
481:

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

475: dbms_sql.define_column (l_cursor,36,V_CREATION_DATE);
476: dbms_sql.define_column (l_cursor,37,V_CREATED_BY);
477: dbms_sql.define_column (l_cursor,38,V_PRORATION_RULE);
478:
479: l_rows := dbms_sql.execute(l_cursor);
480:
481:
482:
483: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(+)');

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

482:
483: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(+)');
484: LOOP --start lease loop....
485:
486: l_count := dbms_sql.fetch_rows( l_cursor );
487:
488: EXIT WHEN l_count <> 1;
489:
490: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);

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

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

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

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

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

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

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

489:
490: dbms_sql.column_value (l_cursor,1,V_LOCATION_ID_1);
491: dbms_sql.column_value (l_cursor,2,V_SPACE_TYPE);
492: dbms_sql.column_value (l_cursor,3,V_LEASE_ID);
493: dbms_sql.column_value (l_cursor,4,V_LEASE_NAME);
494: dbms_sql.column_value (l_cursor,5,V_LEASE_NUMBER);
495: dbms_sql.column_value (l_cursor,6,V_LEASE_COM_DATE);
496: dbms_sql.column_value (l_cursor,7,V_LEASE_TERM_DATE);
497: dbms_sql.column_value (l_cursor,8,V_LEASE_EXE_DATE);

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

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

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

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

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

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

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

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

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

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

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

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

Line 500: dbms_sql.column_value (l_cursor,11,V_LEASE_CLASS_CODE);

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

Line 501: dbms_sql.column_value (l_cursor,12,V_LEASE_RESP_USER);

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

Line 502: dbms_sql.column_value (l_cursor,13,V_LEASE_STATUS);

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

Line 503: dbms_sql.column_value (l_cursor,14,V_LEASE_TYPE);

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

Line 504: dbms_sql.column_value (l_cursor,15,V_ESTIMATED_OCCUPANCY_DATE);

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

Line 505: dbms_sql.column_value (l_cursor,16,V_ACTUAL_OCCUPANCY_DATE);

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

Line 506: dbms_sql.column_value (l_cursor,17,V_ATTRIBUTE_CATEGORY);

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

Line 507: dbms_sql.column_value (l_cursor,18,V_ATTRIBUTE1);

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

Line 508: dbms_sql.column_value (l_cursor,19,V_ATTRIBUTE2);

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

Line 509: dbms_sql.column_value (l_cursor,20,V_ATTRIBUTE3);

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

Line 510: dbms_sql.column_value (l_cursor,21,V_ATTRIBUTE4);

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

Line 511: dbms_sql.column_value (l_cursor,22,V_ATTRIBUTE5);

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

Line 512: dbms_sql.column_value (l_cursor,23,V_ATTRIBUTE6);

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

Line 513: dbms_sql.column_value (l_cursor,24,V_ATTRIBUTE7);

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

Line 514: dbms_sql.column_value (l_cursor,25,V_ATTRIBUTE8);

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

Line 515: dbms_sql.column_value (l_cursor,26,V_ATTRIBUTE9);

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

Line 516: dbms_sql.column_value (l_cursor,27,V_ATTRIBUTE10);

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

Line 517: dbms_sql.column_value (l_cursor,28,V_ATTRIBUTE11);

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

Line 518: dbms_sql.column_value (l_cursor,29,V_ATTRIBUTE12);

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

Line 519: dbms_sql.column_value (l_cursor,30,V_ATTRIBUTE13);

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

Line 520: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE14);

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

Line 521: dbms_sql.column_value (l_cursor,32,V_ATTRIBUTE15);

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

Line 522: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATE_DATE);

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

Line 523: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATED_BY);

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

Line 524: dbms_sql.column_value (l_cursor,35,V_LAST_UPDATE_LOGIN);

520: dbms_sql.column_value (l_cursor,31,V_ATTRIBUTE14);
521: dbms_sql.column_value (l_cursor,32,V_ATTRIBUTE15);
522: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATE_DATE);
523: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATED_BY);
524: dbms_sql.column_value (l_cursor,35,V_LAST_UPDATE_LOGIN);
525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);
526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);
527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);
528:

Line 525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);

521: dbms_sql.column_value (l_cursor,32,V_ATTRIBUTE15);
522: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATE_DATE);
523: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATED_BY);
524: dbms_sql.column_value (l_cursor,35,V_LAST_UPDATE_LOGIN);
525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);
526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);
527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);
528:
529: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(+)');

Line 526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);

522: dbms_sql.column_value (l_cursor,33,V_LAST_UPDATE_DATE);
523: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATED_BY);
524: dbms_sql.column_value (l_cursor,35,V_LAST_UPDATE_LOGIN);
525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);
526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);
527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);
528:
529: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(+)');
530: OPEN c_loc_pn FOR

Line 527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);

523: dbms_sql.column_value (l_cursor,34,V_LAST_UPDATED_BY);
524: dbms_sql.column_value (l_cursor,35,V_LAST_UPDATE_LOGIN);
525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);
526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);
527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);
528:
529: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(+)');
530: OPEN c_loc_pn FOR
531: SELECT

Line 877: IF dbms_sql.is_open (l_cursor) THEN

873: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(-)');
874: END LOOP; --END lease loop...
875: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(-)');
876:
877: IF dbms_sql.is_open (l_cursor) THEN
878: dbms_sql.close_cursor (l_cursor);
879: END IF;
880:
881:

Line 878: dbms_sql.close_cursor (l_cursor);

874: END LOOP; --END lease loop...
875: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(-)');
876:
877: IF dbms_sql.is_open (l_cursor) THEN
878: dbms_sql.close_cursor (l_cursor);
879: END IF;
880:
881:
882: --IF there is something amiss...