eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on JTF_TASKS_B

Line 224: l_task_id jtf_tasks_b.task_id%TYPE

220: := 'CREATE_TASK_ASSIGNMENTS';
221: l_return_status VARCHAR2(1)
222: := fnd_api.g_ret_sts_success;
223: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
224: l_task_id jtf_tasks_b.task_id%TYPE
225: := p_task_id;
226: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
227: := p_resource_type_code;
228: l_resource_id NUMBER

Line 311: FROM jtf_tasks_b

307: , planned_effort
308: , planned_effort_uom
309: , entity
310: , open_flag
311: FROM jtf_tasks_b
312: WHERE task_id = b_task_id;
313:
314: rec_task c_task%ROWTYPE;
315:

Line 1655: FROM jtf_tasks_b

1651: , planned_effort
1652: , planned_effort_uom
1653: , open_flag
1654: , entity
1655: FROM jtf_tasks_b
1656: WHERE task_id = b_task_id;
1657:
1658: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
1659: l_recurrence_rule_id NUMBER;

Line 1658: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

1654: , entity
1655: FROM jtf_tasks_b
1656: WHERE task_id = b_task_id;
1657:
1658: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
1659: l_recurrence_rule_id NUMBER;
1660: l_calendar_start_date DATE;
1661: l_calendar_end_date DATE;
1662: l_planned_effort NUMBER;

Line 1663: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

1659: l_recurrence_rule_id NUMBER;
1660: l_calendar_start_date DATE;
1661: l_calendar_end_date DATE;
1662: l_planned_effort NUMBER;
1663: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1664: l_entity jtf_tasks_b.entity%TYPE;
1665: l_open_flag jtf_tasks_b.open_flag%TYPE;
1666: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1667: BEGIN

Line 1664: l_entity jtf_tasks_b.entity%TYPE;

1660: l_calendar_start_date DATE;
1661: l_calendar_end_date DATE;
1662: l_planned_effort NUMBER;
1663: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1664: l_entity jtf_tasks_b.entity%TYPE;
1665: l_open_flag jtf_tasks_b.open_flag%TYPE;
1666: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1667: BEGIN
1668: SAVEPOINT update_task_assign_pvt;

Line 1665: l_open_flag jtf_tasks_b.open_flag%TYPE;

1661: l_calendar_end_date DATE;
1662: l_planned_effort NUMBER;
1663: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1664: l_entity jtf_tasks_b.entity%TYPE;
1665: l_open_flag jtf_tasks_b.open_flag%TYPE;
1666: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1667: BEGIN
1668: SAVEPOINT update_task_assign_pvt;
1669: x_return_status := fnd_api.g_ret_sts_success;

Line 1870: UPDATE jtf_tasks_b

1866: from jtf_task_all_assignments
1867: where task_assignment_id = l_task_assignment_id;
1868: IF l_assignee_role_db = 'OWNER'
1869: THEN
1870: UPDATE jtf_tasks_b
1871: SET owner_id = l_resource_id,
1872: owner_type_code = l_resource_type_code
1873: WHERE task_id = l_task_id;
1874: END IF;

Line 2488: FROM jtf_tasks_b jtb

2484: , jtb.calendar_start_date
2485: , jtb.task_id
2486: , jtaa.resource_id
2487: , jtb.entity
2488: FROM jtf_tasks_b jtb
2489: , jtf_task_all_assignments jtaa
2490: WHERE jtaa.task_assignment_id = b_task_assignment_id
2491: AND jtb.task_id = jtaa.task_id;
2492: