DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_TASKS_B

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

14: g_dispatcher_initiated CONSTANT PLS_INTEGER := 1;
15: g_customer_initiated CONSTANT PLS_INTEGER := 2;
16:
17:
18: -- Task Information - Important Information of Task from JTF_TASKS_B
19: TYPE tasks_rec_type IS RECORD (
20: row_id VARCHAR2 (18)
21: , task_id jtf_tasks_b.task_id%TYPE
22: , object_version_number jtf_tasks_b.object_version_number%TYPE

Line 21: , task_id jtf_tasks_b.task_id%TYPE

17:
18: -- Task Information - Important Information of Task from JTF_TASKS_B
19: TYPE tasks_rec_type IS RECORD (
20: row_id VARCHAR2 (18)
21: , task_id jtf_tasks_b.task_id%TYPE
22: , object_version_number jtf_tasks_b.object_version_number%TYPE
23: , task_status_id jtf_tasks_b.task_status_id%TYPE
24: , task_status VARCHAR2 (30)
25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE

Line 22: , object_version_number jtf_tasks_b.object_version_number%TYPE

18: -- Task Information - Important Information of Task from JTF_TASKS_B
19: TYPE tasks_rec_type IS RECORD (
20: row_id VARCHAR2 (18)
21: , task_id jtf_tasks_b.task_id%TYPE
22: , object_version_number jtf_tasks_b.object_version_number%TYPE
23: , task_status_id jtf_tasks_b.task_status_id%TYPE
24: , task_status VARCHAR2 (30)
25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
26: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE

Line 23: , task_status_id jtf_tasks_b.task_status_id%TYPE

19: TYPE tasks_rec_type IS RECORD (
20: row_id VARCHAR2 (18)
21: , task_id jtf_tasks_b.task_id%TYPE
22: , object_version_number jtf_tasks_b.object_version_number%TYPE
23: , task_status_id jtf_tasks_b.task_status_id%TYPE
24: , task_status VARCHAR2 (30)
25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
26: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
27: , status_schedulable_flag VARCHAR2 (1)

Line 25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE

21: , task_id jtf_tasks_b.task_id%TYPE
22: , object_version_number jtf_tasks_b.object_version_number%TYPE
23: , task_status_id jtf_tasks_b.task_status_id%TYPE
24: , task_status VARCHAR2 (30)
25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
26: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
27: , status_schedulable_flag VARCHAR2 (1)
28: , type_schedulable_flag VARCHAR2 (1)
29: , status_assigned_flag VARCHAR2 (1)

Line 26: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE

22: , object_version_number jtf_tasks_b.object_version_number%TYPE
23: , task_status_id jtf_tasks_b.task_status_id%TYPE
24: , task_status VARCHAR2 (30)
25: , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE
26: , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE
27: , status_schedulable_flag VARCHAR2 (1)
28: , type_schedulable_flag VARCHAR2 (1)
29: , status_assigned_flag VARCHAR2 (1)
30: , resource_name VARCHAR2 (4000)

Line 31: , task_split_flag jtf_tasks_b.task_split_flag%TYPE

27: , status_schedulable_flag VARCHAR2 (1)
28: , type_schedulable_flag VARCHAR2 (1)
29: , status_assigned_flag VARCHAR2 (1)
30: , resource_name VARCHAR2 (4000)
31: , task_split_flag jtf_tasks_b.task_split_flag%TYPE
32: , parent_task_id jtf_tasks_b.parent_task_id%TYPE
33: , updated_flag VARCHAR2 (1)
34: );
35:

Line 32: , parent_task_id jtf_tasks_b.parent_task_id%TYPE

28: , type_schedulable_flag VARCHAR2 (1)
29: , status_assigned_flag VARCHAR2 (1)
30: , resource_name VARCHAR2 (4000)
31: , task_split_flag jtf_tasks_b.task_split_flag%TYPE
32: , parent_task_id jtf_tasks_b.parent_task_id%TYPE
33: , updated_flag VARCHAR2 (1)
34: );
35:
36: TYPE tasks_tbl_type IS TABLE OF tasks_rec_type;

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

1087: * the profile CSF: Default Effort UOM by calling
1088: * CSF_UTIL_PVT.GET_EFFORT_IN_DEFAULT_UOM function.
1089: *
1090: * All parameters are optional. If Planned Effort, Planned Effort UOM and Task
1091: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B
1092: * wont be queried to get those information. In case of better flexibility,
1093: * the caller can just pass the Task ID and the API will fetch the required
1094: * information. If case none of the required parameters are passed, the API returns
1095: * NULL.