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 265: l_task_id jtf_tasks_b.task_id%TYPE

261: := 'CREATE_TASK_ASSIGNMENTS';
262: l_return_status VARCHAR2(1)
263: := fnd_api.g_ret_sts_success;
264: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
265: l_task_id jtf_tasks_b.task_id%TYPE
266: := p_task_id;
267: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
268: := p_resource_type_code;
269: l_resource_id NUMBER

Line 352: FROM jtf_tasks_b

348: , planned_effort
349: , planned_effort_uom
350: , entity
351: , open_flag
352: FROM jtf_tasks_b
353: WHERE task_id = b_task_id;
354:
355: rec_task c_task%ROWTYPE;
356:

Line 1714: FROM jtf_tasks_b

1710: , planned_effort
1711: , planned_effort_uom
1712: , open_flag
1713: , entity
1714: FROM jtf_tasks_b
1715: WHERE task_id = b_task_id;
1716:
1717: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
1718: l_recurrence_rule_id NUMBER;

Line 1717: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

1713: , entity
1714: FROM jtf_tasks_b
1715: WHERE task_id = b_task_id;
1716:
1717: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
1718: l_recurrence_rule_id NUMBER;
1719: l_calendar_start_date DATE;
1720: l_calendar_end_date DATE;
1721: l_planned_effort NUMBER;

Line 1722: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

1718: l_recurrence_rule_id NUMBER;
1719: l_calendar_start_date DATE;
1720: l_calendar_end_date DATE;
1721: l_planned_effort NUMBER;
1722: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1723: l_entity jtf_tasks_b.entity%TYPE;
1724: l_open_flag jtf_tasks_b.open_flag%TYPE;
1725: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1726: BEGIN

Line 1723: l_entity jtf_tasks_b.entity%TYPE;

1719: l_calendar_start_date DATE;
1720: l_calendar_end_date DATE;
1721: l_planned_effort NUMBER;
1722: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1723: l_entity jtf_tasks_b.entity%TYPE;
1724: l_open_flag jtf_tasks_b.open_flag%TYPE;
1725: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1726: BEGIN
1727: SAVEPOINT update_task_assign_pvt;

Line 1724: l_open_flag jtf_tasks_b.open_flag%TYPE;

1720: l_calendar_end_date DATE;
1721: l_planned_effort NUMBER;
1722: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
1723: l_entity jtf_tasks_b.entity%TYPE;
1724: l_open_flag jtf_tasks_b.open_flag%TYPE;
1725: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1726: BEGIN
1727: SAVEPOINT update_task_assign_pvt;
1728: x_return_status := fnd_api.g_ret_sts_success;

Line 1929: UPDATE jtf_tasks_b

1925: from jtf_task_all_assignments
1926: where task_assignment_id = l_task_assignment_id;
1927: IF l_assignee_role_db = 'OWNER'
1928: THEN
1929: UPDATE jtf_tasks_b
1930: SET owner_id = l_resource_id,
1931: owner_type_code = l_resource_type_code
1932: WHERE task_id = l_task_id;
1933: END IF;

Line 2565: FROM jtf_tasks_b jtb

2561: , jtb.calendar_start_date
2562: , jtb.task_id
2563: , jtaa.resource_id
2564: , jtb.entity
2565: FROM jtf_tasks_b jtb
2566: , jtf_task_all_assignments jtaa
2567: WHERE jtaa.task_assignment_id = b_task_assignment_id
2568: AND jtb.task_id = jtaa.task_id;
2569: