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_STATUSES_VL

Line 118: from jtf_task_statuses_vl

114: end if;
115:
116: begin
117: select 'CLOSE' into l_task_status
118: from jtf_task_statuses_vl
119: where (nvl(closed_flag, 'N') = 'Y'
120: or nvl(completed_flag, 'N') = 'Y'
121: or nvl(cancelled_flag, 'N') = 'Y'
122: or nvl(rejected_flag, 'N') = 'Y')

Line 127: from jtf_task_statuses_vl

123: and task_status_id = jtf_tasks_pub.p_task_user_hooks.task_status_id;
124: EXCEPTION WHEN others THEN
125: begin
126: select 'SLEEP' into l_task_status
127: from jtf_task_statuses_vl
128: where nvl(on_hold_flag, 'N') = 'Y'
129: and task_status_id = jtf_tasks_pub.p_task_user_hooks.task_status_id;
130: EXCEPTION WHEN others THEN
131: l_task_status := 'OPEN';

Line 516: from jtf_task_statuses_vl

512: end;
513:
514: begin
515: select 'CLOSE' into l_task_status
516: from jtf_task_statuses_vl
517: where (nvl(closed_flag, 'N') = 'Y'
518: or nvl(completed_flag, 'N') = 'Y'
519: or nvl(cancelled_flag, 'N') = 'Y'
520: or nvl(rejected_flag, 'N') = 'Y')

Line 526: from jtf_task_statuses_vl

522: l_status_id := 3;
523: EXCEPTION WHEN others THEN
524: begin
525: select 'SLEEP' into l_task_status
526: from jtf_task_statuses_vl
527: where nvl(on_hold_flag, 'N') = 'Y'
528: and task_status_id = jtf_tasks_pub.p_task_user_hooks.task_status_id;
529: l_status_id := 5;
530: EXCEPTION WHEN others THEN

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 1621: from jtf_task_statuses_vl

1617:
1618: -- Get the Task Status based on task Status Id
1619: begin
1620: select 'CLOSE' into l_task_status
1621: from jtf_task_statuses_vl
1622: where (nvl(closed_flag, 'N') = 'Y'
1623: or nvl(completed_flag, 'N') = 'Y'
1624: or nvl(cancelled_flag, 'N') = 'Y'
1625: or nvl(rejected_flag, 'N') = 'Y')

Line 1690: from jtf_task_statuses_vl

1686: l_owner_type := l_ins_owner_type_code;
1687:
1688: begin
1689: select 'CLOSE' into l_ins_task_status
1690: from jtf_task_statuses_vl
1691: where (nvl(closed_flag, 'N') = 'Y'
1692: or nvl(completed_flag, 'N') = 'Y'
1693: or nvl(cancelled_flag, 'N') = 'Y'
1694: or nvl(rejected_flag, 'N') = 'Y')

Line 1699: from jtf_task_statuses_vl

1695: and task_status_id = l_ins_task_status_id;
1696: EXCEPTION WHEN others THEN
1697: begin
1698: select 'SLEEP' into l_ins_task_status
1699: from jtf_task_statuses_vl
1700: where nvl(on_hold_flag, 'N') = 'Y'
1701: and task_status_id = l_ins_task_status_id;
1702: EXCEPTION WHEN others THEN
1703: l_ins_task_status := 'OPEN';

Line 1739: from jtf_task_statuses_vl b

1735:
1736: -- Get the Task Assignment Status Id
1737: begin
1738: select 'OPEN' INTO l_status
1739: from jtf_task_statuses_vl b
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'

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 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 2411: from jtf_task_statuses_vl

2407:
2408: -- Get the Task Status based on task Status Id
2409: begin
2410: select 'CLOSE' into l_task_status
2411: from jtf_task_statuses_vl
2412: where (nvl(closed_flag, 'N') = 'Y'
2413: or nvl(completed_flag, 'N') = 'Y'
2414: or nvl(cancelled_flag, 'N') = 'Y'
2415: or nvl(rejected_flag, 'N') = 'Y')

Line 2481: from jtf_task_statuses_vl

2477: l_owner_type := l_ins_owner_type_code;
2478:
2479: begin
2480: select 'CLOSE' into l_ins_task_status
2481: from jtf_task_statuses_vl
2482: where (nvl(closed_flag, 'N') = 'Y'
2483: or nvl(completed_flag, 'N') = 'Y'
2484: or nvl(cancelled_flag, 'N') = 'Y'
2485: or nvl(rejected_flag, 'N') = 'Y')

Line 2490: from jtf_task_statuses_vl

2486: and task_status_id = l_ins_task_status_id;
2487: EXCEPTION WHEN others THEN
2488: begin
2489: select 'SLEEP' into l_ins_task_status
2490: from jtf_task_statuses_vl
2491: where nvl(on_hold_flag, 'N') = 'Y'
2492: and task_status_id = l_ins_task_status_id;
2493: EXCEPTION WHEN others THEN
2494: l_ins_task_status := 'OPEN';

Line 2523: from jtf_task_statuses_vl b

2519: end if;
2520:
2521: begin
2522: select 'OPEN' INTO l_status
2523: from jtf_task_statuses_vl b
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'

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 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 3139: from jtf_task_statuses_vl

3135:
3136: -- Get the Task Status based on task Status Id
3137: begin
3138: select 'CLOSE' into l_task_status
3139: from jtf_task_statuses_vl
3140: where (nvl(closed_flag, 'N') = 'Y'
3141: or nvl(completed_flag, 'N') = 'Y'
3142: or nvl(cancelled_flag, 'N') = 'Y'
3143: or nvl(rejected_flag, 'N') = 'Y')

Line 3232: from jtf_task_statuses_vl

3228: l_owner_type := l_ins_owner_type_code;
3229:
3230: begin
3231: select 'CLOSE' into l_ins_task_status
3232: from jtf_task_statuses_vl
3233: where (nvl(closed_flag, 'N') = 'Y'
3234: or nvl(completed_flag, 'N') = 'Y'
3235: or nvl(cancelled_flag, 'N') = 'Y'
3236: or nvl(rejected_flag, 'N') = 'Y')

Line 3241: from jtf_task_statuses_vl

3237: and task_status_id = l_ins_task_status_id;
3238: EXCEPTION WHEN others THEN
3239: begin
3240: select 'SLEEP' into l_ins_task_status
3241: from jtf_task_statuses_vl
3242: where nvl(on_hold_flag, 'N') = 'Y'
3243: and task_status_id = l_ins_task_status_id;
3244: EXCEPTION WHEN others THEN
3245: l_ins_task_status := 'OPEN';

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 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')