APPS.OKL_AM_ASSET_RELOCATION_PUB SQL Statements

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

Line: 35

	-- call the insert of pvt

	OKL_AM_ASSET_RELOCATION_PVT.Relocate_Installed_Item(
                                                p_api_version            => l_api_version,
	                                            p_init_msg_list          => l_init_msg_list ,
                                                x_return_status          => l_return_status,
                                                x_msg_count              => l_msg_count,
                                                x_msg_data               => l_msg_data,
											    p_ialo_tbl               => lp_ialo_tbl);

Line: 123

	-- call the insert of pvt

	OKL_AM_ASSET_RELOCATION_PVT.Relocate_Fixed_Asset(
                                                p_api_version            => l_api_version,
	                                            p_init_msg_list          => l_init_msg_list ,
                                                x_return_status          => l_return_status,
                                                x_msg_count              => l_msg_count,
                                                x_msg_data               => l_msg_data,
											    p_falo_tbl               => lp_falo_tbl);

Line: 211

	-- call the insert of pvt

	OKL_AM_ASSET_RELOCATION_PVT.Change_FA_Location (
												p_api_version          => l_api_version,
                                                p_init_msg_list        => l_init_msg_list,
                                                x_return_status        => l_return_status ,
                                                x_msg_count            => l_msg_count,
                                                x_msg_data             => l_msg_data,
                                                p_assets_tbl           => lp_assets_tbl);

Line: 307

	-- call the insert of pvt

	OKL_AM_ASSET_RELOCATION_PVT.Change_Item_Location(
                                                p_api_version            => l_api_version,
	                                            p_init_msg_list          => l_init_msg_list ,
                                                x_msg_count              => l_msg_count,
                                                x_msg_data               => l_msg_data,
                                                x_return_status          => l_return_status,
												p_instance_id			 => lp_instance_id,
												p_location_id			 => lp_location_id,
												p_install_location_id	 => lp_install_location_id);