eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNRX_SP_UTIL_BY_LEASE dependencies on DBMS_SQL

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

7: -- PURPOSE :
8: -- HISTORY :
9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_locations,pn_tenancies
10: -- with _ALL table
11: -- 24-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
12: ----------------------------------------------------------------------------------
13:
14: PROCEDURE pn_space_util_lease(
15: lease_number_low IN VARCHAR2,

Line 107: l_cursor := dbms_sql.open_cursor;

103: retcode:=0;
104: errbuf:='';
105: fnd_profile.get('LOGIN_ID', l_login_id);
106:
107: l_cursor := dbms_sql.open_cursor;
108: l_statement :=
109: 'SELECT
110: loc.location_id LOCATION_ID
111: FROM pn_locations_all loc,

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

145: l_statement :=
146: l_statement || lease_number_where_clause ;
147:
148: pnp_debug_pkg.log(' l_statement:'||l_statement);
149: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
150:
151: dbms_sql.bind_variable
152: (l_cursor,'l_as_of_date',l_as_of_date );
153:

Line 151: dbms_sql.bind_variable

147:
148: pnp_debug_pkg.log(' l_statement:'||l_statement);
149: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
150:
151: dbms_sql.bind_variable
152: (l_cursor,'l_as_of_date',l_as_of_date );
153:
154: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
155: dbms_sql.bind_variable

Line 155: dbms_sql.bind_variable

151: dbms_sql.bind_variable
152: (l_cursor,'l_as_of_date',l_as_of_date );
153:
154: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
155: dbms_sql.bind_variable
156: (l_cursor,'l_lease_number_low',l_lease_number_low );
157: dbms_sql.bind_variable
158: (l_cursor,'l_lease_number_high',l_lease_number_high );
159:

Line 157: dbms_sql.bind_variable

153:
154: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
155: dbms_sql.bind_variable
156: (l_cursor,'l_lease_number_low',l_lease_number_low );
157: dbms_sql.bind_variable
158: (l_cursor,'l_lease_number_high',l_lease_number_high );
159:
160: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
161: dbms_sql.bind_variable

Line 161: dbms_sql.bind_variable

157: dbms_sql.bind_variable
158: (l_cursor,'l_lease_number_high',l_lease_number_high );
159:
160: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
161: dbms_sql.bind_variable
162: (l_cursor,'l_lease_number_high',l_lease_number_high );
163: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
164: dbms_sql.bind_variable
165: (l_cursor,'l_lease_number_low',l_lease_number_low );

Line 164: dbms_sql.bind_variable

160: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
161: dbms_sql.bind_variable
162: (l_cursor,'l_lease_number_high',l_lease_number_high );
163: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
164: dbms_sql.bind_variable
165: (l_cursor,'l_lease_number_low',l_lease_number_low );
166: END IF;
167:
168: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);

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

164: dbms_sql.bind_variable
165: (l_cursor,'l_lease_number_low',l_lease_number_low );
166: END IF;
167:
168: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);
169: l_rows := dbms_sql.execute(l_cursor);
170:
171: LOOP
172:

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

165: (l_cursor,'l_lease_number_low',l_lease_number_low );
166: END IF;
167:
168: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);
169: l_rows := dbms_sql.execute(l_cursor);
170:
171: LOOP
172:
173: l_count := dbms_sql.fetch_rows( l_cursor );

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

169: l_rows := dbms_sql.execute(l_cursor);
170:
171: LOOP
172:
173: l_count := dbms_sql.fetch_rows( l_cursor );
174: EXIT WHEN l_count <> 1;
175:
176: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);
177:

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

172:
173: l_count := dbms_sql.fetch_rows( l_cursor );
174: EXIT WHEN l_count <> 1;
175:
176: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);
177:
178: l_cursor_2 := dbms_sql.open_cursor;
179: l_statement_2 :=
180: 'SELECT distinct

Line 178: l_cursor_2 := dbms_sql.open_cursor;

174: EXIT WHEN l_count <> 1;
175:
176: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);
177:
178: l_cursor_2 := dbms_sql.open_cursor;
179: l_statement_2 :=
180: 'SELECT distinct
181: loc.location_id LOCATION_ID,
182: fl1.meaning LOCATION_TYPE,

Line 257: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);

253: START WITH loc.location_id = :l_LOCATION_ID_1
254: CONNECT BY PRIOR loc.location_id = loc.parent_location_id
255: AND :l_as_of_date BETWEEN prior active_start_date AND prior active_end_date) ';
256:
257: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);
258:
259: dbms_sql.bind_variable
260: (l_cursor_2,'l_as_of_date',l_as_of_date );
261: dbms_sql.bind_variable

Line 259: dbms_sql.bind_variable

255: AND :l_as_of_date BETWEEN prior active_start_date AND prior active_end_date) ';
256:
257: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);
258:
259: dbms_sql.bind_variable
260: (l_cursor_2,'l_as_of_date',l_as_of_date );
261: dbms_sql.bind_variable
262: (l_cursor_2,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
263:

Line 261: dbms_sql.bind_variable

257: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);
258:
259: dbms_sql.bind_variable
260: (l_cursor_2,'l_as_of_date',l_as_of_date );
261: dbms_sql.bind_variable
262: (l_cursor_2,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
263:
264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);

Line 264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);

260: (l_cursor_2,'l_as_of_date',l_as_of_date );
261: dbms_sql.bind_variable
262: (l_cursor_2,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
263:
264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);

Line 265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);

261: dbms_sql.bind_variable
262: (l_cursor_2,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
263:
264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);

Line 266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);

262: (l_cursor_2,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
263:
264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);

Line 267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);

263:
264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);

Line 268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);

264: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

Line 269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);

265: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

Line 270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);

266: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);

Line 271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);

267: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);

Line 272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

268: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);

Line 273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

269: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);

Line 274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);

270: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);

Line 275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);

271: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);

Line 276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);

272: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);

Line 277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);

273: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);

Line 278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);

274: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);

Line 279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);

275: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);

Line 280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);

276: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);

Line 281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);

277: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);

Line 282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);

278: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);

Line 283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);

279: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);

Line 284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);

280: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);

Line 285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);

281: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);

Line 286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);

282: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);

Line 287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);

283: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);

Line 288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);

284: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);

Line 289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);

285: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

Line 290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);

286: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);

Line 291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);

287: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);

Line 292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);

288: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
296:

Line 293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

289: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
296:
297: l_rows_2 := dbms_sql.execute(l_cursor_2);

Line 294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);

290: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
296:
297: l_rows_2 := dbms_sql.execute(l_cursor_2);
298:

Line 295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);

291: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
292: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
296:
297: l_rows_2 := dbms_sql.execute(l_cursor_2);
298:
299: LOOP

Line 297: l_rows_2 := dbms_sql.execute(l_cursor_2);

293: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
294: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
295: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
296:
297: l_rows_2 := dbms_sql.execute(l_cursor_2);
298:
299: LOOP
300:
301: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );

Line 301: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );

297: l_rows_2 := dbms_sql.execute(l_cursor_2);
298:
299: LOOP
300:
301: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
302: EXIT WHEN l_count_2 <> 1;
303:
304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);

Line 304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);

300:
301: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
302: EXIT WHEN l_count_2 <> 1;
303:
304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);

Line 305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);

301: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
302: EXIT WHEN l_count_2 <> 1;
303:
304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);

Line 306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);

302: EXIT WHEN l_count_2 <> 1;
303:
304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);

Line 307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);

303:
304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);

Line 308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);

304: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

Line 309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);

305: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

Line 310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);

306: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);

Line 311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);

307: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);

Line 312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

308: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);

Line 313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

309: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);

Line 314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);

310: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);

Line 315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);

311: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);

Line 316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);

312: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);

Line 317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);

313: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);

Line 318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);

314: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);

Line 319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);

315: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);

Line 320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);

316: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);

Line 321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);

317: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);

Line 322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);

318: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);

Line 323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);

319: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);

Line 324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);

320: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);

Line 325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);

321: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);

Line 326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);

322: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);

Line 327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);

323: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);

Line 328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);

324: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);

Line 329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);

325: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

Line 330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);

326: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);

Line 331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);

327: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);

Line 332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);

328: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
336:

Line 333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

329: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
336:
337: l_cursor_3 := dbms_sql.open_cursor;

Line 334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);

330: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
336:
337: l_cursor_3 := dbms_sql.open_cursor;
338: l_statement_3 :=

Line 335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);

331: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
332: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
336:
337: l_cursor_3 := dbms_sql.open_cursor;
338: l_statement_3 :=
339: 'SELECT

Line 337: l_cursor_3 := dbms_sql.open_cursor;

333: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
334: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
335: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
336:
337: l_cursor_3 := dbms_sql.open_cursor;
338: l_statement_3 :=
339: 'SELECT
340: distinct
341: les.lease_id LEASE_ID,

Line 362: dbms_sql.parse(l_cursor_3, l_statement_3, dbms_sql.native);

358: AND p.property_id(+) = loc.property_id';
359:
360: l_statement_3 := l_statement_3 || lease_number_where_clause ;
361:
362: dbms_sql.parse(l_cursor_3, l_statement_3, dbms_sql.native);
363:
364: dbms_sql.bind_variable
365: (l_cursor_3,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
366:

Line 364: dbms_sql.bind_variable

360: l_statement_3 := l_statement_3 || lease_number_where_clause ;
361:
362: dbms_sql.parse(l_cursor_3, l_statement_3, dbms_sql.native);
363:
364: dbms_sql.bind_variable
365: (l_cursor_3,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
366:
367: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
368: dbms_sql.bind_variable

Line 368: dbms_sql.bind_variable

364: dbms_sql.bind_variable
365: (l_cursor_3,'l_LOCATION_ID_1',v_LOCATION_ID_1 );
366:
367: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
368: dbms_sql.bind_variable
369: (l_cursor_3,'l_lease_number_low',l_lease_number_low );
370: dbms_sql.bind_variable
371: (l_cursor_3,'l_lease_number_high',l_lease_number_high );
372:

Line 370: dbms_sql.bind_variable

366:
367: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN
368: dbms_sql.bind_variable
369: (l_cursor_3,'l_lease_number_low',l_lease_number_low );
370: dbms_sql.bind_variable
371: (l_cursor_3,'l_lease_number_high',l_lease_number_high );
372:
373: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
374: dbms_sql.bind_variable

Line 374: dbms_sql.bind_variable

370: dbms_sql.bind_variable
371: (l_cursor_3,'l_lease_number_high',l_lease_number_high );
372:
373: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
374: dbms_sql.bind_variable
375: (l_cursor_3,'l_lease_number_high',l_lease_number_high );
376: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
377: dbms_sql.bind_variable
378: (l_cursor_3,'l_lease_number_low',l_lease_number_low );

Line 377: dbms_sql.bind_variable

373: ELSIF lease_number_low IS NULL AND lease_number_high IS NOT NULL THEN
374: dbms_sql.bind_variable
375: (l_cursor_3,'l_lease_number_high',l_lease_number_high );
376: ELSIF lease_number_low IS NOT NULL AND lease_number_high IS NULL THEN
377: dbms_sql.bind_variable
378: (l_cursor_3,'l_lease_number_low',l_lease_number_low );
379: END IF;
380:
381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);

Line 381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);

377: dbms_sql.bind_variable
378: (l_cursor_3,'l_lease_number_low',l_lease_number_low );
379: END IF;
380:
381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);
382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);

Line 382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);

378: (l_cursor_3,'l_lease_number_low',l_lease_number_low );
379: END IF;
380:
381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);
382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);

Line 383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);

379: END IF;
380:
381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);
382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);
387:

Line 384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);

380:
381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);
382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);
387:
388: l_rows_3 := dbms_sql.execute(l_cursor_3);

Line 385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);

381: dbms_sql.define_column (l_cursor_3, 1,V_LEASE_ID);
382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);
387:
388: l_rows_3 := dbms_sql.execute(l_cursor_3);
389:

Line 386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);

382: dbms_sql.define_column (l_cursor_3, 2,V_LEASE_NAME,50);
383: dbms_sql.define_column (l_cursor_3, 3,V_LEASE_NUMBER,30);
384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);
387:
388: l_rows_3 := dbms_sql.execute(l_cursor_3);
389:
390: LOOP

Line 388: l_rows_3 := dbms_sql.execute(l_cursor_3);

384: dbms_sql.define_column (l_cursor_3, 4,V_LEASE_COM_DATE);
385: dbms_sql.define_column (l_cursor_3, 5,V_LEASE_TERM_DATE);
386: dbms_sql.define_column (l_cursor_3, 6,V_PROPERTY_CODE,90);
387:
388: l_rows_3 := dbms_sql.execute(l_cursor_3);
389:
390: LOOP
391:
392: l_count_3 := dbms_sql.fetch_rows( l_cursor_3 );

Line 392: l_count_3 := dbms_sql.fetch_rows( l_cursor_3 );

388: l_rows_3 := dbms_sql.execute(l_cursor_3);
389:
390: LOOP
391:
392: l_count_3 := dbms_sql.fetch_rows( l_cursor_3 );
393:
394: EXIT WHEN l_count_3 <> 1;
395:
396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);

Line 396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);

392: l_count_3 := dbms_sql.fetch_rows( l_cursor_3 );
393:
394: EXIT WHEN l_count_3 <> 1;
395:
396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);
397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);

Line 397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);

393:
394: EXIT WHEN l_count_3 <> 1;
395:
396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);
397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);

Line 398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);

394: EXIT WHEN l_count_3 <> 1;
395:
396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);
397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);
402:

Line 399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);

395:
396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);
397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);
402:
403: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);

Line 400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);

396: dbms_sql.column_value (l_cursor_3, 1,V_LEASE_ID);
397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);
402:
403: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
404: INSERT INTO pn_space_util_lease_itf

Line 401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);

397: dbms_sql.column_value (l_cursor_3, 2,V_LEASE_NAME);
398: dbms_sql.column_value (l_cursor_3, 3,V_LEASE_NUMBER);
399: dbms_sql.column_value (l_cursor_3, 4,V_LEASE_COM_DATE);
400: dbms_sql.column_value (l_cursor_3, 5,V_LEASE_TERM_DATE);
401: dbms_sql.column_value (l_cursor_3, 6,V_PROPERTY_CODE);
402:
403: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
404: INSERT INTO pn_space_util_lease_itf
405: (LEASE_ID ,

Line 511: IF dbms_sql.is_open (l_cursor_3) THEN

507: l_request_id );
508:
509: END LOOP;
510:
511: IF dbms_sql.is_open (l_cursor_3) THEN
512: dbms_sql.close_cursor (l_cursor_3);
513: END IF;
514:
515: END LOOP;

Line 512: dbms_sql.close_cursor (l_cursor_3);

508:
509: END LOOP;
510:
511: IF dbms_sql.is_open (l_cursor_3) THEN
512: dbms_sql.close_cursor (l_cursor_3);
513: END IF;
514:
515: END LOOP;
516:

Line 517: IF dbms_sql.is_open (l_cursor_2) THEN

513: END IF;
514:
515: END LOOP;
516:
517: IF dbms_sql.is_open (l_cursor_2) THEN
518: dbms_sql.close_cursor (l_cursor_2);
519: END IF;
520:
521: END LOOP;

Line 518: dbms_sql.close_cursor (l_cursor_2);

514:
515: END LOOP;
516:
517: IF dbms_sql.is_open (l_cursor_2) THEN
518: dbms_sql.close_cursor (l_cursor_2);
519: END IF;
520:
521: END LOOP;
522:

Line 523: IF dbms_sql.is_open (l_cursor) THEN

519: END IF;
520:
521: END LOOP;
522:
523: IF dbms_sql.is_open (l_cursor) THEN
524: dbms_sql.close_cursor (l_cursor);
525: END IF;
526:
527: COMMIT;

Line 524: dbms_sql.close_cursor (l_cursor);

520:
521: END LOOP;
522:
523: IF dbms_sql.is_open (l_cursor) THEN
524: dbms_sql.close_cursor (l_cursor);
525: END IF;
526:
527: COMMIT;
528: