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.4.12010000.3 2008/11/18 10:51:56 rkamasam 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
158: FROM jtf_rs_resource_extns
159: WHERE resource_id = b_resource_id;
160:

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

407: , p_old_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
408: , p_new_assignee_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
409: , p_new_assignee_code IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
410: ) IS
411: CURSOR c_assignees(b_task_id jtf_tasks_b.task_id%TYPE) IS
412: SELECT resource_id
413: , resource_type_code
414: FROM jtf_task_all_assignments
415: WHERE task_id = b_task_id AND assignee_role = 'ASSIGNEE';

Line 533: FROM jtf_tasks_b t

529: , t.task_priority_id
530: , tp.name task_priority_name
531: , t.task_status_id
532: , ts.name task_status_name
533: FROM jtf_tasks_b t
534: , jtf_tasks_tl tl
535: , jtf_task_statuses_tl ts
536: , jtf_task_types_tl tt
537: , jtf_task_priorities_tl tp

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

548: CURSOR c_wf_processs_id IS
549: SELECT jtf_task_workflow_process_s.NEXTVAL
550: FROM DUAL;
551:
552: CURSOR c_type_name(b_type jtf_tasks_b.task_type_id%TYPE) IS
553: SELECT NAME
554: FROM jtf_task_types_vl
555: WHERE task_type_id = b_type;
556:

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

553: SELECT NAME
554: FROM jtf_task_types_vl
555: WHERE task_type_id = b_type;
556:
557: CURSOR c_priority_name(b_priority jtf_tasks_b.task_priority_id%TYPE) IS
558: SELECT NAME
559: FROM jtf_task_priorities_vl
560: WHERE task_priority_id = b_priority;
561:

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

558: SELECT NAME
559: FROM jtf_task_priorities_vl
560: WHERE task_priority_id = b_priority;
561:
562: CURSOR c_status_name(b_status jtf_tasks_b.task_status_id%TYPE) IS
563: SELECT NAME
564: FROM jtf_task_statuses_vl
565: WHERE task_status_id = b_status;
566:

Line 1000: UPDATE jtf_tasks_b

996: END IF;
997:
998: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
999:
1000: UPDATE jtf_tasks_b
1001: SET workflow_process_id = l_wf_process_id
1002: WHERE task_id = p_task_id;
1003: EXCEPTION
1004: WHEN fnd_api.g_exc_unexpected_error THEN