3:
4: -- to store task detail for notification content
5: type task_asgn_record is record
6: (
7: task_number jtf_tasks_b.task_number%type,
8: task_name jtf_tasks_vl.task_name%type,
9: task_desc jtf_tasks_vl.description%type,
10: sch_st_date jtf_tasks_b.scheduled_start_date%type,
11: old_sch_st_date jtf_tasks_b.scheduled_start_date%type,
6: (
7: task_number jtf_tasks_b.task_number%type,
8: task_name jtf_tasks_vl.task_name%type,
9: task_desc jtf_tasks_vl.description%type,
10: sch_st_date jtf_tasks_b.scheduled_start_date%type,
11: old_sch_st_date jtf_tasks_b.scheduled_start_date%type,
12: sch_end_date jtf_tasks_b.scheduled_end_date%type,
13: old_sch_end_date jtf_tasks_b.scheduled_end_date%type,
14: planned_effort varchar2(100),
7: task_number jtf_tasks_b.task_number%type,
8: task_name jtf_tasks_vl.task_name%type,
9: task_desc jtf_tasks_vl.description%type,
10: sch_st_date jtf_tasks_b.scheduled_start_date%type,
11: old_sch_st_date jtf_tasks_b.scheduled_start_date%type,
12: sch_end_date jtf_tasks_b.scheduled_end_date%type,
13: old_sch_end_date jtf_tasks_b.scheduled_end_date%type,
14: planned_effort varchar2(100),
15: priority jtf_task_priorities_vl.name%type,
8: task_name jtf_tasks_vl.task_name%type,
9: task_desc jtf_tasks_vl.description%type,
10: sch_st_date jtf_tasks_b.scheduled_start_date%type,
11: old_sch_st_date jtf_tasks_b.scheduled_start_date%type,
12: sch_end_date jtf_tasks_b.scheduled_end_date%type,
13: old_sch_end_date jtf_tasks_b.scheduled_end_date%type,
14: planned_effort varchar2(100),
15: priority jtf_task_priorities_vl.name%type,
16: asgm_sts_name jtf_task_statuses_vl.name%type,
9: task_desc jtf_tasks_vl.description%type,
10: sch_st_date jtf_tasks_b.scheduled_start_date%type,
11: old_sch_st_date jtf_tasks_b.scheduled_start_date%type,
12: sch_end_date jtf_tasks_b.scheduled_end_date%type,
13: old_sch_end_date jtf_tasks_b.scheduled_end_date%type,
14: planned_effort varchar2(100),
15: priority jtf_task_priorities_vl.name%type,
16: asgm_sts_name jtf_task_statuses_vl.name%type,
17: sr_number cs_incidents_all_b.incident_number%type,