APPS.WSH_CONTAINER_PUB SQL Statements

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

Line: 165

        wsh_interface_grp.Create_Update_Delivery_Detail(
                        p_api_version_number => 1.0,
                        p_init_msg_list      => FND_API.G_FALSE,
                        p_commit             => FND_API.G_FALSE,
                        x_return_status      => x_return_status,
                        x_msg_count          => x_msg_count,
                        x_msg_data           => x_msg_data,
                        p_detail_info_tab    => l_detail_tab,
                        p_IN_rec             => l_detail_rec,
                        x_OUT_rec            => l_out_rec);

Line: 385

   p_outrec.last_update_date     := FND_API.G_MISS_DATE;

Line: 386

   p_outrec.last_update_login    := FND_API.G_MISS_NUM;

Line: 387

   p_outrec.last_updated_by      := FND_API.G_MISS_NUM;

Line: 390

   p_outrec.program_update_date  := FND_API.G_MISS_DATE;

Line: 496

PROCEDURE Update_Container (
	-- Standard parameters
	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_validation_level	IN	NUMBER    DEFAULT FND_API.G_VALID_LEVEL_FULL,
	x_return_status    	OUT NOCOPY 	VARCHAR2,
	x_msg_count 		OUT NOCOPY 	NUMBER,
	x_msg_data 		OUT NOCOPY 	VARCHAR2,

	-- program specific parameters
	p_container_rec		IN	WSH_DELIVERY_DETAILS_PUB.CHANGEDATTRIBUTERECTYPE

) IS

 -- Standard call to check for call compatibility
 l_api_version		CONSTANT	NUMBER	:= 1.0;

Line: 513

 l_api_name		CONSTANT	VARCHAR2(30):= 'Update_Containers';

Line: 531

                                                      'Update_Container';

Line: 533

 WSH_INVALID_CONT_UPDATE		EXCEPTION;

Line: 534

 WSH_FAIL_CONT_UPDATE			EXCEPTION;

Line: 548

	SAVEPOINT Update_Containers_SP;

Line: 576

	-- check to make sure that the container record being input for update
	-- does not have null delivery detail ids or container name or the
	-- container flag is null or 'N'


	-- Now check for valid container based on the information in the
	-- container rec.


        populate_record(p_container_rec,l_detail_info_rec);

Line: 588

        l_detail_rec.action_code := 'UPDATE';

Line: 591

        wsh_interface_grp.Create_Update_Delivery_Detail(
                        p_api_version_number => 1.0,
                        p_init_msg_list      => FND_API.G_FALSE,
                        p_commit             => FND_API.G_FALSE,
                        x_return_status      => x_return_status,
                        x_msg_count          => x_msg_count,
                        x_msg_data           => x_msg_data,
                        p_detail_info_tab    => l_detail_info_tab,
                        p_IN_rec             => l_detail_rec,
                        x_OUT_rec            => l_out_rec);

Line: 610

           raise WSH_FAIL_CONT_UPDATE;

Line: 635

	WHEN WSH_INVALID_CONT_UPDATE then
		rollback to Update_Containers_SP;

Line: 638

		fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');

Line: 650

                   WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');

Line: 653

	WHEN WSH_FAIL_CONT_UPDATE then
		rollback to Update_Containers_SP;

Line: 656

		fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');

Line: 667

                   WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');

Line: 671

		rollback to Update_Containers_SP;

Line: 672

		wsh_util_core.default_handler('WSH_CONTAINER_PUB.Update_Container',l_module_name);

Line: 688

END Update_Container;

Line: 747

 l_api_name		CONSTANT	VARCHAR2(30):= 'Update_Containers';

Line: 1077

 l_api_name		CONSTANT	VARCHAR2(30):= 'Update_Containers';