240: IS
241: l_api_version CONSTANT NUMBER := 1.0;
242: l_api_name CONSTANT VARCHAR2(30)
243: := 'UPDATE_REFERENCES';
244: l_task_reference_id jtf_task_references_vl.task_reference_id%TYPE
245: := p_escalation_reference_id;
246:
247: CURSOR c_escalation_reference
248: IS
246:
247: CURSOR c_escalation_reference
248: IS
249: SELECT 1 x
250: FROM jtf_task_references_vl
251: WHERE task_reference_id = p_escalation_reference_id;
252:
253: escalation_reference c_escalation_reference%ROWTYPE;
254: x CHAR;
314: BEGIN
315: SELECT 1
316: INTO x
317: FROM jtf_tasks_vl tasks,
318: jtf_task_references_vl reference,
319: jtf_task_statuses_vl status
320: WHERE reference.task_reference_id <> p_escalation_reference_id
321: AND tasks.task_id = reference.task_id
322: AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id