[Home] [Help]
78: -- FOR loading Locations Info into the Interface Table ( FOR CAFM )
79: -- ( Run AS a Conc Process )
80: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )
81: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced pn_addresses with _ALL table.
82: -- 29-SEP-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
83: -----------------------------------------------------------------------------
84: PROCEDURE exp_loc_to_cad_itf (
85: p_batch_name IN VARCHAR2 ,
86: p_locn_type IN VARCHAR2 ,
201: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
202: fnd_message.set_token ('TYPE',p_locn_type);
203: pnp_debug_pkg.put_log_msg(fnd_message.get);
204:
205: l_cursor := dbms_sql.open_cursor;
206: l_statement :=
207: 'SELECT
208: LOCATION_ID,
209: LOCATION_CODE,
312: END IF;
313:
314: l_statement := l_statement || ' order by L.LOCATION_CODE' ;
315:
316: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
317:
318: dbms_sql.bind_variable
319: (l_cursor,'date_from',l_last_update_from );
320:
314: l_statement := l_statement || ' order by L.LOCATION_CODE' ;
315:
316: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
317:
318: dbms_sql.bind_variable
319: (l_cursor,'date_from',l_last_update_from );
320:
321: dbms_sql.bind_variable
322: (l_cursor,'date_to',l_last_update_to );
317:
318: dbms_sql.bind_variable
319: (l_cursor,'date_from',l_last_update_from );
320:
321: dbms_sql.bind_variable
322: (l_cursor,'date_to',l_last_update_to );
323:
324: IF (p_locn_type <> 'ALL') THEN
325: dbms_sql.bind_variable
321: dbms_sql.bind_variable
322: (l_cursor,'date_to',l_last_update_to );
323:
324: IF (p_locn_type <> 'ALL') THEN
325: dbms_sql.bind_variable
326: (l_cursor, 'l_locn_type', l_locn_type );
327: END IF;
328:
329: IF p_locn_code_from IS NOT NULL THEN
326: (l_cursor, 'l_locn_type', l_locn_type );
327: END IF;
328:
329: IF p_locn_code_from IS NOT NULL THEN
330: dbms_sql.bind_variable
331: (l_cursor, 'l_locn_code_from', l_locn_code_from );
332: END IF;
333:
334: IF p_locn_code_to IS NOT NULL THEN
331: (l_cursor, 'l_locn_code_from', l_locn_code_from );
332: END IF;
333:
334: IF p_locn_code_to IS NOT NULL THEN
335: dbms_sql.bind_variable
336: (l_cursor, 'l_locn_code_to', l_locn_code_to );
337: END IF;
338:
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
335: dbms_sql.bind_variable
336: (l_cursor, 'l_locn_code_to', l_locn_code_to );
337: END IF;
338:
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
336: (l_cursor, 'l_locn_code_to', l_locn_code_to );
337: END IF;
338:
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
337: END IF;
338:
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
338:
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
339: dbms_sql.define_column (l_cursor, 1,v_location_id);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
340: dbms_sql.define_column (l_cursor, 2,v_location_code,90);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
341: dbms_sql.define_column (l_cursor, 3,v_location_type_lookup_code,30);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
342: dbms_sql.define_column (l_cursor, 4,v_space_type_lookup_code,30);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
343: dbms_sql.define_column (l_cursor, 5,v_parent_location_id);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
344: dbms_sql.define_column (l_cursor, 6,v_lease_or_owned,30);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
345: dbms_sql.define_column (l_cursor, 7,v_building,30);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
346: dbms_sql.define_column (l_cursor, 8,v_floor,20);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
347: dbms_sql.define_column (l_cursor, 9,v_office,20);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
348: dbms_sql.define_column (l_cursor, 10,v_address_line1,240);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
349: dbms_sql.define_column (l_cursor, 11,v_address_line2,240);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
350: dbms_sql.define_column (l_cursor, 12,v_address_line3,240);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
351: dbms_sql.define_column (l_cursor, 13,v_address_line4,240);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
352: dbms_sql.define_column (l_cursor, 14,v_county,60);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
353: dbms_sql.define_column (l_cursor, 15,v_city,60);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
354: dbms_sql.define_column (l_cursor, 16,v_state,60);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
355: dbms_sql.define_column (l_cursor, 17,v_province,60);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
356: dbms_sql.define_column (l_cursor, 18,v_zip_code,60);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
357: dbms_sql.define_column (l_cursor, 19,v_country,60);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
358: dbms_sql.define_column (l_cursor, 20,v_address_style,30);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
359: dbms_sql.define_column (l_cursor, 21,v_max_capacity);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
360: dbms_sql.define_column (l_cursor, 22,v_optimum_capacity);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
361: dbms_sql.define_column (l_cursor, 23,v_rentable_area);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
362: dbms_sql.define_column (l_cursor, 24,v_usable_area);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
363: dbms_sql.define_column (l_cursor, 25,v_allocate_cost_center_code,30);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
364: dbms_sql.define_column (l_cursor, 26,v_uom_code,3);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
365: dbms_sql.define_column (l_cursor, 27,v_attribute_category,30);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
366: dbms_sql.define_column (l_cursor, 28,v_attribute1,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
367: dbms_sql.define_column (l_cursor, 29,v_attribute2,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
368: dbms_sql.define_column (l_cursor, 30,v_attribute3,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
369: dbms_sql.define_column (l_cursor, 31,v_attribute4,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
370: dbms_sql.define_column (l_cursor, 32,v_attribute5,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
371: dbms_sql.define_column (l_cursor, 33,v_attribute6,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
372: dbms_sql.define_column (l_cursor, 34,v_attribute7,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
373: dbms_sql.define_column (l_cursor, 35,v_attribute8,150);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
374: dbms_sql.define_column (l_cursor, 36,v_attribute9,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
375: dbms_sql.define_column (l_cursor, 37,v_attribute10,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
376: dbms_sql.define_column (l_cursor, 38,v_attribute11,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
377: dbms_sql.define_column (l_cursor, 39,v_attribute12,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
378: dbms_sql.define_column (l_cursor, 40,v_attribute13,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
379: dbms_sql.define_column (l_cursor, 41,v_attribute14,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
380: dbms_sql.define_column (l_cursor, 42,v_attribute15,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
381: dbms_sql.define_column (l_cursor, 43,v_addr_attribute_category,30);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
382: dbms_sql.define_column (l_cursor, 44,v_addr_attribute1,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
383: dbms_sql.define_column (l_cursor, 45,v_addr_attribute2,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
384: dbms_sql.define_column (l_cursor, 46,v_addr_attribute3,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
385: dbms_sql.define_column (l_cursor, 47,v_addr_attribute4,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
386: dbms_sql.define_column (l_cursor, 48,v_addr_attribute5,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
387: dbms_sql.define_column (l_cursor, 49,v_addr_attribute6,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
388: dbms_sql.define_column (l_cursor, 50,v_addr_attribute7,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
389: dbms_sql.define_column (l_cursor, 51,v_addr_attribute8,150);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
390: dbms_sql.define_column (l_cursor, 52,v_addr_attribute9,150);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
391: dbms_sql.define_column (l_cursor, 53,v_addr_attribute10,150);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
392: dbms_sql.define_column (l_cursor, 54,v_addr_attribute11,150);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
393: dbms_sql.define_column (l_cursor, 55,v_addr_attribute12,150);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
394: dbms_sql.define_column (l_cursor, 56,v_addr_attribute13,150);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
395: dbms_sql.define_column (l_cursor, 57,v_addr_attribute14,150);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
396: dbms_sql.define_column (l_cursor, 58,v_addr_attribute15,150);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
397: dbms_sql.define_column (l_cursor, 59,v_source,80);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
398: dbms_sql.define_column (l_cursor, 60,v_gross_area);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
399: dbms_sql.define_column (l_cursor, 61,v_assignable_area);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
400: dbms_sql.define_column (l_cursor, 62,v_class,30);
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
401: dbms_sql.define_column (l_cursor, 63,v_status_type,30);
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
402: dbms_sql.define_column (l_cursor, 64,v_suite,30);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
410: l_rows := dbms_sql.execute(l_cursor);
403: dbms_sql.define_column (l_cursor, 65,v_common_area);
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
410: l_rows := dbms_sql.execute(l_cursor);
411:
404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
410: l_rows := dbms_sql.execute(l_cursor);
411:
412: LOOP
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
410: l_rows := dbms_sql.execute(l_cursor);
411:
412: LOOP
413:
414: l_count := dbms_sql.fetch_rows( l_cursor );
410: l_rows := dbms_sql.execute(l_cursor);
411:
412: LOOP
413:
414: l_count := dbms_sql.fetch_rows( l_cursor );
415:
416: EXIT WHEN l_count <> 1;
417:
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
414: l_count := dbms_sql.fetch_rows( l_cursor );
415:
416: EXIT WHEN l_count <> 1;
417:
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
415:
416: EXIT WHEN l_count <> 1;
417:
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
416: EXIT WHEN l_count <> 1;
417:
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
417:
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
418: dbms_sql.column_value (l_cursor, 1,v_location_id);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
419: dbms_sql.column_value (l_cursor, 2,v_location_code);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
420: dbms_sql.column_value (l_cursor, 3,v_location_type_lookup_code);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
421: dbms_sql.column_value (l_cursor, 4,v_space_type_lookup_code);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
422: dbms_sql.column_value (l_cursor, 5,v_parent_location_id);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
423: dbms_sql.column_value (l_cursor, 6,v_lease_or_owned);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
424: dbms_sql.column_value (l_cursor, 7,v_building);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
425: dbms_sql.column_value (l_cursor, 8,v_floor);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
426: dbms_sql.column_value (l_cursor, 9,v_office);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
427: dbms_sql.column_value (l_cursor, 10,v_address_line1);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
428: dbms_sql.column_value (l_cursor, 11,v_address_line2);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
429: dbms_sql.column_value (l_cursor, 12,v_address_line3);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
430: dbms_sql.column_value (l_cursor, 13,v_address_line4);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
431: dbms_sql.column_value (l_cursor, 14,v_county);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
432: dbms_sql.column_value (l_cursor, 15,v_city);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
433: dbms_sql.column_value (l_cursor, 16,v_state);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
434: dbms_sql.column_value (l_cursor, 17,v_province);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
435: dbms_sql.column_value (l_cursor, 18,v_zip_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
436: dbms_sql.column_value (l_cursor, 19,v_country);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
437: dbms_sql.column_value (l_cursor, 20,v_address_style);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
438: dbms_sql.column_value (l_cursor, 21,v_max_capacity);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
439: dbms_sql.column_value (l_cursor, 22,v_optimum_capacity);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
440: dbms_sql.column_value (l_cursor, 23,v_rentable_area);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
441: dbms_sql.column_value (l_cursor, 24,v_usable_area);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
442: dbms_sql.column_value (l_cursor, 25,v_allocate_cost_center_code);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
443: dbms_sql.column_value (l_cursor, 26,v_uom_code);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
444: dbms_sql.column_value (l_cursor, 27,v_attribute_category);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
445: dbms_sql.column_value (l_cursor, 28,v_attribute1);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
446: dbms_sql.column_value (l_cursor, 29,v_attribute2);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
447: dbms_sql.column_value (l_cursor, 30,v_attribute3);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
448: dbms_sql.column_value (l_cursor, 31,v_attribute4);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
449: dbms_sql.column_value (l_cursor, 32,v_attribute5);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
450: dbms_sql.column_value (l_cursor, 33,v_attribute6);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
451: dbms_sql.column_value (l_cursor, 34,v_attribute7);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
452: dbms_sql.column_value (l_cursor, 35,v_attribute8);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
453: dbms_sql.column_value (l_cursor, 36,v_attribute9);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
454: dbms_sql.column_value (l_cursor, 37,v_attribute10);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
455: dbms_sql.column_value (l_cursor, 38,v_attribute11);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
456: dbms_sql.column_value (l_cursor, 39,v_attribute12);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
457: dbms_sql.column_value (l_cursor, 40,v_attribute13);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
458: dbms_sql.column_value (l_cursor, 41,v_attribute14);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
459: dbms_sql.column_value (l_cursor, 42,v_attribute15);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
460: dbms_sql.column_value (l_cursor, 43,v_addr_attribute_category);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
461: dbms_sql.column_value (l_cursor, 44,v_addr_attribute1);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
462: dbms_sql.column_value (l_cursor, 45,v_addr_attribute2);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
463: dbms_sql.column_value (l_cursor, 46,v_addr_attribute3);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
464: dbms_sql.column_value (l_cursor, 47,v_addr_attribute4);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
465: dbms_sql.column_value (l_cursor, 48,v_addr_attribute5);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
466: dbms_sql.column_value (l_cursor, 49,v_addr_attribute6);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
467: dbms_sql.column_value (l_cursor, 50,v_addr_attribute7);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
468: dbms_sql.column_value (l_cursor, 51,v_addr_attribute8);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
469: dbms_sql.column_value (l_cursor, 52,v_addr_attribute9);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
470: dbms_sql.column_value (l_cursor, 53,v_addr_attribute10);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
471: dbms_sql.column_value (l_cursor, 54,v_addr_attribute11);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
472: dbms_sql.column_value (l_cursor, 55,v_addr_attribute12);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
473: dbms_sql.column_value (l_cursor, 56,v_addr_attribute13);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
474: dbms_sql.column_value (l_cursor, 57,v_addr_attribute14);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
475: dbms_sql.column_value (l_cursor, 58,v_addr_attribute15);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
476: dbms_sql.column_value (l_cursor, 59,v_source);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
477: dbms_sql.column_value (l_cursor, 60,v_gross_area);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
478: dbms_sql.column_value (l_cursor, 61,v_assignable_area);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
479: dbms_sql.column_value (l_cursor, 62,v_class);
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
480: dbms_sql.column_value (l_cursor, 63,v_status_type);
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
488: -- Check if data exists in ITF table already.
481: dbms_sql.column_value (l_cursor, 64,v_suite);
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
488: -- Check if data exists in ITF table already.
489:
482: dbms_sql.column_value (l_cursor, 65,v_common_area);
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
488: -- Check if data exists in ITF table already.
489:
490: exists_in_itf := 0;
483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
488: -- Check if data exists in ITF table already.
489:
490: exists_in_itf := 0;
491:
806: pnp_debug_pkg.put_log_msg(fnd_message.get);
807:
808: END LOOP;
809:
810: IF dbms_sql.is_open (l_cursor) THEN
811: dbms_sql.close_cursor (l_cursor);
812: END IF;
813: -- Commit our work.
814:
807:
808: END LOOP;
809:
810: IF dbms_sql.is_open (l_cursor) THEN
811: dbms_sql.close_cursor (l_cursor);
812: END IF;
813: -- Commit our work.
814:
815: COMMIT;
844: -- For loading Space Allocations Info into the Interface Table ( FOR CAFM )
845: -- ( Run AS a Conc Process )
846: -- ( PN_SPACE_ALLOCATIONS --> PN_EMP_SPACE_ASSIGN_ITF )
847: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced PN_LOCATIONS with _ALL table.
848: -- 04-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql
849: -- 28-AUG-06 Shabda o Bug 5449595 - Added changes to accomodate
850: -- project_id and task_id
851: -- 29-AUG-06 SHABDA o Bug 5449595 - Removed long log messages. Removed unused
852: -- commented code
931: fnd_message.set_token ('TYPE',p_locn_type);
932: pnp_debug_pkg.put_log_msg(fnd_message.get);
933:
934:
935: l_cursor := dbms_sql.open_cursor;
936:
937: l_statement :=
938: 'SELECT
939: SP.EMP_SPACE_ASSIGN_ID,
1003:
1004: END IF;
1005:
1006:
1007: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1008:
1009: pnp_debug_pkg.log(' after parse ');
1010:
1011: dbms_sql.bind_variable
1007: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1008:
1009: pnp_debug_pkg.log(' after parse ');
1010:
1011: dbms_sql.bind_variable
1012: (l_cursor,'as_of_date',l_as_of_date );
1013:
1014: dbms_sql.bind_variable
1015: (l_cursor,'v_date',vl_date );
1010:
1011: dbms_sql.bind_variable
1012: (l_cursor,'as_of_date',l_as_of_date );
1013:
1014: dbms_sql.bind_variable
1015: (l_cursor,'v_date',vl_date );
1016:
1017: dbms_sql.bind_variable
1018: (l_cursor,'date_from',l_last_update_from );
1013:
1014: dbms_sql.bind_variable
1015: (l_cursor,'v_date',vl_date );
1016:
1017: dbms_sql.bind_variable
1018: (l_cursor,'date_from',l_last_update_from );
1019:
1020: dbms_sql.bind_variable
1021: (l_cursor,'date_to',l_last_update_to );
1016:
1017: dbms_sql.bind_variable
1018: (l_cursor,'date_from',l_last_update_from );
1019:
1020: dbms_sql.bind_variable
1021: (l_cursor,'date_to',l_last_update_to );
1022:
1023: IF(p_locn_type <> 'ALL') THEN
1024: dbms_sql.bind_variable
1020: dbms_sql.bind_variable
1021: (l_cursor,'date_to',l_last_update_to );
1022:
1023: IF(p_locn_type <> 'ALL') THEN
1024: dbms_sql.bind_variable
1025: (l_cursor, 'l_locn_type', l_locn_type );
1026: END IF;
1027:
1028: IF p_locn_code_FROM IS NOT NULL THEN
1025: (l_cursor, 'l_locn_type', l_locn_type );
1026: END IF;
1027:
1028: IF p_locn_code_FROM IS NOT NULL THEN
1029: dbms_sql.bind_variable
1030: (l_cursor, 'l_locn_code_from', l_locn_code_from );
1031: END IF;
1032:
1033: IF p_locn_code_to IS NOT NULL THEN
1030: (l_cursor, 'l_locn_code_from', l_locn_code_from );
1031: END IF;
1032:
1033: IF p_locn_code_to IS NOT NULL THEN
1034: dbms_sql.bind_variable
1035: (l_cursor, 'l_locn_code_to', l_locn_code_to );
1036: END IF;
1037:
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1034: dbms_sql.bind_variable
1035: (l_cursor, 'l_locn_code_to', l_locn_code_to );
1036: END IF;
1037:
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1035: (l_cursor, 'l_locn_code_to', l_locn_code_to );
1036: END IF;
1037:
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1036: END IF;
1037:
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1037:
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1038: dbms_sql.define_column (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1039: dbms_sql.define_column (l_cursor, 2,v_LOCATION_ID);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1040: dbms_sql.define_column (l_cursor, 3,v_person_id);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1041: dbms_sql.define_column (l_cursor, 4,v_COST_CENTER_CODE,30);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1042: dbms_sql.define_column (l_cursor, 5,v_ALLOCATED_AREA);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1043: dbms_sql.define_column (l_cursor, 6,v_ATTRIBUTE_CATEGORY,30);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1044: dbms_sql.define_column (l_cursor, 7,v_ATTRIBUTE1,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1045: dbms_sql.define_column (l_cursor, 8,v_ATTRIBUTE2,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1046: dbms_sql.define_column (l_cursor, 9,v_ATTRIBUTE3,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1047: dbms_sql.define_column (l_cursor, 10,v_ATTRIBUTE4,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1048: dbms_sql.define_column (l_cursor, 11,v_ATTRIBUTE5,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1049: dbms_sql.define_column (l_cursor, 12,v_ATTRIBUTE6,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1050: dbms_sql.define_column (l_cursor, 13,v_ATTRIBUTE7,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1051: dbms_sql.define_column (l_cursor, 14,v_ATTRIBUTE8,150);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1052: dbms_sql.define_column (l_cursor, 15,v_ATTRIBUTE9,150);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1053: dbms_sql.define_column (l_cursor, 16,v_ATTRIBUTE10,150);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1054: dbms_sql.define_column (l_cursor, 17,v_ATTRIBUTE11,150);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1055: dbms_sql.define_column (l_cursor, 18,v_ATTRIBUTE12,150);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1056: dbms_sql.define_column (l_cursor, 19,v_ATTRIBUTE13,150);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1057: dbms_sql.define_column (l_cursor, 20,v_ATTRIBUTE14,150);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1058: dbms_sql.define_column (l_cursor, 21,v_ATTRIBUTE15,150);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1059: dbms_sql.define_column (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE,30);
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1067:
1060: dbms_sql.define_column (l_cursor, 23,v_LOCATION_CODE,90);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1067:
1068: l_rows := dbms_sql.execute(l_cursor);
1061: dbms_sql.define_column (l_cursor, 24,v_SOURCE,80);
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1067:
1068: l_rows := dbms_sql.execute(l_cursor);
1069:
1062: dbms_sql.define_column (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1063: dbms_sql.define_column (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1067:
1068: l_rows := dbms_sql.execute(l_cursor);
1069:
1070: LOOP
1064: dbms_sql.define_column (l_cursor, 27,v_UTILIZED_AREA);
1065: dbms_sql.define_column (l_cursor, 28,v_PROJECT_ID);
1066: dbms_sql.define_column (l_cursor, 29,v_TASK_ID);
1067:
1068: l_rows := dbms_sql.execute(l_cursor);
1069:
1070: LOOP
1071:
1072: l_count := dbms_sql.fetch_rows( l_cursor );
1068: l_rows := dbms_sql.execute(l_cursor);
1069:
1070: LOOP
1071:
1072: l_count := dbms_sql.fetch_rows( l_cursor );
1073:
1074: pnp_debug_pkg.log(' after fetch_rows');
1075: EXIT WHEN l_count <>1;
1076:
1073:
1074: pnp_debug_pkg.log(' after fetch_rows');
1075: EXIT WHEN l_count <>1;
1076:
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1074: pnp_debug_pkg.log(' after fetch_rows');
1075: EXIT WHEN l_count <>1;
1076:
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1075: EXIT WHEN l_count <>1;
1076:
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1076:
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1079: dbms_sql.column_value (l_cursor, 3,v_person_id);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1080: dbms_sql.column_value (l_cursor, 4,v_COST_CENTER_CODE);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1081: dbms_sql.column_value (l_cursor, 5,v_ALLOCATED_AREA);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1082: dbms_sql.column_value (l_cursor, 6,v_ATTRIBUTE_CATEGORY);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1083: dbms_sql.column_value (l_cursor, 7,v_ATTRIBUTE1);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1084: dbms_sql.column_value (l_cursor, 8,v_ATTRIBUTE2);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1085: dbms_sql.column_value (l_cursor, 9,v_ATTRIBUTE3);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1086: dbms_sql.column_value (l_cursor, 10,v_ATTRIBUTE4);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1087: dbms_sql.column_value (l_cursor, 11,v_ATTRIBUTE5);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1088: dbms_sql.column_value (l_cursor, 12,v_ATTRIBUTE6);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1089: dbms_sql.column_value (l_cursor, 13,v_ATTRIBUTE7);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1090: dbms_sql.column_value (l_cursor, 14,v_ATTRIBUTE8);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1091: dbms_sql.column_value (l_cursor, 15,v_ATTRIBUTE9);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1092: dbms_sql.column_value (l_cursor, 16,v_ATTRIBUTE10);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1093: dbms_sql.column_value (l_cursor, 17,v_ATTRIBUTE11);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1094: dbms_sql.column_value (l_cursor, 18,v_ATTRIBUTE12);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1095: dbms_sql.column_value (l_cursor, 19,v_ATTRIBUTE13);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1096: dbms_sql.column_value (l_cursor, 20,v_ATTRIBUTE14);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1097: dbms_sql.column_value (l_cursor, 21,v_ATTRIBUTE15);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1105: dbms_sql.column_value (l_cursor, 29,v_TASK_ID);
1098: dbms_sql.column_value (l_cursor, 22,v_LOCATION_TYPE_LOOKUP_CODE);
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1105: dbms_sql.column_value (l_cursor, 29,v_TASK_ID);
1106:
1099: dbms_sql.column_value (l_cursor, 23,v_LOCATION_CODE);
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1105: dbms_sql.column_value (l_cursor, 29,v_TASK_ID);
1106:
1107: -- Check if data exists in ITF table already.
1100: dbms_sql.column_value (l_cursor, 24,v_SOURCE);
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1105: dbms_sql.column_value (l_cursor, 29,v_TASK_ID);
1106:
1107: -- Check if data exists in ITF table already.
1108:
1101: dbms_sql.column_value (l_cursor, 25,v_EMP_ASSIGN_START_DATE);
1102: dbms_sql.column_value (l_cursor, 26,v_EMP_ASSIGN_END_DATE);
1103: dbms_sql.column_value (l_cursor, 27,v_UTILIZED_AREA);
1104: dbms_sql.column_value (l_cursor, 28,v_PROJECT_ID);
1105: dbms_sql.column_value (l_cursor, 29,v_TASK_ID);
1106:
1107: -- Check if data exists in ITF table already.
1108:
1109: exists_in_itf := 0;
1291: pnp_debug_pkg.put_log_msg(fnd_message.get);
1292:
1293: END LOOP;
1294:
1295: IF dbms_sql.is_open (l_cursor) THEN
1296: dbms_sql.close_cursor (l_cursor);
1297: END IF;
1298: -- Commit our work.
1299: commit;
1292:
1293: END LOOP;
1294:
1295: IF dbms_sql.is_open (l_cursor) THEN
1296: dbms_sql.close_cursor (l_cursor);
1297: END IF;
1298: -- Commit our work.
1299: commit;
1300: