DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on JTF_TASKS_PUB

Line 34: l_task_table_type jtf_tasks_pub.task_table_type;

30: , x_request_number OUT NOCOPY varchar2
31: , x_planned_effort_uom OUT NOCOPY varchar2
32: )
33: IS
34: l_task_table_type jtf_tasks_pub.task_table_type;
35: l_total_retrieved number;
36: l_total_returned number;
37: l_return_status varchar2(1);
38: l_msg_count number;

Line 42: l_task_rec jtf_tasks_pub.task_rec;

38: l_msg_count number;
39: l_msg_data varchar2(2000);
40: l_object_version_number number;
41:
42: l_task_rec jtf_tasks_pub.task_rec;
43: l_sort_data jtf_tasks_pub.sort_rec ;
44: l_sort_table jtf_tasks_pub.sort_data ;
45:
46:

Line 43: l_sort_data jtf_tasks_pub.sort_rec ;

39: l_msg_data varchar2(2000);
40: l_object_version_number number;
41:
42: l_task_rec jtf_tasks_pub.task_rec;
43: l_sort_data jtf_tasks_pub.sort_rec ;
44: l_sort_table jtf_tasks_pub.sort_data ;
45:
46:
47: CURSOR c_version (v_task_id NUMBER)

Line 44: l_sort_table jtf_tasks_pub.sort_data ;

40: l_object_version_number number;
41:
42: l_task_rec jtf_tasks_pub.task_rec;
43: l_sort_data jtf_tasks_pub.sort_rec ;
44: l_sort_table jtf_tasks_pub.sort_data ;
45:
46:
47: CURSOR c_version (v_task_id NUMBER)
48: IS

Line 66: jtf_tasks_pub.query_task

62:
63: l_sort_data.field_name := 'TASK_NUMBER'; -- this is redundant as we are passing the primary key
64: l_sort_table (1) := l_sort_data;
65:
66: jtf_tasks_pub.query_task
67: (
68: p_api_version => 1.0,
69: p_task_id => p_task_id,
70: p_sort_data => l_sort_table,

Line 147: l_task_table_type jtf_tasks_pub.task_table_type;

143: , p_context IN VARCHAR2
144: ) IS
145:
146: l_task_id number;
147: l_task_table_type jtf_tasks_pub.task_table_type;
148: l_num_rec number;
149: l_total_retrieved number;
150: l_total_returned number;
151: l_return_status varchar2(1);

Line 156: l_task_rec jtf_tasks_pub.task_rec;

152: l_msg_count number;
153: l_msg_data varchar2(2000);
154: l_object_version_number number;
155: l_data varchar2(255);
156: l_task_rec jtf_tasks_pub.task_rec;
157: l_sort_data jtf_tasks_pub.sort_rec ;
158: l_sort_table jtf_tasks_pub.sort_data ;
159: l_planned_start_date date;
160: l_planned_end_date date;

Line 157: l_sort_data jtf_tasks_pub.sort_rec ;

153: l_msg_data varchar2(2000);
154: l_object_version_number number;
155: l_data varchar2(255);
156: l_task_rec jtf_tasks_pub.task_rec;
157: l_sort_data jtf_tasks_pub.sort_rec ;
158: l_sort_table jtf_tasks_pub.sort_data ;
159: l_planned_start_date date;
160: l_planned_end_date date;
161: L_PLANNED_EFFORT number;

Line 158: l_sort_table jtf_tasks_pub.sort_data ;

154: l_object_version_number number;
155: l_data varchar2(255);
156: l_task_rec jtf_tasks_pub.task_rec;
157: l_sort_data jtf_tasks_pub.sort_rec ;
158: l_sort_table jtf_tasks_pub.sort_data ;
159: l_planned_start_date date;
160: l_planned_end_date date;
161: L_PLANNED_EFFORT number;
162: L_PLANNED_EFFORT_UOM varchar2(10);

Line 164: l_task_notes_rec jtf_tasks_pub.task_notes_rec;

160: l_planned_end_date date;
161: L_PLANNED_EFFORT number;
162: L_PLANNED_EFFORT_UOM varchar2(10);
163: l_msg_index_out number;
164: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
165: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
166: l_organization_id NUMBER;
167: l_note_type varchar2(30);
168: l_note_status varchar2(1);

Line 165: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

161: L_PLANNED_EFFORT number;
162: L_PLANNED_EFFORT_UOM varchar2(10);
163: l_msg_index_out number;
164: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
165: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
166: l_organization_id NUMBER;
167: l_note_type varchar2(30);
168: l_note_status varchar2(1);
169: l_acc_hrs_exist_current varchar2(1);

Line 239: jtf_tasks_pub.query_task

235:
236:
237:
238: -- Lets Query The Task
239: jtf_tasks_pub.query_task
240: (
241: p_api_version => 1.0,
242: p_task_id => l_task_id,
243: p_sort_data => l_sort_table,

Line 290: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;

286: l_task_notes_rec.note_type := l_note_type;
287: l_task_notes_tbl (1) := l_task_notes_rec;
288:
289: else
290: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;
291: end if;
292:
293: -- bug # 4724278
294: -- Use Task Manager profile for Task Owner details

Line 625: l_task_notes_rec jtf_tasks_pub.task_notes_rec;

621: l_msg_count number;
622: l_msg_data varchar2(2000);
623:
624: l_data varchar2(255);
625: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
626: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
627: l_msg_index_out number;
628: l_location_id number;
629: l_address_id number;

Line 626: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

622: l_msg_data varchar2(2000);
623:
624: l_data varchar2(255);
625: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
626: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
627: l_msg_index_out number;
628: l_location_id number;
629: l_address_id number;
630:

Line 720: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;

716: l_task_notes_rec.entered_date := sysdate;
717: l_task_notes_rec.note_type := l_note_type;
718: l_task_notes_tbl (1) := l_task_notes_rec;
719: else
720: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;
721: end if;
722:
723: -- bug # 4724278
724: -- Use Task Manager profile for Task Owner details

Line 825: jtf_tasks_pub.create_task (

821: p_attribute_category => p_context
822: );
823: ELSE
824: -- call JTF for non DISPATCH type task
825: jtf_tasks_pub.create_task (
826: p_api_version => 1.0,
827: p_commit => fnd_api.g_true,
828: p_task_name => p_task_name,
829: p_task_type_name => l_task_type_name,