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

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

6: -- INVOKED FROM :
7: -- PURPOSE :
8: -- HISTORY :
9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_locations with _ALL table
10: -- 25-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
11: -------------------------------------------------------------------------------
12: PROCEDURE pn_space_util_loc(
13: property_code_low IN VARCHAR2,
14: property_code_high IN VARCHAR2,

Line 112: l_cursor := dbms_sql.open_cursor;

108: retcode:=0;
109: errbuf:='';
110: fnd_profile.get('LOGIN_ID', l_login_id);
111:
112: l_cursor := dbms_sql.open_cursor;
113: l_statement :=
114: 'SELECT
115: loc.location_id LOCATION_ID
116: FROM pn_locations_all loc,

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

180: END IF;
181:
182: pnp_debug_pkg.log('l_statement:'||l_statement);
183:
184: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
185:
186: dbms_sql.bind_variable
187: (l_cursor,'l_as_of_date',l_as_of_date );
188:

Line 186: dbms_sql.bind_variable

182: pnp_debug_pkg.log('l_statement:'||l_statement);
183:
184: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
185:
186: dbms_sql.bind_variable
187: (l_cursor,'l_as_of_date',l_as_of_date );
188:
189: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
190: dbms_sql.bind_variable

Line 190: dbms_sql.bind_variable

186: dbms_sql.bind_variable
187: (l_cursor,'l_as_of_date',l_as_of_date );
188:
189: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
190: dbms_sql.bind_variable
191: (l_cursor,'l_property_code_low',l_property_code_low );
192: dbms_sql.bind_variable
193: (l_cursor,'l_property_code_high',l_property_code_high );
194:

Line 192: dbms_sql.bind_variable

188:
189: IF property_code_low IS NOT NULL AND property_code_high IS NOT NULL THEN
190: dbms_sql.bind_variable
191: (l_cursor,'l_property_code_low',l_property_code_low );
192: dbms_sql.bind_variable
193: (l_cursor,'l_property_code_high',l_property_code_high );
194:
195: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
196: dbms_sql.bind_variable

Line 196: dbms_sql.bind_variable

192: dbms_sql.bind_variable
193: (l_cursor,'l_property_code_high',l_property_code_high );
194:
195: ELSIF property_code_low IS NULL AND property_code_high IS NOT NULL THEN
196: dbms_sql.bind_variable
197: (l_cursor,'l_property_code_high',l_property_code_high );
198:
199: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
200: dbms_sql.bind_variable

Line 200: dbms_sql.bind_variable

196: dbms_sql.bind_variable
197: (l_cursor,'l_property_code_high',l_property_code_high );
198:
199: ELSIF property_code_low IS NOT NULL AND property_code_high IS NULL THEN
200: dbms_sql.bind_variable
201: (l_cursor,'l_property_code_low',l_property_code_low );
202: END IF;
203:
204: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN

Line 205: dbms_sql.bind_variable

201: (l_cursor,'l_property_code_low',l_property_code_low );
202: END IF;
203:
204: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
205: dbms_sql.bind_variable
206: (l_cursor,'l_location_code_high',l_location_code_high );
207: dbms_sql.bind_variable
208: (l_cursor,'l_location_code_low',l_location_code_low );
209:

Line 207: dbms_sql.bind_variable

203:
204: IF location_code_low IS NOT NULL AND location_code_high IS NOT NULL THEN
205: dbms_sql.bind_variable
206: (l_cursor,'l_location_code_high',l_location_code_high );
207: dbms_sql.bind_variable
208: (l_cursor,'l_location_code_low',l_location_code_low );
209:
210: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
211: dbms_sql.bind_variable

Line 211: dbms_sql.bind_variable

207: dbms_sql.bind_variable
208: (l_cursor,'l_location_code_low',l_location_code_low );
209:
210: ELSIF location_code_low IS NULL AND location_code_high IS NOT NULL THEN
211: dbms_sql.bind_variable
212: (l_cursor,'l_location_code_high',l_location_code_high );
213:
214: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
215: dbms_sql.bind_variable

Line 215: dbms_sql.bind_variable

211: dbms_sql.bind_variable
212: (l_cursor,'l_location_code_high',l_location_code_high );
213:
214: ELSIF location_code_low IS NOT NULL AND location_code_high IS NULL THEN
215: dbms_sql.bind_variable
216: (l_cursor,'l_location_code_low',l_location_code_low );
217: END IF;
218:
219: IF location_type IS NOT NULL THEN

Line 220: dbms_sql.bind_variable

216: (l_cursor,'l_location_code_low',l_location_code_low );
217: END IF;
218:
219: IF location_type IS NOT NULL THEN
220: dbms_sql.bind_variable
221: (l_cursor,'l_location_type',l_location_type );
222: END IF;
223:
224: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);

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

220: dbms_sql.bind_variable
221: (l_cursor,'l_location_type',l_location_type );
222: END IF;
223:
224: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);
225:
226: l_rows := dbms_sql.execute(l_cursor);
227:
228: LOOP

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

222: END IF;
223:
224: dbms_sql.define_column (l_cursor, 1,V_LOCATION_ID_1);
225:
226: l_rows := dbms_sql.execute(l_cursor);
227:
228: LOOP
229:
230: l_count := dbms_sql.fetch_rows( l_cursor );

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

226: l_rows := dbms_sql.execute(l_cursor);
227:
228: LOOP
229:
230: l_count := dbms_sql.fetch_rows( l_cursor );
231:
232: EXIT WHEN l_count <> 1;
233:
234: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);

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

230: l_count := dbms_sql.fetch_rows( l_cursor );
231:
232: EXIT WHEN l_count <> 1;
233:
234: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);
235:
236: l_cursor_2 := dbms_sql.open_cursor;
237: l_statement_2 :=
238: 'SELECT

Line 236: l_cursor_2 := dbms_sql.open_cursor;

232: EXIT WHEN l_count <> 1;
233:
234: dbms_sql.column_value (l_cursor, 1,V_LOCATION_ID_1);
235:
236: l_cursor_2 := dbms_sql.open_cursor;
237: l_statement_2 :=
238: 'SELECT
239: loc.location_id LOCATION_ID,
240: fl1.meaning LOCATION_TYPE,

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

313: AND :l_as_of_date BETWEEN prior active_start_date AND prior active_end_date)';
314:
315: l_LOCATION_ID_1 := V_LOCATION_ID_1;
316:
317: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);
318:
319: dbms_sql.bind_variable
320: (l_cursor_2,'l_as_of_date',l_as_of_date );
321:

Line 319: dbms_sql.bind_variable

315: l_LOCATION_ID_1 := V_LOCATION_ID_1;
316:
317: dbms_sql.parse(l_cursor_2, l_statement_2, dbms_sql.native);
318:
319: dbms_sql.bind_variable
320: (l_cursor_2,'l_as_of_date',l_as_of_date );
321:
322: dbms_sql.bind_variable
323: (l_cursor_2,'l_LOCATION_ID_1',l_LOCATION_ID_1 );

Line 322: dbms_sql.bind_variable

318:
319: dbms_sql.bind_variable
320: (l_cursor_2,'l_as_of_date',l_as_of_date );
321:
322: dbms_sql.bind_variable
323: (l_cursor_2,'l_LOCATION_ID_1',l_LOCATION_ID_1 );
324:
325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);

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

321:
322: dbms_sql.bind_variable
323: (l_cursor_2,'l_LOCATION_ID_1',l_LOCATION_ID_1 );
324:
325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);

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

322: dbms_sql.bind_variable
323: (l_cursor_2,'l_LOCATION_ID_1',l_LOCATION_ID_1 );
324:
325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);

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

323: (l_cursor_2,'l_LOCATION_ID_1',l_LOCATION_ID_1 );
324:
325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);

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

324:
325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);

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

325: dbms_sql.define_column (l_cursor_2, 1,V_LOCATION_ID);
326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

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

326: dbms_sql.define_column (l_cursor_2, 2,V_LOCATION_TYPE,80);
327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

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

327: dbms_sql.define_column (l_cursor_2, 3,V_LOCATION_NAME,30);
328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);

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

328: dbms_sql.define_column (l_cursor_2, 4,V_LOCATION_CODE,90);
329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);

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

329: dbms_sql.define_column (l_cursor_2, 5,V_RENTABLE_AREA);
330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);

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

330: dbms_sql.define_column (l_cursor_2, 6,V_USABLE_AREA);
331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);

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

331: dbms_sql.define_column (l_cursor_2, 7,V_ASSIGNABLE_AREA);
332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);

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

332: dbms_sql.define_column (l_cursor_2, 8,V_COMMON_AREA);
333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);

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

333: dbms_sql.define_column (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);

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

334: dbms_sql.define_column (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);

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

335: dbms_sql.define_column (l_cursor_2, 11,V_USAGE_TYPE,80);
336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);

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

336: dbms_sql.define_column (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY,30);
337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);

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

337: dbms_sql.define_column (l_cursor_2, 13,V_ATTRIBUTE1,150);
338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);

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

338: dbms_sql.define_column (l_cursor_2, 14,V_ATTRIBUTE2,150);
339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);

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

339: dbms_sql.define_column (l_cursor_2, 15,V_ATTRIBUTE3,150);
340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);

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

340: dbms_sql.define_column (l_cursor_2, 16,V_ATTRIBUTE4,150);
341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);

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

341: dbms_sql.define_column (l_cursor_2, 17,V_ATTRIBUTE5,150);
342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);

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

342: dbms_sql.define_column (l_cursor_2, 18,V_ATTRIBUTE6,150);
343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);

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

343: dbms_sql.define_column (l_cursor_2, 19,V_ATTRIBUTE7,150);
344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);

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

344: dbms_sql.define_column (l_cursor_2, 20,V_ATTRIBUTE8,150);
345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);

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

345: dbms_sql.define_column (l_cursor_2, 21,V_ATTRIBUTE9,150);
346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);

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

346: dbms_sql.define_column (l_cursor_2, 22,V_ATTRIBUTE10,150);
347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

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

347: dbms_sql.define_column (l_cursor_2, 23,V_ATTRIBUTE11,150);
348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);

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

348: dbms_sql.define_column (l_cursor_2, 24,V_ATTRIBUTE12,150);
349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);

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

349: dbms_sql.define_column (l_cursor_2, 25,V_ATTRIBUTE13,150);
350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
357:

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

350: dbms_sql.define_column (l_cursor_2, 26,V_ATTRIBUTE14,150);
351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
357:
358: l_rows_2 := dbms_sql.execute(l_cursor_2);

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

351: dbms_sql.define_column (l_cursor_2, 27,V_ATTRIBUTE15,150);
352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
357:
358: l_rows_2 := dbms_sql.execute(l_cursor_2);
359:

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

352: dbms_sql.define_column (l_cursor_2, 28,V_LAST_UPDATE_DATE);
353: dbms_sql.define_column (l_cursor_2, 29,V_LAST_UPDATED_BY);
354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
357:
358: l_rows_2 := dbms_sql.execute(l_cursor_2);
359:
360: LOOP

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

354: dbms_sql.define_column (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
355: dbms_sql.define_column (l_cursor_2, 31,V_CREATION_DATE);
356: dbms_sql.define_column (l_cursor_2, 32,V_CREATED_BY);
357:
358: l_rows_2 := dbms_sql.execute(l_cursor_2);
359:
360: LOOP
361: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
362:

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

357:
358: l_rows_2 := dbms_sql.execute(l_cursor_2);
359:
360: LOOP
361: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
362:
363: EXIT WHEN l_count_2 <> 1;
364:
365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);

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

361: l_count_2 := dbms_sql.fetch_rows( l_cursor_2 );
362:
363: EXIT WHEN l_count_2 <> 1;
364:
365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);

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

362:
363: EXIT WHEN l_count_2 <> 1;
364:
365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);

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

363: EXIT WHEN l_count_2 <> 1;
364:
365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);

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

364:
365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);

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

365: dbms_sql.column_value (l_cursor_2, 1,V_LOCATION_ID);
366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);

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

366: dbms_sql.column_value (l_cursor_2, 2,V_LOCATION_TYPE);
367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);

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

367: dbms_sql.column_value (l_cursor_2, 3,V_LOCATION_NAME);
368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);

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

368: dbms_sql.column_value (l_cursor_2, 4,V_LOCATION_CODE);
369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);

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

369: dbms_sql.column_value (l_cursor_2, 5,V_RENTABLE_AREA);
370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);

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

370: dbms_sql.column_value (l_cursor_2, 6,V_USABLE_AREA);
371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);

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

371: dbms_sql.column_value (l_cursor_2, 7,V_ASSIGNABLE_AREA);
372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);

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

372: dbms_sql.column_value (l_cursor_2, 8,V_COMMON_AREA);
373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);

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

373: dbms_sql.column_value (l_cursor_2, 9,V_MAXIMUM_OCCUPANCY);
374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);

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

374: dbms_sql.column_value (l_cursor_2, 10,V_OPTIMUM_OCCUPANCY);
375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);

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

375: dbms_sql.column_value (l_cursor_2, 11,V_USAGE_TYPE);
376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);

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

376: dbms_sql.column_value (l_cursor_2, 12,V_ATTRIBUTE_CATEGORY);
377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);

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

377: dbms_sql.column_value (l_cursor_2, 13,V_ATTRIBUTE1);
378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);

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

378: dbms_sql.column_value (l_cursor_2, 14,V_ATTRIBUTE2);
379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);

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

379: dbms_sql.column_value (l_cursor_2, 15,V_ATTRIBUTE3);
380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);

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

380: dbms_sql.column_value (l_cursor_2, 16,V_ATTRIBUTE4);
381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);

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

381: dbms_sql.column_value (l_cursor_2, 17,V_ATTRIBUTE5);
382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);

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

382: dbms_sql.column_value (l_cursor_2, 18,V_ATTRIBUTE6);
383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);

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

383: dbms_sql.column_value (l_cursor_2, 19,V_ATTRIBUTE7);
384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);

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

384: dbms_sql.column_value (l_cursor_2, 20,V_ATTRIBUTE8);
385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);

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

385: dbms_sql.column_value (l_cursor_2, 21,V_ATTRIBUTE9);
386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);

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

386: dbms_sql.column_value (l_cursor_2, 22,V_ATTRIBUTE10);
387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);

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

387: dbms_sql.column_value (l_cursor_2, 23,V_ATTRIBUTE11);
388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);

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

388: dbms_sql.column_value (l_cursor_2, 24,V_ATTRIBUTE12);
389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);

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

389: dbms_sql.column_value (l_cursor_2, 25,V_ATTRIBUTE13);
390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:

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

390: dbms_sql.column_value (l_cursor_2, 26,V_ATTRIBUTE14);
391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:
398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');

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

391: dbms_sql.column_value (l_cursor_2, 27,V_ATTRIBUTE15);
392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:
398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');
399: v_code_data := pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);

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

392: dbms_sql.column_value (l_cursor_2, 28,V_LAST_UPDATE_DATE);
393: dbms_sql.column_value (l_cursor_2, 29,V_LAST_UPDATED_BY);
394: dbms_sql.column_value (l_cursor_2, 30,V_LAST_UPDATE_LOGIN);
395: dbms_sql.column_value (l_cursor_2, 31,V_CREATION_DATE);
396: dbms_sql.column_value (l_cursor_2, 32,V_CREATED_BY);
397:
398: pnp_debug_pkg.log(' bfore insert into pn_space_util_loc_itf ');
399: v_code_data := pnp_util_func.get_location_name(V_LOCATION_ID, as_of_date);
400:

Line 510: IF dbms_sql.is_open (l_cursor_2) THEN

506:
507: END LOOP;
508: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn: c_util_loc Loop (-)');
509:
510: IF dbms_sql.is_open (l_cursor_2) THEN
511: dbms_sql.close_cursor (l_cursor_2);
512: END IF;
513:
514: END LOOP;

Line 511: dbms_sql.close_cursor (l_cursor_2);

507: END LOOP;
508: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn: c_util_loc Loop (-)');
509:
510: IF dbms_sql.is_open (l_cursor_2) THEN
511: dbms_sql.close_cursor (l_cursor_2);
512: END IF;
513:
514: END LOOP;
515: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn Loop (-)');

Line 517: IF dbms_sql.is_open (l_cursor) THEN

513:
514: END LOOP;
515: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn Loop (-)');
516:
517: IF dbms_sql.is_open (l_cursor) THEN
518: dbms_sql.close_cursor (l_cursor);
519: END IF;
520:
521: COMMIT;

Line 518: dbms_sql.close_cursor (l_cursor);

514: END LOOP;
515: pnp_debug_pkg.put_log_msg('PNRXULOB: c_pn Loop (-)');
516:
517: IF dbms_sql.is_open (l_cursor) THEN
518: dbms_sql.close_cursor (l_cursor);
519: END IF;
520:
521: COMMIT;
522: --If there is something amiss...