DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_TASKS_B

Line 19: -- Task Information - Important Information of Task from JTF_TASKS_B

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

Line 22: , task_id jtf_tasks_b.task_id%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

Line 23: , object_version_number jtf_tasks_b.object_version_number%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

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

Line 26: , scheduled_start_date jtf_tasks_b.scheduled_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

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

Line 28: , planned_start_date jtf_tasks_b.planned_start_date%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)

Line 29: , planned_end_date jtf_tasks_b.planned_end_date%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)
33: , type_schedulable_flag VARCHAR2 (1)

Line 30: , planned_effort jtf_tasks_b.planned_effort%TYPE

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)

Line 31: , planned_effort_uom jtf_tasks_b.planned_effort_uom%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)
35: , resource_name VARCHAR2 (4000)

Line 36: , task_split_flag jtf_tasks_b.task_split_flag%TYPE

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:

Line 37: , parent_task_id jtf_tasks_b.parent_task_id%TYPE

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;

Line 1129: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B

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.