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 2115: l_task_id jtf_tasks_b.task_id%TYPE;

2111:
2112:
2113: FUNCTION create_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
2114: RETURN VARCHAR2 IS
2115: l_task_id jtf_tasks_b.task_id%TYPE;
2116: l_wf_process_id NUMBER;
2117: l_notif_not_sent VARCHAR2(1000);
2118: x_return_status VARCHAR2(200);
2119: x_msg_count NUMBER;