5529: IF (p_query_or_next_code = 'Q') THEN
5530: v_tbl.DELETE;
5531: create_sql_statement;
5532: --dump_long_line('v_sel:',v_select);
5533: v_cursor_id := DBMS_SQL.open_cursor;
5534: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5535:
5536: -- bind variables only if they added to the sql statement
5537: IF (p_task_id IS NOT NULL) THEN
5530: v_tbl.DELETE;
5531: create_sql_statement;
5532: --dump_long_line('v_sel:',v_select);
5533: v_cursor_id := DBMS_SQL.open_cursor;
5534: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5535:
5536: -- bind variables only if they added to the sql statement
5537: IF (p_task_id IS NOT NULL) THEN
5538: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5534: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
5535:
5536: -- bind variables only if they added to the sql statement
5537: IF (p_task_id IS NOT NULL) THEN
5538: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5539: END IF;
5540:
5541: IF (p_description IS NOT NULL) THEN
5542: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5538: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
5539: END IF;
5540:
5541: IF (p_description IS NOT NULL) THEN
5542: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5543: END IF;
5544:
5545: IF (p_task_status_id IS NOT NULL) THEN
5546: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5542: DBMS_SQL.bind_variable(v_cursor_id, ':b2', p_description);
5543: END IF;
5544:
5545: IF (p_task_status_id IS NOT NULL) THEN
5546: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5547: END IF;
5548:
5549: IF (p_task_priority_id IS NOT NULL) THEN
5550: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5546: DBMS_SQL.bind_variable(v_cursor_id, ':b3', p_task_status_id);
5547: END IF;
5548:
5549: IF (p_task_priority_id IS NOT NULL) THEN
5550: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5551: END IF;
5552:
5553: IF (p_owner_type_code IS NOT NULL) THEN
5554: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5550: DBMS_SQL.bind_variable(v_cursor_id, ':b4', p_task_priority_id);
5551: END IF;
5552:
5553: IF (p_owner_type_code IS NOT NULL) THEN
5554: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5555: END IF;
5556:
5557: IF (p_owner_id IS NOT NULL) THEN
5558: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5554: DBMS_SQL.bind_variable(v_cursor_id, ':b5', p_owner_type_code);
5555: END IF;
5556:
5557: IF (p_owner_id IS NOT NULL) THEN
5558: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5559: END IF;
5560:
5561: IF (p_assigned_by_id IS NOT NULL) THEN
5562: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5558: DBMS_SQL.bind_variable(v_cursor_id, ':b6', p_owner_id);
5559: END IF;
5560:
5561: IF (p_assigned_by_id IS NOT NULL) THEN
5562: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5563: END IF;
5564:
5565: IF (p_address_id IS NOT NULL) THEN
5566: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5562: DBMS_SQL.bind_variable(v_cursor_id, ':b7', p_assigned_by_id);
5563: END IF;
5564:
5565: IF (p_address_id IS NOT NULL) THEN
5566: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5567: END IF;
5568:
5569: IF (p_planned_start_date IS NOT NULL) THEN
5570: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5566: DBMS_SQL.bind_variable(v_cursor_id, ':b8', p_address_id);
5567: END IF;
5568:
5569: IF (p_planned_start_date IS NOT NULL) THEN
5570: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5571: END IF;
5572:
5573: IF (p_planned_end_date IS NOT NULL) THEN
5574: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5570: DBMS_SQL.bind_variable(v_cursor_id, ':b9', p_planned_start_date);
5571: END IF;
5572:
5573: IF (p_planned_end_date IS NOT NULL) THEN
5574: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5575: END IF;
5576:
5577: IF (p_scheduled_start_date IS NOT NULL) THEN
5578: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5574: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_planned_end_date);
5575: END IF;
5576:
5577: IF (p_scheduled_start_date IS NOT NULL) THEN
5578: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5579: END IF;
5580:
5581: IF (p_scheduled_end_date IS NOT NULL) THEN
5582: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5578: DBMS_SQL.bind_variable(v_cursor_id, ':b11', p_scheduled_start_date);
5579: END IF;
5580:
5581: IF (p_scheduled_end_date IS NOT NULL) THEN
5582: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5583: END IF;
5584:
5585: IF (p_actual_start_date IS NOT NULL) THEN
5586: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5582: DBMS_SQL.bind_variable(v_cursor_id, ':b12', p_scheduled_end_date);
5583: END IF;
5584:
5585: IF (p_actual_start_date IS NOT NULL) THEN
5586: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5587: END IF;
5588:
5589: IF (p_actual_end_date IS NOT NULL) THEN
5590: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5586: DBMS_SQL.bind_variable(v_cursor_id, ':b13', p_actual_start_date);
5587: END IF;
5588:
5589: IF (p_actual_end_date IS NOT NULL) THEN
5590: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5591: END IF;
5592:
5593: IF (p_object_type_code IS NOT NULL) THEN
5594: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5590: DBMS_SQL.bind_variable(v_cursor_id, ':b14', p_actual_end_date);
5591: END IF;
5592:
5593: IF (p_object_type_code IS NOT NULL) THEN
5594: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5595: END IF;
5596:
5597: IF (p_percentage_complete IS NOT NULL) THEN
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5594: DBMS_SQL.bind_variable(v_cursor_id, ':b15', p_object_type_code);
5595: END IF;
5596:
5597: IF (p_percentage_complete IS NOT NULL) THEN
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5599: END IF;
5600:
5601: IF (p_reason_code IS NOT NULL) THEN
5602: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5598: DBMS_SQL.bind_variable(v_cursor_id, ':b16', p_percentage_complete);
5599: END IF;
5600:
5601: IF (p_reason_code IS NOT NULL) THEN
5602: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5603: END IF;
5604:
5605: IF (p_private_flag IS NOT NULL) THEN
5606: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5602: DBMS_SQL.bind_variable(v_cursor_id, ':b17', p_reason_code);
5603: END IF;
5604:
5605: IF (p_private_flag IS NOT NULL) THEN
5606: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5607: END IF;
5608:
5609: IF (p_restrict_closure_flag IS NOT NULL) THEN
5610: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5606: DBMS_SQL.bind_variable(v_cursor_id, ':b18', p_private_flag);
5607: END IF;
5608:
5609: IF (p_restrict_closure_flag IS NOT NULL) THEN
5610: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5611: END IF;
5612:
5613: IF (p_multi_booked_flag IS NOT NULL) THEN
5614: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5610: DBMS_SQL.bind_variable(v_cursor_id, ':b19', p_restrict_closure_flag);
5611: END IF;
5612:
5613: IF (p_multi_booked_flag IS NOT NULL) THEN
5614: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5615: END IF;
5616:
5617: IF (p_milestone_flag IS NOT NULL) THEN
5618: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5614: DBMS_SQL.bind_variable(v_cursor_id, ':b20', p_multi_booked_flag);
5615: END IF;
5616:
5617: IF (p_milestone_flag IS NOT NULL) THEN
5618: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5619: END IF;
5620:
5621: IF (p_holiday_flag IS NOT NULL) THEN
5622: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5618: DBMS_SQL.bind_variable(v_cursor_id, ':b21', p_milestone_flag);
5619: END IF;
5620:
5621: IF (p_holiday_flag IS NOT NULL) THEN
5622: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5623: END IF;
5624:
5625: IF (p_workflow_process_id IS NOT NULL) THEN
5626: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5622: DBMS_SQL.bind_variable(v_cursor_id, ':b22', p_holiday_flag);
5623: END IF;
5624:
5625: IF (p_workflow_process_id IS NOT NULL) THEN
5626: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5627: END IF;
5628:
5629: IF (p_notification_flag IS NOT NULL) THEN
5630: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5626: DBMS_SQL.bind_variable(v_cursor_id, ':b23', p_workflow_process_id);
5627: END IF;
5628:
5629: IF (p_notification_flag IS NOT NULL) THEN
5630: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5631: END IF;
5632:
5633: IF (p_parent_task_id IS NOT NULL) THEN
5634: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5630: DBMS_SQL.bind_variable(v_cursor_id, ':b27', p_notification_flag);
5631: END IF;
5632:
5633: IF (p_parent_task_id IS NOT NULL) THEN
5634: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5635: END IF;
5636:
5637: IF (p_alarm_on IS NOT NULL) THEN
5638: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5634: DBMS_SQL.bind_variable(v_cursor_id, ':b28', p_parent_task_id);
5635: END IF;
5636:
5637: IF (p_alarm_on IS NOT NULL) THEN
5638: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5639: END IF;
5640:
5641: IF (p_alarm_count IS NOT NULL) THEN
5642: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5638: DBMS_SQL.bind_variable(v_cursor_id, ':b29', p_alarm_on);
5639: END IF;
5640:
5641: IF (p_alarm_count IS NOT NULL) THEN
5642: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5643: END IF;
5644:
5645: IF (p_alarm_fired_count IS NOT NULL) THEN
5646: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5642: DBMS_SQL.bind_variable(v_cursor_id, ':b30', p_alarm_count);
5643: END IF;
5644:
5645: IF (p_alarm_fired_count IS NOT NULL) THEN
5646: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5647: END IF;
5648:
5649: IF (p_task_name IS NOT NULL) THEN
5650: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5646: DBMS_SQL.bind_variable(v_cursor_id, ':b31', p_alarm_fired_count);
5647: END IF;
5648:
5649: IF (p_task_name IS NOT NULL) THEN
5650: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5651: END IF;
5652:
5653: IF (p_owner_territory_id IS NOT NULL) THEN
5654: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5650: DBMS_SQL.bind_variable(v_cursor_id, ':b32', p_task_name);
5651: END IF;
5652:
5653: IF (p_owner_territory_id IS NOT NULL) THEN
5654: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5655: END IF;
5656:
5657: IF (p_customer_id IS NOT NULL) THEN
5658: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5654: DBMS_SQL.bind_variable(v_cursor_id, ':b33', p_owner_territory_id);
5655: END IF;
5656:
5657: IF (p_customer_id IS NOT NULL) THEN
5658: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5659: END IF;
5660:
5661: IF (p_cust_account_id IS NOT NULL) THEN
5662: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5658: DBMS_SQL.bind_variable(v_cursor_id, ':b34', p_customer_id);
5659: END IF;
5660:
5661: IF (p_cust_account_id IS NOT NULL) THEN
5662: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5663: END IF;
5664:
5665: IF (p_task_type_id IS NOT NULL) THEN
5666: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5662: DBMS_SQL.bind_variable(v_cursor_id, ':b35', p_cust_account_id);
5663: END IF;
5664:
5665: IF (p_task_type_id IS NOT NULL) THEN
5666: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5667: END IF;
5668:
5669: IF (p_source_object_id IS NOT NULL) THEN
5670: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5666: DBMS_SQL.bind_variable(v_cursor_id, ':b36', p_task_type_id);
5667: END IF;
5668:
5669: IF (p_source_object_id IS NOT NULL) THEN
5670: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5671: END IF;
5672:
5673: IF (p_location_id IS NOT NULL) THEN
5674: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5670: DBMS_SQL.bind_variable(v_cursor_id, ':b37', p_source_object_id);
5671: END IF;
5672:
5673: IF (p_location_id IS NOT NULL) THEN
5674: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5675: END IF;
5676:
5677: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5678: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5674: DBMS_SQL.bind_variable(v_cursor_id, ':b38', p_location_id);
5675: END IF;
5676:
5677: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5678: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5679: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5680: END IF;
5681:
5682: -- define the output columns
5675: END IF;
5676:
5677: IF (p_ref_object_type_code IS NOT NULL) AND(p_ref_object_id IS NOT NULL) THEN
5678: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_ref_object_id);
5679: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5680: END IF;
5681:
5682: -- define the output columns
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5679: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_ref_object_type_code);
5680: END IF;
5681:
5682: -- define the output columns
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5680: END IF;
5681:
5682: -- define the output columns
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5681:
5682: -- define the output columns
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5682: -- define the output columns
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5683: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5684: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5685: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5686: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5687: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5688: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5689: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5690: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5691: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5692: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5693: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 20);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5694: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5695: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5696: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5697: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5698: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5699: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5700: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5701: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5702: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5703: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5704: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5705: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5706: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5707: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5708: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5709: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5710: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5711: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5712: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5713: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5714: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5715: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5716: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5717: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5718: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5719: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5720: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5721: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5722: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5723: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5724: DBMS_SQL.define_column(v_cursor_id, 42, v_type.notification_flag, 1);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5725: DBMS_SQL.define_column(v_cursor_id, 43, v_type.notification_period);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5726: DBMS_SQL.define_column(v_cursor_id, 44, v_type.notification_period_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5727: DBMS_SQL.define_column(v_cursor_id, 45, v_type.parent_task_id);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5728: DBMS_SQL.define_column(v_cursor_id, 46, v_type.alarm_start);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5729: DBMS_SQL.define_column(v_cursor_id, 47, v_type.alarm_start_uom, 3);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5730: DBMS_SQL.define_column(v_cursor_id, 48, v_type.alarm_on, 1);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5731: DBMS_SQL.define_column(v_cursor_id, 49, v_type.alarm_count);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5732: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_fired_count);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5733: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_interval);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5734: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_interval_uom, 3);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5735: DBMS_SQL.define_column(v_cursor_id, 53, v_type.attribute1, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5736: DBMS_SQL.define_column(v_cursor_id, 54, v_type.attribute2, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5737: DBMS_SQL.define_column(v_cursor_id, 55, v_type.attribute3, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5738: DBMS_SQL.define_column(v_cursor_id, 56, v_type.attribute4, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5739: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute5, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5740: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute6, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5741: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute7, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5742: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute8, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5743: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute9, 150);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5744: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute10, 150);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5745: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute11, 150);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5746: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute12, 150);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5747: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute13, 150);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5748: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute14, 150);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5749: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute15, 150);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5750: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute_category, 150);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5751: DBMS_SQL.define_column(v_cursor_id, 69, v_type.owner, 100);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5752: DBMS_SQL.define_column(v_cursor_id, 70, v_type.cust_account_number, 30);
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5760: v_cnt := 0;
5753: DBMS_SQL.define_column(v_cursor_id, 71, v_type.cust_account_id);
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5760: v_cnt := 0;
5761:
5754: DBMS_SQL.define_column(v_cursor_id, 72, v_type.owner_territory_id);
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5760: v_cnt := 0;
5761:
5762: LOOP
5755: DBMS_SQL.define_column(v_cursor_id, 73, v_type.creation_date);
5756: DBMS_SQL.define_column(v_cursor_id, 74, v_type.escalation_level, 30);
5757: DBMS_SQL.define_column(v_cursor_id, 75, v_type.object_version_number);
5758: DBMS_SQL.define_column(v_cursor_id, 76, v_type.location_id);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5760: v_cnt := 0;
5761:
5762: LOOP
5763: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5759: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
5760: v_cnt := 0;
5761:
5762: LOOP
5763: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5764: v_cnt := v_cnt + 1;
5765: -- retrieve the rows from the buffer
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5762: LOOP
5763: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5764: v_cnt := v_cnt + 1;
5765: -- retrieve the rows from the buffer
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5763: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
5764: v_cnt := v_cnt + 1;
5765: -- retrieve the rows from the buffer
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5764: v_cnt := v_cnt + 1;
5765: -- retrieve the rows from the buffer
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5765: -- retrieve the rows from the buffer
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5766: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5767: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5768: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5769: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5770: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5771: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5772: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5773: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5774: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5775: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5776: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5777: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5778: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5779: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5780: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5781: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5782: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5783: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5784: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5785: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5786: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5787: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5788: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5789: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5790: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5791: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5792: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5793: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5794: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5795: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5796: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5797: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5798: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5799: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5800: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5801: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5802: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5803: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5804: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5805: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5806: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5807: DBMS_SQL.column_value(v_cursor_id, 42, v_type.notification_flag);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5808: DBMS_SQL.column_value(v_cursor_id, 43, v_type.notification_period);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5809: DBMS_SQL.column_value(v_cursor_id, 44, v_type.notification_period_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5810: DBMS_SQL.column_value(v_cursor_id, 45, v_type.parent_task_id);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5811: DBMS_SQL.column_value(v_cursor_id, 46, v_type.alarm_start);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5812: DBMS_SQL.column_value(v_cursor_id, 47, v_type.alarm_start_uom);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5813: DBMS_SQL.column_value(v_cursor_id, 48, v_type.alarm_on);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5814: DBMS_SQL.column_value(v_cursor_id, 49, v_type.alarm_count);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5815: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_fired_count);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5816: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_interval);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5817: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_interval_uom);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5818: DBMS_SQL.column_value(v_cursor_id, 53, v_type.attribute1);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5819: DBMS_SQL.column_value(v_cursor_id, 54, v_type.attribute2);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5820: DBMS_SQL.column_value(v_cursor_id, 55, v_type.attribute3);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5821: DBMS_SQL.column_value(v_cursor_id, 56, v_type.attribute4);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5822: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute5);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5823: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute6);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5824: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute7);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5825: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute8);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5826: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute9);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5827: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute10);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5828: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute11);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5829: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute12);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5830: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute13);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5831: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute14);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5832: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute15);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5833: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute_category);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5841: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5834: DBMS_SQL.column_value(v_cursor_id, 69, v_type.owner);
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5841: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5842: -- 'v_type.task_id:'||
5835: DBMS_SQL.column_value(v_cursor_id, 70, v_type.cust_account_number);
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5841: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5842: -- 'v_type.task_id:'||
5843: -- to_char(v_type.task_id));
5836: DBMS_SQL.column_value(v_cursor_id, 71, v_type.cust_account_id);
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5841: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5842: -- 'v_type.task_id:'||
5843: -- to_char(v_type.task_id));
5844: v_tbl(v_cnt) := v_type;
5837: DBMS_SQL.column_value(v_cursor_id, 72, v_type.owner_territory_id);
5838: DBMS_SQL.column_value(v_cursor_id, 73, v_type.creation_date);
5839: DBMS_SQL.column_value(v_cursor_id, 74, v_type.escalation_level);
5840: DBMS_SQL.column_value(v_cursor_id, 75, v_type.object_version_number);
5841: DBMS_SQL.column_value(v_cursor_id, 76, v_type.location_id);
5842: -- 'v_type.task_id:'||
5843: -- to_char(v_type.task_id));
5844: v_tbl(v_cnt) := v_type;
5845: END LOOP;
5843: -- to_char(v_type.task_id));
5844: v_tbl(v_cnt) := v_type;
5845: END LOOP;
5846:
5847: DBMS_SQL.close_cursor(v_cursor_id);
5848: END IF; --p_query_or_next_code;
5849:
5850: -- copy records to be returned back
5851: x_total_retrieved := v_tbl.COUNT;
6219: IF (p_query_or_next_code = 'Q') THEN
6220: v_n_tbl.DELETE;
6221: create_sql_statement;
6222: --dump_long_line('v_sel:',v_select);
6223: v_cursor_id := DBMS_SQL.open_cursor;
6224: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
6225:
6226: -- bind variables only if they added to the sql statement
6227: IF (p_query_type = 'DEPENDENCY') THEN
6220: v_n_tbl.DELETE;
6221: create_sql_statement;
6222: --dump_long_line('v_sel:',v_select);
6223: v_cursor_id := DBMS_SQL.open_cursor;
6224: DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
6225:
6226: -- bind variables only if they added to the sql statement
6227: IF (p_query_type = 'DEPENDENCY') THEN
6228: IF (p_task_id IS NOT NULL) THEN
6225:
6226: -- bind variables only if they added to the sql statement
6227: IF (p_query_type = 'DEPENDENCY') THEN
6228: IF (p_task_id IS NOT NULL) THEN
6229: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6230: END IF;
6231: ELSIF(p_query_type = 'ASSIGNED') THEN
6232: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6228: IF (p_task_id IS NOT NULL) THEN
6229: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6230: END IF;
6231: ELSIF(p_query_type = 'ASSIGNED') THEN
6232: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6234: ELSIF(p_query_type = 'OWNER') THEN
6235: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6236: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6229: DBMS_SQL.bind_variable(v_cursor_id, ':b1', p_task_id);
6230: END IF;
6231: ELSIF(p_query_type = 'ASSIGNED') THEN
6232: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6234: ELSIF(p_query_type = 'OWNER') THEN
6235: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6236: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6237: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6231: ELSIF(p_query_type = 'ASSIGNED') THEN
6232: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6234: ELSIF(p_query_type = 'OWNER') THEN
6235: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6236: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6237: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6238: END IF;
6239:
6232: DBMS_SQL.bind_variable(v_cursor_id, ':b10', p_assigned_by);
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6234: ELSIF(p_query_type = 'OWNER') THEN
6235: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6236: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6237: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6238: END IF;
6239:
6240: -- define the output columns
6233: DBMS_SQL.bind_variable(v_cursor_id, ':b11', v_find_date);
6234: ELSIF(p_query_type = 'OWNER') THEN
6235: DBMS_SQL.bind_variable(v_cursor_id, ':b100', p_owner_type_code);
6236: DBMS_SQL.bind_variable(v_cursor_id, ':b101', p_owner_id);
6237: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6238: END IF;
6239:
6240: -- define the output columns
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6237: DBMS_SQL.bind_variable(v_cursor_id, ':b102', v_find_date);
6238: END IF;
6239:
6240: -- define the output columns
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6238: END IF;
6239:
6240: -- define the output columns
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6239:
6240: -- define the output columns
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6240: -- define the output columns
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6241: DBMS_SQL.define_column(v_cursor_id, 1, v_type.task_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6242: DBMS_SQL.define_column(v_cursor_id, 2, v_type.task_number, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6243: DBMS_SQL.define_column(v_cursor_id, 3, v_type.task_name, 80);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6244: DBMS_SQL.define_column(v_cursor_id, 4, v_type.description, 4000);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6245: DBMS_SQL.define_column(v_cursor_id, 5, v_type.task_type_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6246: DBMS_SQL.define_column(v_cursor_id, 6, v_type.task_type, 30);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6247: DBMS_SQL.define_column(v_cursor_id, 7, v_type.task_status_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6248: DBMS_SQL.define_column(v_cursor_id, 8, v_type.task_status, 30);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6249: DBMS_SQL.define_column(v_cursor_id, 9, v_type.task_priority_id);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6250: DBMS_SQL.define_column(v_cursor_id, 10, v_type.task_priority, 30);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6251: DBMS_SQL.define_column(v_cursor_id, 11, v_type.owner_type_code, 10);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6252: DBMS_SQL.define_column(v_cursor_id, 12, v_type.owner_id);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6253: DBMS_SQL.define_column(v_cursor_id, 13, v_type.assigned_by_id);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6254: DBMS_SQL.define_column(v_cursor_id, 14, v_type.assigned_by_name, 100);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6255: DBMS_SQL.define_column(v_cursor_id, 15, v_type.customer_id);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6256: DBMS_SQL.define_column(v_cursor_id, 16, v_type.customer_name, 255);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6257: DBMS_SQL.define_column(v_cursor_id, 17, v_type.customer_number, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6258: DBMS_SQL.define_column(v_cursor_id, 18, v_type.address_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6259: DBMS_SQL.define_column(v_cursor_id, 19, v_type.planned_start_date);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6260: DBMS_SQL.define_column(v_cursor_id, 20, v_type.planned_end_date);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6261: DBMS_SQL.define_column(v_cursor_id, 21, v_type.scheduled_start_date);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6262: DBMS_SQL.define_column(v_cursor_id, 22, v_type.scheduled_end_date);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6263: DBMS_SQL.define_column(v_cursor_id, 23, v_type.actual_start_date);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6264: DBMS_SQL.define_column(v_cursor_id, 24, v_type.actual_end_date);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6265: DBMS_SQL.define_column(v_cursor_id, 25, v_type.object_type_code, 30);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6266: DBMS_SQL.define_column(v_cursor_id, 26, v_type.object_id);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6267: DBMS_SQL.define_column(v_cursor_id, 27, v_type.obect_name, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6268: DBMS_SQL.define_column(v_cursor_id, 28, v_type.DURATION);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6269: DBMS_SQL.define_column(v_cursor_id, 29, v_type.duration_uom, 3);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6270: DBMS_SQL.define_column(v_cursor_id, 30, v_type.planned_effort);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6271: DBMS_SQL.define_column(v_cursor_id, 31, v_type.planned_effort_uom, 3);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6272: DBMS_SQL.define_column(v_cursor_id, 32, v_type.actual_effort);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6273: DBMS_SQL.define_column(v_cursor_id, 33, v_type.actual_effort_uom, 3);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6274: DBMS_SQL.define_column(v_cursor_id, 34, v_type.percentage_complete);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6275: DBMS_SQL.define_column(v_cursor_id, 35, v_type.reason_code, 30);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6276: DBMS_SQL.define_column(v_cursor_id, 36, v_type.private_flag, 1);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6277: DBMS_SQL.define_column(v_cursor_id, 37, v_type.publish_flag, 1);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6278: DBMS_SQL.define_column(v_cursor_id, 38, v_type.multi_booked_flag, 1);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6279: DBMS_SQL.define_column(v_cursor_id, 39, v_type.milestone_flag, 1);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6280: DBMS_SQL.define_column(v_cursor_id, 40, v_type.holiday_flag, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6281: DBMS_SQL.define_column(v_cursor_id, 41, v_type.workflow_process_id);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6282: DBMS_SQL.define_column(v_cursor_id, 46, v_type.notification_flag, 1);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6283: DBMS_SQL.define_column(v_cursor_id, 47, v_type.notification_period);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6284: DBMS_SQL.define_column(v_cursor_id, 48, v_type.notification_period_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6285: DBMS_SQL.define_column(v_cursor_id, 49, v_type.parent_task_id);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6286: DBMS_SQL.define_column(v_cursor_id, 50, v_type.alarm_start);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6287: DBMS_SQL.define_column(v_cursor_id, 51, v_type.alarm_start_uom, 3);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6288: DBMS_SQL.define_column(v_cursor_id, 52, v_type.alarm_on, 1);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6289: DBMS_SQL.define_column(v_cursor_id, 53, v_type.alarm_count);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6290: DBMS_SQL.define_column(v_cursor_id, 54, v_type.alarm_fired_count);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6291: DBMS_SQL.define_column(v_cursor_id, 55, v_type.alarm_interval);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6292: DBMS_SQL.define_column(v_cursor_id, 56, v_type.alarm_interval_uom, 3);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6293: DBMS_SQL.define_column(v_cursor_id, 57, v_type.attribute1, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6294: DBMS_SQL.define_column(v_cursor_id, 58, v_type.attribute2, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6295: DBMS_SQL.define_column(v_cursor_id, 59, v_type.attribute3, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6296: DBMS_SQL.define_column(v_cursor_id, 60, v_type.attribute4, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6297: DBMS_SQL.define_column(v_cursor_id, 61, v_type.attribute5, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6298: DBMS_SQL.define_column(v_cursor_id, 62, v_type.attribute6, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6299: DBMS_SQL.define_column(v_cursor_id, 63, v_type.attribute7, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6300: DBMS_SQL.define_column(v_cursor_id, 64, v_type.attribute8, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6301: DBMS_SQL.define_column(v_cursor_id, 65, v_type.attribute9, 150);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6302: DBMS_SQL.define_column(v_cursor_id, 66, v_type.attribute10, 150);
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6310: v_cnt := 0;
6303: DBMS_SQL.define_column(v_cursor_id, 67, v_type.attribute11, 150);
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6310: v_cnt := 0;
6311:
6304: DBMS_SQL.define_column(v_cursor_id, 68, v_type.attribute12, 150);
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6310: v_cnt := 0;
6311:
6312: LOOP
6305: DBMS_SQL.define_column(v_cursor_id, 69, v_type.attribute13, 150);
6306: DBMS_SQL.define_column(v_cursor_id, 70, v_type.attribute14, 150);
6307: DBMS_SQL.define_column(v_cursor_id, 71, v_type.attribute15, 150);
6308: DBMS_SQL.define_column(v_cursor_id, 72, v_type.attribute_category, 150);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6310: v_cnt := 0;
6311:
6312: LOOP
6313: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6309: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
6310: v_cnt := 0;
6311:
6312: LOOP
6313: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6314: v_cnt := v_cnt + 1;
6315: -- retrieve the rows from the buffer
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6312: LOOP
6313: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6314: v_cnt := v_cnt + 1;
6315: -- retrieve the rows from the buffer
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6313: EXIT WHEN(DBMS_SQL.fetch_rows(v_cursor_id) = 0);
6314: v_cnt := v_cnt + 1;
6315: -- retrieve the rows from the buffer
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6314: v_cnt := v_cnt + 1;
6315: -- retrieve the rows from the buffer
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6315: -- retrieve the rows from the buffer
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6316: DBMS_SQL.column_value(v_cursor_id, 1, v_type.task_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6317: DBMS_SQL.column_value(v_cursor_id, 2, v_type.task_number);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6318: DBMS_SQL.column_value(v_cursor_id, 3, v_type.task_name);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6319: DBMS_SQL.column_value(v_cursor_id, 4, v_type.description);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6320: DBMS_SQL.column_value(v_cursor_id, 5, v_type.task_type_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6321: DBMS_SQL.column_value(v_cursor_id, 6, v_type.task_type);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6322: DBMS_SQL.column_value(v_cursor_id, 7, v_type.task_status_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6323: DBMS_SQL.column_value(v_cursor_id, 8, v_type.task_status);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6324: DBMS_SQL.column_value(v_cursor_id, 9, v_type.task_priority_id);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6325: DBMS_SQL.column_value(v_cursor_id, 10, v_type.task_priority);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6326: DBMS_SQL.column_value(v_cursor_id, 11, v_type.owner_type_code);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6327: DBMS_SQL.column_value(v_cursor_id, 12, v_type.owner_id);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6328: DBMS_SQL.column_value(v_cursor_id, 13, v_type.assigned_by_id);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6329: DBMS_SQL.column_value(v_cursor_id, 14, v_type.assigned_by_name);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6330: DBMS_SQL.column_value(v_cursor_id, 15, v_type.customer_id);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6331: DBMS_SQL.column_value(v_cursor_id, 16, v_type.customer_name);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6332: DBMS_SQL.column_value(v_cursor_id, 17, v_type.customer_number);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6333: DBMS_SQL.column_value(v_cursor_id, 18, v_type.address_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6334: DBMS_SQL.column_value(v_cursor_id, 19, v_type.planned_start_date);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6335: DBMS_SQL.column_value(v_cursor_id, 20, v_type.planned_end_date);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6336: DBMS_SQL.column_value(v_cursor_id, 21, v_type.scheduled_start_date);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6337: DBMS_SQL.column_value(v_cursor_id, 22, v_type.scheduled_end_date);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6338: DBMS_SQL.column_value(v_cursor_id, 23, v_type.actual_start_date);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6339: DBMS_SQL.column_value(v_cursor_id, 24, v_type.actual_end_date);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6340: DBMS_SQL.column_value(v_cursor_id, 25, v_type.object_type_code);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6341: DBMS_SQL.column_value(v_cursor_id, 26, v_type.object_id);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6342: DBMS_SQL.column_value(v_cursor_id, 27, v_type.obect_name);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6343: DBMS_SQL.column_value(v_cursor_id, 28, v_type.DURATION);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6344: DBMS_SQL.column_value(v_cursor_id, 29, v_type.duration_uom);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6345: DBMS_SQL.column_value(v_cursor_id, 30, v_type.planned_effort);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6346: DBMS_SQL.column_value(v_cursor_id, 31, v_type.planned_effort_uom);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6347: DBMS_SQL.column_value(v_cursor_id, 32, v_type.actual_effort);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6348: DBMS_SQL.column_value(v_cursor_id, 33, v_type.actual_effort_uom);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6349: DBMS_SQL.column_value(v_cursor_id, 34, v_type.percentage_complete);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6350: DBMS_SQL.column_value(v_cursor_id, 35, v_type.reason_code);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6351: DBMS_SQL.column_value(v_cursor_id, 36, v_type.private_flag);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6352: DBMS_SQL.column_value(v_cursor_id, 37, v_type.publish_flag);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6353: DBMS_SQL.column_value(v_cursor_id, 38, v_type.multi_booked_flag);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6354: DBMS_SQL.column_value(v_cursor_id, 39, v_type.milestone_flag);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6355: DBMS_SQL.column_value(v_cursor_id, 40, v_type.holiday_flag);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6356: DBMS_SQL.column_value(v_cursor_id, 41, v_type.workflow_process_id);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6357: DBMS_SQL.column_value(v_cursor_id, 46, v_type.notification_flag);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6358: DBMS_SQL.column_value(v_cursor_id, 47, v_type.notification_period);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6359: DBMS_SQL.column_value(v_cursor_id, 48, v_type.notification_period_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6360: DBMS_SQL.column_value(v_cursor_id, 49, v_type.parent_task_id);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6361: DBMS_SQL.column_value(v_cursor_id, 50, v_type.alarm_start);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6362: DBMS_SQL.column_value(v_cursor_id, 51, v_type.alarm_start_uom);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6363: DBMS_SQL.column_value(v_cursor_id, 52, v_type.alarm_on);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6364: DBMS_SQL.column_value(v_cursor_id, 53, v_type.alarm_count);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6365: DBMS_SQL.column_value(v_cursor_id, 54, v_type.alarm_fired_count);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6366: DBMS_SQL.column_value(v_cursor_id, 55, v_type.alarm_interval);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6367: DBMS_SQL.column_value(v_cursor_id, 56, v_type.alarm_interval_uom);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6368: DBMS_SQL.column_value(v_cursor_id, 57, v_type.attribute1);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6369: DBMS_SQL.column_value(v_cursor_id, 58, v_type.attribute2);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6370: DBMS_SQL.column_value(v_cursor_id, 59, v_type.attribute3);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6371: DBMS_SQL.column_value(v_cursor_id, 60, v_type.attribute4);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6372: DBMS_SQL.column_value(v_cursor_id, 61, v_type.attribute5);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6373: DBMS_SQL.column_value(v_cursor_id, 62, v_type.attribute6);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6374: DBMS_SQL.column_value(v_cursor_id, 63, v_type.attribute7);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6375: DBMS_SQL.column_value(v_cursor_id, 64, v_type.attribute8);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6383: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6376: DBMS_SQL.column_value(v_cursor_id, 65, v_type.attribute9);
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6383: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6384: -- 'v_type.task_id:'||
6377: DBMS_SQL.column_value(v_cursor_id, 66, v_type.attribute10);
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6383: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6384: -- 'v_type.task_id:'||
6385: -- to_char(v_type.task_id));
6378: DBMS_SQL.column_value(v_cursor_id, 67, v_type.attribute11);
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6383: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6384: -- 'v_type.task_id:'||
6385: -- to_char(v_type.task_id));
6386: v_n_tbl(v_cnt) := v_type;
6379: DBMS_SQL.column_value(v_cursor_id, 68, v_type.attribute12);
6380: DBMS_SQL.column_value(v_cursor_id, 69, v_type.attribute13);
6381: DBMS_SQL.column_value(v_cursor_id, 70, v_type.attribute14);
6382: DBMS_SQL.column_value(v_cursor_id, 71, v_type.attribute15);
6383: DBMS_SQL.column_value(v_cursor_id, 72, v_type.attribute_category);
6384: -- 'v_type.task_id:'||
6385: -- to_char(v_type.task_id));
6386: v_n_tbl(v_cnt) := v_type;
6387: END LOOP;
6384: -- 'v_type.task_id:'||
6385: -- to_char(v_type.task_id));
6386: v_n_tbl(v_cnt) := v_type;
6387: END LOOP;
6388: --dbms_sql.close_cursor(v_cursor_id);
6389: END IF; --p_query_or_next_code;
6390:
6391: -- copy records to be returned back
6392: x_total_retrieved := v_n_tbl.COUNT;