The following lines contain the word 'select', 'insert', 'update' or 'delete':
'Route Id of the Route that is being updated .....' || l_route_id
);
'Invalid DML Operation is specified....DML Operation should be Update'
);
PROCEDURE Delete_Route
(
-- standard IN params
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
p_commit IN VARCHAR2 :=FND_API.G_FALSE,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
p_default IN VARCHAR2 :=FND_API.G_FALSE,
p_module_type IN VARCHAR2 :=NULL,
-- standard OUT params
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
-- procedure params
p_route_id IN VARCHAR2,
p_route_number IN VARCHAR2,
p_route_revision IN NUMBER,
p_route_object_version IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTE';
SAVEPOINT delete_route_pub;
'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'
);
'Route Id of the Route that is being deleted .....' || l_route_id
);
AHL_RM_ROUTE_PVT.delete_route
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_default => p_default,
p_module_type => p_module_type,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_route_id => l_route_id,
p_object_version_number => p_route_object_version
);
Rollback to delete_route_pub;
Rollback to delete_route_pub;
Rollback to delete_route_pub;
p_procedure_name => 'DELETE_ROUTE',
p_error_text => SQLERRM);
END Delete_Route;
SELECT RESOURCE_ID
from AHL_RESOURCES
where name = c_resource_name;
SELECT rt_oper_resource_id
from AHL_RT_OPER_RESOURCES
where
object_ID = c_route_id
and aso_resource_id = c_resource_id;
'Route Id of the Operation that is being updated .....' || l_route_id
);