eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_WF_SUBSCRIBE_PVT dependencies on JTF_TASKS_B

Line 5: l_task_id jtf_tasks_b.task_id%TYPE;

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);
8: l_abort_workflow VARCHAR2(1);
9: x_return_status VARCHAR2(200);

Line 6: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

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);
8: l_abort_workflow VARCHAR2(1);
9: x_return_status VARCHAR2(200);
10: x_msg_count NUMBER;

Line 49: l_task_id jtf_tasks_b.task_id%TYPE;

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;
52: l_enable_workflow VARCHAR2(1);
53: l_abort_workflow VARCHAR2(1);

Line 51: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

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;
52: l_enable_workflow VARCHAR2(1);
53: l_abort_workflow VARCHAR2(1);
54: x_return_status VARCHAR2(200);
55: x_msg_count NUMBER;

Line 156: l_task_id jtf_tasks_b.task_id%TYPE;

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);
159: l_abort_workflow VARCHAR2(1);
160: x_return_status VARCHAR2(200);

Line 157: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

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);
159: l_abort_workflow VARCHAR2(1);
160: x_return_status VARCHAR2(200);
161: x_msg_count NUMBER;

Line 205: l_task_id jtf_tasks_b.task_id%TYPE;

201: l_abort_workflow VARCHAR2(1);
202: x_return_status VARCHAR2(200);
203: x_msg_count NUMBER;
204: x_msg_data VARCHAR2(1000);
205: l_task_id jtf_tasks_b.task_id%TYPE;
206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN

Line 255: l_task_id jtf_tasks_b.task_id%TYPE;

251: x_return_status VARCHAR2(200);
252: x_msg_count NUMBER;
253: x_msg_data VARCHAR2(1000);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;

Line 332: l_task_id jtf_tasks_b.task_id%TYPE;

328: x_return_status VARCHAR2(200);
329: x_msg_count NUMBER;
330: x_msg_data VARCHAR2(1000);
331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
332: l_task_id jtf_tasks_b.task_id%TYPE;
333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN