DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on JTF_TASKS_PUB

Line 33: l_task_table_type jtf_tasks_pub.task_table_type;

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

Line 41: l_task_rec jtf_tasks_pub.task_rec;

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

Line 42: l_sort_data jtf_tasks_pub.sort_rec ;

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

Line 43: l_sort_table jtf_tasks_pub.sort_data ;

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

Line 65: jtf_tasks_pub.query_task

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

Line 145: l_task_table_type jtf_tasks_pub.task_table_type;

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

Line 154: l_task_rec jtf_tasks_pub.task_rec;

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

Line 155: l_sort_data jtf_tasks_pub.sort_rec ;

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

Line 156: l_sort_table jtf_tasks_pub.sort_data ;

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

Line 162: l_task_notes_rec jtf_tasks_pub.task_notes_rec;

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

Line 163: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

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

Line 236: jtf_tasks_pub.query_task

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

Line 287: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;

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

Line 609: l_task_notes_rec jtf_tasks_pub.task_notes_rec;

605: l_msg_count number;
606: l_msg_data varchar2(2000);
607:
608: l_data varchar2(255);
609: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
610: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
611: l_msg_index_out number;
612: l_location_id number;
613: l_address_id number;

Line 610: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;

606: l_msg_data varchar2(2000);
607:
608: l_data varchar2(255);
609: l_task_notes_rec jtf_tasks_pub.task_notes_rec;
610: l_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
611: l_msg_index_out number;
612: l_location_id number;
613: l_address_id number;
614:

Line 704: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;

700: l_task_notes_rec.entered_date := sysdate;
701: l_task_notes_rec.note_type := l_note_type;
702: l_task_notes_tbl (1) := l_task_notes_rec;
703: else
704: l_task_notes_tbl := jtf_tasks_pub.g_miss_task_notes_tbl;
705: end if;
706:
707: -- bug # 4724278
708: -- Use Task Manager profile for Task Owner details

Line 809: jtf_tasks_pub.create_task (

805: p_attribute_category => p_context
806: );
807: ELSE
808: -- call JTF for non DISPATCH type task
809: jtf_tasks_pub.create_task (
810: p_api_version => 1.0,
811: p_commit => fnd_api.g_true,
812: p_task_name => p_task_name,
813: p_task_type_name => l_task_type_name,