DBA Data[Home] [Help]

APPS.JTF_TASK_WF_SUBSCRIBE_PVT dependencies on WF_EVENT_T

Line 3: FUNCTION create_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

1: PACKAGE BODY jtf_task_wf_subscribe_pvt AS
2: /* $Header: jtftkwkb.pls 120.1.12000000.2 2007/10/04 14:16:11 venjayar ship $ */
3: FUNCTION create_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
4: RETURN VARCHAR2 IS
5: l_task_id jtf_tasks_b.task_id%TYPE;
6: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
7: l_enable_workflow VARCHAR2(1);

Line 47: FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

43: wf_event.seterrorinfo(p_event, 'WARNING');
44: RETURN 'WARNING';
45: END create_task_notif_subs;
46:
47: FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
48: RETURN VARCHAR2 IS
49: l_task_id jtf_tasks_b.task_id%TYPE;
50: l_task_audit_id jtf_task_audits_b.task_audit_id%TYPE;
51: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 154: FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

150: wf_event.seterrorinfo(p_event, 'WARNING');
151: RETURN 'WARNING';
152: END update_task_notif_subs;
153:
154: FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
155: RETURN VARCHAR2 IS
156: l_task_id jtf_tasks_b.task_id%TYPE;
157: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
158: l_enable_workflow VARCHAR2(1);

Line 198: FUNCTION create_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

194: wf_event.seterrorinfo(p_event, 'WARNING');
195: RETURN 'WARNING';
196: END delete_task_notif_subs;
197:
198: FUNCTION create_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
199: RETURN VARCHAR2 IS
200: l_enable_workflow VARCHAR2(1);
201: l_abort_workflow VARCHAR2(1);
202: x_return_status VARCHAR2(200);

Line 246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

242: wf_event.seterrorinfo(p_event, 'WARNING');
243: RETURN 'WARNING';
244: END create_assg_notif_subs;
245:
246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
247: RETURN VARCHAR2 IS
248: l_enable_workflow VARCHAR2(1);
249: l_abort_workflow VARCHAR2(1);
250: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

Line 324: FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)

320: wf_event.seterrorinfo(p_event, 'WARNING');
321: RETURN 'WARNING';
322: END update_assg_notif_subs;
323:
324: FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
325: RETURN VARCHAR2 IS
326: l_enable_workflow VARCHAR2(1);
327: l_abort_workflow VARCHAR2(1);
328: x_return_status VARCHAR2(200);