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_TASK_ALL_ASSIGNMENTS

Line 206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

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
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

Line 207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;

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
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);

Line 208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;

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
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);

Line 250: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

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;
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;

Line 254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

250: l_assignee_role_db jtf_task_all_assignments.assignee_role%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;

Line 256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

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;
260: BEGIN

Line 257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;

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;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);

Line 258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

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;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

Line 259: l_orig_resource_id jtf_task_all_assignments.resource_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;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);

Line 331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

327: l_abort_workflow VARCHAR2(1);
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;

Line 333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

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
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);

Line 334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;

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
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);

Line 335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;

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
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);