5448: IF (p_query_or_next_code = 'Q') THEN
5449: v_tbl.DELETE;
5450: create_sql_statement;
5451: --dump_long_line('v_sel:',v_select);
5452: v_cursor_id := DBMS_SQL.open_cursor;
5453: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5454:
5455: -- bind variables only if they added to the sql statement
5456: IF (p_task_id IS NOT NULL) THEN
5449: v_tbl.DELETE;
5450: create_sql_statement;
5451: --dump_long_line('v_sel:',v_select);
5452: v_cursor_id := DBMS_SQL.open_cursor;
5453: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5454:
5455: -- bind variables only if they added to the sql statement
5456: IF (p_task_id IS NOT NULL) THEN
5457: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5453: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5454:
5455: -- bind variables only if they added to the sql statement
5456: IF (p_task_id IS NOT NULL) THEN
5457: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5458: END IF;
5459:
5460: IF (p_description IS NOT NULL) THEN
5461: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5457: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5458: END IF;
5459:
5460: IF (p_description IS NOT NULL) THEN
5461: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5462: END IF;
5463:
5464: IF (p_task_status_id IS NOT NULL) THEN
5465: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5461: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5462: END IF;
5463:
5464: IF (p_task_status_id IS NOT NULL) THEN
5465: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5466: END IF;
5467:
5468: IF (p_task_priority_id IS NOT NULL) THEN
5469: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5465: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5466: END IF;
5467:
5468: IF (p_task_priority_id IS NOT NULL) THEN
5469: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5470: END IF;
5471:
5472: IF (p_owner_type_code IS NOT NULL) THEN
5473: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5469: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5470: END IF;
5471:
5472: IF (p_owner_type_code IS NOT NULL) THEN
5473: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5474: END IF;
5475:
5476: IF (p_owner_id IS NOT NULL) THEN
5477: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5473: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5474: END IF;
5475:
5476: IF (p_owner_id IS NOT NULL) THEN
5477: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5478: END IF;
5479:
5480: IF (p_assigned_by_id IS NOT NULL) THEN
5481: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5477: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5478: END IF;
5479:
5480: IF (p_assigned_by_id IS NOT NULL) THEN
5481: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5482: END IF;
5483:
5484: IF (p_address_id IS NOT NULL) THEN
5485: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5481: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5482: END IF;
5483:
5484: IF (p_address_id IS NOT NULL) THEN
5485: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5486: END IF;
5487:
5488: IF (p_planned_start_date IS NOT NULL) THEN
5489: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5485: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5486: END IF;
5487:
5488: IF (p_planned_start_date IS NOT NULL) THEN
5489: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5490: END IF;
5491:
5492: IF (p_planned_end_date IS NOT NULL) THEN
5493: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5489: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5490: END IF;
5491:
5492: IF (p_planned_end_date IS NOT NULL) THEN
5493: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5494: END IF;
5495:
5496: IF (p_scheduled_start_date IS NOT NULL) THEN
5497: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5493: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5494: END IF;
5495:
5496: IF (p_scheduled_start_date IS NOT NULL) THEN
5497: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5498: END IF;
5499:
5500: IF (p_scheduled_end_date IS NOT NULL) THEN
5501: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5497: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5498: END IF;
5499:
5500: IF (p_scheduled_end_date IS NOT NULL) THEN
5501: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5502: END IF;
5503:
5504: IF (p_actual_start_date IS NOT NULL) THEN
5505: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5501: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5502: END IF;
5503:
5504: IF (p_actual_start_date IS NOT NULL) THEN
5505: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5506: END IF;
5507:
5508: IF (p_actual_end_date IS NOT NULL) THEN
5509: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5505: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5506: END IF;
5507:
5508: IF (p_actual_end_date IS NOT NULL) THEN
5509: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5510: END IF;
5511:
5512: IF (p_object_type_code IS NOT NULL) THEN
5513: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5509: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5510: END IF;
5511:
5512: IF (p_object_type_code IS NOT NULL) THEN
5513: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5514: END IF;
5515:
5516: IF (p_percentage_complete IS NOT NULL) THEN
5517: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5513: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5514: END IF;
5515:
5516: IF (p_percentage_complete IS NOT NULL) THEN
5517: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5518: END IF;
5519:
5520: IF (p_reason_code IS NOT NULL) THEN
5521: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5517: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5518: END IF;
5519:
5520: IF (p_reason_code IS NOT NULL) THEN
5521: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5522: END IF;
5523:
5524: IF (p_private_flag IS NOT NULL) THEN
5525: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5521: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5522: END IF;
5523:
5524: IF (p_private_flag IS NOT NULL) THEN
5525: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5526: END IF;
5527:
5528: IF (p_restrict_closure_flag IS NOT NULL) THEN
5529: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5525: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5526: END IF;
5527:
5528: IF (p_restrict_closure_flag IS NOT NULL) THEN
5529: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5530: END IF;
5531:
5532: IF (p_multi_booked_flag IS NOT NULL) THEN
5533: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5529: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5530: END IF;
5531:
5532: IF (p_multi_booked_flag IS NOT NULL) THEN
5533: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5534: END IF;
5535:
5536: IF (p_milestone_flag IS NOT NULL) THEN
5537: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5533: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5534: END IF;
5535:
5536: IF (p_milestone_flag IS NOT NULL) THEN
5537: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5538: END IF;
5539:
5540: IF (p_holiday_flag IS NOT NULL) THEN
5541: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5537: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5538: END IF;
5539:
5540: IF (p_holiday_flag IS NOT NULL) THEN
5541: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5542: END IF;
5543:
5544: IF (p_workflow_process_id IS NOT NULL) THEN
5545: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5541: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5542: END IF;
5543:
5544: IF (p_workflow_process_id IS NOT NULL) THEN
5545: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5546: END IF;
5547:
5548: IF (p_notification_flag IS NOT NULL) THEN
5549: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5545: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5546: END IF;
5547:
5548: IF (p_notification_flag IS NOT NULL) THEN
5549: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5550: END IF;
5551:
5552: IF (p_parent_task_id IS NOT NULL) THEN
5553: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5549: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5550: END IF;
5551:
5552: IF (p_parent_task_id IS NOT NULL) THEN
5553: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5554: END IF;
5555:
5556: IF (p_alarm_on IS NOT NULL) THEN
5557: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5553: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5554: END IF;
5555:
5556: IF (p_alarm_on IS NOT NULL) THEN
5557: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5558: END IF;
5559:
5560: IF (p_alarm_count IS NOT NULL) THEN
5561: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5557: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5558: END IF;
5559:
5560: IF (p_alarm_count IS NOT NULL) THEN
5561: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5562: END IF;
5563:
5564: IF (p_alarm_fired_count IS NOT NULL) THEN
5565: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5561: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5562: END IF;
5563:
5564: IF (p_alarm_fired_count IS NOT NULL) THEN
5565: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5566: END IF;
5567:
5568: IF (p_task_name IS NOT NULL) THEN
5569: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5565: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5566: END IF;
5567:
5568: IF (p_task_name IS NOT NULL) THEN
5569: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5570: END IF;
5571:
5572: IF (p_owner_territory_id IS NOT NULL) THEN
5573: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5569: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5570: END IF;
5571:
5572: IF (p_owner_territory_id IS NOT NULL) THEN
5573: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5574: END IF;
5575:
5576: IF (p_customer_id IS NOT NULL) THEN
5577: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5573: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5574: END IF;
5575:
5576: IF (p_customer_id IS NOT NULL) THEN
5577: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5578: END IF;
5579:
5580: IF (p_cust_account_id IS NOT NULL) THEN
5581: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5577: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5578: END IF;
5579:
5580: IF (p_cust_account_id IS NOT NULL) THEN
5581: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5582: END IF;
5583:
5584: IF (p_task_type_id IS NOT NULL) THEN
5585: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5581: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5582: END IF;
5583:
5584: IF (p_task_type_id IS NOT NULL) THEN
5585: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5586: END IF;
5587:
5588: IF (p_source_object_id IS NOT NULL) THEN
5589: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5585: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5586: END IF;
5587:
5588: IF (p_source_object_id IS NOT NULL) THEN
5589: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5590: END IF;
5591:
5592: IF (p_location_id IS NOT NULL) THEN
5593: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5589: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5590: END IF;
5591:
5592: IF (p_location_id IS NOT NULL) THEN
5593: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5594: END IF;
5595:
5596: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5597: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5593: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5594: END IF;
5595:
5596: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5597: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5599: END IF;
5600:
5601: -- define the output columns
5594: END IF;
5595:
5596: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5597: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5599: END IF;
5600:
5601: -- define the output columns
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5599: END IF;
5600:
5601: -- define the output columns
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5599: END IF;
5600:
5601: -- define the output columns
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5600:
5601: -- define the output columns
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5601: -- define the output columns
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5602: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5603: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5604: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5605: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5606: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5607: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5608: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5609: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5610: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5611: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5612: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5613: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5614: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5615: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5616: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5617: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5618: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5619: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5620: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5621: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5622: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5623: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5624: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5625: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5626: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5627: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5628: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5629: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5630: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5631: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5632: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5633: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5634: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5635: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5636: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5637: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5638: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5639: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5640: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5641: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5642: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5643: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5644: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5645: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5646: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5647: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5648: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5649: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5650: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5651: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5652: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5653: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5654: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5655: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5656: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5657: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5658: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5659: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5660: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5661: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5662: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5663: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5664: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5665: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5666: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5667: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5668: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5669: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5670: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5671: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5679: v_cnt := 0;
5672: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5679: v_cnt := 0;
5680:
5673: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5679: v_cnt := 0;
5680:
5681: LOOP
5674: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5675: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5676: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5677: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5679: v_cnt := 0;
5680:
5681: LOOP
5682: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5678: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5679: v_cnt := 0;
5680:
5681: LOOP
5682: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5683: v_cnt := v_cnt + 1;
5684: -- retrieve the rows from the buffer
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5681: LOOP
5682: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5683: v_cnt := v_cnt + 1;
5684: -- retrieve the rows from the buffer
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5682: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5683: v_cnt := v_cnt + 1;
5684: -- retrieve the rows from the buffer
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5683: v_cnt := v_cnt + 1;
5684: -- retrieve the rows from the buffer
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5684: -- retrieve the rows from the buffer
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5685: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5686: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5687: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5688: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5689: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5690: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5691: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5692: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5693: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5694: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5695: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5696: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5697: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5698: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5699: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5700: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5701: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5702: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5703: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5704: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5705: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5706: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5707: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5708: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5709: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5710: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5711: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5712: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5713: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5714: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5715: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5716: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5717: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5718: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5719: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5720: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5721: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5722: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5723: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5724: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5725: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5726: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5727: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5728: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5729: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5730: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5731: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5732: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5733: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5734: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5735: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5736: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5737: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5738: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5739: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5740: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5741: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5742: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5743: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5744: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5745: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5746: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5747: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5748: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5749: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5750: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5751: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5752: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5760: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5753: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5760: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5761: -- 'v_type.task_id:'||
5754: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5760: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5761: -- 'v_type.task_id:'||
5762: -- to_char(v_type.task_id));
5755: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5760: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5761: -- 'v_type.task_id:'||
5762: -- to_char(v_type.task_id));
5763: v_tbl(v_cnt) := v_type;
5756: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5757: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5758: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5759: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5760: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5761: -- 'v_type.task_id:'||
5762: -- to_char(v_type.task_id));
5763: v_tbl(v_cnt) := v_type;
5764: END LOOP;
5762: -- to_char(v_type.task_id));
5763: v_tbl(v_cnt) := v_type;
5764: END LOOP;
5765:
5766: DBMS_SQL.close_cursor(v_cursor_id);
5767: END IF; --p_query_or_next_code;
5768:
5769: -- copy records to be returned back
5770: x_total_retrieved := v_tbl.COUNT;
6138: IF (p_query_or_next_code = 'Q') THEN
6139: v_n_tbl.DELETE;
6140: create_sql_statement;
6141: --dump_long_line('v_sel:',v_select);
6142: v_cursor_id := DBMS_SQL.open_cursor;
6143: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
6144:
6145: -- bind variables only if they added to the sql statement
6146: IF (p_query_type = 'DEPENDENCY') THEN
6139: v_n_tbl.DELETE;
6140: create_sql_statement;
6141: --dump_long_line('v_sel:',v_select);
6142: v_cursor_id := DBMS_SQL.open_cursor;
6143: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
6144:
6145: -- bind variables only if they added to the sql statement
6146: IF (p_query_type = 'DEPENDENCY') THEN
6147: IF (p_task_id IS NOT NULL) THEN
6144:
6145: -- bind variables only if they added to the sql statement
6146: IF (p_query_type = 'DEPENDENCY') THEN
6147: IF (p_task_id IS NOT NULL) THEN
6148: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6149: END IF;
6150: ELSIF(p_query_type = 'ASSIGNED') THEN
6151: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6147: IF (p_task_id IS NOT NULL) THEN
6148: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6149: END IF;
6150: ELSIF(p_query_type = 'ASSIGNED') THEN
6151: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6153: ELSIF(p_query_type = 'OWNER') THEN
6154: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6155: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6148: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6149: END IF;
6150: ELSIF(p_query_type = 'ASSIGNED') THEN
6151: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6153: ELSIF(p_query_type = 'OWNER') THEN
6154: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6155: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6156: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6150: ELSIF(p_query_type = 'ASSIGNED') THEN
6151: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6153: ELSIF(p_query_type = 'OWNER') THEN
6154: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6155: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6156: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6157: END IF;
6158:
6151: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6153: ELSIF(p_query_type = 'OWNER') THEN
6154: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6155: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6156: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6157: END IF;
6158:
6159: -- define the output columns
6152: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6153: ELSIF(p_query_type = 'OWNER') THEN
6154: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6155: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6156: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6157: END IF;
6158:
6159: -- define the output columns
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6156: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6157: END IF;
6158:
6159: -- define the output columns
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6157: END IF;
6158:
6159: -- define the output columns
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6158:
6159: -- define the output columns
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6159: -- define the output columns
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6160: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6161: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6162: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6163: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6164: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6165: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6166: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6167: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6168: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6169: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6170: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6171: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6172: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6173: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6174: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6175: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6176: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6177: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6178: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6179: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6180: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6181: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6182: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6183: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6184: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6185: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6186: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6187: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6188: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6189: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6190: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6191: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6192: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6193: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6194: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6195: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6196: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6197: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6198: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6199: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6200: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6201: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6202: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6203: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6204: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6205: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6206: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6207: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6208: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6209: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6210: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6211: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6212: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6213: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6214: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6215: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6216: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6217: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6218: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6219: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6220: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6221: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6229: v_cnt := 0;
6222: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6229: v_cnt := 0;
6230:
6223: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6229: v_cnt := 0;
6230:
6231: LOOP
6224: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6225: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6226: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6227: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6229: v_cnt := 0;
6230:
6231: LOOP
6232: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6228: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6229: v_cnt := 0;
6230:
6231: LOOP
6232: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6233: v_cnt := v_cnt + 1;
6234: -- retrieve the rows from the buffer
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6231: LOOP
6232: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6233: v_cnt := v_cnt + 1;
6234: -- retrieve the rows from the buffer
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6232: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6233: v_cnt := v_cnt + 1;
6234: -- retrieve the rows from the buffer
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6233: v_cnt := v_cnt + 1;
6234: -- retrieve the rows from the buffer
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6234: -- retrieve the rows from the buffer
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6235: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6236: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6237: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6238: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6239: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6240: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6241: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6242: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6243: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6244: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6245: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6246: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6247: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6248: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6249: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6250: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6251: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6252: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6253: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6254: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6255: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6256: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6257: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6258: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6259: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6260: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6261: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6262: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6263: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6264: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6265: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6266: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6267: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6268: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6269: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6270: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6271: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6272: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6273: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6274: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6275: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6276: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6277: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6278: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6279: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6280: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6281: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6282: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6283: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6284: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6285: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6286: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6287: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6288: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6289: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6290: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6291: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6292: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6293: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6294: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6302: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6295: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6302: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6303: -- 'v_type.task_id:'||
6296: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6302: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6303: -- 'v_type.task_id:'||
6304: -- to_char(v_type.task_id));
6297: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6302: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6303: -- 'v_type.task_id:'||
6304: -- to_char(v_type.task_id));
6305: v_n_tbl(v_cnt) := v_type;
6298: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6299: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6300: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6301: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6302: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6303: -- 'v_type.task_id:'||
6304: -- to_char(v_type.task_id));
6305: v_n_tbl(v_cnt) := v_type;
6306: END LOOP;
6303: -- 'v_type.task_id:'||
6304: -- to_char(v_type.task_id));
6305: v_n_tbl(v_cnt) := v_type;
6306: END LOOP;
6307: --dbms_sql.close_cursor(v_cursor_id);
6308: END IF; --p_query_or_next_code;
6309:
6310: -- copy records to be returned back
6311: x_total_retrieved := v_n_tbl.COUNT;