DBA Data[Home] [Help]

APPS.JTF_TASKS_PVT dependencies on JTF_TASKS_B

Line 8: task_id jtf_tasks_b.task_id%TYPE := NULL

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

Line 9: , template_id jtf_tasks_b.template_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

Line 11: , task_type_id jtf_tasks_b.task_type_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

Line 12: , task_status_id jtf_tasks_b.task_status_id%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

Line 13: , task_priority_id jtf_tasks_b.task_priority_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
17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL

Line 14: , planned_start_date jtf_tasks_b.planned_start_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

Line 15: , planned_end_date jtf_tasks_b.planned_end_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

Line 16: , scheduled_start_date jtf_tasks_b.scheduled_start_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

Line 17: , scheduled_end_date jtf_tasks_b.scheduled_end_date%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

Line 18: , actual_start_date jtf_tasks_b.actual_start_date%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

Line 19: , actual_end_date jtf_tasks_b.actual_end_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
23: , abort_workflow VARCHAR2(1) := NULL

Line 20: , source_object_type_code jtf_tasks_b.source_object_type_code%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
24: );

Line 21: , source_object_id jtf_tasks_b.source_object_id%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: );
25:

Line 1275: task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num

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

Line 1276: , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num

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

Line 1277: , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num

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

Line 1278: , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num

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

Line 1279: , planned_start_date jtf_tasks_b.planned_start_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

Line 1280: , planned_end_date jtf_tasks_b.planned_end_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

Line 1281: , scheduled_start_date jtf_tasks_b.scheduled_start_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)

Line 1282: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date

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)

Line 1283: , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date

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: );

Line 1284: , actual_end_date jtf_tasks_b.actual_end_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: );
1288: END; -- Package spec