APPS.IEU_TASKS_USERHOOKS dependencies on JTF_TASKS_B

Line 510: select task_status_id into l_task_status_id from jtf_tasks_b

506:
507: end if;
508:
509: begin
510: select task_status_id into l_task_status_id from jtf_tasks_b
511: where task_id = jtf_tasks_pub.p_task_user_hooks.task_id;
512: end;
513:
514: begin

Line 1013: from jtf_tasks_b

1009: -- then
1010: begin
1011: select source_object_type_code
1012: into l_task_source_obj_type_code
1013: from jtf_tasks_b
1014: where task_id = jtf_tasks_pub.p_task_user_hooks.task_id;
1015:
1016: exception when others then
1017: l_task_source_obj_type_code := null;

Line 1219: from jtf_tasks_b

1215: then
1216:
1217: begin
1218: select task_type_id, entity into l_task_type_id, l_entity
1219: from jtf_tasks_b
1220: where task_id = jtf_tasks_pub.p_task_user_hooks.task_id;
1221: exception when others then l_task_type_id := null;
1222: end;
1223:

Line 1397: from jtf_tasks_b

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

Line 1607: from jtf_tasks_b

1603: -- Get the Task Status 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;

Line 1669: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

1665: into l_ins_task_id, l_ins_task_number, l_ins_customer_id, l_ins_owner_id, l_ins_owner_type_code,
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')

Line 1789: from jtf_tasks_b

1785: end if;
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:

Line 2181: from jtf_tasks_b

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

Line 2397: from jtf_tasks_b

2393: -- Get the Task Status 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;

Line 2461: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

2457: l_ins_source_object_id, l_ins_source_object_type_code,
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')

Line 2571: from jtf_tasks_b

2567: end if;
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:

Line 2918: from jtf_tasks_b

2914: begin
2915:
2916: select source_object_type_code
2917: into l_task_source_obj_type_code
2918: from jtf_tasks_b
2919: where task_id = l_task_id;
2920: exception when others then
2921: l_task_source_obj_type_code := null;
2922: end;

Line 3125: from jtf_tasks_b

3121: -- Get the Task Status Id
3122: begin
3123: select task_status_id, deleted_flag
3124: into l_tsk_sts_id, l_del_flag
3125: from jtf_tasks_b
3126: where task_id = l_task_id;
3127: exception
3128: when others then null;
3129: end;

Line 3212: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

3208: into l_ins_task_id, l_ins_task_number, l_ins_customer_id, l_ins_owner_id, l_ins_owner_type_code,
3209: l_ins_source_object_id, l_ins_source_object_type_code,
3210: l_ins_planned_start_date, 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,
3211: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code, l_entity
3212: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
3213: where tb.task_id = l_task_id
3214: and tb.entity = 'TASK'
3215: and tb.task_id = tt.task_id
3216: and tt.language = userenv('LANG')

Line 3369: from jtf_tasks_b

3365: end ;
3366:
3367: begin
3368: select task_type_id, entity into l_task_type_id, l_entity
3369: from jtf_tasks_b
3370: where task_id = l_task_id;
3371: exception when others then l_task_type_id := null;
3372: end;
3373: