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.BIV_SR_DETAILS_PKG dependencies on JTF_TASKS_B

Line 146: jtf_tasks_b t

142: procedure update_escalation_level as
143: cursor c_escalation is
144: select r.object_id, t.escalation_level, owner_id, r.creation_date
145: from jtf_task_references_b r,
146: jtf_tasks_b t
147: where r.object_type_code = 'SR'
148: and r.reference_code = 'ESC'
149: and r.task_id = t.task_id
150: and t.task_type_id = 22;

Line 152: l_esc_level jtf_tasks_b.escalation_level % type;

148: and r.reference_code = 'ESC'
149: and r.task_id = t.task_id
150: and t.task_type_id = 22;
151: l_incident_id cs_incidents_all_b.incident_id % type;
152: l_esc_level jtf_tasks_b.escalation_level % type;
153: l_owner_type_code jtf_tasks_b.owner_type_code % type;
154: l_owner_id jtf_tasks_b.owner_id % type;
155: l_dt jtf_task_references_b.creation_date % type;
156:

Line 153: l_owner_type_code jtf_tasks_b.owner_type_code % type;

149: and r.task_id = t.task_id
150: and t.task_type_id = 22;
151: l_incident_id cs_incidents_all_b.incident_id % type;
152: l_esc_level jtf_tasks_b.escalation_level % type;
153: l_owner_type_code jtf_tasks_b.owner_type_code % type;
154: l_owner_id jtf_tasks_b.owner_id % type;
155: l_dt jtf_task_references_b.creation_date % type;
156:
157: begin

Line 154: l_owner_id jtf_tasks_b.owner_id % type;

150: and t.task_type_id = 22;
151: l_incident_id cs_incidents_all_b.incident_id % type;
152: l_esc_level jtf_tasks_b.escalation_level % type;
153: l_owner_type_code jtf_tasks_b.owner_type_code % type;
154: l_owner_id jtf_tasks_b.owner_id % type;
155: l_dt jtf_task_references_b.creation_date % type;
156:
157: begin
158: open c_escalation;