APPS.AHL_RM_ROUTE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 549

 	     'Route Id of the Route that is being updated  .....' || l_route_id
          );

Line: 589

 			    'Invalid DML Operation is specified....DML Operation should be Update'
 		    );

Line: 875

 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';

Line: 905

  SAVEPOINT delete_operation_pub;

Line: 939

	     'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'
         );

Line: 975

	     'Route Id of the Route that is being deleted  .....' || l_route_id
         );

Line: 981

  	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
	);

Line: 1045

     Rollback to delete_route_pub;

Line: 1053

     Rollback to delete_route_pub;

Line: 1060

      Rollback to delete_route_pub;

Line: 1063

                                 p_procedure_name => 'DELETE_ROUTE',
                                 p_error_text     => SQLERRM);

Line: 1070

END Delete_Route;

Line: 1866

SELECT RESOURCE_ID
from AHL_RESOURCES
where name = c_resource_name;

Line: 1874

SELECT rt_oper_resource_id
from AHL_RT_OPER_RESOURCES
where
object_ID = c_route_id
and aso_resource_id = c_resource_id;

Line: 1959

	     'Route Id of the Operation that is being updated  .....' || l_route_id
         );