DBA Data[Home] [Help]

APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_TASKS_B

Line 12: l_resource_name jtf_tasks_b.source_object_name%TYPE := NULL;

8: TYPE cur_typ IS REF CURSOR;
9: c cur_typ;
10: l_api_name VARCHAR2(20) := 'Get_Resource_Name';
11: l_sql_statement VARCHAR2(500) := NULL;
12: l_resource_name jtf_tasks_b.source_object_name%TYPE := NULL;
13: l_where_clause jtf_objects_b.where_clause%TYPE := NULL;
14:
15: -------------------------------------------------------------------------
16: -- Create a SQL statement for getting the resource name

Line 1688: update jtf_tasks_b

1684: itemtype => p_wf_item_type_name,
1685: itemkey => l_itemkey
1686: );
1687:
1688: update jtf_tasks_b
1689: set workflow_process_id = l_itemkey
1690: where task_id = p_task_id;
1691:
1692: -- Standard check of p_commit.

Line 2080: l_task_id jtf_tasks_b.task_id%TYPE;

2076:
2077:
2078: FUNCTION create_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2079: RETURN VARCHAR2 IS
2080: l_task_id jtf_tasks_b.task_id%TYPE;
2081: l_wf_process_id NUMBER;
2082: l_notif_not_sent VARCHAR2(1000);
2083: x_return_status VARCHAR2(200);
2084: x_msg_count NUMBER;