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.IEU_TASKS_USERHOOKS dependencies on JTF_TASK_ASSIGNMENTS

Line 825: from jtf_task_assignments c

821: if jtf_tasks_pub.p_task_user_hooks.owner_type_code = 'RS_GROUP' then
822: begin
823: select c.resource_id, c.resource_type_code
824: into l_assignee_id, l_assignee_type
825: from jtf_task_assignments c
826: where c.task_id = jtf_tasks_pub.p_task_user_hooks.task_id
827: and c.assignee_role = 'ASSIGNEE'
828: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
829: and c.resource_id in ( select resource_id

Line 834: from jtf_task_assignments a,jtf_task_statuses_vl b

830: from jtf_rs_group_members
831: where group_id = jtf_tasks_pub.p_task_user_hooks.owner_id
832: and nvl(delete_flag,'N') <> 'Y')
833: and c.last_update_date = (select max(a.last_update_date)
834: from jtf_task_assignments a,jtf_task_statuses_vl b
835: where a.task_id = jtf_tasks_pub.p_task_user_hooks.task_id
836: and a.assignee_role = 'ASSIGNEE'
837: and a.assignment_status_id = b.task_status_id
838: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')

Line 1398: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

1394:
1395: select source_object_type_code
1396: into l_task_source_obj_type_code
1397: from jtf_tasks_b
1398: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
1399:
1400: exception when others then
1401: l_task_source_obj_type_code := null;
1402: end;

Line 1507: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||

1503: end if; /* source_object_type_code is not null */
1504:
1505: if l_activation_status = 'Y' then
1506:
1507: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
1508: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
1510: then
1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;

Line 1508: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */

1504:
1505: if l_activation_status = 'Y' then
1506:
1507: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
1508: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
1510: then
1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
1512: else

Line 1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')

1505: if l_activation_status = 'Y' then
1506:
1507: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
1508: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
1510: then
1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
1512: else
1513: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

Line 1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;

1507: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
1508: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
1510: then
1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
1512: else
1513: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
1514: BEGIN
1515:

Line 1513: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

1509: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
1510: then
1511: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
1512: else
1513: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
1514: BEGIN
1515:
1516: SELECT booking_end_date
1517: INTO l_ins_due_date

Line 1519: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1515:
1516: SELECT booking_end_date
1517: INTO l_ins_due_date
1518: FROM JTF_TASK_ALL_ASSIGNMENTS
1519: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1520: AND assignee_role = 'OWNER';
1521:
1522: EXCEPTION
1523: WHEN OTHERS THEN

Line 1538: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

1534: l_tasks_data_list.extend;
1535:
1536: l_tasks_data_list(l_tasks_data_list.last) := SYSTEM.WR_TASKS_DATA_OBJ (
1537: 'CREATE_TASK_ASG',
1538: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1539: null,
1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,

Line 1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,

1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
1560:
1561: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();

Line 1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,

1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
1560:
1561: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();
1562:

Line 1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);

1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
1560:
1561: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();
1562:
1563: l_def_data_list.extend;

Line 1573: where WORKITEM_PK_ID = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1569: l_owner_type_actual := 'RS_GROUP';
1570: Select owner_id
1571: into l_orig_grp_owner
1572: from ieu_uwqm_items
1573: where WORKITEM_PK_ID = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1574: -- and workitem_obj_code = 'TASK'
1575: -- and owner_type_actual = 'RS_GROUP';
1576: and workitem_obj_code = l_workitem_obj_code
1577: and owner_type_actual = l_owner_type_actual;

Line 1608: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

1604: begin
1605: select task_status_id, deleted_flag
1606: into l_tsk_sts_id, l_del_flag
1607: from jtf_tasks_b
1608: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
1609: exception
1610: when others then null;
1611: end;
1612:

Line 1635: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1631: begin
1632: select 'Y'
1633: into l_wi_exists
1634: from ieu_uwqm_items
1635: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1636: and workitem_obj_code = 'TASK';
1637: exception
1638: when others then
1639: l_wi_exists := 'N';

Line 1670: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1666: l_ins_source_object_id, l_ins_source_object_type_code, l_ins_planned_start_date, l_ins_planned_end_date,
1667: l_ins_actual_ins_start_date, l_ins_actual_ins_end_date, l_ins_scheduled_start_date, l_ins_scheduled_end_date,
1668: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code
1669: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
1670: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1671: and tb.entity = 'TASK'
1672: and tb.task_id = tt.task_id
1673: and tt.language = userenv('LANG')
1674: and tp.task_priority_id = nvl(tb.task_priority_id, 4)

Line 1722: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1718: l_workitem_obj_code := 'TASK';
1719: select owner_id, owner_type, source_object_id, source_object_type_code, assignee_id -- Niraj, 4220060, Added assignee_id
1720: into l_owner_id, l_owner_type, l_source_object_id, l_source_object_type_code, l_wr_assignee_id -- Niraj, 4220060, Added
1721: from ieu_uwqm_items
1722: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1723: -- and workitem_obj_code = 'TASK';
1724: and workitem_obj_code = l_workitem_obj_code;
1725: EXCEPTION WHEN others THEN
1726: null;

Line 1744: and b.task_status_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id;

1740: where nvl(b.closed_flag, 'N') = 'N'
1741: and nvl(b.completed_flag, 'N') = 'N'
1742: and nvl(b.cancelled_flag, 'N') = 'N'
1743: and nvl(b.rejected_flag, 'N') = 'N'
1744: and b.task_status_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id;
1745: exception when others then l_status := 'CLOSED';
1746: end;
1747:
1748:

Line 1749: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code = 'RS_TEAM')

1745: exception when others then l_status := 'CLOSED';
1746: end;
1747:
1748:
1749: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code = 'RS_TEAM')
1750: or (l_status = 'CLOSED')
1751: then
1752: l_assignee_id := null;
1753: l_assignee_type := null;

Line 1758: from jtf_task_assignments c

1754: -- insert into p_temp(msg) values('selecting asg id from jtf tsk asg table');
1755: begin
1756: select c.resource_id, c.resource_type_code
1757: into l_assignee_id, l_assignee_type
1758: from jtf_task_assignments c
1759: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1760: and c.last_update_date = (select max(a.last_update_date)
1761: from jtf_task_assignments a,jtf_task_statuses_vl b
1762: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

Line 1759: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1755: begin
1756: select c.resource_id, c.resource_type_code
1757: into l_assignee_id, l_assignee_type
1758: from jtf_task_assignments c
1759: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1760: and c.last_update_date = (select max(a.last_update_date)
1761: from jtf_task_assignments a,jtf_task_statuses_vl b
1762: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1763: and a.assignee_role = 'ASSIGNEE'

Line 1761: from jtf_task_assignments a,jtf_task_statuses_vl b

1757: into l_assignee_id, l_assignee_type
1758: from jtf_task_assignments c
1759: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1760: and c.last_update_date = (select max(a.last_update_date)
1761: from jtf_task_assignments a,jtf_task_statuses_vl b
1762: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1763: and a.assignee_role = 'ASSIGNEE'
1764: and a.resource_type_code <> 'RS_TEAM'
1765: and a.assignment_status_id = b.task_status_id

Line 1762: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1758: from jtf_task_assignments c
1759: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1760: and c.last_update_date = (select max(a.last_update_date)
1761: from jtf_task_assignments a,jtf_task_statuses_vl b
1762: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1763: and a.assignee_role = 'ASSIGNEE'
1764: and a.resource_type_code <> 'RS_TEAM'
1765: and a.assignment_status_id = b.task_status_id
1766: and (nvl(b.closed_flag, 'N') = 'N'

Line 1773: and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

1769: and nvl(b.rejected_flag, 'N') = 'N'
1770: and b.task_status_id = c.assignment_status_iD))
1771: and assignee_role = 'ASSIGNEE'
1772: and c.resource_type_code <> 'RS_TEAM'
1773: and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1774: and rownum < 2;
1775: exception when others then
1776: l_assignee_id := null;
1777: l_assignee_type := null;

Line 1783: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;

1779:
1780: else
1781: --insert into p_temp(msg) values('setting asg id to hooks data');
1782:
1783: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
1784: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;
1785: end if;
1786:
1787: begin

Line 1784: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;

1780: else
1781: --insert into p_temp(msg) values('setting asg id to hooks data');
1782:
1783: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
1784: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;
1785: end if;
1786:
1787: begin
1788: select task_type_id, entity into l_task_type_id, l_entity

Line 1790: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

1786:
1787: begin
1788: select task_type_id, entity into l_task_type_id, l_entity
1789: from jtf_tasks_b
1790: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
1791: exception when others then l_task_type_id := null;
1792: end;
1793:
1794:

Line 1802: from jtf_task_assignments

1798: if l_owner_type = 'RS_GROUP'
1799: then
1800: begin
1801: select count(0) into l_task_asg_count
1802: from jtf_task_assignments
1803: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1804: and assignee_role = 'ASSIGNEE';
1805: exception when others then l_task_asg_count := 0;
1806: end;

Line 1803: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1799: then
1800: begin
1801: select count(0) into l_task_asg_count
1802: from jtf_task_assignments
1803: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1804: and assignee_role = 'ASSIGNEE';
1805: exception when others then l_task_asg_count := 0;
1806: end;
1807:

Line 1841: -- else get the most recent grp member assignee from JTF_TASK_ASSIGNMENTS.

1837: --------- Add another assignee----------
1838:
1839: -- If the new assignee created is not a member of the group,
1840: -- then get the assignee from UWQ WR if the record exists
1841: -- else get the most recent grp member assignee from JTF_TASK_ASSIGNMENTS.
1842:
1843: if nvl(l_group_id, 'N') = 'N'
1844: then
1845:

Line 1853: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1849: l_workitem_obj_code := 'TASK';
1850: select assignee_id, assignee_type_actual
1851: into l_assignee_id, l_assignee_type
1852: from ieu_uwqm_items
1853: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1854: -- and workitem_obj_code = 'TASK';
1855: and workitem_obj_code = l_workitem_obj_code;
1856: exception when others then
1857: l_assignee_id := null;

Line 1864: from jtf_task_assignments c

1860: else
1861: begin
1862: select c.resource_id, c.resource_type_code
1863: into l_assignee_id, l_assignee_type
1864: from jtf_task_assignments c
1865: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1866: and c.assignee_role = 'ASSIGNEE'
1867: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
1868: and c.resource_id in ( select resource_id

Line 1865: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1861: begin
1862: select c.resource_id, c.resource_type_code
1863: into l_assignee_id, l_assignee_type
1864: from jtf_task_assignments c
1865: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1866: and c.assignee_role = 'ASSIGNEE'
1867: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
1868: and c.resource_id in ( select resource_id
1869: from jtf_rs_group_members

Line 1872: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

1868: and c.resource_id in ( select resource_id
1869: from jtf_rs_group_members
1870: where group_id = l_owner_id
1871: and nvl(delete_flag,'N') <> 'Y')
1872: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1873: and c.last_update_date = (select max(a.last_update_date)
1874: from jtf_task_assignments a,jtf_task_statuses_vl b
1875: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1876: and a.assignee_role = 'ASSIGNEE'

Line 1874: from jtf_task_assignments a,jtf_task_statuses_vl b

1870: where group_id = l_owner_id
1871: and nvl(delete_flag,'N') <> 'Y')
1872: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1873: and c.last_update_date = (select max(a.last_update_date)
1874: from jtf_task_assignments a,jtf_task_statuses_vl b
1875: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1876: and a.assignee_role = 'ASSIGNEE'
1877: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1878: and a.assignment_status_id = b.task_status_id

Line 1875: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

1871: and nvl(delete_flag,'N') <> 'Y')
1872: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1873: and c.last_update_date = (select max(a.last_update_date)
1874: from jtf_task_assignments a,jtf_task_statuses_vl b
1875: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1876: and a.assignee_role = 'ASSIGNEE'
1877: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1878: and a.assignment_status_id = b.task_status_id
1879: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')

Line 1877: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

1873: and c.last_update_date = (select max(a.last_update_date)
1874: from jtf_task_assignments a,jtf_task_statuses_vl b
1875: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1876: and a.assignee_role = 'ASSIGNEE'
1877: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1878: and a.assignment_status_id = b.task_status_id
1879: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
1880: and a.resource_id in ( select resource_id
1881: from jtf_rs_group_members

Line 1910: IF ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') OR

1906: end if;
1907:
1908: -- Niraj, Bug 4220060
1909: -- Set the flag to Y if the assignee_role = OWNER
1910: IF ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') OR
1911: ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND
1912: (NVL(l_wr_assignee_id, -1) <> NVL(l_assignee_id, -1))) )
1913: THEN
1914: l_update_wr_item_call := 'Y';

Line 1911: ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND

1907:
1908: -- Niraj, Bug 4220060
1909: -- Set the flag to Y if the assignee_role = OWNER
1910: IF ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') OR
1911: ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND
1912: (NVL(l_wr_assignee_id, -1) <> NVL(l_assignee_id, -1))) )
1913: THEN
1914: l_update_wr_item_call := 'Y';
1915: ELSE

Line 1939: /* insert into p_temp(msg) values ('asg role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role ||

1935: l_workitem_comment_code2,
1936: null,
1937: null,
1938: null);
1939: /* insert into p_temp(msg) values ('asg role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role ||
1940: ' entity: '||l_entity|| ' group id: '||l_group_id); */
1941:
1942: -- insert into p_temp(msg) values ('passign due date as: '||l_ins_due_date);
1943: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')

Line 1943: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')

1939: /* insert into p_temp(msg) values ('asg role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role ||
1940: ' entity: '||l_entity|| ' group id: '||l_group_id); */
1941:
1942: -- insert into p_temp(msg) values ('passign due date as: '||l_ins_due_date);
1943: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')
1944: and (l_entity = 'TASK')
1945: --and (nvl(l_group_id, 'N') = 'Y')
1946: then
1947: if (l_wi_exists = 'N')

Line 1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_TRUE,
1984: p_commit => FND_API.G_FALSE,
1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,

Line 2010: elsif (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')

2006: end if;
2007: x_return_status := l_return_status;
2008:
2009:
2010: elsif (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2011: then
2012: -- Create or Update Task User Hook should have been invoked
2013: -- before invoking Create/Update Task Assignment if the assignee role is owner.
2014: -- So update the rec only if its present in IEU_UWQM_ITEMS

Line 2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

2020: p_api_version => 1.0,
2021: p_init_msg_list => FND_API.G_TRUE,
2022: p_commit => FND_API.G_FALSE,
2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,

Line 2182: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

2178:
2179: select source_object_type_code
2180: into l_task_source_obj_type_code
2181: from jtf_tasks_b
2182: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
2183:
2184: exception when others then
2185: l_task_source_obj_type_code := null;
2186: end;

Line 2290: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||

2286: end if;
2287:
2288: if l_activation_status = 'Y' then
2289:
2290: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
2291: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
2292:
2293:
2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')

Line 2291: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */

2287:
2288: if l_activation_status = 'Y' then
2289:
2290: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
2291: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
2292:
2293:
2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2295: then

Line 2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')

2290: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
2291: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
2292:
2293:
2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2295: then
2296: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
2297: else
2298: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

Line 2296: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;

2292:
2293:
2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2295: then
2296: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
2297: else
2298: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
2299: BEGIN
2300:

Line 2298: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

2294: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2295: then
2296: l_ins_due_date := jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date;
2297: else
2298: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
2299: BEGIN
2300:
2301: SELECT booking_end_date
2302: INTO l_ins_due_date

Line 2304: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2300:
2301: SELECT booking_end_date
2302: INTO l_ins_due_date
2303: FROM JTF_TASK_ALL_ASSIGNMENTS
2304: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2305: AND assignee_role = 'OWNER';
2306:
2307: EXCEPTION
2308: WHEN OTHERS THEN

Line 2323: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

2319: l_tasks_data_list.extend;
2320:
2321: l_tasks_data_list(l_tasks_data_list.last) := SYSTEM.WR_TASKS_DATA_OBJ (
2322: 'UPDATE_TASK_ASG',
2323: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2324: null,
2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,

Line 2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,

2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
2345:
2346: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();

Line 2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,

2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
2345:
2346: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();
2347:

Line 2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);

2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
2345:
2346: l_def_data_list := SYSTEM.DEF_WR_DATA_NST();
2347:
2348: l_def_data_list.extend;

Line 2358: where WORKITEM_PK_ID = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2354: l_owner_type_actual := 'RS_GROUP';
2355: Select owner_id
2356: into l_orig_grp_owner
2357: from ieu_uwqm_items
2358: where WORKITEM_PK_ID = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2359: -- and workitem_obj_code = 'TASK'
2360: -- and owner_type_actual = 'RS_GROUP';
2361: and workitem_obj_code = l_workitem_obj_code
2362: and owner_type_actual = l_owner_type_actual;

Line 2389: -- if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')

2385:
2386: BEGIN
2387:
2388:
2389: -- if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')
2390: -- then
2391:
2392:
2393: -- Get the Task Status Id

Line 2398: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

2394: begin
2395: select task_status_id, deleted_flag
2396: into l_tsk_sts_id, l_del_flag
2397: from jtf_tasks_b
2398: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
2399: exception
2400: when others then null;
2401: end;
2402:

Line 2425: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2421: begin
2422: select 'Y'
2423: into l_wi_exists
2424: from ieu_uwqm_items
2425: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2426: and workitem_obj_code = 'TASK';
2427: exception
2428: when others then
2429: l_wi_exists := 'N';

Line 2462: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2458: l_ins_planned_start_date,
2459: l_ins_planned_end_date, l_ins_actual_ins_start_date, l_ins_actual_ins_end_date, l_ins_scheduled_start_date, l_ins_scheduled_end_date,
2460: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code
2461: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
2462: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2463: and tb.entity = 'TASK'
2464: and tb.task_id = tt.task_id
2465: and tt.language = userenv('LANG')
2466: and tp.task_priority_id = nvl(tb.task_priority_id, 4)

Line 2513: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2509: l_workitem_obj_code := 'TASK';
2510: select owner_id, owner_type, source_object_id, source_object_type_code, assignee_id -- Niraj, 4220060, Added assignee_id
2511: into l_owner_id, l_owner_type, l_source_object_id, l_source_object_type_code, l_wr_assignee_id -- Niraj, 4220060, Added
2512: from ieu_uwqm_items
2513: where workitem_pk_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2514: -- and workitem_obj_code = 'TASK';
2515: and workitem_obj_code = l_workitem_obj_code;
2516: EXCEPTION WHEN others THEN null;
2517: end ;

Line 2528: and b.task_status_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id;

2524: where nvl(b.closed_flag, 'N') = 'N'
2525: and nvl(b.completed_flag, 'N') = 'N'
2526: and nvl(b.cancelled_flag, 'N') = 'N'
2527: and nvl(b.rejected_flag, 'N') = 'N'
2528: and b.task_status_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id;
2529: exception when others then l_status := 'CLOSED';
2530: end;
2531:
2532:

Line 2533: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code = 'RS_TEAM')

2529: exception when others then l_status := 'CLOSED';
2530: end;
2531:
2532:
2533: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code = 'RS_TEAM')
2534: or (l_status = 'CLOSED')
2535: then
2536: l_assignee_id := null;
2537: l_assignee_type := null;

Line 2542: from jtf_task_assignments c

2538:
2539: begin
2540: select c.resource_id, c.resource_type_code
2541: into l_assignee_id, l_assignee_type
2542: from jtf_task_assignments c
2543: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2544: and c.last_update_date = (select max(a.last_update_date)
2545: from jtf_task_assignments a,jtf_task_statuses_vl b
2546: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

Line 2543: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2539: begin
2540: select c.resource_id, c.resource_type_code
2541: into l_assignee_id, l_assignee_type
2542: from jtf_task_assignments c
2543: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2544: and c.last_update_date = (select max(a.last_update_date)
2545: from jtf_task_assignments a,jtf_task_statuses_vl b
2546: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2547: and a.assignee_role = 'ASSIGNEE'

Line 2545: from jtf_task_assignments a,jtf_task_statuses_vl b

2541: into l_assignee_id, l_assignee_type
2542: from jtf_task_assignments c
2543: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2544: and c.last_update_date = (select max(a.last_update_date)
2545: from jtf_task_assignments a,jtf_task_statuses_vl b
2546: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2547: and a.assignee_role = 'ASSIGNEE'
2548: and a.resource_type_code <> 'RS_TEAM'
2549: and a.assignment_status_id = b.task_status_id

Line 2546: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2542: from jtf_task_assignments c
2543: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2544: and c.last_update_date = (select max(a.last_update_date)
2545: from jtf_task_assignments a,jtf_task_statuses_vl b
2546: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2547: and a.assignee_role = 'ASSIGNEE'
2548: and a.resource_type_code <> 'RS_TEAM'
2549: and a.assignment_status_id = b.task_status_id
2550: and (nvl(b.closed_flag, 'N') = 'N'

Line 2557: and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

2553: and nvl(b.rejected_flag, 'N') = 'N'
2554: and b.task_status_id = c.assignment_status_iD))
2555: and assignee_role = 'ASSIGNEE'
2556: and c.resource_type_code <> 'RS_TEAM'
2557: and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2558: and rownum < 2;
2559: exception when others then
2560: l_assignee_id := null;
2561: l_assignee_type := null;

Line 2565: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;

2561: l_assignee_type := null;
2562: end;
2563:
2564: else
2565: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
2566: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;
2567: end if;
2568:
2569: begin

Line 2566: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;

2562: end;
2563:
2564: else
2565: l_assignee_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
2566: l_assignee_type := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code;
2567: end if;
2568:
2569: begin
2570: select task_type_id, entity into l_task_type_id, l_entity

Line 2572: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;

2568:
2569: begin
2570: select task_type_id, entity into l_task_type_id, l_entity
2571: from jtf_tasks_b
2572: where task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id;
2573: exception when others then l_task_type_id := null;
2574: end;
2575:
2576: if (l_dist_from = 'GROUP_OWNED') and

Line 2600: from jtf_task_assignments c

2596: then
2597: begin
2598: select c.resource_id, c.resource_type_code
2599: into l_assignee_id, l_assignee_type
2600: from jtf_task_assignments c
2601: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2602: and c.assignee_role = 'ASSIGNEE'
2603: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
2604: and c.resource_id in ( select resource_id

Line 2601: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2597: begin
2598: select c.resource_id, c.resource_type_code
2599: into l_assignee_id, l_assignee_type
2600: from jtf_task_assignments c
2601: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2602: and c.assignee_role = 'ASSIGNEE'
2603: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
2604: and c.resource_id in ( select resource_id
2605: from jtf_rs_group_members

Line 2608: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

2604: and c.resource_id in ( select resource_id
2605: from jtf_rs_group_members
2606: where group_id = l_owner_id
2607: and nvl(delete_flag,'N') <> 'Y')
2608: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2609: and c.last_update_date = (select max(a.last_update_date)
2610: from jtf_task_assignments a,jtf_task_statuses_vl b
2611: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2612: and a.assignee_role = 'ASSIGNEE'

Line 2610: from jtf_task_assignments a,jtf_task_statuses_vl b

2606: where group_id = l_owner_id
2607: and nvl(delete_flag,'N') <> 'Y')
2608: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2609: and c.last_update_date = (select max(a.last_update_date)
2610: from jtf_task_assignments a,jtf_task_statuses_vl b
2611: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2612: and a.assignee_role = 'ASSIGNEE'
2613: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2614: and a.assignment_status_id = b.task_status_id

Line 2611: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id

2607: and nvl(delete_flag,'N') <> 'Y')
2608: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2609: and c.last_update_date = (select max(a.last_update_date)
2610: from jtf_task_assignments a,jtf_task_statuses_vl b
2611: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2612: and a.assignee_role = 'ASSIGNEE'
2613: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2614: and a.assignment_status_id = b.task_status_id
2615: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')

Line 2613: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

2609: and c.last_update_date = (select max(a.last_update_date)
2610: from jtf_task_assignments a,jtf_task_statuses_vl b
2611: where a.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2612: and a.assignee_role = 'ASSIGNEE'
2613: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2614: and a.assignment_status_id = b.task_status_id
2615: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
2616: and a.resource_id in ( select resource_id
2617: from jtf_rs_group_members

Line 2636: /** insert into p_temp values('task id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id||

2632: l_assignee_id := null;
2633: l_assignee_type := null;
2634: end;
2635:
2636: /** insert into p_temp values('task id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id||
2637: ' task asg id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id||
2638: ' owner id: '||l_owner_id ||
2639: ' asg id: '||l_assignee_id||' asg type: '|| l_assignee_type); **/
2640:

Line 2637: ' task asg id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id||

2633: l_assignee_type := null;
2634: end;
2635:
2636: /** insert into p_temp values('task id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id||
2637: ' task asg id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id||
2638: ' owner id: '||l_owner_id ||
2639: ' asg id: '||l_assignee_id||' asg type: '|| l_assignee_type); **/
2640:
2641: end if; /* l_group_id */

Line 2657: IF ( ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND

2653: l_workitem_comment_code2 := 'GRP_MAX_ASSGN';
2654: end if;
2655:
2656: -- Niraj, Bug 4220060
2657: IF ( ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND
2658: (NVL(l_wr_assignee_id, -1) <> NVL(l_assignee_id, -1) )
2659: ) OR
2660: (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') )
2661: THEN

Line 2660: (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') )

2656: -- Niraj, Bug 4220060
2657: IF ( ( (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE') AND
2658: (NVL(l_wr_assignee_id, -1) <> NVL(l_assignee_id, -1) )
2659: ) OR
2660: (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER') )
2661: THEN
2662: l_update_wr_item_call := 'Y';
2663: ELSE
2664: l_update_wr_item_call := 'N';

Line 2686: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')

2682: null);
2683:
2684: -- insert into p_temp(msg) values ('passign due date as: '||l_ins_due_date);
2685:
2686: if (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'ASSIGNEE')
2687: and (l_entity = 'TASK')
2688: -- and (nvl(l_other_asg_update_flag, 'N') = 'N')
2689: -- and (nvl(l_update_wr_item_call, 'Y') = 'Y')
2690: then

Line 2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

2727: p_api_version => 1.0,
2728: p_init_msg_list => FND_API.G_TRUE,
2729: p_commit => FND_API.G_FALSE,
2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,

Line 2755: elsif (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')

2751: end if;
2752:
2753: x_return_status := l_return_status;
2754: -- insert into p_temp values(' called update wr items.. ret sts: '||x_return_status);
2755: elsif (jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role = 'OWNER')
2756: then
2757: -- Create or Update Task User Hook should have been invoked
2758: -- before invoking Create/Update Task Assignment if the assignee role is owner.
2759: -- So update the rec only if its present in IEU_UWQM_ITEMS

Line 2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,

2765: p_api_version => 1.0,
2766: p_init_msg_list => FND_API.G_TRUE,
2767: p_commit => FND_API.G_FALSE,
2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,

Line 2907: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

2903: begin
2904: select task_id
2905: into l_task_id
2906: from jtf_task_all_assignments
2907: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
2908: exception when others then null;
2909: end;
2910:
2911:

Line 3026: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||

3022: end if;
3023:
3024: if l_activation_status = 'Y' then
3025:
3026: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
3027: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
3028:
3029:
3030: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

Line 3027: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */

3023:
3024: if l_activation_status = 'Y' then
3025:
3026: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
3027: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
3028:
3029:
3030: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
3031: BEGIN

Line 3030: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner

3026: /* insert into p_temp(msg) values ('assignee_role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role||
3027: ' booking end date: '|| jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date); */
3028:
3029:
3030: -- Get the Bookings End Date from JTF_TASK_ASSIGNMENTS where assignee_role= owner
3031: BEGIN
3032:
3033: SELECT booking_end_date
3034: INTO l_ins_due_date

Line 3037: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)

3033: SELECT booking_end_date
3034: INTO l_ins_due_date
3035: FROM JTF_TASK_ALL_ASSIGNMENTS
3036: WHERE task_id = (select task_id from jtf_task_all_assignments
3037: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)
3038: AND assignee_role = 'OWNER';
3039:
3040: EXCEPTION
3041: WHEN OTHERS THEN

Line 3179: from jtf_task_assignments

3175: -- This work item is being deleted
3176:
3177: begin
3178: select count(0) into l_task_asg_count
3179: from jtf_task_assignments
3180: where task_id = l_task_id
3181: and assignee_role = 'ASSIGNEE';
3182: exception
3183: when others then l_task_asg_count := 0;

Line 3261: from jtf_task_assignments c

3257:
3258: begin
3259: select c.resource_id, c.resource_type_code
3260: into l_assignee_id, l_assignee_type
3261: from jtf_task_assignments c
3262: where c.task_id = l_task_id
3263: and c.assignee_role = 'ASSIGNEE'
3264: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3265: and c.resource_id in ( select resource_id

Line 3269: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

3265: and c.resource_id in ( select resource_id
3266: from jtf_rs_group_members
3267: where group_id = l_owner_id
3268: and nvl(delete_flag,'N') <> 'Y')
3269: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3270: and c.last_update_date = (select max(a.last_update_date)
3271: from jtf_task_assignments a,jtf_task_statuses_vl b
3272: where a.task_id = l_task_id
3273: and a.assignee_role = 'ASSIGNEE'

Line 3271: from jtf_task_assignments a,jtf_task_statuses_vl b

3267: where group_id = l_owner_id
3268: and nvl(delete_flag,'N') <> 'Y')
3269: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3270: and c.last_update_date = (select max(a.last_update_date)
3271: from jtf_task_assignments a,jtf_task_statuses_vl b
3272: where a.task_id = l_task_id
3273: and a.assignee_role = 'ASSIGNEE'
3274: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3275: and a.assignment_status_id = b.task_status_id

Line 3274: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id

3270: and c.last_update_date = (select max(a.last_update_date)
3271: from jtf_task_assignments a,jtf_task_statuses_vl b
3272: where a.task_id = l_task_id
3273: and a.assignee_role = 'ASSIGNEE'
3274: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3275: and a.assignment_status_id = b.task_status_id
3276: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3277: and a.resource_id in ( select resource_id
3278: from jtf_rs_group_members

Line 3359: from jtf_task_assignments c

3355:
3356: begin
3357: select resource_id, resource_type_code
3358: into l_assignee_id, l_assignee_type
3359: from jtf_task_assignments c
3360: where c.task_id = l_task_id
3361: and task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
3362: EXCEPTION WHEN others THEN
3363: l_assignee_id := null;

Line 3361: and task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

3357: select resource_id, resource_type_code
3358: into l_assignee_id, l_assignee_type
3359: from jtf_task_assignments c
3360: where c.task_id = l_task_id
3361: and task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
3362: EXCEPTION WHEN others THEN
3363: l_assignee_id := null;
3364: l_assignee_type := null;
3365: end ;

Line 3408: from jtf_task_assignments c

3404: l_other_asg_deleted_flag := 'N';
3405: begin
3406: select c.resource_id, c.resource_type_code
3407: into l_assignee_id, l_assignee_type
3408: from jtf_task_assignments c
3409: where c.task_id = l_task_id
3410: and c.assignee_role = 'ASSIGNEE'
3411: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3412: and c.resource_id in ( select resource_id

Line 3417: from jtf_task_assignments a,jtf_task_statuses_vl b

3413: from jtf_rs_group_members
3414: where group_id = l_owner_id
3415: and nvl(delete_flag,'N') <> 'Y')
3416: and c.last_update_date = (select max(a.last_update_date)
3417: from jtf_task_assignments a,jtf_task_statuses_vl b
3418: where a.task_id = l_task_id
3419: and a.assignee_role = 'ASSIGNEE'
3420: and a.assignment_status_id = b.task_status_id
3421: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')

Line 3431: and task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)

3427: and nvl(b.completed_flag, 'N') = 'N'
3428: and nvl(b.cancelled_flag, 'N') = 'N'
3429: and nvl(b.rejected_flag, 'N') = 'N'
3430: and b.task_status_id = c.assignment_status_id)
3431: and task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)
3432: and rownum < 2;
3433: exception when others then
3434: l_assignee_id := null;
3435: l_assignee_type := null;