The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UPDATE_TASK_DEPENDENCY (
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT NULL
, p_commit IN VARCHAR2 DEFAULT NULL
, p_object_version_number IN OUT NOCOPY NUMBER
, p_dependency_id IN NUMBER
, p_task_id IN NUMBER DEFAULT NULL
, p_dependent_on_task_id IN NUMBER DEFAULT NULL
, p_dependency_type_code IN VARCHAR2 DEFAULT NULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, 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
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
SAVEPOINT csf_update_task_dependency_pub;
jtf_task_dependency_pub.update_task_dependency (
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_object_version_number => p_object_version_number
, p_dependency_id => p_dependency_id
, p_task_id => p_task_id
, p_dependent_on_task_id => p_dependent_on_task_id
, p_dependency_type_code => p_dependency_type_code
, p_validated_flag => 'N'
, p_adjustment_time => NULL
, p_adjustment_time_uom => 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
);
ROLLBACK TO csf_update_task_dependency_pub;
ROLLBACK TO csf_update_task_dependency_pub;
END UPDATE_TASK_DEPENDENCY;
PROCEDURE DELETE_TASK_DEPENDENCY (
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT NULL
, p_commit IN VARCHAR2 DEFAULT NULL
, p_object_version_number IN NUMBER
, p_dependency_id IN NUMBER
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_DEPENDENCY';
SAVEPOINT csf_delete_task_dependency_pub;
jtf_task_dependency_pub.delete_task_dependency (
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_object_version_number => p_object_version_number
, p_dependency_id => p_dependency_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO csf_delete_task_dependency_pub;
ROLLBACK TO csf_delete_task_dependency_pub;
END DELETE_TASK_DEPENDENCY;
SELECT dependency_id
, object_version_number
FROM jtf_task_depends
WHERE task_id = p_task_id
UNION
SELECT dependency_id
, object_version_number
FROM jtf_task_depends
WHERE dependent_on_task_id = p_task_id;
DELETE_TASK_DEPENDENCY(
p_api_version => 1.0
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_object_version_number => l_object_version_number
, p_dependency_id => l_dependency_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);