APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASK_TYPES_B

Line 8: FROM jtf_task_types_b tt, jtf_tasks_b ta

4: RETURN BOOLEAN IS
5: CURSOR c_task_flag(b_task_id jtf_tasks_b.task_id%TYPE) IS
6: SELECT tt.notification_flag
7: , ta.notification_flag
8: FROM jtf_task_types_b tt, jtf_tasks_b ta
9: WHERE ta.task_id = b_task_id AND ta.task_type_id = tt.task_type_id;
10:
11: l_type_notif_flag jtf_tasks_b.notification_flag%TYPE;
12: l_task_notif_flag jtf_tasks_b.notification_flag%TYPE;

Line 36: FROM jtf_task_types_b tt, jtf_tasks_b ta

32: FUNCTION wf_process(p_task_id IN NUMBER)
33: RETURN VARCHAR2 IS
34: CURSOR c_process(b_task_id jtf_tasks_b.task_id%TYPE) IS
35: SELECT tt.workflow_type || ',' || tt.workflow workflow
36: FROM jtf_task_types_b tt, jtf_tasks_b ta
37: WHERE ta.task_id = b_task_id AND ta.task_type_id = tt.task_type_id;
38:
39: l_workflow VARCHAR2(200); --jtf_task_types_b.workflow%type; --Bug 4289436
40: BEGIN

Line 39: l_workflow VARCHAR2(200); --jtf_task_types_b.workflow%type; --Bug 4289436

35: SELECT tt.workflow_type || ',' || tt.workflow workflow
36: FROM jtf_task_types_b tt, jtf_tasks_b ta
37: WHERE ta.task_id = b_task_id AND ta.task_type_id = tt.task_type_id;
38:
39: l_workflow VARCHAR2(200); --jtf_task_types_b.workflow%type; --Bug 4289436
40: BEGIN
41: ---
42: --- Find the name of the Workflow process to be run
43: ---

Line 542: l_process jtf_task_types_b.workflow%TYPE;

538: , x_msg_data OUT NOCOPY VARCHAR2
539: ) IS
540: l_format_mask CONSTANT VARCHAR2(80) := fnd_profile.VALUE('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS';
541:
542: l_process jtf_task_types_b.workflow%TYPE;
543: l_itemtype VARCHAR2(8) := 'JTFTASK';
544: l_itemkey wf_item_activity_statuses.item_key%TYPE;
545: l_wf_process_id NUMBER;
546: