12: ---------------------------------------------------------------------------
13:
14: Type TASK_TEMPLATE_GROUP_REC is RECORD
15: (
16: TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
13:
14: Type TASK_TEMPLATE_GROUP_REC is RECORD
15: (
16: TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
14: Type TASK_TEMPLATE_GROUP_REC is RECORD
15: (
16: TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
15: (
16: TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
16: TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
17: TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
18: SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
19: START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
20: END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
21: DESCRIPTION jtf_task_temp_groups_vl.description%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
22: ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
23: ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
24: ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
25: ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
26: ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
27: ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
28: ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
29: ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
30: ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
31: ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39: application_id jtf_task_temp_groups_vl.application_id%type
32: ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39: application_id jtf_task_temp_groups_vl.application_id%type
40: );
33: ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39: application_id jtf_task_temp_groups_vl.application_id%type
40: );
41:
34: ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39: application_id jtf_task_temp_groups_vl.application_id%type
40: );
41:
42:
35: ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36: ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37: ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38: object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39: application_id jtf_task_temp_groups_vl.application_id%type
40: );
41:
42:
43: Type task_temp_group_tbl is table of task_template_group_rec