15: g_customer_initiated CONSTANT PLS_INTEGER := 2;
16:
17: g_reschedule VARCHAR2(1) := NULL;
18:
19: -- Task Information - Important Information of Task from JTF_TASKS_B
20: TYPE tasks_rec_type IS RECORD (
21: row_id VARCHAR2 (18)
22: , task_id jtf_tasks_b.task_id%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
18:
19: -- Task Information - Important Information of Task from JTF_TASKS_B
20: TYPE tasks_rec_type IS RECORD (
21: row_id VARCHAR2 (18)
22: , task_id jtf_tasks_b.task_id%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
19: -- Task Information - Important Information of Task from JTF_TASKS_B
20: TYPE tasks_rec_type IS RECORD (
21: row_id VARCHAR2 (18)
22: , task_id jtf_tasks_b.task_id%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
20: TYPE tasks_rec_type IS RECORD (
21: row_id VARCHAR2 (18)
22: , task_id jtf_tasks_b.task_id%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
22: , task_id jtf_tasks_b.task_id%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
23: , object_version_number jtf_tasks_b.object_version_number%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
24: , task_status_id jtf_tasks_b.task_status_id%TYPE
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
32: , status_schedulable_flag VARCHAR2 (1)
25: , task_status VARCHAR2 (30)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
32: , status_schedulable_flag VARCHAR2 (1)
33: , type_schedulable_flag VARCHAR2 (1)
26: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
32: , status_schedulable_flag VARCHAR2 (1)
33: , type_schedulable_flag VARCHAR2 (1)
34: , status_assigned_flag VARCHAR2 (1)
27: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
28: , planned_start_date jtf_tasks_b.planned_start_date%TYPE
29: , planned_end_date jtf_tasks_b.planned_end_date%TYPE
30: , planned_effort jtf_tasks_b.planned_effort%TYPE
31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE
32: , status_schedulable_flag VARCHAR2 (1)
33: , type_schedulable_flag VARCHAR2 (1)
34: , status_assigned_flag VARCHAR2 (1)
35: , resource_name VARCHAR2 (4000)
32: , status_schedulable_flag VARCHAR2 (1)
33: , type_schedulable_flag VARCHAR2 (1)
34: , status_assigned_flag VARCHAR2 (1)
35: , resource_name VARCHAR2 (4000)
36: , task_split_flag jtf_tasks_b.task_split_flag%TYPE
37: , parent_task_id jtf_tasks_b.parent_task_id%TYPE
38: , updated_flag VARCHAR2 (1)
39: );
40:
33: , type_schedulable_flag VARCHAR2 (1)
34: , status_assigned_flag VARCHAR2 (1)
35: , resource_name VARCHAR2 (4000)
36: , task_split_flag jtf_tasks_b.task_split_flag%TYPE
37: , parent_task_id jtf_tasks_b.parent_task_id%TYPE
38: , updated_flag VARCHAR2 (1)
39: );
40:
41: TYPE tasks_tbl_type IS TABLE OF tasks_rec_type;
1125: * the profile CSF: Default Effort UOM by calling
1126: * CSF_UTIL_PVT.GET_EFFORT_IN_DEFAULT_UOM function.
1127: *
1128: * All parameters are optional. If Planned Effort, Planned Effort UOM and Task
1129: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B
1130: * wont be queried to get those information. In case of better flexibility,
1131: * the caller can just pass the Task ID and the API will fetch the required
1132: * information. If case none of the required parameters are passed, the API returns
1133: * NULL.