APPS.AHL_FMP_MR_PUB SQL Statements

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

Line: 494

		AHL_FMP_MR_HEADER_PVT.UPDATE_MR_HEADER
		(
			p_api_version          	=> 1.0,
			p_init_msg_list        	=> FND_API.G_FALSE,
			p_commit               	=> FND_API.G_FALSE,
			p_validation_level     	=> p_validation_level,
			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_x_mr_header_rec      	=> l_mr_header_rec
		);

Line: 520

				'AHL_FMP_MR_HEADER_PVT.UPDATE_MR_HEADER successful'
			);

Line: 809

PROCEDURE Delete_Mr
(
	-- 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_mr_header_id 			IN          	NUMBER,
	p_mr_title			IN		VARCHAR2,
	p_mr_version_number		IN		NUMBER,
	p_mr_object_version  		IN          	NUMBER
)
IS
	-- 1.	Declare local variables
	l_api_name	CONSTANT	VARCHAR2(30)	:= 'Delete_Mr';

Line: 841

	SAVEPOINT Delete_Mr_SP;

Line: 895

	AHL_FMP_MR_HEADER_PVT.DELETE_MR_HEADER
	(
		p_api_version          	=> 1.0,
		p_init_msg_list        	=> FND_API.G_FALSE,
		p_commit               	=> FND_API.G_FALSE,
		p_validation_level     	=> p_validation_level,
		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_mr_header_id      	=> l_mr_header_id,
		p_OBJECT_VERSION_NUMBER	=> p_mr_object_version
	);

Line: 952

		Rollback to Delete_Mr_SP;

Line: 962

		Rollback to Delete_Mr_SP;

Line: 972

		Rollback to Delete_Mr_SP;

Line: 978

				p_procedure_name 	=> 'Delete_Mr',
				p_error_text     	=> SUBSTR(SQLERRM,1,240)
			);

Line: 989

END Delete_Mr;