APPS.JTF_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 60: cursor C is select ROWID from jtf_task_all_assignments

56: X_BOOKING_START_DATE in DATE,
57: X_BOOKING_END_DATE in DATE,
58: X_OBJECT_CAPACITY_ID in NUMBER
59: ) is
60: cursor C is select ROWID from jtf_task_all_assignments
61: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
62:
63: x_return_status varchar2(1) ;
64: l_msg_count NUMBER;

Line 67: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

63: x_return_status varchar2(1) ;
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(2000);
66: l_enable_audit varchar2(5);
67: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
68: := x_assignee_role;
69: begin
70: if l_assignee_role is null then
71: l_assignee_role := 'ASSIGNEE';

Line 156: insert into jtf_task_all_assignments (

152: );
153: END IF;
154:
155:
156: insert into jtf_task_all_assignments (
157: SCHED_TRAVEL_DURATION_UOM,
158: ACTUAL_TRAVEL_DISTANCE,
159: ACTUAL_TRAVEL_DURATION,
160: ACTUAL_TRAVEL_DURATION_UOM,

Line 295: from jtf_task_all_assignments

291: X_OBJECT_VERSION_NUMBER in NUMBER
292: ) is
293: cursor c1 is select
294: OBJECT_VERSION_NUMBER
295: from jtf_task_all_assignments
296: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID
297: for update of TASK_ASSIGNMENT_ID nowait;
298: tlinfo c1%rowtype ;
299:

Line 382: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

378: x_return_status varchar2(1);
379: l_msg_count NUMBER;
380: l_msg_data VARCHAR2(2000);
381: l_enable_audit varchar2(5);
382: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
383: := x_assignee_role;
384: begin
385: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
386: l_assignee_role := 'ASSIGNEE';

Line 472: update jtf_task_all_assignments set

468: );
469: END IF;
470:
471:
472: update jtf_task_all_assignments set
473: SCHED_TRAVEL_DURATION_UOM = X_SCHED_TRAVEL_DURATION_UOM,
474: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
475: ACTUAL_TRAVEL_DISTANCE = X_ACTUAL_TRAVEL_DISTANCE,
476: ACTUAL_TRAVEL_DURATION = X_ACTUAL_TRAVEL_DURATION,

Line 559: delete from jtf_task_all_assignments

555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
559: delete from jtf_task_all_assignments
560: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
561:
562: if (sql%notfound) then
563: raise no_data_found;