4: g_abort_workflow CONSTANT VARCHAR2(1) := fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF');
5:
6: --Created for BES enh 2391065
7: TYPE task_rec_type IS RECORD(
8: task_id jtf_tasks_b.task_id%TYPE := NULL
9: , template_id jtf_tasks_b.template_id%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
5:
6: --Created for BES enh 2391065
7: TYPE task_rec_type IS RECORD(
8: task_id jtf_tasks_b.task_id%TYPE := NULL
9: , template_id jtf_tasks_b.template_id%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
7: TYPE task_rec_type IS RECORD(
8: task_id jtf_tasks_b.task_id%TYPE := NULL
9: , template_id jtf_tasks_b.template_id%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
8: task_id jtf_tasks_b.task_id%TYPE := NULL
9: , template_id jtf_tasks_b.template_id%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
9: , template_id jtf_tasks_b.template_id%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
10: , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
11: , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
12: , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
13: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21: , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
14: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21: , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
22: , enable_workflow VARCHAR2(1) := NULL
15: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21: , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
22: , enable_workflow VARCHAR2(1) := NULL
23: , abort_workflow VARCHAR2(1) := NULL
16: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21: , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
22: , enable_workflow VARCHAR2(1) := NULL
23: , abort_workflow VARCHAR2(1) := NULL
24: );
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20: , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21: , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
22: , enable_workflow VARCHAR2(1) := NULL
23: , abort_workflow VARCHAR2(1) := NULL
24: );
25:
1271: );
1272:
1273: -- Created for Enh 2797666
1274: TYPE sub_task_rec IS RECORD(
1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1272:
1273: -- Created for Enh 2797666
1274: TYPE sub_task_rec IS RECORD(
1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1273: -- Created for Enh 2797666
1274: TYPE sub_task_rec IS RECORD(
1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1274: TYPE sub_task_rec IS RECORD(
1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1285: , p_enable_workflow VARCHAR2(1)
1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1285: , p_enable_workflow VARCHAR2(1)
1286: , abort_workflow VARCHAR2(1)
1279: , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1285: , p_enable_workflow VARCHAR2(1)
1286: , abort_workflow VARCHAR2(1)
1287: );
1280: , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284: , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1285: , p_enable_workflow VARCHAR2(1)
1286: , abort_workflow VARCHAR2(1)
1287: );
1288: END; -- Package spec