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_assignee_role jtf_task_all_assignments.assignee_role%TYPE

Line 64: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

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_assignee_role jtf_task_all_assignments.assignee_role%TYPE
65: := x_assignee_role;
66: begin
67: if l_assignee_role is null then
68: l_assignee_role := 'ASSIGNEE';

Line 117: insert into jtf_task_all_assignments (

113:
114:
115:
116:
117: insert into jtf_task_all_assignments (
118: SCHED_TRAVEL_DURATION_UOM,
119: ACTUAL_TRAVEL_DISTANCE,
120: ACTUAL_TRAVEL_DURATION,
121: ACTUAL_TRAVEL_DURATION_UOM,

Line 256: from jtf_task_all_assignments

252: X_OBJECT_VERSION_NUMBER in NUMBER
253: ) is
254: cursor c1 is select
255: OBJECT_VERSION_NUMBER
256: from jtf_task_all_assignments
257: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID
258: for update of TASK_ASSIGNMENT_ID nowait;
259: tlinfo c1%rowtype ;
260:

Line 340: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

336: X_BOOKING_END_DATE in DATE,
337: X_OBJECT_CAPACITY_ID in NUMBER
338: ) is
339: x_return_status varchar2(1);
340: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
341: := x_assignee_role;
342: begin
343: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
344: l_assignee_role := 'ASSIGNEE';

Line 390: update jtf_task_all_assignments set

386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;
389:
390: update jtf_task_all_assignments set
391: SCHED_TRAVEL_DURATION_UOM = X_SCHED_TRAVEL_DURATION_UOM,
392: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
393: ACTUAL_TRAVEL_DISTANCE = X_ACTUAL_TRAVEL_DISTANCE,
394: ACTUAL_TRAVEL_DURATION = X_ACTUAL_TRAVEL_DURATION,

Line 476: delete from jtf_task_all_assignments

472: THEN
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476: delete from jtf_task_all_assignments
477: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
478:
479: if (sql%notfound) then
480: raise no_data_found;