712: CREATED_BY JTF_NOTES_B.CREATED_BY%TYPE );
713: TYPE sr_notes_table IS TABLE OF GET_SR_NOTES_REC INDEX BY BINARY_INTEGER;
714:
715: TYPE GET_SR_TASKS_REC IS RECORD (
716: task_type cs_sr_tasks_v.task_type%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
713: TYPE sr_notes_table IS TABLE OF GET_SR_NOTES_REC INDEX BY BINARY_INTEGER;
714:
715: TYPE GET_SR_TASKS_REC IS RECORD (
716: task_type cs_sr_tasks_v.task_type%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
714:
715: TYPE GET_SR_TASKS_REC IS RECORD (
716: task_type cs_sr_tasks_v.task_type%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
715: TYPE GET_SR_TASKS_REC IS RECORD (
716: task_type cs_sr_tasks_v.task_type%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
716: task_type cs_sr_tasks_v.task_type%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
717: task_status cs_sr_tasks_v.task_status%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
718: task_priority cs_sr_tasks_v.task_priority%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
719: restrict_closure_flag cs_sr_tasks_v.restrict_closure_flag%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
720: owner_type cs_sr_tasks_v.owner_type%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
721: owner cs_sr_tasks_v.owner%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
722: task_name cs_sr_tasks_v.task_name%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
723: description cs_sr_tasks_v.description%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
724: task_number cs_sr_tasks_v.task_number%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
725: parent_task_number cs_sr_tasks_v.parent_task_number%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
726: escalation_level cs_sr_tasks_v.escalation_level%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
727: task_confirmation_status cs_sr_tasks_v.task_confirmation_status%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
728: planned_start_date cs_sr_tasks_v.planned_start_date%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
729: planned_end_date cs_sr_tasks_v.planned_end_date%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
730: scheduled_start_date cs_sr_tasks_v.scheduled_start_date%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
731: scheduled_end_date cs_sr_tasks_v.scheduled_end_date%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
732: actual_start_date cs_sr_tasks_v.actual_start_date%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
733: actual_end_date cs_sr_tasks_v.actual_end_date%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
734: planned_effort cs_sr_tasks_v.planned_effort%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
735: planned_effort_uom cs_sr_tasks_v.planned_effort_uom%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
736: actual_effort cs_sr_tasks_v.actual_effort%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
737: actual_effort_uom cs_sr_tasks_v.actual_effort_uom%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
738: DURATION cs_sr_tasks_v.DURATION%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
739: duration_uom cs_sr_tasks_v.duration_uom%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
740: private_flag cs_sr_tasks_v.private_flag%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
741: publish_flag cs_sr_tasks_v.publish_flag%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
742: row_id cs_sr_tasks_v.row_id%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
743: created_by cs_sr_tasks_v.created_by%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
744: creation_date cs_sr_tasks_v.creation_date%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
745: last_updated_by cs_sr_tasks_v.last_updated_by%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
746: last_update_date cs_sr_tasks_v.last_update_date%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
747: last_update_login cs_sr_tasks_v.last_update_login%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
748: source_object_id cs_sr_tasks_v.source_object_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
749: source_object_type_code cs_sr_tasks_v.source_object_type_code%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
750: source_object_name cs_sr_tasks_v.source_object_name%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
751: task_type_id cs_sr_tasks_v.task_type_id%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
752: task_status_id cs_sr_tasks_v.task_status_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
753: task_priority_id cs_sr_tasks_v.task_priority_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
754: owner_id cs_sr_tasks_v.owner_id%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
755: owner_territory_id cs_sr_tasks_v.owner_territory_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
756: task_id cs_sr_tasks_v.task_id%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
757: timezone_id cs_sr_tasks_v.timezone_id%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
758: parent_task_id cs_sr_tasks_v.parent_task_id%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
759: object_version_number cs_sr_tasks_v.object_version_number%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
760: customer_id cs_sr_tasks_v.customer_id%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
761: cust_account_id cs_sr_tasks_v.cust_account_id%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
762: owner_type_code cs_sr_tasks_v.owner_type_code%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
763: recurrence_rule_id cs_sr_tasks_v.recurrence_rule_id%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
764: multi_booked_flag cs_sr_tasks_v.multi_booked_flag%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
765: milestone_flag cs_sr_tasks_v.milestone_flag%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
766: holiday_flag cs_sr_tasks_v.holiday_flag%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
767: billable_flag cs_sr_tasks_v.billable_flag%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
768: currency_code cs_sr_tasks_v.currency_code%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
769: costs cs_sr_tasks_v.costs%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
770: attribute1 cs_sr_tasks_v.attribute1%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
771: attribute2 cs_sr_tasks_v.attribute2%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
772: attribute3 cs_sr_tasks_v.attribute3%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
773: attribute4 cs_sr_tasks_v.attribute4%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
774: attribute5 cs_sr_tasks_v.attribute5%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
775: attribute6 cs_sr_tasks_v.attribute6%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
776: attribute7 cs_sr_tasks_v.attribute7%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
777: attribute8 cs_sr_tasks_v.attribute8%TYPE,
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
785: attribute_category cs_sr_tasks_v.attribute_category%TYPE
778: attribute9 cs_sr_tasks_v.attribute9%TYPE,
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
785: attribute_category cs_sr_tasks_v.attribute_category%TYPE
786: );
779: attribute10 cs_sr_tasks_v.attribute10%TYPE,
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
785: attribute_category cs_sr_tasks_v.attribute_category%TYPE
786: );
787:
780: attribute11 cs_sr_tasks_v.attribute11%TYPE,
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
785: attribute_category cs_sr_tasks_v.attribute_category%TYPE
786: );
787:
788: TYPE tasks_table IS TABLE OF GET_SR_TASKS_REC INDEX BY BINARY_INTEGER;
781: attribute12 cs_sr_tasks_v.attribute12%TYPE,
782: attribute13 cs_sr_tasks_v.attribute13%TYPE,
783: attribute14 cs_sr_tasks_v.attribute14%TYPE,
784: attribute15 cs_sr_tasks_v.attribute15%TYPE,
785: attribute_category cs_sr_tasks_v.attribute_category%TYPE
786: );
787:
788: TYPE tasks_table IS TABLE OF GET_SR_TASKS_REC INDEX BY BINARY_INTEGER;
789: --end changes for 12.2