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 IEU_UWQM_ITEMS

Line 280: from ieu_uwqm_items

276: l_workitem_obj_code := 'TASK';
277: l_owner_type_actual := 'RS_GROUP';
278: Select owner_id
279: into l_orig_grp_owner
280: from ieu_uwqm_items
281: where WORKITEM_PK_ID = jtf_tasks_pub.p_task_user_hooks.task_id
282: -- and workitem_obj_code = 'TASK'
283: and workitem_obj_code = l_workitem_obj_code
284: -- and owner_type_actual = 'RS_GROUP';

Line 426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;

422: l_wr_priority_id number := null;
423: l_priority_id number;
424:
425: l_status_id NUMBER;
426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;
427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;

Line 427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;

423: l_priority_id number;
424:
425: l_status_id NUMBER;
426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;
427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;

Line 428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;

424:
425: l_status_id NUMBER;
426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;
427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;
432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;

Line 429: l_wr_title ieu_uwqm_items.title%TYPE;

425: l_status_id NUMBER;
426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;
427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;
432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;
433: l_update_task_reqd_flag VARCHAR2(1);

Line 430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;

426: l_wr_status_id ieu_uwqm_items.status_id%TYPE;
427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;
432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;
433: l_update_task_reqd_flag VARCHAR2(1);
434:

Line 431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;

427: l_wr_party_id ieu_uwqm_items.party_id%TYPE;
428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;
432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;
433: l_update_task_reqd_flag VARCHAR2(1);
434:
435:

Line 432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;

428: l_wr_owner_id ieu_uwqm_items.owner_id%TYPE;
429: l_wr_title ieu_uwqm_items.title%TYPE;
430: l_wr_owner_type_actual ieu_uwqm_items.owner_type_actual%TYPE;
431: l_wr_source_object_id ieu_uwqm_items.source_object_id%TYPE;
432: l_wr_source_object_type_code ieu_uwqm_items.source_object_type_code%TYPE;
433: l_update_task_reqd_flag VARCHAR2(1);
434:
435:
436: begin

Line 683: from ieu_uwqm_items

679: l_workitem_obj_code := 'TASK';
680: l_owner_type_actual := 'RS_GROUP';
681: Select owner_id
682: into l_orig_grp_owner
683: from ieu_uwqm_items
684: where WORKITEM_PK_ID = jtf_tasks_pub.p_task_user_hooks.task_id
685: -- and workitem_obj_code = 'TASK'
686: -- and owner_type_actual = 'RS_GROUP';
687: and workitem_obj_code = l_workitem_obj_code

Line 758: from ieu_uwqm_items

754: l_wr_status_id,
755: l_wr_owner_type_actual,
756: l_wr_source_object_id,
757: l_wr_source_object_type_code
758: from ieu_uwqm_items
759: where workitem_pk_id = jtf_tasks_pub.p_task_user_hooks.task_id
760: -- and workitem_obj_code = 'TASK';
761: and workitem_obj_code = l_workitem_obj_code;
762:

Line 1166: from ieu_uwqm_items

1162: l_workitem_obj_code := 'TASK';
1163: l_owner_type_actual := 'RS_GROUP';
1164: Select owner_id
1165: into l_orig_grp_owner
1166: from ieu_uwqm_items
1167: where WORKITEM_PK_ID = jtf_tasks_pub.p_task_user_hooks.task_id
1168: -- and workitem_obj_code = 'TASK'
1169: -- and owner_type_actual = 'RS_GROUP';
1170: and workitem_obj_code = l_workitem_obj_code

Line 1201: from ieu_uwqm_items

1197:
1198: begin
1199: select 'Y'
1200: into l_wi_exists
1201: from ieu_uwqm_items
1202: where workitem_pk_id = jtf_tasks_pub.p_task_user_hooks.task_id
1203: and workitem_obj_code = 'TASK';
1204: exception
1205: when others then

Line 1362: l_wr_assignee_id ieu_uwqm_items.assignee_id%TYPE; -- Niraj, Bug 4220060, Added

1358: l_ins_task_status varchar2(10);
1359: l_ins_task_status_id number;
1360: l_ins_task_type_id number;
1361: l_ins_work_item_id NUMBER;
1362: l_wr_assignee_id ieu_uwqm_items.assignee_id%TYPE; -- Niraj, Bug 4220060, Added
1363: l_update_wr_item_call varchar2(5); -- Niraj, Bug 4220060, Added
1364:
1365: begin
1366:

Line 1572: from ieu_uwqm_items

1568: l_workitem_obj_code := 'TASK';
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

Line 1634: from ieu_uwqm_items

1630: -- Check if the Work Item exists in UWQ Metaphor Table
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

Line 1721: from ieu_uwqm_items

1717: begin
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

Line 1852: from ieu_uwqm_items

1848: begin
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

Line 2014: -- So update the rec only if its present in IEU_UWQM_ITEMS

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
2015: if (l_wi_exists <> 'N')
2016: then
2017:
2018: --insert into p_temp(msg) values (' calling update ');

Line 2146: l_wr_assignee_id ieu_uwqm_items.assignee_id%TYPE; -- Niraj, Bug 4220060, Added

2142: l_ins_task_status varchar2(10);
2143: l_ins_task_status_id number;
2144: l_ins_task_type_id number;
2145: l_ins_work_item_id NUMBER;
2146: l_wr_assignee_id ieu_uwqm_items.assignee_id%TYPE; -- Niraj, Bug 4220060, Added
2147:
2148: begin
2149: -- insert into p_temp(msg) values('proc update asg task');
2150:

Line 2357: from ieu_uwqm_items

2353: l_workitem_obj_code := 'TASK';
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

Line 2424: from ieu_uwqm_items

2420: -- Check if the Work Item exists in UWQ Metaphor Table
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

Line 2512: from ieu_uwqm_items

2508: begin
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;

Line 2759: -- So update the rec only if its present in IEU_UWQM_ITEMS

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
2760: if (l_wi_exists <> 'N')
2761: then
2762:
2763: -- insert into p_temp(msg) values(' calling update wr item' );

Line 3089: from ieu_uwqm_items

3085: l_workitem_obj_code := 'TASK';
3086: l_owner_type_actual := 'RS_GROUP';
3087: Select owner_id
3088: into l_orig_grp_owner
3089: from ieu_uwqm_items
3090: where WORKITEM_PK_ID = l_task_id
3091: -- and workitem_obj_code = 'TASK'
3092: -- and owner_type_actual = 'RS_GROUP';
3093: and workitem_obj_code = l_workitem_obj_code

Line 3152: from ieu_uwqm_items

3148: -- Check if the Work Item exists in UWQ Metaphor Table
3149: begin
3150: select 'Y'
3151: into l_wi_exists
3152: from ieu_uwqm_items
3153: where workitem_pk_id =l_task_id
3154: and workitem_obj_code = 'TASK';
3155: exception
3156: when others then

Line 3379: from ieu_uwqm_items

3375: begin
3376: l_workitem_obj_code := 'TASK';
3377: select owner_id, owner_type, source_object_id, source_object_type_code
3378: into l_owner_id, l_owner_type, l_source_object_id, l_source_object_type_code
3379: from ieu_uwqm_items
3380: where workitem_pk_id = l_task_id
3381: -- and workitem_obj_code = 'TASK';
3382: and workitem_obj_code = l_workitem_obj_code;
3383: EXCEPTION WHEN others THEN null;

Line 3394: from ieu_uwqm_items

3390: begin
3391: l_workitem_obj_code := 'TASK';
3392: select assignee_id, assignee_type_actual
3393: into l_uwq_assignee_id, l_uwq_assignee_type
3394: from ieu_uwqm_items
3395: where workitem_pk_id = l_task_id
3396: -- and workitem_obj_code = 'TASK';
3397: and workitem_obj_code = l_workitem_obj_code;
3398: exception when others then