The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_references (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_object_version_number IN OUT NOCOPY NUMBER,
p_escalation_reference_id IN NUMBER,
p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
p_attribute1 IN VARCHAR2 DEFAULT null ,
p_attribute2 IN VARCHAR2 DEFAULT null ,
p_attribute3 IN VARCHAR2 DEFAULT null ,
p_attribute4 IN VARCHAR2 DEFAULT null ,
p_attribute5 IN VARCHAR2 DEFAULT null ,
p_attribute6 IN VARCHAR2 DEFAULT null ,
p_attribute7 IN VARCHAR2 DEFAULT null ,
p_attribute8 IN VARCHAR2 DEFAULT null ,
p_attribute9 IN VARCHAR2 DEFAULT null ,
p_attribute10 IN VARCHAR2 DEFAULT null ,
p_attribute11 IN VARCHAR2 DEFAULT null ,
p_attribute12 IN VARCHAR2 DEFAULT null ,
p_attribute13 IN VARCHAR2 DEFAULT null ,
p_attribute14 IN VARCHAR2 DEFAULT null ,
p_attribute15 IN VARCHAR2 DEFAULT null ,
p_attribute_category IN VARCHAR2 DEFAULT null,
p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
)
IS
l_api_version CONSTANT NUMBER := 1.0;
:= 'UPDATE_REFERENCES';
SELECT 1 x
FROM jtf_task_references_vl
WHERE task_reference_id = p_escalation_reference_id;
SELECT REFERENCE_CODE , OBJECT_TYPE_CODE , OBJECT_ID, TASK_ID
FROM JTF_TASK_REFERENCES_B
WHERE task_reference_id = reference_id;
SAVEPOINT update_references_pub;
SELECT 1
INTO x
FROM jtf_tasks_vl tasks,
jtf_task_references_vl reference,
jtf_task_statuses_vl status
WHERE reference.task_reference_id <> p_escalation_reference_id
AND tasks.task_id = reference.task_id
AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id
AND reference.object_type_code = p_object_type_code
AND reference.object_id = p_object_id
AND tasks.task_status_id = status.task_status_id
AND status.closed_flag = 'Y';
jtf_task_references_pub.update_references (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => p_object_version_number,
p_task_reference_id => p_escalation_reference_id,
p_object_type_code => p_object_type_code,
p_object_name => p_object_name,
p_object_id => p_object_id,
p_object_details => p_object_details,
p_reference_code => p_reference_code,
p_usage => NULL,
x_return_status => x_return_status,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute_category => p_attribute_category
);
jtf_esc_wf_events_pvt.publish_update_escRef
(P_ESC_REF_REC_OLD => l_esc_ref_rec_old,
P_ESC_REF_REC_NEW => l_esc_ref_rec_new);
ROLLBACK TO update_references_pub;
ROLLBACK TO update_references_pub;
ROLLBACK TO update_references_pub;
PROCEDURE delete_references (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_object_version_number IN NUMBER,
p_escalation_reference_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REFERENCE';
SELECT REFERENCE_CODE, OBJECT_TYPE_CODE, OBJECT_ID, TASK_ID
FROM JTF_TASK_REFERENCES_B
WHERE task_reference_id = reference_id;
SAVEPOINT delete_task_reference_pub;
jtf_task_references_pvt.delete_references (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => p_object_version_number,
p_task_reference_id => p_escalation_reference_id,
x_return_status => x_return_status,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count
);
jtf_esc_wf_events_pvt.publish_delete_escRef
(p_esc_ref_rec => l_esc_ref_rec);
ROLLBACK TO delete_task_reference_pub;
ROLLBACK TO delete_task_reference_pub;