APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASKS_B

Line 5: CURSOR c_task_flag(b_task_id jtf_tasks_b.task_id%TYPE) IS

1: PACKAGE BODY jtf_task_wf_util AS
2: /* $Header: jtftkwub.pls 120.13 2011/12/22 07:24:16 hemasha ship $ */
3: FUNCTION do_notification(p_task_id IN NUMBER)
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;

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 11: l_type_notif_flag jtf_tasks_b.notification_flag%TYPE;

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;
13: BEGIN
14: ---
15: --- Check if notification flag is set on the Task or for the Task type

Line 12: l_task_notif_flag jtf_tasks_b.notification_flag%TYPE;

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;
13: BEGIN
14: ---
15: --- Check if notification flag is set on the Task or for the Task type
16: ---

Line 34: CURSOR c_process(b_task_id jtf_tasks_b.task_id%TYPE) IS

30: END do_notification;
31:
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:

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 61: l_resource_name jtf_tasks_b.source_object_name%TYPE := NULL;

57: TYPE cur_typ IS REF CURSOR;
58:
59: c cur_typ;
60: l_sql_statement VARCHAR2(500) := NULL;
61: l_resource_name jtf_tasks_b.source_object_name%TYPE := NULL;
62: l_where_clause jtf_objects_b.where_clause%TYPE := NULL;
63:
64: -------------------------------------------------------------------------
65: -- Create a SQL statement for getting the resource name

Line 67: CURSOR c_get_res_name(b_resource_type jtf_tasks_b.owner_type_code%TYPE) IS

63:
64: -------------------------------------------------------------------------
65: -- Create a SQL statement for getting the resource name
66: -------------------------------------------------------------------------
67: CURSOR c_get_res_name(b_resource_type jtf_tasks_b.owner_type_code%TYPE) IS
68: SELECT where_clause
69: , 'SELECT ' || select_name || ' FROM ' || from_table || ' WHERE ' || select_id || ' = :RES'
70: FROM jtf_objects_vl
71: WHERE object_code = b_resource_type;

Line 156: CURSOR c_resource_party(b_resource_id jtf_tasks_b.owner_id%TYPE) IS

152: END IF;
153: END include_role;
154:
155: PROCEDURE get_party_details(p_resource_id IN NUMBER, p_resource_type_code IN VARCHAR2, x_role_name OUT NOCOPY VARCHAR2) IS
156: CURSOR c_resource_party(b_resource_id jtf_tasks_b.owner_id%TYPE) IS
157: SELECT source_id,user_id
158: FROM jtf_rs_resource_extns
159: WHERE resource_id = b_resource_id;
160:

Line 444: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS

440: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
441: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
442: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
443: ) IS
444: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
445: SELECT resource_id
446: , resource_type_code
447: FROM jtf_task_all_assignments
448: WHERE task_id = b_task_id AND assignee_role = 'ASSIGNEE';

Line 566: FROM jtf_tasks_b t

562: , t.task_priority_id
563: , tp.name task_priority_name
564: , t.task_status_id
565: , ts.name task_status_name
566: FROM jtf_tasks_b t
567: , jtf_tasks_tl tl
568: , jtf_task_statuses_tl ts
569: , jtf_task_types_tl tt
570: , jtf_task_priorities_tl tp

Line 585: CURSOR c_type_name(b_type jtf_tasks_b.task_type_id%TYPE) IS

581: CURSOR c_wf_processs_id IS
582: SELECT jtf_task_workflow_process_s.NEXTVAL
583: FROM DUAL;
584:
585: CURSOR c_type_name(b_type jtf_tasks_b.task_type_id%TYPE) IS
586: SELECT NAME
587: FROM jtf_task_types_vl
588: WHERE task_type_id = b_type;
589:

Line 590: CURSOR c_priority_name(b_priority jtf_tasks_b.task_priority_id%TYPE) IS

586: SELECT NAME
587: FROM jtf_task_types_vl
588: WHERE task_type_id = b_type;
589:
590: CURSOR c_priority_name(b_priority jtf_tasks_b.task_priority_id%TYPE) IS
591: SELECT NAME
592: FROM jtf_task_priorities_vl
593: WHERE task_priority_id = b_priority;
594:

Line 595: CURSOR c_status_name(b_status jtf_tasks_b.task_status_id%TYPE) IS

591: SELECT NAME
592: FROM jtf_task_priorities_vl
593: WHERE task_priority_id = b_priority;
594:
595: CURSOR c_status_name(b_status jtf_tasks_b.task_status_id%TYPE) IS
596: SELECT NAME
597: FROM jtf_task_statuses_vl
598: WHERE task_status_id = b_status;
599:

Line 1034: UPDATE jtf_tasks_b

1030: END IF;
1031:
1032: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
1033:
1034: UPDATE jtf_tasks_b
1035: SET workflow_process_id = l_wf_process_id
1036: WHERE task_id = p_task_id;
1037: EXCEPTION
1038: WHEN fnd_api.g_exc_unexpected_error THEN